Specify a Connection String

<< Click to Display Table of Contents >>

Navigation:  User Interface (UI) Elements > Report Designer > Data Source Wizard > Connect to a Database >

Specify a Connection String

 

 

Specify a Connection String

On this page, define a custom connection string or select one of the supported data source types.

SCS1

The following data source types are supported.

Amazon Redshift Firebird

Google BigQuery

IBM DB2

Microsoft Access 2007

Microsoft Access 97

Microsoft SQL Server

Microsoft SQL Server Compact Edition

MySQL

Oracle

Pervasive PSQL

PostgreSQL

SAP Sybase Advantage

SAP Sybase ASE

SAP Sybase SQL Anywhere

SQLite

Teradata

VistaDB

VistaDB5

XML file

Depending on the data provider selected, it may be necessary to specify additional connection options (such as authentication type and database name) on this page.

Click Next to proceed to the next wizard page, depending on whether or not the created connection uses server authentication.

Save the Connection String - if server authentication is required, this page allows you to specify whether or not you want to save the user credentials along with the connection string.

Create a Query or Select a Stored Procedure - if server authentication is not required, the page above does not appear, and you will proceed to constructing the query.