CDT data to SQL Query

Question

Hello Everyone, 
 
 I had a requirement where I had to read an excel file and populate that excel data in a CDT (let's call it example_CDT ) for displaying that data in an interface. 
 I did that and now the whole data is there as a list of items where items are of type example_CDT . This CDT is already mapped to a table in the DB. 
 Now, I want to generate and download SQL queries that can be used to insert the data which is there in the list of CDT into the DB. 
 
 Is there any Appian smart service available through which I can convert get SQL queries from CDT data? 
 please consider example_CDT as a Nested CDT .

Mike Schmitt · Answer

AwsmeShikhar said: developers want to review the data 
 Why does this require generation / download of SQL scripts? You could simply show the data on an interface within the process instance for example.

Mike Schmitt · Answer

Is there any particular reason why you can't use the Appian Write to Data Store Entity functionality to handle this? Why the extra steps to "generate and download" SQL queries?

CDT data to SQL Query

Top Replies