Access CRM data like you would a database - read, write, and update Leads, Contacts, Opportunities, Accounts, etc. through a standard ODBC Driver interface.
Features and Benefits
ODBC 3.8 compliant native protocol based drivers.View All Features
Unicode, 32-bit and 64-bit support
Support 32-bit and 64-bit applications and unicode ODBC APIs.View All Features
Our drivers undergo extensive testing and are certified to be compatible with leading analytics and reporting applications like Tableau, Microsoft Excel, and many more.View All Features
Our exclusive remoting feature allows hosting the ODBC connection on a server to enable connections from various clients on any platform (Java, .NET, C++, PHP, Python, etc.), using any standards based technology (ODBC, JDBC, etc.). ODBC Remoting is enabled using the popular MySQL wire protocol server.View All Features
Standards-Compliant ODBCODBC 3.8 compliant native protocol based drivers.
Unicode, 32-bit and 64-bit supportSupport 32-bit and 64-bit applications and unicode ODBC APIs.
Certified CompatibilityOur drivers undergo extensive testing and are certified to be compatible with leading analytics and reporting applications like Tableau, Microsoft Excel, and many more.
ODBC RemotingOur exclusive remoting feature allows hosting the ODBC connection on a server to enable connections from various clients on any platform (Java, .NET, C++, PHP, Python, etc.), using any standards based technology (ODBC, JDBC, etc.). ODBC Remoting is enabled using the popular MySQL wire protocol server.
Replication and CachingOur replication and caching commands make it easy to copy data to local and cloud data stores such as Oracle, SQL Server, Google Cloud SQL, etc. The replication commands include many features that allow for intelligent incremental updates to cached data.
String, Date, Numeric SQL FunctionsThe driver includes a library of 50 plus functions that can manipulate column values into the desired result. Popular examples include Regex, JSON, and XML processing functions.
Collaborative Query ProcessingOur drivers enhance the data source's capabilities by additional client-side processing, when needed, to enable analytic summaries of data such as SUM, AVG, MAX, MIN, etc.
Easily Customizable and ConfigurableThe data model exposed by our ODBC Drivers can easily be customized to add or remove tables/columns, change data types, etc. without requiring a new build. These customizations are supported at runtime using human-readable schema files that are easy to edit.
Secure ConnectivityIncludes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.
Straightforward ODBC ConnectivityAccess SugarCRM data through widely available tools - standard ODBC interface offering the greatest accessibility from applications and developer technologies.
BI, ETL, & Reporting Tool IntegrationODBC is the most widely supported interface for connecting applications with data. All kinds of BI, Reporting, ETL, Database, and Analytics tools offer the ability to read and write data via ODBC connectivity.
Build Apps That Connect To SugarCRMAs the most widely used interface to relational data, ODBC interfaces are accessible from every major development technology, including PHP, Python, Delphi, Visual Basic, Labview, PowerBuilder, FoxPro, FileMaker Pro, and more.
SupportPhone Support: (919) 928-5214
Support Email: firstname.lastname@example.org
Support Knowledge Base: http://www.cdata.com/kb/
Terms & ConditionsTerms of Service: http://www.cdata.com/company/legal/terms.aspx