Skip to main content

Striim Platform 5.4.0 documentation

fabric-data-warehouse-configure-target

Fabric Data Warehouse Writer requires an Azure Data Lake Storage account, which you must create prior to running this wizard (see Learn / Azure / Storage / Blobs / Create a storage account to use with Azure Data Lake Storage). The ADLS network access rule must be Enabled from all networks (see Learn / Azure / Storage / Configure Azure Storage firewalls and virtual networks / Change the default network access rule).

  • Use Connection Profile: Enable to use connection profiles, in which case select Connection Profile Name and External Stage Connection Profile Name (see Connection profiles).

  • Connection URL or SQL connection string:

    Do not include the warehouse name in the connection string. It is specified as a separate property.

    Specify the SQL connection string from Fabric Data Warehouse portal. See the instructions at Learn / Microsoft Fabric / Data Warehouse / Connectivity to data warehousing in Microsoft Fabric / Retrieve the SQL connection string.

    Alternatively, provide the full JDBC connection URL with Active Directory password for authentication using the format:

    jdbc:sqlserver://;serverName=<host URL>;encrypt=true;Authentication=ActiveDirectoryPassword

    Note the unusual semicolon after //.

  • Warehouse Name: Specify the Microsoft Fabric data warehouse to be written to.

  • Username: Specify the Microsoft Fabric username to be used by Striim.

  • Password: Specify the password for the specified username.

  • Azure Account Name: Specify the name of the Azure Data Lake Storage account to be used by Fabric Data Warehouse Writer, which you can find in Azure at Storage accounts.

  • Azure Account Access Key: Specify the account access key for the specified Azure Data Lake Storage account, which you can find in Azure at Storage accounts > <account name> > Security + networking > Access keys.

  • How would you like to write continuous changes to Fabric Data Warehouse? See the notes for the Mode property in Fabric Data Warehouse Writer properties for discussion of Merge mode versus Append Only mode.Fabric Data Warehouse Writer properties

    • Choose Write continuous changes directly to use Merge mode.

    • Choose Write continuous changes as audit records to use Append Only mode.

      If you choose this option, Striim will add two columns to each target table: STRIIM__OPTIME will contain a timestamp of when the data was loaded from the source, and STRIIM__OPTYPE will contain a string describing the operation for the record: SELECT for initial load and INSERT, UPDATE, or DELETE for CDC.

In this section: