Hi,
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?
Regards
Armel
Hi,
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?
Regards
Armel
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…
Regards
Armel Lupapi
Group IT | armel.lupapi@investec.co.za<mailto:armel.lupapi@investec.co.za> | 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.”
Add the JDBC driver file to the EAR file as explained below.
The specified item was not found.
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.