Simba Sage Intacct ODBC Connector
Real-Time Sage Intacct in Excel, BI, ETL, and Beyond
Unlock Insights From Sage Intacct
Sage Intacct runs the financial backbone of fast-growing organizations: general ledger, AP, AR, cash management, purchasing, employee expenses, and the dimensional structures that tie revenue, spend, and people to entities, departments, projects, and locations. The Simba Sage Intacct ODBC Connector gives your BI tools, reporting platforms, and custom applications a direct SQL connection to that data through the Sage Intacct API, so your product can stop forcing customers into spreadsheets and start querying Intacct the way it queries every other system in your stack. Behind the scenes, the connector translates standard SQL into native Sage Intacct API calls, handles authentication with Sage Intacct, scopes queries to the correct company, and returns results as relational tables that Power BI, Tableau, Excel, Logi Symphony, and your ETL pipelines can read out of the box. Modern encryption, a consistent ODBC interface, and predictable connection behavior make it a clean choice for product teams shipping Sage Intacct connectivity inside their applications without standing up a separate replication pipeline.
Why Sage Intacct Connectivity Slows Product Teams
Sage Intacct Integrations Are Never Truly Done
Pulling Sage Intacct data into analytics tools usually means hand-writing API calls, parsing XML, and rebuilding the pipeline every time the schema changes. Engineering hours pile up on plumbing instead of shipping product.
Customers Choose Excel Over Your Reporting
Your users default to exporting Sage Intacct reports to Excel and stitching them into dashboards by hand. Numbers drift between versions, refresh cycles slip, and the audit trail ends up buried in email attachments instead of a queryable source.
Every New Entity Adds Integration Overhead
Every Sage Intacct customer brings their own company IDs, credentials, and entity structure. Code that works for one entity needs rework for three: more authentication paths, more edge cases, more support tickets when something maps wrong.
Bring Sage Intacct Data Into the Tools You Already Use
SQL Access on Top of the Intacct API
The connector translates standard SQL into native Sage Intacct API calls. Your team writes SELECT statements; the connector handles authentication, pagination, XML parsing, and response mapping. No custom integration code for your team to maintain or rebuild when the schema shifts.
Embed Sage Intacct Access Into Your Product
ODBC is a standard your platform already speaks. Connect your reporting engine, embedded analytics, ETL pipeline, or custom app to Sage Intacct without sending customers to Excel for the data your product can't reach today.
Multi-Entity Customers, One Integration Path
Company-scoped connections handle each customer's entity structure through the same connector. Add a new Sage Intacct customer, single or multi-entity, without forking your integration code or adding a new auth path for every company ID.
Financial Data From Across Sage Intacct
The connector brings Sage Intacct GL, AR, AP, cash, and dimensional data into your BI tools, ETL pipelines, custom apps, and embedded reporting through standard SQL.
GL Accounts
Journal Entries
AR Invoices
AP Bills
Customers
Vendors
Departments
Locations
Employees
Need access to additional Intacct entities? Contact us to discuss your requirements.
Features
SQL Access to Sage Intacct via ODBC: Connect to Sage Intacct using SQL queries from analytics applications like Microsoft Excel, Power BI, Logi Symphony, QlikView, Tableau, and more, through the ODBC interface.
Native Sage Intacct API Integration: Translates SQL into native Sage Intacct API calls, eliminating the need for custom Web Services integration code or third-party replication.
ODBC 3.80 Compliant Connector: Provides 32- and 64-bit ODBC 3.80 compliant connectivity for standardized integration with your existing analytics and reporting tools.
Automatic Schema Mapping: Maps Sage Intacct objects into relational tables that BI and analytics tools can read out of the box, with no manual schema modelling required.
Web Services Authentication: Authenticates against Sage Intacct using your Web Services credentials, supporting both DSN-based and connection string workflows.
Company-Scoped Connections: Scope each connection to the correct Sage Intacct company, keeping multi-entity reporting cleanly separated.
Modern Encryption: Connections use modern TLS encryption to protect financial credentials and query traffic in transit.
DSN and DSN-Less Connection Support: Use a traditional DSN or pass a full connection string at runtime, with configuration options accessible through both the UI and key-value pairs in the string.
Configurable Logging: Tune log level, log path, maximum number of log files, and maximum file size to fit your operational and compliance requirements.
Flexible Licensing Options: Offers simple per-host licensing (server or desktop) with the same cost regardless of processors or cores. Departmental, enterprise, and worldwide licensing are available on request.
OEM Licensing Options: OEM licensing is available for organizations that want to embed or redistribute the technology as part of their own commercial software, appliance, platform, or bundled solution. This option is designed for partners who need licensing aligned to their product packaging, deployment model, and customer distribution requirements.
Specifications
Supports Sage Intacct API: Fully compatible with the Sage Intacct Web Services API.
32- and 64-Bit Application Support: Works seamlessly with both 32-bit and 64-bit applications.
ODBC 3.80 Compliance: Adheres to the ODBC 3.80 specification for standardized database connectivity.
Unicode Support: Fully supports Unicode for international character sets and data.
Enhanced Security Measures: TLS encryption for connections, scoped authentication, and configurable connection behavior to fit governed finance environments.