Create a Data Integration Platform Cloud Classic Instance on OCI Classic

Before You Begin

This tutorial shows you how to create a Data Integration Platform Cloud Classic Instance on Oracle Cloud Infrastructure (OCI) Classic. While this tutorial takes approximately 30 minutes to complete, it doesn't include wait times for instances to be provisioned.

Background

Data Integration Platform Cloud Classic is an Oracle Cloud service that offers a single platform to connect to hundreds of on-premises and cloud data sources. From this platform, you extract, load, and transform (ELT) data entities of any shape and format, synchronize or replicate selected data sources, integrate with big data technologies, perform data analytics, and maintain data quality.

When you create an Oracle Data Integration Platform Cloud Classic service instance, you create a Data Integration environment in the cloud. Data integration applications are installed for you on one or more VMs which offer you consoles to perform all your data integration needs.

For Data Integration Platform Cloud Classic, you can select one of the following editions:

• Standard Edition: For a bulk copy of your data sources to the cloud, or to extract, load and transform your data.
• Enterprise Edition: For a selective copy or real time replication of your data sources, or to extract, load and transform your data.
• Governance Edition: To extract, load, transform, manage, replicate, and maintain data quality.

For this tutorial, you create an instance with Governance Edition.

What Do You Need?

• The link, username and password for your Oracle cloud services.
• A web browser

Create a Database Deployment

1. Log in to Oracle Cloud.
2. Open the navigation menu in the upper left corner, select Data Management, and then Database Classic.
3. On the Instances page, click Create Instance.
4. Complete the Instance page as follows, and then click Next: (You may see less fields according to your subscription type.)
   • Instance Name: DBCSDEF
   • Description: DEF database for DIPC 
   • Notification Email: <a valid email address to receive provisioning status>
   • Region: No Preference (If you select a region, then you'll get a deployment on Oracle Cloud Infrastructure (OCI) and you can't use it for the DIPC instance in the next section.)
   • Tags: warehouse (Click the Click to Create a Tag button, create a tag called warehouse and then click OK.)
   • License Type: Select the appropriate license option
   • Software Release: Oracle Database 12c Release 1
   • Software Edition: Enterprise Edition
   • Database Type: Single Instance



5. On the Details page, complete the Database Configuration fields as follows, and then click Next:
   • DB Name: ORCL
   • PDB Name: PDB1
   • Administration Password and Confirm Password fields: password
   • Usable Data Storage (GB):25

   The entry for Usable Database Storage, populates the Total Data File Storage (GB) field to reflect the amount of storage for your instance, such as space for operating system and product binaries, supporting files, database data and configuration files. After you create the instance, you can add more data storage later.

   • Compute Shape: OC3 - 1.0 OCPU, 7.5 GB RAM
   • Click Edit for SSH Public Key.
   • In the SSH Public Key for VM Access dialog, select Create a New Key, then click Enter.

     

   • Click Download in the Download Keys dialog.
   • Save the sshkeybundle.zip file to your computer.
   • Confirm that the SSH Public Key field now contains a public key value.

   

6. Expand Advanced Settings, and then complete the fields as follows:
• Listener Port: 1521
• Select your timezone from the Timezone menu.
• Select Enable Oracle GoldenGate.
• De-select Include "Demos" PDB to save database space.



7. Complete the Backup and Recovery Configuration fields as follows, and then click Next:
• Backup Destination: Both Cloud Storage and Local Storage
• Cloud Storage Container: The container field is automatically filled with the proper container URL format. This format is the REST Endpoint URL you found in step 1-7, appended with a slash and then the container name. If you want a new container created for you, just append a new name (it can be different name than the pre-populated one). For this tutorial, change the pre-populated container name which is dbcs-DBCSDEF with the name, dbcsDEF.
  Format: rest_endpoint_url/containerName
  Example: https://dipc.storage.oraclecloud.com/v1/Storage-dipc/dbcsDEF
• Username: Enter the username for Storage Classic, Database and Data Integration Platform Cloud Classic.
• Password: Enter the password.
• Create Cloud Storage Container: Select

Note: If your Storage administrator has already created a container for you to use, then deselect this checkbox and use the existing container name in the Cloud Storage Container field with the format of rest_endpoint_url/existingContainerName



8. Click Next and ensure that in the Confirm step, you get a message that the container was created.

   

9. Review the details for your database cloud deployment. If you need to make changes, click Previous or use the navigation train to go back. Otherwise, click Create.
10. Click the DBCSDEF instance and refresh the Service Overview page until the status displays Ready.

Create a Data Integration Platform Cloud Classic Instance

1. In the Oracle Cloud Infrastructure console, open the navigation menu, select Platform Services, and then Data Integration Platform Classic.
2. On the Instances page, click Create Instance.
3. Complete the Instance fields as follows, and then click Next:
• Service Name: DIPCDEF
• Service Description: Data Integration Platform Cloud Classic for DEF instance
• Notification Email: <a valid email address to receive provisioning status>
• Tags: DEF (Click the plus symbol to create a tag called DEF)
• Cluster Size: 2
• Service Edition: Governance Edition (Refer to Before you Begin section of this tutorial to learn more about these editions.)

  

4. Complete the Database Configuration fields as follows: (This database is used to store the schema of the Data Integration Platform Cloud Classic server for this instance.)
• Database Service: DBCSDEF
• PDB Name: PDB1
• Username: SYS
• Password: password



5. Complete the Backup and Recovery Configuration fields as follows:
• As a rule of thumb, for Storage containers you enter the URL of a new or existing container in the format of the REST Endpoint URL that you found in step 2-6 and you append it with a slash and then the container name. If you want a new container created for you, you append a new name, instead of an existing container name, and then select the checkbox to create the container. (For this tutorial, you create a new one. Not all services , pre-poluate the REST endpoint URL for the Cloud Storage Container field so it will come in handy to know how to find the REST endpoint URL.)
  Format: rest_endpoint_url/containerName
  Example: https://dipc.storage.oraclecloud.com/v1/Storage-dipc/dipcDEF
• Cloud Storage Username: Enter the username for Storage Classic, Database and Data Integration Platform Cloud Classic.
• Cloud Storage Password: Enter the password
• Create Cloud Storage Container: select checkbox

  

6. Complete the WebLogic Server Configuration fields as follows, and then click Next:
• Compute Shape: OC3m - 4.0 OCPU, 60.0 GB RAM
• Click Edit for SSH Public Key.
• Separately, in your computer's file browser, find the zipped folder containing the system generated key for the database deployment, called sshkeybundle.zip and unzip it. (Refer to section 2-5 of this tutorial. You can also create a new key for this section.)
• In the SSH Public Key for VM Access dialog box, select Key File Name and then browse to sshkeybundle folder and select publicKey. Then click Enter.



• Administrator Username: <Your choice of username to access consoles of Data Integration Platform Cloud Classic>
• Password: <Your choice of password for the username in this section>
• Confirm Password: <Confirm your choice of password for the username in this section>

  

7. Review the details for your Data Integration Platform Cloud Classic instance. If you need to make changes, click Previous or use the navigation train to go back. Otherwise, click Create.
8. On the Instances page, confirm that the DIPCDEF instance appears in the list of instances with the Status displayed as: Creating service...

   

9. Refresh the Instances page until the Status: Creating service ... is no longer displayed on this page.
10. Click the DIPCDEF instance to go to the Instance Overview page and then confirm that the Status field displays Ready.
11. Go back to the Instances page, click the Action Menu of DIPCDEF, and then click Data Integration Platform Console to access this console.

Want to Learn More?

• Data Integration Platform Cloud Classic on Oracle Help Center
• Data Integration Platform Cloud Classic on Oracle Cloud Website
• Oracle Database Cloud on Oracle Help Center