ETL for ACL AuditExchange is powered by InformaticaŽ, the worldwide market leader in
Extract, Transform and Load (ETL) technology.
Available Data Sources
ETL for ACL AuditExchange includes:
Flat fi les Delimited ODBC-compliant data sources Sybase SQL
Informix Oracle dBase Microsoft Access Simple XML
Specialized Connectors for Complex Databases include:
DB2 Teradata IMS for z/OS VSAM for z/OS
ADABAS IDMS for z/OS SAS Hyperion Essbase
Specialized Connectors for ERP systems include:
JD Edwards EnterpriseOne JD Edwards World Siebel CRM Salesforce.com
SAP CRM SAP BW SAP ERP Oracle e- Business Suite PeopleSoft Enterprise
Specialized Connectors for Complex Data include:
With a Complex
Data
Exchange,
you can reach:
Add-ons to the Complex Data
Exchange include
format
libraries for:
PDF Spreadsheet data Report (Print) files Complex XML XBRL SAP Private file formats
SWIFT HIPAA HL7 AFP EDI-X12 EDI - FACT
ETL for ACL AuditExchange allows your audit team to enjoy
streamlined access to a multitude of sources — from ERP
and complex databases to industry-specifi c data. ETL allows
you to:
Extract large volumes of data from different platforms
and systems at scheduled times
Refresh the data on a recurring basis to support your
repetitive and continuous audits
Populate the AuditExchange repository with data
in ACL format for use, re-use and sharing across
the team
Benefits
Provide the right information at the right time
With ETL for ACL AuditExchange, you can accumulate data
knowledge within the AuditExchange repository. Your audit
department can access:
General purpose data sets for multiple use
Defi ned data sets for specifi c audit objectives
Data dictionaries
A Simple Transformation data mapping with ETL for ACL AuditExchange
Enhance collaboration and productivity within the
audit team
ETL for ACL AuditExchange helps your audit team work
faster and better together. Using the AuditExchange
repository, teams can easily share and re-use data work
and results.
ETL for ACL AuditExchange is easy to deploy and manage
across audit teams whose members have different roles and
responsibilities. You can assign one or more data access
specialist/s from the audit team who are technically
accomplished. They can administer and manage data
brought in with ETL for ACL AuditExchange and ensure that
all team members use a consistent and proven set of data
to complete high-quality audits.
Flat fi les
