Custom Connection Strings for Data Sources
- 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 |
---|---|
Xpo Xpo * 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 “Xpo | |
Xpo Xpo | |
Xpo | |
Xpo | |
Xpo Xpo Xpo | |
Xpo | |
Xpo Xpo | |
Xpo | |
Xpo | |
Xpo | |
Xpo | |
Xpo | |
Xpo | |
Xpo | |
Xpo | |
Xpo | |
Xpo Xpo | |
Xpo | |
Xpo Xpo |
#Connection Strings for an OLAP Cube
Data Source | Sample Connection String |
---|---|
OLAP Data Source | Provider=MSOLAP;Data Source=http://demos. |
#Connection Strings for JSON Data
Data Source | Sample Connection String |
---|---|
JSON URI | uri=https://raw. |
JSON File | file=C:\customers. |