0

How to integrate Oracle DB/APEX with abinitio.

Scenario : I have a Abinitio code which generates the monthly report. So being database developer i wants to run same code which is in abinitio and generates monthly report. So i am looking for any connector between Abinitio and oracle DB / APEX.

Prajakta Pardeshi
  • 11
  • 1

2 Answers2

0

To integrate Oracle with another database you have different options

  1. JDBC (you have to develop this function in JAVA as ETL) (Use a software like Talend or another ETL)
  2. Oracle Link Database (You have to ask your DBA if it's possible)
  3. Expose the info in JSON and make a web service call (Develop a web service in java, node, python, as so on) and consume the json exposed.

If I were you, I would use the option number 3 because It's cleaner option.

If you need more info let me know asap.

Enrique Flores
  • 716
  • 4
  • 13
0
  1. Preliminary step: make sure that JDBC drivers is installer and accessible
  2. create DBC file for specify connection to Oracle DBMS.
  3. use m_db for generate DBC template and also for test connection from Shell or GDE
Zam
  • 2,880
  • 1
  • 18
  • 33