Skip to main content

Azure Synapse

Azure Synapse Analytics is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless on-demand or provisioned resources—at scale.

Timbr + Azure Synapse

Integrating Azure Synapse with Timbr combines the strengths of both platforms. It allows you to use Timbr's semantic graph capabilities alongside Azure Synapse's powerful analytics and data integration features. This integration enhances your ability to perform semantic querying, data virtualization, and integrated data management in a scalable cloud environment, leading to faster insights and more efficient data operations across your entire data estate.

Getting Started with Azure Synapse​

If you haven't yet set up an Azure Synapse workspace, follow these steps to get started:

To connect Timbr to your Azure Synapse datasource, you need to use the appropriate JDBC driver. For information on connecting to Azure Synapse, refer to the Azure Synapse Connectivity documentation.

Connecting Timbr to Azure Synapse in the Timbr Platform​

Once you've set up an Azure Synapse workspace and have the necessary connection information, it's time to connect Timbr to Azure Synapse. Follow the steps below for a detailed tutorial on connecting Timbr to Azure Synapse:

  1. Navigate to Manage Datasources: From the Timbr interface, click on the Manage tab and select Datasources.

  2. Add New Datasource: On the top right, click the Add New Datasource button. Alternatively, you can click the big add button beneath the knowledge graphs and datasources tabs.

Add new datasource

  1. Fill in Connection Details: A pop-up window will appear where you need to provide the relevant connection details to connect Azure Synapse to Timbr.

There are two options in Timbr to enter the connection information: Simple or JDBC Url.

On the top right of the pop-up window , the toggle can be switched from Simple to JDBC Url in order to connect the datasource using the relevant JDBC URL.

tabs

Simple Tab Connection Configuration​

  1. Select Simple Tab: Ensure the Simple tab is selected.

  2. Fill in the Following Details:

    • Database Type: Select Azure Synapse Analytics.
    • Datasource Name: Enter a name for your datasource.
    • Description: Provide a description of the datasource (Optional).
    • Hostname / IP: Enter the hostname or IP address of your Azure Synapse datasource.
    • Port: Default is 1433.
    • Username: Enter your Azure Synapse username.
    • Password: Enter your Azure Synapse password.
    • Database Name: Specify the name of the database.
    • Additional Parameters: Add any additional connection parameters using ; as separators.

JDBC URL Tab Configuration​

  1. Select JDBC URL Tab: Ensure the JDBC URL tab is selected.

  2. Fill in the Following Details:

    • Database Type: Select Azure Synapse Analytics.
    • Datasource Name: Enter a name for your datasource.
    • Description: Provide a description of the datasource (Optional).
    • Username: Enter your Azure Synapse username.
    • Password: Enter your Azure Synapse password.
    • JDBC URL: Enter the JDBC connection URL (e.g., jdbc:sqlserver://[host]:port).

jdbc tab

Save and Test Connection​

  1. After entering the details, click the Save button to save the information, connecting the Azure Synapse datasource to the Timbr environment.
  2. Once saved, on the top right, click the Test connection button to verify the datasource’s connectivity, ensuring it is active and responsive.

For a comprehensive guide on connecting Timbr to various datasources, refer to the detailed documentation: