Campaign Optimization - Predicting How and When to Contact Leads

Set up Connection between SQL Server and PowerBI

Follow the instructions below to set up a connection between your SQL Server database and PowerBI. Perform these steps after you have created the Campaign database.
Follow the instructions below to set up a connection between your Hive table and PowerBI. Perform these steps after you have created the recommendations table by executiong the campaign_main.R and campaign_scoring scripts.
  1. Download and install the Spark ODBC driver.
  2. Push the Windows key on your keyboard
  3. Type ODBC
  4. Open the correct app depending on what type of computer you are using (64 bit or 32 bit). To find out if your computer is running 32-bit or 64-bit Windows, do the following:
    • Open System by clicking the Start button, clicking Control Panel, clicking System and Maintenance, and then clicking System.
    • . Under System, you can view the system type
  5. Click on Add
  6. Select Server Native Client 11.0 and click Finish.
  7. Select Microsoft Spark ODBC Driver and click Finish
  8. Under Name, Enter Campaign. Under Server enter the MachineName from the SQL Server logins set up section. Press Next.
  9. Under Name, Enter Campaign. Add the Host name (of the form myclustername.azurehdinsight.net). For username, enter admin. Enter the password you chose when you created the cluster.
  10. Select SQL Server authentication and enter the credentials you created in the SQL Server set up section. Press Next
  11. Check the box for Change the default database to and enter Campaign. Press Next.
  12. Press Finish
  13. Press Test Data Source
  14. Press Test.
  15. Press OK in the new popover. This will close the popover and return to the previous popovers.

  16. Now that the Data Source is tested. Press OK
  17. Finally, click OK and close the window

    18. You are now ready to use this connection in PowerBI by following the instructions here.