Custom Connection Strings for the SQL Data Source

To identify the database type in a custom connection string, use the XpoProvider parameter. The table below contains sample connection strings for all supported SQL data providers.

SQL Data Source

Sample Connection Strings

Microsoft SQL Server*

XpoProvider=MSSqlServer; data source=localhost; initial catalog=Northwind; Integrated Security=SSPI; Persist Security Info=True;

XpoProvider=MSSqlServer; data source=localhost; initial catalog=Northwind; User Id=admin; Password=password; Persist Security Info=True;

* All Dashboard controls automatically use the MS SQL data provider if you set the "Initial Catalog" parameter to specify the database name and the connection string does not contain the word "Provider" (for instance, the "XpoProvider" parameter).

Microsoft Access

XpoProvider=MSAccess; Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\nwind.mdb; User Id=; Password=;

XpoProvider=MSAccess; Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\Northwind.accdb;

Microsoft SQL Server CE

XpoProvider=MSSqlServerCE; Data Source=C:\Northwind.sdf;

Oracle Database

XpoProvider=Oracle; Data Source=localhost:1521/instancename; user id=admin; password=password;

XpoProvider=ODP; Data Source=localhost:1521/instancename; user id=admin; password=password;

XpoProvider=ODPManaged; Data Source=localhost:1521/instancename; user id=admin; password=password;

Amazon Redshift

XpoProvider=Amazon Redshift; Server=myserver.redshift.amazonaws.com; Port=5439; User ID=amazon_red; Password=password; Database=Analysis_Data; Encoding=UNICODE

Google BigQuery

XpoProvider=BigQuery; ProjectID=TestProject; DataSetId=Northwind; OAuthClientId=testclientid.apps.googleusercontent.com; OAuthClientSecret=secret; OAuthRefreshToken=refreshToken

XpoProvider=BigQuery; ProjectID=TestProject; DataSetId=Northwind; ServiceAccountEmail=testaccount@developer.gserviceaccount.com; PrivateKeyFileName=C:\p12key.p12

Teradata

XpoProvider=Teradata; Data Source=localhost; Database=Northwind; PortNumber=1025; User ID=admin; Password=password;

SAP Sybase Advantage

XpoProvider=Advantage; Data Source=C:\Northwind.add; ServerType=local; User ID=Admin; TrimTrailingSpaces=true

SAP Sybase ASE

XpoProvider=Ase; Data Source=localhost; Initial Catalog=Northwind; Port=5000; User ID=Admin; Password=password; Persist Security Info=true

SAP SQL Anywhere

XpoProvider=Asa; DBF=c:\Northwind.db; Uid=Admin; PWD=password; Persist Security Info=true

IBM DB2

XpoProvider=DB2; Server=localhost:50000; User ID=Admin; Password=password; Database=Northwind; Persist Security Info=true

Firebird

XpoProvider=Firebird; DataSource=localhost; User=Admin; Password=password; Database=Northwind.fdb; ServerType=0; Charset=NONE

MySQL

XpoProvider=MySql; Server=localhost; User ID=Admin; Password=password; Database=Northwind; Persist Security Info= true; Charset=utf8

Pervasive PSQL

XpoProvider=Pervasive; Server=localhost; UID=Admin; PWD=password

PostgreSQL

XpoProvider=Postgres; Server=localhost; User ID=Admin; Password=password; Database=Northwind; Encoding=UNICODE

VistaDB

XpoProvider=VistaDB; Data Source=C:\Northwind.vdb4

XpoProvider=VistaDB5; Data Source=C:\Northwind.vdb5

SQLite

XpoProvider=SQLite; Data Source=C:\Northwind.db

XML file

XpoProvider=InMemoryDataStore; Data Source=C:\Northwind.xml; Read Only=false