Integration Hub

[Rick1]

Hello, we are looking to start using Integration HUB. Currently we have a bunch home grown integrations but will need to start using a better OOB solution.

Our data is located in our Data warehouse which is comprised of all ORACLE tables. Looking at the IH SPOKES for ORACLE they all seem to point to a specific source; ORACLE-HCM for example is one of the SPOKES.

My question is: What IH SPOKE would best be used to just connect to ORACLE Tables?

Appreciate your time on this.

Thx! 

[Ted Norlander]

I would have a look at JDBC-connections to access an Oracle DB, you most likely also need to establish a MID-server to be able to access the Oracle DB unless your organization allows for direct access from internet (which would surprise me).

Most spokes for IH are basically technical setups used to access specific application API's, hence your findings on Oracle HCM and others.

Like I said earlier...if you want to query tables on an Oracle DB try the JDBC-connector.

[Rick1]

Thank you very much!