With the August 2020 release, Oracle Integration now includes a great new feature that allows you to export all the design-time meta-data from your instance into a single export file stored on OCI Object Storage. That same export file can then be imported into a different instance of Oracle Integration, effectively giving you a complete migration and/or backup capability. There are several options that can be chosen when configuring an export job depending on your intended use and we will explore those a bit later on.
I have also included a Further Reading section at the bottom of this guide that will take you to the relevant documentation for this UI and it’s underlying API’s – should you wish to automate these activities in your devops processes.
This guide will walk you through these major steps:
Before we get started creating export jobs, we must create a storage bucket in OCI and then configure secure access so that Oracle Integration can connect to your storage bucket. Let’s first go and create a storage bucket in OCI and then we will come back to Oracle Integration to configure and use it.
First, open your OCI console for your cloud account. Next, locate “Object Storage” in the left sidebar menu and select the sub menu “Object Storage” i.e. Object Storage Object Storage
This will open a page that lists all the storage buckets you have in the current compartment. Note in the image below, I have already selected a compartment called “steve_tindall”. You should select an appropriate compartment for your storage buckets.
Click the “Create Bucket” button and fill in the required information. I took all the defaults except for the name. From the screenshot above you can see that I created a bucket called “oicmigrations”.
Next, select you bucket from the list to open the bucket details screen.
From here you can see that you have created a new bucket and that bucket is empty. At this point we need to take note of the namespace for your bucket. You will need this later on when configuring the Oracle Integration Import/Export UI. I suggest copying this text, along with the bucket name now, and pasting it into a text document for later use.
To create an Auth Token, click on your Avatar in the top right of the OCI console and select your username under the heading “Profile” in the menu.
This will bring you to your profile page where you can create your Auth Token. On the left of the page under the heading “Resources” you will find several links including “Auth Tokens”, click on this to list your existing tokens.
Click the “Generate Token” button to create a new token. Give the token a description. I gave mine a description of “Import-Export Token”.
When you generate your token (see image below) YOU MUST COPY the token straight away. You will not be able to see this token or retrieve it ever again. I suggest you copy it straight away and paste it into a text document. You will need it in the next step.
Now we have a storage bucket ready to go, but before we can run an export job in Oracle Integration, we need to connect our Integration instance to our storage bucket.
To do this, open you Oracle Integration instance homepage and the click on “Settings” in the left sidebar. Under the settings menu you will find “Storage”. This is where you configure you Oracle Integration instance to connect to your storage bucket.
On this page you need to fill in all four of the fields as follows:
Once you see the green banner appear saying that you have saved the storage bucket config successfully, you are good to move onto the next step.
Now we can finally configure the export job in Oracle Integration. Under the settings menu in the left sidebar you will find the Import/Export UI.
To create a new export job, click the “Export” button in the top right corner of the Import/Export screen. You will see a configuration drawer slide out from the right side of the page.
Coincidently, this new slide-out draw feature of the UI is now used throughout the whole Oracle Integration UI for these types of configuration tasks.
The required information to create a job is simple and quite self-explanatory. You need to provide a Job Name, choose whether to include security artefacts, and a Description. You will also note that the storage bucket name you defined in the Storage configuration UI is listed here indicating that this is the target location for this export job. See the image below for reference.
The security artefacts that will be exported with your meta-data are as follows:
Once you have completed all the fields, click the “Start Export Job” button. The export will take anywhere from 3 to 15 minutes to complete.
Once completed, you can check that the export file was generated successfully by looking at your bucket in the OCI console. See image below showing the zip file created in my “oicmigrations” bucket called “Steve-Blog-Export.zip”. Note that during the export process you will see several temporary files written to the storage bucket. Do not delete or move these files. The export process generates many files during its operations and then finally puts them all in one resulting zip file with the name of your export job. Only once you see this file can you use it correctly.
We are now onto the final step in this guide. Let’s take our export file and import it into our target Oracle Integration instance.
Before we can do that though we need to configure your target instance to read the storage bucket just like we did in the first instance. Following the same steps, configure your target instance using the fields on the Storage page under Settings in the left sidebar.
Next, click “Import/Export” in the left sidebar. You should see an empty list of import jobs (unless someone else in your company has already run an import).
Click the “Import” button in the top right of the page. You will see a configuration drawer slide out from the right side of the screen. Here you can configure the options for importing an export file into your Oracle Integration instance. There are several options for importing into your instance. These are explained below.
The different import options allow you to control the state of the integrations and processes after the import job completes. The simplest option is to tick all options. If you tick all options the import job will do the following:
It is important to note that you can execute an import without choosing Activate or Start Schedules. This is useful if you know you need to change some of the endpoints in your connections (say from test systems to production systems) before you want them to be active. If you are using the import/export tool, for example, to move integrations from a test instance to a production instance, you might want to follow a sequence similar to this:
This third step will cause the integrations in the in the export file (which are now already in your target instance as well) to be activated and to have their schedules started without replacing their meta-data or updating their respective connection credentials.
Lastly, you can check the status of you job, for both import and exports, by clicking on the job name in the Import/Export UI. This will expand the list with details of the job and it current status. It the image below, you can see that for my job, the Process component of the export has completed but the integration component is still running. You can also see the overall status of the job next to the job name.
Finally, if you need to debug a problem, you can download a log of what was exported. You will find this download icon next to the job name ONLY AFTER the job has completed. This will download a full report of the import or export job.
The documentation for these new features can be found here: https://docs.oracle.com/en/cloud/paas/integration-cloud/oracle-integration-oci/import-and-export-instances.html
If you would like to automate this export and import process, so that it could be included in your automated devops processes or your CI/CD pipelines for example, you can call the underlying API's in Oracle Integration server by following this documentation in the admin guide: https://docs.oracle.com/en/cloud/paas/integration-cloud/integration-cloud-auton/export-integration-and-process-design-time-metadata-instances.html