Custom Connection Strings for an SQL Data Source
- 2 minutes to read
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 |