Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Alexandre Serighelli (ASerighelli)
Santander F1rst
SSA
Santander F1rst
BR
ASerighelli Member since 2016 7 posts
Santander F1rst
Posted: May 24, 2024
Last activity: Jun 24, 2024
Posted: 24 May 2024 9:45 EDT
Last activity: 24 Jun 2024 8:47 EDT
Closed
Solved

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?

To see attachments, please log in.
Pega Platform 8.8.3
Client-managed Cloud
Data Management
Senior System Architect

Accepted Solution

Posted: 1 year ago
Updated: 1 year ago
Posted: 7 Jun 2024 5:07 EDT
Updated: 24 Jun 2024 8:47 EDT
Marije Schillern (MarijeSchillern)
MOD
Senior Knowledge Management Specialist
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

Show More

@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

Show Less
To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice