Process Variable data to SQL database table

Hi All,

i have got all the data from Oracle in a Process Variable which of type CDT, 

how can i put this data into SQL database.

Thanks a lot in advance 

  Discussion posts and replies are publicly visible

Parents
  • Now you have a CDT you could use that to generate a table in your DB (I presume you mean 'MySQL' as opposed to MS SQL Server?). Or you can hand-build a table that matches the CDT format. Either way, adding the CDT to a datastore that connects to your DB and publishing it will allow you to use the 'Write to Datastore' Smart Service in you process to write the data.

Reply
  • Now you have a CDT you could use that to generate a table in your DB (I presume you mean 'MySQL' as opposed to MS SQL Server?). Or you can hand-build a table that matches the CDT format. Either way, adding the CDT to a datastore that connects to your DB and publishing it will allow you to use the 'Write to Datastore' Smart Service in you process to write the data.

Children
No Data