Connection Strings in PPS Monitoring

ODBC connection string in PPS Monitoring can become a little awkward, therefore I thought it wise to write a quick blog post with various connection strings in for a quick reference. 

Using ODBC connection strings, you can connect to many data sources including: SQL Server, Access, Oracle, Excel etc. Lets remember that PPS monitoring is best used when connection to multidimensional data sources, and the built in reports can use only Multidimensional sources.  KPI’s can however use these connection strings and therefore, it is often a requirement to connect to relational stores. Here are a few examples of connections strings

  • SQL Server: Driver = {SQL Server}; Server=SERVERNAME; Database=ADVENTUREWORKS
  • Access: Driver= {Microsoft Access Driver (*.mdb)}; dbq=c:SourceLocationSourceAccessDB.mdb; uid=USERNAME; pwd=PASSWORD;
  • Oracle: Driver= {Microsoft ODBC for Oracle}; server=SERVER; uid=USERNAME; pwd=PASSWORD;
  • Excel: Driver={Microsoft Excel Driver (*.xls)}; dbq=C:SOURCELOCATIONWORKBOOK.xls; ReadOnly=True;

Leave a Reply

Your email address will not be published. Required fields are marked *