Skip to main content
Question

Setting up live connection with Informatica

  • August 23, 2024
  • 1 reply
  • 80 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

    Community Code of ConductAccessibility statement