Download the trial version of Data Connector and install it to your SharePoint server.

Navigate to the site in which the Case List is located.

In the upper right corner, click Settings and then click Site Settings.

On the Site Settings page, click Data Connector Settings under BoostSolutions Software section in the bottom right corner of the page.

On the Data Connector Settings page, click Create Job.

After clicking Create Job, you will enter the Edit Job page.

In the Job Name section, specify a unique name for the job, such as job-1.

In the Direction section, specify the direction for the data connection. Select From list to external data option.

When the direction is set as From list to external data, then the SharePoint list is the data source, and the external data is the target.

In the List section, specify a SharePoint list or Document Library from which you want to sync data to the external data source. Click to browse and select the Case List from the drop-down list.

In the Choose a view drop-down list, select a view to filter items, here we select the All Items view.

If you select All list items (No filter), it means that all items in the SharePoint list will be exported to the external data.

In the External Data and Authentication section, configure the settings as following. Specify the external data type and database authentication. (Ensure the user account you specify has the appropriate permissions to access the external data source.)

External Data Type: Select Oracle as the external data type.

Host Name/IP: Enter the host name where the Oracle database is situated or the IP address of the Oracle server on which the Oracle database we want to sync is stored.

Port Number: Enter the TCP/IP port number to connect to the database server (The default port number is 1521).

Service Name/SID: Set the Service Name/SID which you want to connect. Select the corresponding radio button. Here we select Service Name and input test.boost.

Username: Enter the name of a user who has Write permission to the database.

Password: Enter the user’s password.

Click Connect to connect the Oracle Server we specified. If everything goes right, it will show Connection successful below the Connect button. And the databases existed on the specified Oracle server will be populated to the dropdown list as shown in the picture above.

Database: Select a database. Here we select the default database.

In the Data Settings section, specify which external data will be connected to the SharePoint list. Type the table’s name in the textbox and click Check button to verify whether the table is existed in the Oracle database.

Here we type the table’s name cases (the table CASES stored in the test.boost as we described in the sample data section) in the textbox and click the Check button.

After verifying, it recognized that the CASES table is existed in the Oracle database as following.

Otherwise, a warning message will appear below the textbox as following.

In the Column Mapping section, map the fields in the external database to the columns in the SharePoint list as following.

Because the columns’ name and type are the same in the SharePoint list and the Oracle database, the columns will be automatically mapped by default.

Select Case Number column as the key. A “key column” is one that uniquely identifies records and can be used to compare data sources.

If the columns name or type are different between SharePoint list and external data source, you have to map the columns manually by clicking Add a column mapping link.

Keep other settings as default and click Save to save the settings.

And then you will find that the job has been created on the Data Connector Settings page, the job-1.

Click the Run button for the job-1 and waiting for the job to be run completely.

After the job run completely, click Close. In the Oracle database, check the table CASES. And then you will find that the items in the SharePoint list have been synced successfully to the Oracle database as following.