Hi,

I hope this would help: JDBC Datalist Database Binder

Thanks!!

Hi, 

There are a number of ways depending on the type of integration.

Of course the JDBC connection can be used. You can also trigger a process with an import tool that will take a flat file and import it into Joget.  Import Tool

Or you can use the JSON Tool to call the ERPs API.

Cheers,

Eric 

Hi,

You can also export data into csv file from your ERP and import from MYSQL. Easy way is to download Toad for mysql freeware

"METHOD 1: Click Tools → Import → Import Wizard. This window can be used to import data from various kinds of source files into a table."

http://www.toadworld.com/products/toad-for-oracle/w/toad_for_oracle_wiki/148.how-to-import-data-from-an-excel-file-into-a-table

Regards,

TK

Hi TK, Technically that would work. However, especially for less experienced users or if this is something that is intended to be done every x hours / days / months, using the existing plug-ins may be better. It will also ensure that the data is in the right format and doesn't screw up your forms. Cheers

Thanks Eric For such an activity which is executing on regular basis, developer can write a connector, it will connect with source and target databases and map the tables accordingly. In this way data can be transferred in a single click. Regards