Guide to integrate your Azure Synapse with Sprinkle
This page covers the details about integrating Azure Synapse with Sprinkle.
If you don't have an existing Azure Synapse cluster. You can refer Azure documentation. Create a dedicated sql-pool while setting up the warehouse (refer- docs).
When setting up Synapse connection, Sprinkle additionally requires Azure Storage Container. This guide covers the role of all the components and steps to setup.
Integrating Synapse: All analytical data is stored and queried from Synapse warehouse
Create Azure Storage Container: Sprinkle stores all intermediate data and report caches in this bucket
Step by Step Guide
STEP-1: Allow Synapse to accept connection from Sprinkle
Allow inbound connection on Synapse jdbc port (default is 1433) from Sprinkle IPs (18.104.22.168, 22.214.171.124).
STEP-2: Configure Synapse Connection
Log into Sprinkle application
Navigate to Admin -> Drivers -> Create Warehouse
Select Azure Synapse
Provide all the mandatory details
Distinct Name: Name to identify this connection
JDBC URL : Refer Get JDBC URL. Provide url in the format jdbc:sqlserver://yourserver.sql.azuresynapse.net:1433;database=yourdatabase;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.sql.azuresynapse.net;loginTimeout=30;
Create Azure Storage Container
Sprinkle requires Azure Storage container to store intermediate data and report caches. Follow the below steps to create and configure storage container:
STEP-1: Create a Storage Account
Login to the Azure Portal and select All Services.
Select Storage Account and choose Add.
Select the subscription in which you want to create the account.
Select the desired resource group or create a new resource group. You can refer to the Azure Documentation of resource management.
Provide the storage name, this name should be unique across all the Azure storages. The name also must be between 3 and 24 characters in length, and may include only numbers and lowercase letters.
Select a location for your storage account, or use the default location.
Select a performance tier, recommended is Standard.
Set the Account kind field to Storage V2 (general-purpose v2).
Specify other settings if anything is required
Select Review + Create to review your storage account settings and create the account.
Click on Create, it will create the account
STEP-2: Create Storage Container
Login and go to the new storage account in the Azure portal.
In the left menu for the storage account, select Containers from the Blob service section.
Click on the + Container button.
Provide a name for your new container. The container name must be lowercase, must start with a letter or number, and can include only letters, numbers, and the dash (-) character. Refer to the Azure Documentation for more information.
Set the level of public access to the container or you can whitelist the Sprinkle IP shown in Driver Setup.