One Star

[resolved] Connecting via ODBC to Progress Openedge in Talend

I have requirement to connect to Progress Openedge DB through ODBC in Talend.Please let me know how do i get the openedgedrivers odbc drivers configured in Talend.
also would be hitting progress DB from Talend through ODBC to insert/update/merge data. will the talend component take care of insert in Progress DB. my concern is do we need to write progress compatible queries to perform insert/update or merge.
Seventeen Stars

Re: [resolved] Connecting via ODBC to Progress Openedge in Talend

The components you need are called tDBInput for reading table data via ODBC and tDBOutput to write data into a table via ODBC.
Of course you can differentiate between insert/update and delete.
You can also create a connection based on ODBC in the metadata section to get all tables and columns.