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.
Step 3: Enter your Identity Domain value as received in the Oracle Cloud Service activation email and click Go.
Step 4: Sign in as the database administrator user for your service and click Sign In.
Step 5: In My Services, click the name of your Database Schema Service.
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.
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.
Step 8: Enter a new password, confirm the new password, and click Save. Keep a note of the new password that you entered.
Step 9: Click Save. Next, you need to create a a cloud connection user in your Database Schema Service.
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.
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.
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.
Step 4: Click on Open Service Console.
Step 5: Click tools icon from top right corner of Oracle Application Express home page and select Manage Users and Groups.
Step 6: Click Create User>.
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.
Step 8: The user is created successfully. Next, you create a Cloud Connection in SQL Developer.
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…
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|
Step 3: The Cloud Connection is created. Click + symbol beside your cloud connection to expand the node.
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.