Creating an OMS Profile Score Report

Step 2: Create a Data Connection

Open the Report Designer and open your new Profile Key report. I am using a SQL Server database, so to gain access to the tables and data that I need for this report I must first connect to my Analytics database.

In the Report Designer, Dictionary panel, click New Item, New Connection.

Select Sql Connection as the type of connection and click OK.

In the New Sql Connection dialog box, you can enter a connection string that includes your SQL database name, username and password. If you don’t know this information, look at your existing Sitecore connection string or open SQL Server Management Studio to find out.

This is the format you need for the connection string:

user id=<username>;
password=<password>;
Data Source=<name of datasource>;
Database=<name of database>

For Example:

user id=sa;
password=Blue50;
Data Source=.\SQLEXPRESS;
Database=Nicam_Sitecore_Analytics

Click Test to test the connection.

 

My next post: Step 3 – Understand the Database Structure