What's new?
SQL Transformation. Expanding Data Sources
We believe you are aware of Workato Data Orchestration capabilities!
- Extensive Connectivity: Move data effortlessly from apps, databases, and AI.
- Data Pipeline Recipes: Automate data movement for faster go-live.
- Flexible Transformations: Use push-down transformations or native SQL for big data.
- Enhanced Observability: Custom dashboards and actionable insights
As part of the Workato SQL Transformation capabilities, we are now expanding Data Sources to allow you to specify one or more sources for performing SQL queries. You can add as many data sources as required!
- Data Tables: you can now retrieve data from tables configured within Workato without additional setup requirements.
- You can now run SQL transformation directly on Excel files
- It is possible now to Query different file formats (Excel, CSV, etc)
- As stated above, you can now select multiple Data Sources and transform Data by joining them!
Check Data Transformation Documentation
Availability of AI features on all Data Centers
Struggling with a backlog of ever-growing tasks? Workato Copilot is here to help. Available in all data centers, Copilot assists users of all experience levels through recipe creation, offering suggestions and auto-completing tasks to expedite your development. Whether creating a new connector, mapping complex data pills, or starting a recipe from scratch, Copilot is your guide. Watch Copilot in action to see how it can help you build faster!
We believe AI can do more than accelerate workflows; it can uncover insights to make business processes smarter. Introducing AI by Workato, developed with OpenAI. From generating personalized CS responses and finding top talent to driving actions from customer calls, AI by Workato helps users bring new smarts to existing processes. Don’t miss out!
These AI features are now available in all of Workato’s data centers, and they’re ready to make your workflows faster and smarter! (Note: Learn How Workato keeps your data secure)
Check AI Features in Workato.
Platform Connector Updates
We have made significant enhancements to various critical strategic connectors, such as Data Tables, NetSuite, OpenAI or S3. Find below the top 10 releases, and check the entire list the full Platform Connector Release Notes.
- OpenAI: New/Improved Actions:
- We have enhanced the "Send messages to ChatGPT" action by adding function support
- Users can now create any schema using the schema editor, not just key-value pairs in the Parse Text action
- The new “Summarize text” action allows for text summarization
- Data Tables: Users can now use the "Remove values from a record" action to remove values, relations, and attached files from a record
- Google Sheets: The picklist API previously only returned the available spreadsheets, not the individual sheets within them. We have now added an option for a picklist "with_sheets". When this option is set to true, the API will return the individual sheets within a spreadsheet. In addition, Non-English characters are now supported in Google Sheets datapills!
- Amazon S3: Several improvements to the Amazon S3 usability like hints, improved error handling or new support options for different fields.
- NetSuite: Two new features for the NetSuite connector: Get Record by ID and Search Records. Additional Bug fixes.
- AI by Workato: We have improved the “Categorise Text” action. Some UX enhancements including changing the title and description dynamically based on the user input for category type were implemented.
- Sharepoint: We have improved the Sharepoint search files action. Previously, users could only search by exact filename. Now, we have introduced advanced filters to make the search action more versatile.
- Gmail: The connection setup process for the Gmail connector has been revamped and allows more granular scopes.
- BIM360: We have set a minimum scope and added the ability to select granular scopes. Customers can now customize their scopes by selecting permissions from the picklist, which will overwrite the default permissions.
- Outlook: We have made enhancements to Outlook by adding new actions and a trigger. The new actions include the ability to create a calendar, delete an event, and list calendars. Additionally, a new trigger has been added for deleted events.
In addition, more enhancements for connectors like Shopify, Workday, Jira, Adobe Experience Manager, SFTP, Formstack, Coupa, Outreach, ServiceNow, Egnyte or Dropbox!
Workato Connectors
Workato Connectors
