Skip to main content

SQL Server

SQL Server is a robust and scalable database management system developed by Microsoft. It is widely used in enterprise environments for managing large-scale data applications. SQL Server supports a broad range of data types and extensive business intelligence capabilities.

Timbr + SQL Server

Integrating SQL Server with Timbr allows you to leverage Timbr’s semantic graph capabilities while utilizing SQL Server’s powerful data management tools. This integration enhances features like semantic querying, data virtualization, and integrated data management, providing insights and efficiencies not typically available with traditional database management systems.

Getting Started with SQL Server​

To begin integrating SQL Server with Timbr, ensure that you have SQL Server installed and that you have the necessary permissions to connect to it.

To enable Timbr to connect to your SQL Server datasource, you need to download the JDBC driver. For detailed information on JDBC connections and other connectors, refer to the SQL Server Connector Documentation.

Connecting Timbr to SQL Server in the Timbr Platform​

Once you've connected to a SQL Server database and have the JDBC driver ready, it's time to connect Timbr to SQL Server. Follow the steps below for a detailed tutorial on connecting Timbr to SQL Server:

  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 SQL Server 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 Microsoft SQL Server.
    • 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 SQL Server.
    • Port: Default is 5442.
    • Username: Enter your SQL Server username.
    • Password: Enter your SQL Server password.
    • Database Name: Specify the name of the database.
    • Additional Parameters: Add any additional connection parameters using ; or & 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 Microsoft SQL Server.
    • Datasource Name: Enter a name for your datasource.
    • Description: Provide a description of the datasource (Optional).
    • Username: Enter your SQL Server username.
    • Password: Enter your SQL Server password.
    • JDBC URL: Enter the JDBC connection URL (e.g., jdbc:sqlserver://hostname:port/database).

jdbc tab

Save and Test Connection​

  1. After entering the details, click the Save button to save the information, connecting the SQL Server 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: