Follow

Data Source - Oracle Database

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”.

DataSources-ConnectOracleDB.png

To successfully retrieve data from an Oracle Database data source, the following properties need to be set.

DataSources-OracleDBProperties.png

  • Name (String)
Name to identify the data source.
  • Server (String)
Location of the Oracle Database (Server Name or IP Address).
  • Service (String)
Service name of the Oracle service. The default is XE.
  • Port (Int)
Port of the Oracle service. The default is 1521.
  • Username (String)
Oracle authentication username. If left blank, Windows authentication will be used.
  • Password (String)
Oracle authentication Password. If left blank, Windows authentication will be used.
  • Alternate Schema (String)
If you don’t want to connect to the schema linked to your username, an alternate schema can be supplied.
  • Timeout (Int)
Timeout for SQL queries. The default is 15 seconds.
  • Definition (File location. JSON formatted file)
Definition settings to create a custom namespace as per your database schema.
  • Maximum Concurrent (Int)
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.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments