Introduction to Integrations
The Dattos platform was designed to operate as a secure hub between your environment and the financial data ecosystem. Instead of relying on manual exports, you connect the platform to your sources—ERP systems, banks, internal systems, files—and it automatically retrieves and delivers data, with protected credentials and auditable access. This article is the starting point: it introduces the integration options and points you to the right article for each path.
What you can connect
ERPs with native connectors: SAP S/4HANA, SAP Business One, Dynamics 365 Finance & Operations, Dynamics 365 Business Central, Oracle NetSuite, Oracle E-Business Suite, and Sankhya—using the ERP step in the data preparation flow, which extracts ready-to-use reports through each system’s official APIs.
Any system with an API or database: the API Rest and Database steps support custom integrations with systems that don’t have a native connector—or with reports the connector doesn’t provide.
Files and storage services: spreadsheets, text files, PDFs (with extraction by Dattos AI), XML, and specialized financial formats (CNAB, OFX, SPED, NF-e, acquirer EDI, SWIFT), with automatic collection from SFTP and FTP servers and Amazon S3, Azure Blob Storage, and Google Cloud Storage buckets, through the Source Directory.
Banking institutions: account statements and data via Open Finance (with consent) or through a banking VAN (financial file exchange), as well as direct bank APIs.
Outputs to other systems: export steps generate Excel spreadsheets, text files, PDF/HTML documents, and direct database loads; the Output Directory delivers files to file repositories.
BI tools and spreadsheets: the Data Lake exposes results as an SQL/ODBC source for Power BI, Tableau, dbt, or Excel—without exporting files.
Scripts, pipelines, and AI assistants: the Dattos CLI operates the platform from the command line (automation, CI/CD), and the MCP server connects assistants such as Claude and ChatGPT to your processes and data.
Where each integration is configured
Most integrations are configured directly in the data preparation flow for Turbo AI processes—each source and each export is a step in the flow. Three integrations are exceptions:
SFTP and storage services: enabled in the credentials/integrations settings and selected in the processes’ Source and Output Directories.
Open Finance: set up through the Integrations menu, with authorization from the account holder.
Banking VAN: enabled as a service by the Dattos implementation team upon request.
How to choose a path
Start with the native connector. If your ERP is on the list and the report is available, the ERP step requires the least technical configuration.
No connector or no report? Use custom integrations: the API Rest step (system with an API) or the Database step (direct SQL access or access through an intermediary database).
High volume? For more than 500,000 records per run, avoid APIs—use a database or file exchange instead.
Banking data? Prefer Open Finance when the bank is available; use a VAN for file-based operations.
Is the destination a BI tool? Don’t export files—connect the tool to the Data Lake.
Need to operate the platform outside the UI? For a fixed sequence of steps that must be repeated identically (scheduled runs, pipelines, replicating a process across environments), use the Dattos CLI. For a path that depends on what you find (investigating, exploring, diagnosing), or for a non-technical operator, use MCP with an AI assistant.
Systems on an internal network: when the ERP or database cannot be accessed over the internet, you can connect through a site-to-site VPN/VPC—a private, encrypted tunnel between the Dattos environment and yours, without exposing any services publicly. Contact support for an assessment.
Where to go next
Custom integrations via API Rest and SQL connectors.
File repositories: which ones Dattos connects to and how to set them up.
Banking integration: overview.
Data Lake: connect your BI tool or spreadsheet.
ERP step—and the configuration articles for each connector (ERP Integration: SAP S/4HANA, SAP Business One, Dynamics 365, Oracle NetSuite, Oracle E-Business Suite, Sankhya).
Export steps: Excel Export, Text File Export, Document Export, Database Export.
Dattos CLI: installation and getting started—and Connecting AI assistants via MCP.