How i can create a insert query in a connector?

Q&A
1

Hi ,

I want to create a insert query , and for do this i create a connector and then i put my insert query, but i could not try because the try button was disabled.

Regards

2

There must be something wrong with your connector definition…you need to check it.

3

Also I recommend to use your database administration tool to test your insert query and then copy paste it to the connector configuration. Use a groovy script if you want to dynamically build it.

Note that if possible I really advise to use Business Data Model. That make all database storage a lot easier.