Forum Stats

  • 3,769,223 Users
  • 2,252,930 Discussions
  • 7,874,951 Comments

Discussions

Bypass Upgrade Assistant thru Schema export/import ?

Gururaj0-Oracle
Gururaj0-Oracle Member Posts: 78 Employee
edited Jun 8, 2020 9:55AM in Data Integrator

Scenario:

Customer is on ODI 12.2.1.2.6 on-prem and we are planning to board them to ODI on OCI Cloud(12.2.1.4).

Option 1:  Install ODI 12.2.1.4 on-prem, Invoke Upgrade Assistant and move to ODI 12.2.1.4. Export/Import on-prem schema to ODI 12.2.1.4 on Cloud Marketplace,

Option 2: Use the Existing ODI 12.2.1.4 on Cloud Marketplace. Just export and import their ODI 12.2.1.2.6  schema ?  Will this Work ? If not, why ?

Please comment any other options/suggestions as well.

Regards

Gururaj

Tagged:
Gururaj0-Oracle

Best Answer

  • Adrian_Popescu-Oracle
    Adrian_Popescu-Oracle RomaniaPosts: 1,950 Employee
    edited Jun 7, 2020 8:25AM Accepted Answer

    Hi Gururaj,

    First you need to check what kind of database is used to store the ODI repositories in ODI on Marketplace: it may be MySQL or ADB (ADW or ATP).

    Option 1 is the best, because the schemas are upgraded to ODI 12.2.1.4.

    Option 2 won't work because ODI 12.2.1.4 Studio/agents can connect only to ODI 12.2.1.4 repositories.

    A 3rd approach may also be used - Smart export of project from ODI 12.2.1.6 and Smart Import into ODI 12.2.1.4.

    This is because the Smart Import will also do the upgrade.

    But in the Oracle official documentation only the upgrade of ODI repositories is described.

    Adrian

Answers