Connector for SQL Server

The Connector module for SQL Server connects Dataristix to SQL Server databases.

Data originating from other connectors (i.e. the OPC UA Connector) can be stored into a database, and data originating from a database can also be sent to other connectors, including the SQL Server connector itself, thus facilitating database-to-database transfers.

The SQL Server connector uses the Common Database Connector Interface.

Tip

For deployments on Azure Kubernetes, you can use integrated security with a managed identity. Ensure to associate a managed identity with your Dataristix instance during deployment and that federated credentials are configured for the identity.

To configure federated credentials, go to your managed identity and add federated credentials by entering your Kubernetes cluster’s Issuer URL, namespace “dataristix”, and service account “<dataristix instance name>-service-account” (for example, “dataristix1-service-account”).

You will also need to grant access for the managed identity in your SQL database.

Use the appropriate connection string with “Active Directory Managed Identity” authentication. Within the Dataristix database settings, select option “Save credentials for future use” and enter the client ID of your managed identity as the Login ID (leave the password blank).

Note

On first attempt, connections may time out. Retry a few times if initial connection attempts are unsuccessful.