Datasource Connection Strings in BI4Cloud

Connection string takes the general form

  DATASOURCE yourname=SQLSERVER 'connection_string'

 Connection_string is this case is the connection string for the Sql Server Dot Net Provider

For many SQL server databases the following format will work.

DATASOURCE a1=SQLSERVER 'Data Source={SQL Server Instance};Initial Catalog={Database Name};User Id={User Name};Password={User Password}'

Specifically if your SQL Server instance was called SPECK\MSSQL2012 and has a Database called exo_live and a valid user was ir and their password was ir1234 then the following would be a valid connection string 

DATASOURCE a1=SQLSERVER 'Data Source=SPECK\MSSQL2012;Initial Catalog=exo_live;User Id=ir;Password=ir1234'  

We know how daunting this is and so we have built in a feature to build this string.

When using the BI Connector when you choose a SQL Server data source you will get a "Build" button.

Pressing this brings up a ODBC or SQL server connection dialogue.

Choose either ODBC or SQL Server and complete the fields to make your connections