Excel Integration Requirements

The following are the prerequisites necessary for IBM Automatic Data Lineage to connect to this third-party system, which you may choose to do at your sole discretion. Note that while these are usually sufficient to connect to this third-party system, we cannot guarantee that the connection or integration will be successful since we have no control, liability, or responsibility for third-party products or services, including for their performance.

• Excel workbooks in XLSX or XLSM format
• ODC files (required if a PowerPivot data model is used)
  • Located in the C:\Users\<username>\Documents\My Data Sources directory by default in Windows
• The scanner is designed to analyze and import data lineage information to Automatic Data Lineage based on formulas, pivot charts and pivot tables, and connections to databases and other sources. It is not intended for importing actual data/rows to Automatic Data Lineage nor does it do so.