Connecting to OneLake using T-SQL?

Ignition
1

Hi everyone,

Has anyone successfully connected to Microsoft OneLake (Fabric) using their T-SQL connection?

Need some pointers on how. :slight_smile:

1 Like
2

Were you able to figure this one out? I also have a need to push data from Ignition to OneLake. Really don't want to push to Azure database and then have to setup a pipeline for my LakeHouse.

3

Yes, indeed.

  • You need to upload JAR libraries for entra-authentication and all its dependencies.
  • You need to have your credentials blank, and define them as extra connection propeties. (AADSecurePrincipalId)
  • You need to change your mssql-translator.

At this time you will not be able to use T-SQL as Tag Historian storage, as it is yet not supporting unique indexes.

Or, maybe we can now?