Custom Connection Strings for Data Sources
- 2 minutes to read
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 |
---|---|
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). | |
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; | |
XpoProvider=MSSqlServer;Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Northwind.mdf;Integrated Security=True | |
XpoProvider=MSSqlServerCE; Data Source=C:\Northwind.sdf; | |
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; | |
XpoProvider=Amazon Redshift; Server=myserver.redshift.amazonaws.com; Port=5439; User ID=amazon_red; Password=password; Database=Analysis_Data; Encoding=UNICODE | |
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 | |
XpoProvider=Teradata; Data Source=localhost; Database=Northwind; PortNumber=1025; User ID=admin; Password=password; | |
XpoProvider=Advantage; Data Source=C:\Northwind.add; ServerType=local; User ID=Admin; TrimTrailingSpaces=true | |
XpoProvider=Ase; Data Source=localhost; Initial Catalog=Northwind; Port=5000; User ID=Admin; Password=password; Persist Security Info=true | |
XpoProvider=Asa; DBF=c:\Northwind.db; Uid=Admin; PWD=password; Persist Security Info=true | |
XpoProvider=DB2; Server=localhost:50000; User ID=Admin; Password=password; Database=Northwind; Persist Security Info=true | |
XpoProvider=Firebird; DataSource=localhost; User=Admin; Password=password; Database=Northwind.fdb; ServerType=0; Charset=NONE | |
XpoProvider=MySql; Server=localhost; User ID=Admin; Password=password; Database=Northwind; Persist Security Info= true; Charset=utf8 | |
XpoProvider=Pervasive; Server=localhost; UID=Admin; PWD=password | |
XpoProvider=Postgres; Server=localhost; User ID=Admin; Password=password; Database=Northwind; Encoding=UNICODE | |
XpoProvider=VistaDB; Data Source=C:\Northwind.vdb4 XpoProvider=VistaDB5; Data Source=C:\Northwind.vdb5 | |
XpoProvider=SQLite; Data Source=C:\Northwind.db | |
XpoProvider=InMemoryDataStore; Data Source=C:\Northwind.xml; Read Only=false; XpoProvider=XmlDataSet;Data Source=C:\Northwind.xml;Read Only=false |
OLAP Data Source
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; |
JSON Data Source
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 |