Question on CRUD Actions w/ External SQL

taylor

If I want to consume and deserialize a message from Kafka, and then execute CRUD Actions in our external SQL Database directly from decisions using the data deserialized from Kafka, this is possible correct? I'm asking because my brief review / understanding of this would be a database structure, but then after reviewing, I'm wondering if this would have to be done in a raw sql step? Any links to existing documentation / datatype that should be used / CRUD guidelines specific for the above circumstance I'm talking about would be great!

Kathryn_Decisions

We can not currently use a database structure in an external database. However, we can integrate directly with an external database in a flow.

First, you will need to integrate with the external database: https://documentation.decisions.com/docs/external-database-integration

Then, you will need to integrate with the table from the external database: https://documentation.decisions.com/docs/integrate-with-database-table

Create a flow and use the Get All From dbo.<table_name> to get all of the data from the table. This step is found under Integration/Database/<YourDatabaseConnectionName>/<YourDatabaseTableName>.

Then use a ForEach step to create your data structure and pass in the list from the Get All From step. Then map the inputs of the Create step. Lastly, run the flow and you will now have data structures in Decisions you can use CRUD actions on populated from an external database!

Data Structure CRUD Overview: https://documentation.decisions.com/docs/data-structure-crud-overview