Static Readonly SampleConnectionString
SampleConnectionString: object
azureBlobStorage
azureBlobStorage: string = "AccountKey=<key>;AccountName=<account>;ContainerName=<conainer>;BlobName=<blob>;\r\n" +"BlobContentType=CSV;CodePage=<page>;CsvSeparator=<separator>; OR\r\n" +"BlobContentType=Excel;FirstRowIsHeader=<{bool.TrueString}>; OR\r\n" +"BlobContentType=JSON; OR\r\n" +"BlobContentType=XML;"
azureSql
azureSql: string = "Server =<server address>; User ID =<username>; Password =<password>; Initial Catalog =<database name>;"
azureTableStorage
azureTableStorage: string = "DefaultEndpointsProtocol=https;AccountName=<AccountName>;AccountKey=<AccountKey>;EndpointSuffix=core.windows.net"
bigQuery
bigQuery: string = "Base64EncodedAuthSecret=<secret>;ProjectId=<projectID>;DatasetId=<datasetID>"
cosmosSql
cosmosSql: string = "Database=<myDataBase>;AccountEndpoint=<EndpointUrl>;AccountKey=<PrimaryKey>;"
dataWorld
dataWorld: string = "Owner=<owner>;Database=<id>;Token=<token>"
db2
db2: string = "Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword;\r\n" +"Max Pool Size=100;Min Pool Size=10;"
firebase
firebase: string = "AuthSecret=<secret>;BasePath=<path>"
firebird
firebird: string = "User=SYSDBA; Password=masterkey; Database=SampleDatabase.fdb;\r\n" +"DataSource=myServerAddress; Port=3050; Dialect=3; Charset=NONE;\r\n" +"Role=; Connection lifetime=15; Pooling=true; MinPoolSize=0;\r\n" +"MaxPoolSize=50; Packet Size=8192; ServerType=0;"
googleAnalytics
googleAnalytics: string = "Base64EncodedAuthSecret=<secret>;AccountId=<accountId>;PropertyId=<propertyId>;ViewId=<viewId>;Metrics=<metrics>;Dimensions=<dimensions>"
graphQL
graphQL: string = ""
informix
informix: string = "Database=myDataBase;Host=192.168.10.10;Server=db_engine_tcp;Service=1492;\r\n" +"Protocol=onsoctcp;UID=myUsername;Password=myPassword;"
mongoDb
mongoDb: string = "mongodb://<user>:<password>@localhost/test"
msAccess
msAccess: string = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Password=pass;\r\n" +"Data Source=C:\\myAccessFile.accdb;"
msSql
msSql: string = "Integrated Security=False; Data Source=myServerAddress;\r\n" +"Initial Catalog=myDataBase; User ID=myUsername; Password=myPassword;"
mySql
mySql: string = "Server=myServerAddress; Database=myDataBase;\r\n" +"UserId=myUsername; Pwd=myPassword;"
oData
oData: string = "https://services.odata.org/V4/Northwind/Northwind.svc"
odbc
odbc: string = "Driver={SQL Server}; Server=myServerAddress;\r\n" +"Database=myDataBase; Uid=myUsername; Pwd=myPassword;"
oleDb
oleDb: string = "Provider=SQLOLEDB.1; Integrated Security=SSPI;\r\n" +"Persist Security Info=False; Initial Catalog=myDataBase;\r\n" +"Data Source=myServerAddress"
oracle
oracle: string = "Data Source=TORCL;User Id=myUsername;Password=myPassword;"
postgreSql
postgreSql: string = "Server=myServerAddress; Port=5432; Database=myDataBase;\r\n" +"User Id=myUsername; Password=myPassword;"
quickBooks
quickBooks: string = ""
sqLite
sqLite: string = "Data Source=c:\mydb.db; Version=3;"
sqlCe
sqlCe: string = "Data Source=c:\MyData.sdf; Persist Security Info=False;"
sybase
sybase: string = "Data Source=myASEserver;Port=5000;Database=myDataBase;Uid=myUsername;Pwd=myPassword;"
sybaseAds
sybaseAds: string = "Data Source=\\myserver\myvolume\mypat\mydd.add;User ID=myUsername;Password=myPassword;ServerType=REMOTE;"
teradata
teradata: string = "Data Source=myServerAddress;User ID=myUsername;Password=myPassword;"
vistaDb
vistaDb: string = "Data Source=D:\folder\myVistaDatabaseFile.vdb4;Open Mode=ExclusiveReadWrite;"