Skip to main content
Question

Setting up live connection with Informatica

  • August 23, 2024
  • 1 reply
  • 37 views

shayan.sarka12
Level 1
Forum|alt.badge.img+4

Hi Celopeers,

I would like to set-up a live connection with Informatica for fetching data for Celonis. What would be the best way to go about it?

1 reply

mateusz.dudek14
Level 11
Forum|alt.badge.img+11

Hi,

 

Usually it's pretty straightforward:

 

  1. Check if there's standard connector (Probably not)
  2. Check if there's REST API / OData to get the data
  3. Try to use option to build custom extractor using custom extractor builder in Data Integration module
  4. If for any reason you're missing a option to fully utilise that API (f.e. authorization requires series of requests to first get auth token) or don't like it (like me) - just write your own. You can prototype in Postman (Postman: The Complete Guide - REST API Testing | Udemy) and autogenerate python code, to be used in ML workbench along with PyCelonis / Data Push API.

 

With that case, as it's "Intelligent Data Management cloud" you can also make it the other way around, utilising only Data Push API and using that platform - up to you.

 

Link: Cloud API and Application Integration | Informatica

Link2: Data Upload - PyCelonis

Link3: Getting Started (celonis.com)

 

Best Regards,

Mateusz Dudek