Embedded
Schedule Free Demo
Try it Free
Search results
Suggest a FeaturePDF

Connect to Oracle data source

Supported Server Versions: Oracle Database (11g, 12c, 18c, and 19c)

Using the Oracle connection type, you can connect an Oracle database.

Choose oracle data source

  1. Click on the Data icon in the configuration panel. Data icon configuration panel
  2. In the DATA configuration panel, click on the NEW DATA button. New Data Panel
  3. In the connection type panel, choose the Oracle data source type. Connection types panel

Create Oracle data source with basic options

When you create a new data, the NEW DATASOURCE panel will show up with basic options,

  1. Specify the data source name without special characters, in Name field.
  2. In Server Name field, you need to specify the remote server name like myserver.domain.com.
  3. In Service Instance Name field, you need to specify the Oracle Service Identifier Name like ORA19, XE.
  4. In Port field, you need to specify the Port number. Here, the default port number is 1521.
  5. Specify the username of your Oracle server in Username field.
  6. Specify the password of your Oracle server in Password field.
  7. Enable the Save password option to embed the credentials within the report when saving it in Report Server.
  8. Choose or enter an existing valid database. e.g. ADVENTUREWORKS. Basic Option
  9. Click on the Connect to connect the Bold Reports® with Oracle database.
  10. Drag and drop the table from the table schema in the query design view page. Query Designer
  11. Click Finish to save the data source with a relevant name to proceed with designing report. Data List

Create Oracle data source with advanced options

To connect the Oracle database with advanced options, click on the Advanced Options in New Data panel.

Advance Option

Now, the panel is switched to Advanced Options, where you can build your own connection string. Enter a valid connection string as mentioned below and authentication type to connect with specified data source.

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));

Set the connection string and input the username and password of Oracle server.

Advance Connection

Drag and drop the table from the table schema in the query design view page.

Query Designer

Click Finish to save the data source with a relevant name to proceed with designing report.

Data List

Click on Basic Options to switch back to the basic connection settings.

Switch Basic Option

Connection string

Connection strings are the text representation of connection properties for a data provider.

If the database is on your local computer. Specify connection string like the below.

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)))User ID=system;Password=1234

If database is located in any other server domain, specify connection string like the below.

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myserver.domain.com)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)))User ID=system;Password=1234

Authentication types

You can set oracle database credentials, prompted credentials, or use no credentials.

Advanced authentication

Authentication - A user name and password must be supplied to access the oracle database, the credentials might be for a database login. The credentials are passed to the data source for authentication.

Advanced authentication

Enable the Save password option to embed the credentials within the report when saving it in Report Server.

On report download action, the credentials will be not be saved with report data.

Prompt - When you configure a data source connection to use prompted credentials, each user who access the report must enter a user name and password on preview action to retrieve the data.

Advanced authentication

None - Choose the authentication type as None, when the authentication details or any other arguments required to connect with the data source are provided in connection string.