Data Integration

Get Involved. Join the Conversation.

Comments

  • Matej Leban

    Hi Siddharth 

    I've installed odi Agent (ADIPC - ODI, DB12) on my machine. Agent is running while I can see it from ADIPC instance.

    How can i start ODI studio from (linux environment)? 

    Which command do I need to run to get ODI Studio up and running?

    B Matej

  • Matej Leban

    HI Julien, 

    There are 2 flavours of DIPC: DIPC Classic (User managed) and ADIPC (Oracle Managed). 
    DIPC Classic is no longer sold. We have to "follow" Siddharths Post

    BrMatej

  • siddharth Dang

    Hi Dragos,

    When you download DIPC agent, you get DIPC components along with it. Currently when you download agent for linux, you will get ODI studio along with it. Here are the oracle support links to help you understand in detail how this is done. 

    https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=v97enuz25_9&_afrLoop=330233885763836

    https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=330302338014055&id=2452537.1&displayIndex=7&_afrWindowMode=0&_adf.ctrl-state=v97enuz25_212#FIX

    Once your interfaces are developed, then you can extract the scenarios from the studio and deploy it into the cloud via the GUI. These scenarios are executed with the agents in the cloud using the data execution jobs. Try to keep the agent names in the studio the same as well to avoid any issues.

    Regards,

    Siddharth Dang

  • Raghavendra Manchigiah

    Thank you Julien.

    We will be consulting an Oracle CSM for guidance.

    Regards,

    Raghvendra

  • Julien Testut

    Hi Raghvendra,

    The ODI Execution Task is limited to Oracle, SQL Server, MySQL, Autonomous Data Warehouse, Files and Object Storage. Web Services or SaaS Apps are not currently supported. For this use case you may want to consider using OIC first, it might be worth looking at ODICS in case OIC cannot meet your requirements.

    Thanks,
    Julien

  • Julien Testut

    Hi Dragos,

    For ETL use cases we do recommend using ODICS which gives you full access to ODI. More information about how to use the ODI Execution Task is available in the DIPC doc: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/odi-execution.html#GUID-6E58FD2A-2CA9-4692-9AC7-06FB4C480E0B

    Using the ODI Execution Task requires having a separate user-managed ODI installation so this is more targeted for existing ODI users.

    Thanks,
    Julien

  • Julien Testut

    Hi Raghvendra,

    I'd recommend assessing if OIC can do this first before considering alternatives such as ODICS. Please contact your local Oracle account team who should be able to assist with this.

    Thanks,
    Julien

  • Raghavendra Manchigiah
    Hi Werner Thanks for the input. Could you kindly elaborate further in why Dipc cannot support a fusion was target? Dev is done in ODi studio where we can invoke a Fusion ws ( invokeOdiws tool). Can't we export this scenario into Dipc and execute it ? Thanks & Regards, Raghvendra
  • Werner He

    Hi Raghvendra

    You mentioned...

    we need to read transactional data from an On prem DB and invoke a  target Fusion Webservice

    ...

    DIPC won't be able to support Fusion Webservice as a target. So this is definitely not a DIPC use case. Although DIPC does have GoldenGate use case that can get transactional data out of your on prem DB, you will need find some other method to push the data into target Fusion Webservice. 

    In other words, DIPC can only solve half of your requirement.

    Thanks,

    Werner

  • Raghavendra Manchigiah

    Hi Damon

    Could you please advise on what basis DIPC cannot be considered for Web services? We have a use case where we need to read transactional data from an On prem DB and invoke a  target Fusion Webservice. Expect heavy load ~ 150 K transactions per day - or would this better handled in OIC?

    Regards,

    Raghvendra

  • Erik Castro

    Moving to correct forum for DIPC queries

  • Damon G. Brown

    Correct.  By definition DIPC is for bulk load/replicate, not web services; Integration Cloud (OIC) can handle Web Services.

  • Dragos Vilcu

    Hello ,

    about the fact you need to export / import your work .. . do you have any more details / documents ? 

    - "ODI Studio somewhere else to do the design work" : but that means you need to have at repository somewhere you can access  (would a ODI repository be even compatible? ), and maybe even similar source , targets and agents defined 

    - "export it to archive"  : what exactly do you mean by that ? exporting the work / master repository ? 

    - "then import it into the ODI Task Execution in DIPC" : do you where/how exactly can that be done (in the UI) ? 

    Thank you, 

    Dragos

  • Werner He

    The Informix connection isn't certified on DIPC.  In DIPC classic, you have access to the ODI studio, hence you will be able to connect to Informix from there.  However, Oracle has stopped offering DIPC classic to new customers.  in current DIPC running on OCI, you don't have access to the host any more, hence, you have no access to the ODI Studio.  Thus you loose that capability.

    If Informix is the source data and you are looking for the ODI use case, I would suggest you try ODICS instead of DIPC. 

    You are correct, EDQ has never supported Informix.  The only way to use data from Informix is to have some ETL tool to get the data into a Database that EDQ supports, such as Oracle Database.  

    Thanks,

    Werner

  • Werner He

    Hi Dragos,

    You are correct.  In the new DIPC, i.e., DIPC on OCI, you have no access to the DIPC host any more.  Hence you don't have ODI Studio.  Current DIPC only supports ODI Task Execution.  Basically, you will have ODI Studio somewhere else to do the design work, then export it to archive, then import it into the ODI Task Execution in DIPC.  That is the only way to use ODI functionality in DIPC on OCI.  

    So if you are looking for a full functionality of ODI use case, it is better to switch to ODICS instead of using DIPC.

    Thanks,

    Werner