December 18, 2020
We are glad to inform our users about the new Skyvia features: Returning feature in Data Import and a number of new connectors.
This feature allows obtaining IDs or any other fields from records inserted by the import and assigning them back to the corresponding source records. It can be very useful if you want, for example, to import records from a database to Salesforce and store Salesforce IDs of the imported records in the source database. You may also need to import Salesforce records to some other source and store target IDs in a Salesforce External ID field.
This feature is not limited to Id/primary key values. It allows using any target columns in mapping, as well as constants, expressions, or relation mapping. Thus, you may use the Returning feature, for example, to mark successfully inserted source records with some constant values.
The new Returning feature is available only in the Import packages using the new data integration engine. You should select the Use New Runtime check box in your package to use it. Besides, it must be a package, importing data from a cloud app or database, and the source object must support updates.
This feature also returns values only for records that are created in the target. Thus, it is available only for the insert and upsert operations.
If your package meets the requirements above, you will see the Use returning check box in the mapping settings. You should select it to make the Returning settings available. In the Returning settings, you configure mapping for source columns as usually, and this mapping will be applied when updating source records for successfully created target records.
With the new Skyvia connectors you will be able to quickly integrate, manage, and share data of the following cloud applications:
As always, you are welcome to try our new feature and leave your feedback! We appreciate your support and help in improvements of our products.