Is it possible to collect/connect Aveksa to a Progress/OpenEdge Database?
Both from a collection and from an AFX point of vue?
There is no available drivers and class for that DB type on Aveksa and AFX.
Any idea/though on this?
Add the JDBC driver file to the EAR file as explained below.
HowTo: Installing jTDS drivers in wildfly Via 7.0
A database type ADC can be created as shown below. Similarly EDC can be created.
For AFX the process is similar. Add the JDBC JAR file to the esb library and create a connector as shown below. ( I have not tested this approach but I see no reason why it shouldn't work).
Even though the template is for MS SQL you should be able to modify the driver class name.
Pradeep, you say "Add the JDBC JAR file to the esb library ".
Can you be more specific with the path?
Just add the JAR file to /home/oracle/AFX/esb/lib/user an restart the AFX server.
I suspect /home/oracle/AFX/esb/lib/user is for 6.8.1 and perhaps 6.9 (some patch?)
I am thinking /home/oracle/AFX/mule/lib/user may be the equivalent 6.9.1 location.
Quick clarification: up to v7.0 it was AFX/mule. From 7.0.1 onward it has been changed to AFX/esb.
Thanks for the clarification, I saw that as well.
My initial query was to find out to connect (from an account collector) to a OpenEdge DB table/view.
Aveksa doesn’t have a default out of the box DB connector for OpenEdge, like it does have for Oracle, SQLServer…
Group IT | firstname.lastname@example.org<mailto:email@example.com> | Tel: +27 11 286 8063 | Cell: +27 76 920 8549
Client Support Centre: +27 11 286 9663 / 0860 110 161 | www.investec.co.za <https://www.investec.co.za/>
“The best way to get started is to quit talking and begin doing.”
Retrieving data ...