Data Integration

Get Involved. Join the Conversation.

Posts

  • Dragos Vilcu
    using ODI Studio with DIPC ?9
    Topic posted April 12, 2019 by Dragos VilcuRed Ribbon: 250+ Points, tagged DIPC 
    Title:
    using ODI Studio with DIPC ?
    Content:

    while in DIPC - C (Classic) it was possible , by connecting through SS tunneling to some instance with ODI Studio ,  to use ODI Studio and connect to DIPC - C repository , according to the documentation there is no such option anymore for  DIPC  : " You won't have access to the database and storage associated with your instance."

    in such conditions, what are the options of developing an ELT for DIPC ? I couldn't find any documentation on this fundamental problem . the only thing I found in the documentation was "If you need ODI Studio, run it from a user-managed instance or on-premises, and then import/export the design work. You won't have access to WebLogic Server to fix an ODI data source. Instead, you must file a report to the operations team." ,  but that phrase is hardly sufficient to understand how can it be really done in practice... any other documentation available on this topic ? 

     

     

  • 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.

  • Dragos Vilcu
    web services as source for DIPC6
    Topic posted April 19, 2019 by Dragos VilcuRed Ribbon: 250+ Points 
    Title:
    web services as source for DIPC
    Summary:
    web services as source for DIPC
    Content:

    Hello ,

    can DIPC (not DIPC - Classic) use web services as a source ? it seems not, as per "ODI Execution" certification matrix .

    Thank you

     

  • Gunapareddy Kishore
    While Loading assignment details through HSDL we are getting...65.0
    Topic posted August 30, 2018 by Gunapareddy KishoreBronze Medal: 1,250+ Points 
    Title:
    While Loading assignment details through HSDL we are getting error
    Summary:
    Error: Work terms records are required when you create or update assignments
    Content:

    Hi,

    We are trying to update the assignment details through HSDL we have added the required columns but while it's importing the data we are getting the below error

     

    Error:Work terms records are required when you create or update assignments
     

    Regards,

    Kishore

    Image:
  • Mark Hamilton
    DIPC Remote Agent RegistrationAnswered5
    Topic posted August 16, 2019 by Mark HamiltonGreen Ribbon: 100+ Points, tagged DIPC, ODI, Provisioning 
    Title:
    DIPC Remote Agent Registration
    Summary:
    Problem with Registration
    Content:

    Hi,

    I am trying to setup Data integration Platform Cloud.

    I am following the guide which instructs me to download the agent package from the platform. I have done this for windows.

    When I run the dicloudConfigureAgent.bat or .sh for Linux file, I am prompted for some parameters. I could not see how to add the parameters into the file, as mentioned in the guide. I enter them and the program creates an agent instance. When I go into this instance domain / folder I only see one sub-folder called, Conf, but there should be a bin sub-folder with the startAgentinstance.bat file within it. This has not been created. I expect that I have not entered some parameters properly. One guide mentions that a cloud username and password is required but I am not asked for those from the program. Please can you help? 

    Kind Regards,

    Mark

    Version:
    DIPC current Cloud version
  • David Tran
    Can OIC poll for file creating in FTP directory?5
    Topic posted February 15, 2019 by David TranRed Ribbon: 250+ Points, tagged Cloud, Data Transformation, Tip 
    Title:
    Can OIC poll for file creating in FTP directory?
    Summary:
    Trying to poll a directory in an FTP for new files
    Content:

    Hello All!

    I need to trigger an integration for when a new file is uploaded into an FTP directory. Is this possible?

    Any help will be appreciated.

    Thanks!

  • Rashmi Rao
    SFTP Delivery option in HCM Extracts4
    Topic posted September 14, 2018 by Rashmi RaoBronze Trophy: 5,000+ Points 
    Title:
    SFTP Delivery option in HCM Extracts
    Summary:
    I have developed a custom HCM Extract and want to deliver it to the client's SFTP Server.
    Content:

    Business requirement is to create a custom HCM Extract and deliver it to the SFTP Server.I have added the SFTP details in the the BI Publisher Administration option but now how to use it with my custom extract.

  • Raghavendra Manchigiah
    Integration Usecase3
    Topic posted May 9, 2019 by Raghavendra Manchigiah, tagged Data Transformation, DIPC, ODI, On-Premise 
    Title:
    Integration Usecase
    Summary:
    On Prem DB to SaaS Integration
    Content:

    Dear Experts,

    We are evaluating PaaS offerings to implement the following Integration use case :

    Integrate transactional data from an On-Prem MS SQL Server DB to Fusion Cloud ERP. We expect the load to be heavy ( 150K transactions daily) and are considering ODICS to implement it . Additional requirements include field level validations before submitting payload to Fusion webservice.

    Is this doable in ODICS or is OIC recommended( There may be a need for certain amount of orchestration)

    Kindly advise

    Regards,

    Raghvendra

     

     

  • Nirmal Kumar
    Pull data from on-premise Oracle DB into PaaS database using...3
    Topic posted January 16, 2019 by Nirmal KumarRed Ribbon: 250+ Points, tagged Cloud, Data Transformation, On-Premise 
    Title:
    Pull data from on-premise Oracle DB into PaaS database using DB link
    Summary:
    Pull data from on-premise Oracle DB into PaaS database using DB link
    Content:

    Hi All,

    Please advise how to Pull data from an on-premise Oracle DB having DB link into Oracle PaaS database.

     

    Thanks,

    Nirmal

  • Subrahmanyam Vempati
    ODI-Read files from SFTP Server25.0
    Topic posted October 17, 2019 by Subrahmanyam VempatiBronze Trophy: 5,000+ Points, tagged Cloud, ODI, Tip 
    Title:
    ODI-Read files from SFTP Server
    Summary:
    ODI-Read files from SFTP Server
    Content:

    Hi ,

    We want to read the files from SFTP server and process in ODI. Is there any way we can read the file content directly , Instead of loading it in local folder and process.

    Thanks,

    Vempati

    Version:
    ODI 12c