Intention is to pull together a summary of the requirements to enable Intelligent Cloud Insights and the required Integration Sync via Azure Data Factory.

In working through a client scenario and testing I found a few issues that I ran into and thought I would pull this together as a summary to assist with the configuration.

(remember to configure and play with the Sandbox before enabling in the related production database!)

Default Business Central Documentation:

In Preparation, your OnPremise SQL must be configured ahead.  Prepare the following ahead:

  • Create a SQL User with a password (remember to clear the "must reset" to avoid error).  This will be treated as a service account user.
    • Recommend assigning as sysadmin for Server Role
  • Ensure the SQL Database Compatibility is >=130
  • Using the Wizard in Business Central, you will need to:
    • Select the relevant OnPremise DataSource  (Business Central and GP are currently supported and NAV 2018 is expected Spring of 2019)
    • Enter the specific SQL Connection string with the applicable SQL User and password created using the following example:

      SQL Connection String 


      Integration Runtime Name 

      {will be generated after selecting next.  This can be found in the integration tool after.  Need to define if adding to an existing integration service}

      Authentication Key 

      {Copy/Paste the string generated into the Integration installstoin.  looks like a long string like: IR@b81......lGo= } 

    • install the Microsoft Azure Data Factory Integration Runtime.  Note the Authorization Key as you will paste it during the installation of the SHIR tool.

Install and register self-hosted IR from the Download Center

  1. Go to the Microsoft integration runtime download page.
  2. Select Download, select the 64-bit version (32-bit is not supported), and select Next.
  3. Run the MSI file directly, or save it to your hard disk and run it.
  4. On the Welcome page, select a language and select Next.
  5. Accept the Microsoft Software License Terms and select Next.
  6. Select folder to install the self-hosted integration runtime, and select Next.
  7. On the Ready to install page, select Install.
  8. Click Finish to complete installation.

For troubleshooting please review the following links for additional information: