Custom Connection Strings for Data Sources

Jul 20, 2025
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=[email protected]; 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