Skip to main content
Solved

Anyone connecting to Oracle Cloud for EiS, HCM and Financial Management solutions.

tmoreland
Participant

I'm trying to connect to Oracle cloud for the human resources and financial management services. So far, I am not having any luck. Has anyone been able to set up these connections? If we could connect to the existing EiS reports that would be a fine work around but as far as I can tell we can not have the EiS reports automatically load into a FTP site where we could grab them.

We are currently using FME 2017 but are fine upgrading if a new version is needed. Any advice or help wold be greatly appreciated.

Best answer by markatsafe

@tmoreland I thought I might try and summarize some of options you have for connecting to a enterprise databases such as an EIS or CMS.

- Direct connect to the Oracle. As @SteveAtSafe mentions, once you get the connection, you're then looking at the raw database tables and you'll have to join the appropriate tables using FME transformers such FeatureJoiner or SQLExecutor. Your DBA is unlikely to favour this approach.

- Convince your DBA to create a materialized view of the report that you want. Then you can connect to that view directly with FME.

- investigate whether your EiS offers an API (REST or SOAP). FME's HTTPCaller can then be used to retrieve the data you need.

- In some cases you might be able to automate the creation of the reports through FME. Often these reports are created through a web page, and it is sometimes possible to use the HTTPCaller to generate the reports, which you can then automate.

View original
Did this help you find an answer to your question?

5 replies

fmelizard
Contributor
Forum|alt.badge.img+17
  • fmelizardContributor
  • Contributor
  • June 19, 2018
Hi @tmoreland. Are you using FME? If yes, what version?

 

tmoreland
Participant
  • tmorelandParticipant
  • Author
  • Participant
  • June 19, 2018
Yes. We are using FME 2017 but have no problem upgrading to 2018 if needed.

 

 

tmoreland
Participant
  • tmorelandParticipant
  • Author
  • Participant
  • June 19, 2018
fmelizard wrote:
Hi @tmoreland. Are you using FME? If yes, what version?

 

Yes. We are using FME 2017 but have no problem upgrading to 2018 if needed.

 

 

steveatsafe
Safer
Forum|alt.badge.img+12
@tmoreland, If this is simply an Oracle database in the Oracle Cloud it is possible to connect. It does take some figuring out to get the correct service name, and possibly complicated by pluggable databases (containers). However, if this is some sort of service provided by Oracle through API calls then it may not be something we can do as easily as connecting to a Database. Do you have any information on what sort of connections you are thinking you can make to these systems?

 

 

What applications do you use now to connect to these systems? Can you make a connect with Oracle's SQLDeveloper tool?

 

 

(Many applications do use APIs to read/write & connect to the Oracle Services in the Cloud, this masks the databases behind the scenes. So it may be a tall order determining the underlying Database that you may not even be permitted to connect to directly) .

 

SteveatSafe
M
Forum|alt.badge.img+2
  • markatsafe
  • Best Answer
  • June 22, 2018

@tmoreland I thought I might try and summarize some of options you have for connecting to a enterprise databases such as an EIS or CMS.

- Direct connect to the Oracle. As @SteveAtSafe mentions, once you get the connection, you're then looking at the raw database tables and you'll have to join the appropriate tables using FME transformers such FeatureJoiner or SQLExecutor. Your DBA is unlikely to favour this approach.

- Convince your DBA to create a materialized view of the report that you want. Then you can connect to that view directly with FME.

- investigate whether your EiS offers an API (REST or SOAP). FME's HTTPCaller can then be used to retrieve the data you need.

- In some cases you might be able to automate the creation of the reports through FME. Often these reports are created through a web page, and it is sometimes possible to use the HTTPCaller to generate the reports, which you can then automate.

Reply


Helpful Members This Week

Community Stats

30,958
Posts
117,332
Replies
38,746
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.