All Connectors ⋅ Generic Database (ODBC) Generic Database Supports:ODBCOLEDB 3 Minute Video View Live Demo Generic Database Connector Overview Frequently Asked Questions Overview SmartConnect with ODBC/OLEDB There are tens of thousands of software applications in the mid market. Some of these have web service API’s, some are cloud based, some have prebuilt connectors for SmartConnect and some export XML files. For all the other on premise applications that you need to connect to, SmartConnect provides the ability to connect directly through an ODBC/OLEDB connection to get at that data for your integrations. Leverage Your Legacy Data Direct database connections mean that SmartConnect can connect to all your legacy applications as long as there is an ODBC/OLEDB driver available. So whether you need to connect to an old Quick Books, MYOB, a MYSQL database, an upscale Oracle system or any other home grown legacy database based software – SmartConnect has you covered. Frequently Asked Questions Is there a downside to using ODBC? No, but there are a few things to watch for. With our prebuilt connectors we go to great lengths to provide users with friendly names for tables and fields and have built in specific functionality to handle software quirks (for example GUID’s for CRM). With ODBC you are connecting directly so you see table names and fields in their raw form. This can be daunting, but for anyone that understands those databases this can be the easiest way to connect. See For Yourself Signup for the Webinar Do More with ODBC/OLEDB + SMARTCONNECT Legacy Data Bridge the time gap and utilize data from mature applications with ODBC. Excel Add-in Enter data into Excel and have it end up in any app via the ODBC connection. No API. No Problem. ODBC / OLEDB connections allow you to work with apps that don't have an API. Direct Queries Use the ODBC connector for rocket fast data retrieval that bypass slow business rules. CONNECT ODBC DATA TO ALL OF YOUR BUSINESS APPS See how SmartConnect gets your data working together with other platforms including: Salesforce CRM Dynamics GP Xero Cloud ERP Dynamics NAV Web Services Dynamics CRM Microsoft SQL Flat File / Folder Excel Add-In View All Connectors FREE EBOOK DOWNLOADThe 10 Commandments of Data Integration READ IT NOW Free 30 Day Trial Get Started Now © 2016 SmartConnect by eOne Solutions. All Rights Reserved.