Yes — there are several activity/data collection and observability tools that can ingest from ERP systems, spreadsheets, and APIs, while also providing strong data lineage. The best choice depends on whether you want:

• End-to-end data integration + lineage
• Data catalog/lineage with ingestion connectors
• Workflow automation / operational activity tracking
• ERP-specific integration

Here are some strong options:

1. Informatica Intelligent Data Management Cloud (IDMC)

Good for: Enterprise-grade ingestion and lineage
Supports: ERP sources, files/spreadsheets, APIs, databases, SaaS
Lineage: Very strong, one of the best in enterprise environments

Why it fits:

• Connectors for systems like SAP, Oracle ERP, Microsoft Dynamics
• Can ingest Excel/CSV/spreadsheet files
• API-based ingestion and orchestration support
• Strong end-to-end lineage, impact analysis, governance

2. Microsoft Fabric / Power BI + Data Factory

Good for: Microsoft-centric organizations
Supports: ERP connectors, Excel/SharePoint/OneDrive, APIs via Data Factory / custom connectors
Lineage: Good within the Microsoft ecosystem

Why it fits:

• Excel and spreadsheet ingestion is straightforward
• ERP data via connectors, staging, or custom pipelines
• API ingestion through pipelines and notebook workflows
• Built-in lineage in the Fabric/Power BI ecosystem

3. Talend Data Fabric

Good for: Flexible ingestion with governance
Supports: ERP, flat files/spreadsheets, APIs
Lineage: Strong, especially when paired with Talend Data Catalog

Why it fits:

• Broad connector ecosystem
• Can handle spreadsheet and ERP sources
• API integration and transformation pipelines
• Data catalog provides lineage and metadata tracking

4. Alteryx

Good for: Business users and analyst-friendly data prep
Supports: Spreadsheet-heavy workflows, APIs, some ERP through connectors
Lineage: Moderate to good, depending on setup

Why it fits:

• Excellent for Excel-centric activity data collection
• API ingestion is possible
• ERP integration often via database export, connectors, or intermediate layers
• More focused on prep and analytics than deep enterprise lineage

5. Boomi Data Integration / Boomi AtomSphere

Good for: iPaaS and workflow integration
Supports: ERP, spreadsheets/files, APIs
Lineage: Good, especially with governance add-ons

Why it fits:

• Strong ERP integration (SAP, Oracle, NetSuite, etc.)
• Handles file-based ingestion and API orchestration
• Useful when your “activity data collection” is more operational integration than analytics ETL

6. Fivetran + Data Catalog/Lineage layer

Good for: Reliable ingestion, less transformation
Supports: Many ERP/SaaS sources, CSV/Google Sheets/Excel via staging, APIs via custom connectors
Lineage: Needs augmentation

Why it fits:

• Great for ingestion from modern apps and some ERP sources
• Spreadsheet ingestion often done via cloud storage or sheets connectors
• Stronger lineage usually comes from pairing with tools like:
  • DataHub
  • OpenMetadata
  • Collibra
  • Alation

7. DataHub / OpenMetadata + ingestion tools

Good for: Central lineage and metadata management
Supports: ERP, spreadsheets, APIs if connected through pipelines/connectors
Lineage: Excellent if your pipelines emit metadata well

Why it fits:

• Not primarily ingestion tools, but very strong for lineage
• Works best when combined with ETL/ELT tools like Airbyte, Fivetran, Talend, Informatica
• Useful if “strong lineage” is the top priority

8. Celonis

Good for: ERP activity/process mining
Supports: ERP systems especially well; can ingest files and API-based data
Lineage: More process lineage/activity tracing than traditional data lineage

Why it fits:

• Excellent if you mean activity data collection in the sense of business process events from ERP
• Strong for SAP/Oracle ERP process mining
• Can combine ERP and supporting data sources
• Not a traditional data integration/lineage tool, but very relevant for activity-level data capture

---

Best fit by use case

If you want strongest lineage

• Informatica IDMC
• Collibra + ETL tool
• DataHub/OpenMetadata + ETL tool

If you want ERP + spreadsheet + API ingestion in one platform

• Informatica IDMC
• Talend
• Boomi
• Microsoft Fabric (if you’re Microsoft-heavy)

If you mean activity/process data from ERP

• Celonis
• SAP Signavio
• UiPath Process Mining

---

Practical recommendation

If you need a tool that genuinely handles ERP, spreadsheets, and API ingestion with strong lineage, the most common enterprise shortlist is:

1. Informatica IDMC
2. Talend Data Fabric
3. Boomi
4. Microsoft Fabric (especially if already on Microsoft stack)
5. Fivetran + DataHub/OpenMetadata if you want a modular modern stack

If you want, I can also give you:

• a comparison table
• open-source alternatives
• or a shortlist based on your ERP system (SAP, Oracle, NetSuite, Dynamics, etc.).