Transform and Write
Learn how to transform and write data using the DBSync Cloud Workflow
Introduction
DBSync Cloud Workflow Transform and Write Action is used to read data from the source application, transform it, and write it in the target application.
Through this action, you can transform data by changing formats or applying calculations before it gets sent to the target application.
Use Case
In this tutorial, we will demonstrate how to use the Transform and Write action to pull Salesforce Accounts and insert them as Customers in QuickBooks.
Prerequisites
Before you begin, ensure you have the following:
A sample flow, query, and debug setup. Refer to the Query documentation for more information on query creation.
The Salesforce application connector is configured.
The QuickBooks application connector is configured.
Confiigure Transform and Write Action
In the Flow screen, drag the Flow Action from the Actions palette on the left and drop to the center of the screen.
Click the Configure button on the flow panel to configure the flow.
In the Flow configuration panel that opens on the right side, enter the required description for the flow and click Save.
Add a Query Action: Now drag and drop the Query action into your workflow.
Click Configure and set the source to Salesforce and the object to Account. You can choose All Fields or specific fields as required.
Preview Query Results: Click Preview to display the results of the query. Ensure that the query returns the expected data and then click Save.
Add Transform and Write Action: Drag and drop the Transform and Write action into your workflow.
Click Configure and select the operation as Insert, the target as QuickBooks and the object as Customer.
Mapping Fields: Click Map and define how data fields from the source system are transformed and transferred to corresponding fields in the target system during integration.
Drag and drop the necessary fields from the Salesforce Account object to the corresponding QuickBooks Customer fields. For example, map the Display Name field in QuickBooks with the Name field from Salesforce.
Save the Mapping: After completing the mapping, click Save to save the mapping configuration and close.
Save the Transform and Write Action Workflow: Click Save to save the Transform and Write action.
Run the Integration: Click Run
to execute the integration. The console will display the executed query, and it will insert the Salesforce Accounts as Customers in QuickBooks.Debugging: If needed, add a Debug action before the Transform and Write action to verify the data being processed. Configure the Debug action to display relevant fields to confirm that the data is correct before it is written to QuickBooks.
Review Console Output: After running the integration, check the console output for any errors or confirmation messages to ensure the process completed successfully.
Iterate and Optimize: Based on the results and any errors encountered, make necessary adjustments to the mapping or query as needed. Repeat the process until the workflow operates as expected.
PRO TIP:
When mapping fields in the 'Transform and Write' action, ensure that the data types between the source and target fields are compatible. This prevents data conversion issues and ensures smooth data transfer.
1. Can I transform data before writing it to the target application?
Yes, the 'Transform and Write' action allows you to transform data, such as changing formats or applying calculations, before writing it to the target application.
2. Is it possible to use multiple queries in a single Transform and Write action?
Yes, you can use multiple queries and combine their data in a single 'Transform and Write' action to write comprehensive data sets to the target application.
3. How do I handle errors encountered during the Transform and Write process?
Use the console output and debug actions to identify and troubleshoot errors. Check for issues like data type mismatches, missing fields, or incorrect mappings.
4. Can I schedule the Transform and Write action to run automatically?
Yes, DBSync Cloud Workflow allows you to schedule flows, including the Transform and Write actions, to run automatically at specified times.
Related Content
Query: Creating and Managing Queries in DBSync Cloud Workflow
Flow: Automating Workflows with Scheduled Tasks
Logs: Troubleshooting Common Errors in DBSync Integrations
Last updated