Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online transaction processing, data warehousing and mixed database workloads.
To create a connection to the Oracle Database Data Source, right-click on the Data Sources group, click “Oracle”, and then select “Oracle Database”.
To successfully retrieve data from an Oracle Database data source, the following properties need to be set.
|
Name to identify the data source. |
|
Location of the Oracle Database (Server Name or IP Address). |
|
Service name of the Oracle service. The default is XE. |
|
Port of the Oracle service. The default is 1521. |
|
Oracle authentication username. If left blank, Windows authentication will be used. |
|
Oracle authentication Password. If left blank, Windows authentication will be used. |
|
If you don’t want to connect to the schema linked to your username, an alternate schema can be supplied. |
|
Timeout for SQL queries. The default is 15 seconds. |
|
Definition settings to create a custom namespace as per your database schema. |
|
Maximum pooling count size for the Oracle connection. The default is 100. |
Note: The Oracle data source connector also supports the use of a custom namespace by means of a definition file. Also, refer to the Microsoft SQL Data Source for sample queries.