Creating an Oracle (Thin) data source
  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.
- Log in to SoftExpert Suite and go to the Data Integration > Data source: Database (DI003) menu.
- Click on
to create a new data source. - Select the Oracle (Thin) driver from the drop-down list.
- Enter the connection information for the Oracle database, including the database name, host, port, user name, and password.
- Test the connection by clicking on the
button.
If the connection is successful, you will receive the message Successful
connection. Click on 
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.
In the Database name field, you must enter the Oracle SERVICE_NAME.
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.
Support to the use of Oracle OCI8 data source types has been interrupted.