Access to hard-to-expose sources
It fits when the database or DSN is only reachable from the customer's private network.
ODBC, DSN and local agent
Automate ODBC reporting with a local agent and without exposing the database
When the source depends on a DSN, a local driver or an internal network, the local agent makes it possible to run queries from the customer environment and send the result to the platform without publishing the database.
You can sign up without a card and validate with a test source when it fits your schedule.
Local connectors in context
ODBC and the agent are the bridge—link ERP, IBM i and SQL Server as your architecture requires.
What this approach adds
Less security friction
The cloud does not need a public IP for the database to start validating the flow.
Continuity with existing processes
Your team keeps drivers, DSN and access logic where they already work today.
When it fits best
Especially useful when the limitation is not the query but connectivity.
- Generic ODBC with a DSN already configured in the customer network.
- Legacy software that requires specific local drivers.
- Firewall or compliance restrictions that prevent direct cloud access.
- Teams that need to validate manually first and scale afterwards.
Frequently asked questions
Does the local agent completely replace opening the firewall?
It avoids exposing the database with a public IP, but your team still needs to allow the agent's outbound traffic to the required endpoints.
Can I schedule reports if the source depends on the agent?
It depends on the connection type and the current product support for that source. Initial validation is precisely how you confirm that point.
Product guide index
All public pages by use case: they help visitors and search engines see how topics connect—without mixing unrelated products.
Check whether your ODBC source fits with a local agent
Sign up, review connectivity requirements and validate a real case before broadening scope.
If you want to compare quotas and plans before creating an account, use the pricing section on the home page.