Question
Santander F1rst
BR
Last activity: 24 Jun 2024 8:47 EDT
BIX extraction to ADLS
Hi,
Currently we have several BIX extract rules running daily to extract the delta information from the history tables into an external PostgreSQL database.
From this external postgresql database we run an export into a ADLS instance.
We want to shorten the path and run the BIX extracts directly into the ADLS instance.
Do we have the drivers to connect to the ADLS instance?
Accepted Solution
Updated: 24 Jun 2024 8:47 EDT
Pegasystems Inc.
GB
@ASerighelli The Azure Data Lake Store File System Task is a component of the SQL Server Integration Services (SSIS) Feature Pack for Azure.
Pega BIX output is supported by components mentioned in The Platform Support Guide.
Microsoft SQL Server JDBC driver versions 10.2 and later enables data-in-transit encryption by default, which causes errors when not properly configured. To avoid issues, you must either disable encryption or configure encryption settings. For more information, see Review a Microsoft SQL database or Azure SQL (Managed Instance or Database) before an update.
Configuring the target database for BIX command-line extractions in on-premises systems
Running a BIX command-line extraction in on-premises systems
@ASerighelli The Azure Data Lake Store File System Task is a component of the SQL Server Integration Services (SSIS) Feature Pack for Azure.
Pega BIX output is supported by components mentioned in The Platform Support Guide.
Microsoft SQL Server JDBC driver versions 10.2 and later enables data-in-transit encryption by default, which causes errors when not properly configured. To avoid issues, you must either disable encryption or configure encryption settings. For more information, see Review a Microsoft SQL database or Azure SQL (Managed Instance or Database) before an update.
Configuring the target database for BIX command-line extractions in on-premises systems
Running a BIX command-line extraction in on-premises systems
Overview of BIX extractions in Pega Cloud environments