Data Integration

Get Involved. Join the Conversation.

Posts

  • Athena Chou
    Request a sample script to import data into ERP CLOUD from...15.0
    Topic posted August 14, 2018 by Athena Chou, tagged Cloud, On-Premise 
    Title:
    Request a sample script to import data into ERP CLOUD from On-Premise EBS
    Summary:
    Request a sample script to import data into ERP CLOUD from On-Premise EBS
    Content:

    Hi,

    Could you provide a very simple script or store procedure to show how to call webservice to import data into ERP Cloud from EBS?

    For example, user maintain supplier master data in EBS, and we would like to sync this data to ERP Cloud.

    Another question, is there any extra configration for EBS if we use store procedure to call WebService?

    Thank you

    Athena

     

    Code Snippet:
  • Rama Pedamallu
    ADFS (Active Directory Federation Services) related...11.0
    Topic posted June 22, 2018 by Rama Pedamallu, tagged Cloud 
    Title:
    ADFS (Active Directory Federation Services) related issue
    Summary:
    ADFS (Active Directory Federation Services) related issue
    Content:

     we implemented ADFS on our Oracle ERP. we have hybrid screen now. Next 2 weeks, we are planning to disable Hybrid screen. In that situation, using URL, users can directly log into Oracle ERP without entering login credentials.

      Incase of any issues with Active Directory, users can't log into Oracle ERP. Is there any backdoor entry/ any other option to get hybrid page (without creating SR with Oracle to enable hybrid page)? 

  • Tarun Dadhich
    HCM Extract - How to avoid sending blank file15.0
    Topic posted May 9, 2018 by Tarun DadhichGold Medal: 3,500+ Points, tagged Cloud 
    Title:
    HCM Extract - How to avoid sending blank file
    Content:

    Hi Everyone,

    We are developing a HCM extract to send email with attachments. The interface will be a changes only interface and will be scheduled daily. We don't want to send the email if there is no data extracted. Appreciate your help. 

    Delivery Type is Email and HTML/Excel will be the Template.

    Regards,

    Tarun

  • Rama Pedamallu
    How to use "Web service" as data source to send...15.0
    Topic posted April 30, 2018 by Rama Pedamallu 
    Title:
    How to use "Web service" as data source to send data to Service Now from Oracle
    Summary:
    How to use "Web service" as data source to send data to Service Now from Oracle
    Content:

    Hi

      we are implementing Procurement module in Oracle cloud. we need to send PO information from Oracle to Service Now. We are using "Web Services" as data source. I want to send PO information to Service Now to Oracle using "Web Service" as data source.

    I am able to configure Web Services data Source in Oracle. But unable to find info on how to use this data source to transmit data from Oracle to Service Now.

    If any one provide some info on the process, will definitely helpful to me.

  • Ramprasad Nomula
    Stored Procedure13.0
    Topic posted April 18, 2018 by Ramprasad NomulaGreen Ribbon: 100+ Points 
    Title:
    Stored Procedure
    Summary:
    Stored Procedure
    Content:

    Hi All,
    Please help me to how to call a stored procedure in document script section in SQL

  • Ramprasad Nomula
    ODI Package14.0
    Topic posted April 2, 2018 by Ramprasad NomulaGreen Ribbon: 100+ Points, tagged ODI, Tip 
    Title:
    ODI Package
    Summary:
    ODI Package
    Content:

    Hi
    I imported a package in to ODI 11g,while I  am checking I face some issue.Please help me by checking the below Screen shot "Linked objects are missed" All intrefaces and variables available in my Project

     

     

     

    pastedImage_0.png

  • Prakash Penugonda
    What is the step by step process to integrate PBCS and HCM1
    Topic posted March 29, 2018 by Prakash Penugonda 
    Title:
    What is the step by step process to integrate PBCS and HCM
    Summary:
    What is the step by step process to integrate PBCS and HCM
    Content:

    I have seen Oracle Document already but anyone can explain me step by step it would be better.

  • Ramprasad Nomula
    Moving ODI objects15.0
    Topic posted March 29, 2018 by Ramprasad NomulaGreen Ribbon: 100+ Points, tagged ODI 
    Title:
    Moving ODI objects
    Summary:
    Moving ODI objects
    Content:

    Hi All,

    I am trying to  moving interface from one project to another project in ODI 11g.
    Below are the my test cases

    I) i) I  exported interface from new project and deleted from that project

       ii) Imported in to existing project ( but I faced an issue here: instead of importing to existing project again in sits into new project{where from I exported})

     

    2)  i) I  exported interface from new project and deleted from that project

         ii) Directly I tried to move(Drag from new project to existing), here it throws an error "ODI-20057 you cannot move an interface into a folder belonging to another project.

     

    Please help me to solve this

  • Vasanth Mareedu
    When ODICS certification will be released?15.0
    Topic posted March 23, 2018 by Vasanth Mareedu, tagged ODI, Tip 
    Title:
    When ODICS certification will be released?
    Summary:
    When ODICS certification will be released?
    Content:

    Hi,

     

    Could you please let me know the date of ODICS certification available date?

  • Nagesh Nadimatla Ext
    Redshift Data server connectivity issue with standalone...85.0
    Topic posted February 23, 2018 by Nagesh Nadimatla ExtGreen Ribbon: 100+ Points, tagged Big Data / Data Lake, Cloud, ODI, Tip 
    Title:
    Redshift Data server connectivity issue with standalone agent in ODI 12.2.1 on windows server
    Summary:
    Redshift Data server connectivity issue with standalone agent in ODI 12.2.1 on windows server
    Content:

    I have configured Redshift Data server in ODI for this i have copied the suitable JDBC drivers for Redshift in odi installed folder.

    After this when I am trying to test Red shift connection from local agent it is connecting successfully. But trying to test it from standalone agent it is giving below mentioned error.

     

    I have done below changes in Redhsift Dataserver and added the Jdbc drivers in below mentioned paths. Before testing the connection i have restarted Admin server and ODI Agents :

    JDBC Driver:com.amazon.redshift.jdbc42.Driver

    JDBC URL: jdbc:redshift://endpoint:port/database

    pastedImage_2.png

    Path

    C:\Oracle\product\middleware\odi\odi\sdk\lib\RedshiftJDBC42-1.2.10.1009.jar

    C:\Oracle\config\odidev-domain\lib\RedshiftJDBC42-1.2.10.1009.jar

    C:\%APPDATA%\Roaming\odi\oracledi\userlib\RedshiftJDBC42-1.2.10.1009.jar

     

    Error:

    oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: Could not load JDBC driver class [com.amazon.redshift.jdbc42.Driver]

    at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:439)

    at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invoke(InternalRemoteRuntimeAgentInvoker.java:162)

    at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:1118)

    at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:664)

    at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$9.doInBackground(SnpsDialogTestConnet.java:622)

    at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)

    at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)

    at java.lang.Thread.run(Thread.java:748)

     

    Please guide me to resolve this issue. Thank you in Advance.