Jet Reports Homepage |  Community Forum |  Downloads |  Submit A Ticket |  Jet Express Support
Feedback

Connect Jet Enterprise to Azure SQL Databases


Overview

This document describes the steps needed to establish a connection to an Azure database and extract data.

Step-by-step guide

 

  1. Add a SQL Server data source

  2. Configure the SQL Server data source


    Server name : Use the F ully Q ualified D omain N ame supplied by Microsoft
    Database : The database you want to connect to
    Login: The login to Azure only supports SQL Server authentication. Please supply credentials with access rights to the database.
    SSIS : Currently the only supported connection method to Azure is ADO.NET. Please set the option 'Use Integration Services for transfer' to 'No'.

  3. If the 'Test Connection' is failing and the settings are correct it is most likely caused by the firewall setting on the Azure server. Please login to your Azure server and ensure the Jet Data Manager server has been granted access to the Azure server. Typically you need to add the external company IP address to the firewall rules


  4. Once the connection has been set up successfully you can read the objects from the data source

 

 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments