Skip to main content
Version: Next

Creating an Oracle (Thin) data source

caution

  Prerequisites
Access to the Data Integration > Data source: Database (DI003) menu.
Having an Oracle database instance installed and configured in your infrastructure.

In order to simplify the configuration of a data source for connection to an external Oracle database (which is not the SoftExpert Suite primary database), we have introduced a new driver option called Oracle (Thin).

The Oracle Thin driver streamlines the configuration process by eliminating the need to have the configuration files (tnsnames.ora and SQLNet.ora) present during the installation of SoftExpert Suite. Now, users can set up the connection to the Oracle database in a more direct manner and without depending on the presence of these configuration files.

  1. Log in to SoftExpert Suite and go to the Data Integration > Data source: Database (DI003) menu.
  2. Click on new to create a new data source.
  3. Select the Oracle (Thin) driver from the drop-down list.
  4. Enter the connection information for the Oracle database, including the database name, host, port, user name, and password.
  5. Test the connection by clicking on the default button.

If the connection is successful, you will receive the message Successful connection. Click on save_exit to save and exit the Oracle data source.

Now, you can use the Oracle data source in external attributes, in SoftExpert Analytics or in Dataset.

caution

In the Database name field, you must enter the Oracle SERVICE_NAME.

tip

Make sure that your SoftExpert Suite instance has access to the Oracle database server and that the inserted credentials are correct. Moreover, we highly recommend accessing the desired data with a user account that has the minimum required permissions.

danger

Support to the use of Oracle OCI8 data source types has been interrupted.

Last updated on