Querying the Reporting Database with SSMS

To query sanitized read-only data directly from the customer's reporting database, connect to the SQL server as a client via the SQL Server Management Studio (SSMS).

  1. Download and install Microsoft SQL Server Management Studio.
  2. Connect to the Reporting Services VPN using the appropriate two-factor authentication.
    • When using Salesforce Authenticator, the password consists of your personal VPN password plus the current 6-digit code shown in the Salesforce Authenticator app. For example, if your password is [email protected], and the code shown in the app is 654321, then you would enter [email protected] in the Password field.
  3. Access the reporting database server using SSMS.
  4. Enter the full database server name including a 'r' in place of 'A' or 'B' before the *.oc.demandware.net portion of the server name.

    For example for US01, the server name format is US01p-sql06r.us01.oc.demandware.net.

  5. From the Authentication dropdown list, click SQL Server Authentication.
  6. Enter your SQL Server login user name and password.
  7. Click Options >>.
    The Connect to Server page opens.
  8. In the Connect to database: field, enter the full reporting database name including an 'r' to reflect reporting.
    The full reporting database name format is: bf_<customer>_com_r
  9. Select Encrypt Connection and Trust server certificate.
    Note: These checkboxes aren't available in older versions of SSMS. If using an older version, click the Additional Connection Parameters tab, and then enter the connection string parameters, Encrypt=True;TrustServerCertificate=True.
  10. Click Connect.
    You should now be connected to the reporting database server.
    Note: If you can't connect, ping the SQL server.
    • If the ping returns a message that the host wasn't found when running SSMS from a Windows virtual machine on a Mac, you may need to add all of the servers to the /etc/hosts file. Contact Salesforce Support for a list of the host IPs for US01 and US02.
    • If your server is listed in the /etc/hosts file but you can't ping the SQL server, disconnect from the VPN, restart the OpenVPNServiceInteractive service, and then reconnect.
X Privacy Update: We use cookies to make interactions with our websites and services easy and meaningful, to better understand how they are used. By continuing to use this site you are giving us your consent to do this. Privacy Policy.