Custom Connection Strings for Data Sources

• Dec 23, 2021
• 2 minutes to read

Connection Strings for SQL Data Providers

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 Provider	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 Database File	XpoProvider=MSSqlServer;Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Northwind.mdf;Integrated Security=True
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=[e-mail]; 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; XpoProvider=XmlDataSet;Data Source=C:\Northwind.xml;Read Only=false

Connection Strings for an OLAP Cube

Data Source	Sample Connection String
OLAP Data Source	Provider=MSOLAP;Data Source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll; Initial catalog=Adventure Works DW Standard Edition;Cube name=Adventure Works;Query Timeout=100;

Connection Strings for JSON Data

Data Source	Sample Connection String
JSON URI	uri=https://raw.githubusercontent.com/DevExpress-Examples/DataSources/master/JSON/customers.json
JSON File	file=C:\customers.json