Simba Epicor ODBC Data Connector
Bring Your Epicor Kinetic ERP Data
into Your Tools
Unlock Insights From Epicor Kinetic
Epicor Kinetic holds the operational truth of your business: jobs in progress, part inventories, BOMs, sales orders, supplier deliveries, AR and AP balances, and shop floor labor. The Simba Epicor ODBC Driver gives your BI tools, reporting platforms, and custom applications a direct SQL connection to that data through the Epicor Kinetic REST API (v2), so analysts and developers can stop hand-coding REST calls and start querying Kinetic the way they already query every other system in your stack. Behind the scenes, the driver translates standard SQL into native Kinetic REST API calls, handles authentication with Epicor, scopes queries to the right Company, and returns results as relational tables that Power BI, Tableau, Excel, Logi Symphony, and your ETL pipelines can read out of the box. SSL encryption with peer and host verification, support for the Windows trust store or a custom certificate path, and broad cross-platform coverage across Windows, macOS, and major Linux distributions make it ready for regulated manufacturers, distributors, and retailers running Kinetic at scale.
Why Epicor Kinetic Data Is Hard to Use for Reporting
Custom REST Code Drains Engineering Cycles
Pulling Kinetic data into analytics tools usually means hand-writing REST calls, paginating results, parsing JSON, and patching the pipeline every time Epicor updates a service. Engineering hours pile up on plumbing instead of delivering analytics.
Cloud Kinetic Blocks Direct Database Access
Cloud Kinetic does not expose its underlying database. Teams that relied on direct SQL connections lose that path, leaving them with manual exports, screen-level reports, or costly third-party replication tools just to see their own ERP data.
Replicated Extracts Lag the Shop Floor
Nightly extracts and warehouse syncs leave production, inventory, and order data hours behind reality. By the time a dashboard refreshes, the job has moved, stock has shifted, and decisions get made on yesterday rather than what is happening now.
Bring Kinetic Data Into the Tools You Already Use
SQL Access on Top of Kinetic REST
The driver translates standard SQL into native Epicor Kinetic REST calls. Analysts write SELECT statements; the driver handles authentication, pagination, JSON parsing, and response mapping, with no custom integration code to maintain.
Drop-In Connectivity for BI and ETL
Connect Power BI, Tableau, Excel, Logi Symphony, QlikView, and your ETL tools to Kinetic through the ODBC interface they already speak. Kinetic data joins your analytics stack on day one, without new tools, query languages, or training cycles.
Enterprise Security and Multi-Company Scope
API Key authentication, SSL with peer and host verification, and trust store or custom cert path support keep connections secure. The Company parameter scopes each connection to the correct Kinetic instance, ideal for finance and reporting teams across multi-Company deployments.
Financial and Master Data From Kinetic
The driver brings Kinetic financial, GL, and core master data into your BI tools, ETL pipelines, custom apps, and embedded reporting through standard SQL.
GL Accounts
Chart of Accounts
AP Invoices
Budgets
Fiscal Periods
Payment Terms
Customers
Suppliers
Parts and Inventory
Features
SQL Access to Epicor Kinetic via ODBC: Connect to Epicor Kinetic using SQL queries from analytics applications like Microsoft Excel, Power BI, Logi Symphony, QlikView, Tableau, and more, through the ODBC interface.
Native Epicor Kinetic REST API v2 Integration: Translates SQL into native Epicor Kinetic REST calls, eliminating the need for custom REST integration code or third-party replication.
ODBC 3.80 Compliant Connector: Provides 32- and 64-bit ODBC 3.80 compliant connectivity for Windows, macOS, and Linux platforms.
Automatic Schema Mapping: Maps Kinetic resources into relational tables that BI and analytics tools can read out of the box, with no manual schema modelling required.
API Key and Basic Authentication: Authenticates against the Kinetic Server using your Epicor API Key combined with Basic Authentication credentials, supporting both SQLBrowseConnect and SQLDriverConnect.
Company-Scoped Connections: The Company connection parameter scopes each session to the correct Kinetic Company, making it clean to support multi-plant and multi-entity Epicor deployments.
SSL Encryption With Trust Store Support: Supports one-way SSL authentication with peer and host verification, using the Windows trust store or a custom certificate path defined through the TrustCertsPath property.
Configurable Logging: Tune log level, log path, maximum number of log files, and maximum file size to fit your operational and compliance requirements. 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.
Cross-Platform Compatibility: Compatible with Windows, macOS, and major Linux distributions for flexible deployment across on-premises, cloud, and hybrid environments.
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 Epicor Kinetic API v2: Fully compatible with version 2 of the Epicor Kinetic REST 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: SSL with peer and host verification, Windows trust store support, custom certificate path via TrustCertsPath, and configurable HTTPS endpoints.