Interaction Between Datastores and Workflows
First published on: 03/20/2025/12:00 pm
In order to write or read from the datastores, the project needs to have the "Saltbox Apps and Data Analytics Connector" installed.
Please refer to full connector documentation on Saltbox Connector Release Notes.
Create/Populate a datastore using a workflow
-
Start by creating a new workflow.
-
On the workflow designer add the action "Push Data to a Datastore".
-
Create a new transformation map, make sure output is JSON.
** the transformation can be done in a separate step, and the output sent to this step
-
On the Filters and Configs Settings section, populate the target Datastore Name. If the datastore doesn’t exists it will be created, otherwise it will be overridden/updated.
-
Populate the DS primary key column name.
-
Open the visual data mapper to apply mapping from your source data to the datastore structure.
-
If you are populating an existing datastore, use the target picker to select what is the datastore you want to populate
-
When the datastore doesn’t exist, and you are using the action to create a new datastore, use the predefined connector target, this will create the base target and user will have to manually add the columns or copy from the source structure as needed.
-
When you want to create DATE columns, make sure to use Convert to Datastore Date function. Specify the source data date format, the function will convert the source date into a date format understood by the target datastore. If this step is skipped, the end user might not be able to perform date operations on this datastore.
-
-
Save the map, and execute the workflow. Once processing is complete, you should be able to see your datastore on the assets page, open it and preview the inserted data.
Extract record from a datastore
Use Get Record By ID action to extract a record from a datastore.
Populate the datastore name and the value of PK.
Update an existing record
In the VDM use Update Single Record target.
