For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
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 ?
Comment
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
Average Rating:



1 rating
|
Sign in to rate this
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
Be the first to rate this
|
Sign in to rate this
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
Be the first to rate this
|
Sign in to rate this
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
Be the first to rate this
|
Sign in to rate this
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
Be the first to rate this
|
Sign in to rate this
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
Be the first to rate this
|
Sign in to rate this
Hi Mate,
If you dont see ODI studio then download one and install it like a normal ODI studio and follow the link to configure it to connect to DIPC.
https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/tutorial-odistudio-compute/
Regards,
Siddharth Dang
Be the first to rate this
|
Sign in to rate this
Hi Siddharth,
the referenced document seems to apply only to user-managed DIPC (classic) because one of the steps includes connecting with SSH to the DIPC virtual machine where the ODI server is installed and downloading some files.
The product change name in January 2019 is a nightmare because some documentation has not been updated becoming confusing.
2018 name - 2019 name
DIPC Autonomous -> DIPC
DIPC -> DIPC Classic
Begoña Villamor.
Be the first to rate this
|
Sign in to rate this
Hi Dragos,
Did you managed to set up ODI Studio with DIPC? Did you need a database (out of DIPC) to create ODI repository?
Thanks!
Be the first to rate this
|
Sign in to rate this