Extracting data from Pega Cloud to an on-premises database

Extracting data from Pega Cloud directly to an on-premises database improves efficiency by eliminating the need for file extraction and the development of a file extraction infrastructure. You can use Business Intelligence Exchange (BIX) to extract data from Pega Cloud to an on-premises relational database management system.

  1. In Pega Cloud, in the header of Designer Studio, click Create > SysAdmin > Extract.
  2. In the Label field, enter a name for the extract.
  3. In the Apply to field, enter or select the class that the extract applies to.
  4. Click Create and open.
  5. On the Definition tab, in the Output format field, select Database Schema.
  6. Click the Gear icon to open the Property Configuration menu.
    1. In the To table field, enter the name of the database for the data to be extracted to.
    2. In the From class field, enter or select the class that the data is extracted from.
    3. Use the Property Name Contains: field to search for the properties that you want to extract.
    4. Select the check box next to the property that you want to extract.
    5. Click Submit.
  7. On the File Specification tab, in the Output database name field, enter the name of the database for the data to be extracted to.
  8. Click Save.
  9. Click Action > Run.
  10. Select the Generate schema DDL check box.
  11. Click Perform extract.
  12. Click Click here to download DDL(s) to download the DDL file to your system.
  13. Open the DDL: file.
  14. In the DDL file, run the SQL CREATE TABLE command and the SELECT command.
  15. Unselect the Generate schema DDL check box, and then click Perform Extract again to transmit the data created in step 13 in the DDL file to the table created in step 13.