Data Loading From SQL Developer : Installing an Application into your Database Schema Service

There are three tasks you need to perform before you can perform the data upload from SQL Developer:

  • Change the password for the SFTP user
  • Create a cloud connection user in your Database Schema Service
  • Create a cloud connection in SQL Developer

 

Change the Password for the SFTP User

You need to change the password for the SFTP user defined for your Database Schema Service. Perform the following steps:

Step 1: Sign In to your Database Schema Service. Click Sign In from the main cloud page.

 

Step 2: Make sure the correct Data Center is selected and click Sign In to My Services.

S2

Step 3: Enter your Identity Domain value as received in the Oracle Cloud Service activation email and click Go.

s3

Step 4: Sign in as the database administrator user for your service and click Sign In.

 

s4

 

Step 5: In My Services, click the name of your Database Schema Service.

 

s5

 

Step 6: Make note of the Service SFTP Host & Port and the Service SFTP User Name. You will be using these later to define a connection. Note: You want the Service SFTP information for your Database Service, not the Domain SFTP information for your entire identity domain.

s6

 

Step 7: Click the link in the Service SFTP User Name field. This will bring you directly into the Users tab, with only your Service SFTP User listed. On the right side of the screen, click the icon with 4 horizontal bars, and from the pop-up window, click Reset Password.

s7

 

Step 8: Enter a new password, confirm the new password, and click Save. Keep a note of the new password that you entered.

 

s8

 

Step 9: Click Save. Next, you need to create a a cloud connection user in your Database Schema Service.

s9

 

Create a Cloud Connection User in Your Database Schema Service

You need to create a user to load the tables and data into your Database Schema Service. Perform the following steps:

Step 1: In the previous step, you were in the Users tab of My Services. Click the Dashboard tab. Click your database name.

ss1

 

Step 2: You are in the Overview tile of the Dashboard tab. Note the URL in the Service Instance URL field. If you hover your mouse over the URL, a pop-up shows the complete URL. Right-click the URL and select Copy link address from the context menu. Then paste the URL into a text file so that you can copy and paste it in the next section.

ss2

Step 3: Make note of the port number at the end of the Service SFTP Host & Port field. In this example, the port number is 22. This is the URL and Port Number you need to specify in the next section when you create a SQL Developer connection to this Database Schema Service.

 

ss3

 

Step 4: Click on Open Service Console.

ss4

 

Step 5: Click tools icon from top right corner of Oracle Application Express home page and select Manage Users and Groups.

ss5

 

Step 6: Click Create User>.

ss6

 

Step 7: Enter the required information (Username, Email Address, Password). Change Require Change of Password on first User to No, and select SQL Developer from the list of User Groups. Then click Create User.

ss7

 

Step 8: The user is created successfully. Next, you create a Cloud Connection in SQL Developer.

ss8

 

 

Create a Cloud Connection in SQL Developer

In this section, you add some tables from another database into your Cart and deploy to the cloud. Perform the following steps:

Step 1: Open SQL Developer. Note: You must have release 3.2.10.09 or later. From the Connections window, Right-click Cloud Connections and select New Cloud Connection…

sss1

 

Step 2: Enter the following information and click OK.

Connection Name Identity Domain of your service
Database Username Name of user with SQL Developer user group
Database URL URL to Database Schema Service, which you saw in My Services -> database -> Details -> Overview tab, as shown earlier in the screenshot of Step 2 in the “Create a Cloud Connection User in Your Database Schema Service” section of this OBE
SFTP Username User from email that you changed password for
SFTP Hostname Service sftp hostname from email
SFTP Port Service sftp port which you saw in My Services -> database -> Details -> Overview tab

sss2

Step 3: The Cloud Connection is created. Click + symbol beside your cloud connection to expand the node.

sss40

 

Step 4: The connection to your Database Schema Service is successful. Now you can see the tab;eYou are now ready to load data into your Database Schema Service.

sss3

 

 

Leave A Reply

Your email address will not be published. Required fields are marked *