Generic Extract from Datasets

Oracle Revenue Management and Billing enables you to extract high-volume transactional data from the pre-defined datasets. This feature enables bulk extraction and is specifically recommended for extracting large quantities of data for downstream consumption in data warehouses or data lakes. This feature facilitates you with:

  • Pre-defined Data Models – Uses pre-defined, seeded data objects to ensure accurate data extraction.

  • Extraction Templates – Enables designing templates to extract data from the specific fields of the dataset in an organized manner.

  • Full and Incremental Extraction – Supports both full and incremental (delta) extraction, capturing only new or modified data to minimize system load.

  • Extraction Formats – Enables to extract data in the following supported formats:

    • Comma Separated Values (CSV)

    • Extensible Markup Language (XML)

    • Fixed Position (PRN)

    • JavaScript Object Notation (JSON)

    • Pipe Separated Values (PSV)

    • Tilde Separated Values (TILD)

  • Scheduling and Performance – Enables scheduling and is designed to handle high volumes without severely impacting the performance of the system.

Note: This feature is tested and certified only for the health insurance domain and not for the financial services domain.