Can TCI (Develop) INSERT in to a mysql DB or only SELECT

[Scott Farnsworth]

I can't find very specific documentation about the MySQLQuery action in the docs or on the community site. I'm thinking that perhaps it only supports a SELECT type of query to get data out, but i'm curious to know if I can use it to put data in to a DB I have a use case where I want to accept data from an endpoint and then write it in to a DB. Am i going about it the right way

I had gotten some error about the go connector not being able to cast it as a select, I'm not able to reproduce that error currently though.

[Vinay Khatri]

Hello,

There is a MySQLInsert activity which allows you to write data to the DB. Below is the link to TCI docs which has more details :

https://integration.cloud.tibco.com/docs/#Subsystems/flogo-mysql/connector-users-guide/mysql-insert.html

If you are seeing any specific error while using this activity I suggest you to open a case so that we can troubleshoot this further.

Thanks,

Vinay