HPCC ODBC/JDBC Driver from CData
Posted by: CData Software
With the CData Driver you can access HPCC data within Informatica the same way you would connect to any other ODBC/JDBC data source.The CData Driver allows you to connect-to live HPCC data through any ODBC/JDBC capable application or tool!The CData ODBC/JDBC Driver for HPCC is a standards based pure Java type 4 ODBC/JDBC driver.
Overview
ODBC Driver:The HPCC ODBC Driver allows you to connect with live HPCC data directly from any application that supports ODBC connectivity. ODBC is the most widely supported interfaces 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, including Informatica.The HPCC Driver wraps the complexity of accessing HPCC services in an easy-to-integrate ODBC Driver. Our Driver hides the intricacies of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more. JDBC Driver:The HPCC JDBC Driver allows you to connect to HPCC data through an easy-to-use, bi-directional, fully-managed Java Driver. JDBC is the most widely supported interfaces for connecting Java-based applications with data. All kinds of BI, Reporting, ETL, Database, and Analytics tools offer the ability to read and write data via JDBC connectivity. This allows you to connect to HPCC from the BI, ETL, or reporting tool of your choice, including Informatica.The HPCC Driver wraps the complexity of accessing HPCC services in an easy-to-integrate, pure Java JDBC Driver. Applications then access HPCC data through the HPCC Driver with simple Transact-SQL. The Driver hides the intricacies of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.
Features
ODBC Driver:- Standards-Compliant ODBC: ODBC 3.8 compliant native protocol based drivers.
- Unicode, 32-bit and 64-bit support: Support 32-bit and 64-bit applications and unicode ODBC APIs.
- Certified Compatibility: Our drivers undergo extensive testing and are certified to be compatible with leading analytics and reporting applications like Tableau, Microsoft Excel, and many more. Secure Connectivity.
- Replication and Caching: Our 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.
- Secure Connectivity: Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.
- Easily Customizable and Configurable: The 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.
- Full Read/Write Functionality: Comprehensive support for CRUD (Create, Read, Update, and Delete) operations.
- Pure Java Type 4 Drivers: 100% Java architecture based drivers that implement the native protocol without reliance on client-side libraries.
- All-in-One Deployment: Single JAR that supports JDBC 3.0 and JDBC 4.0 specification and JVM versions 1.5 and above.
- Certified Compatibility: Our drivers undergo extensive testing and are certified to be compatible with leading analytics and reporting applications like SAP Crystal Reports, Pentaho, Business Objects, and many more.
- Secure Connectivity: Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.
Support
CData Software is a leading provider of data access & connectivity solutions. We excel in the development of Drivers and data technologies for live access to applications, databases, and Web APIs.. HeadquartersCData SoftwareSuite 300, 600 Market St.Chapel Hill, NC 27516United States Website www.cdata.com| Email : | support@cdata.com |
| Phone : | US: 1-800-235-7250 (Option 4)Int’l: +1-919-928-5214 (Option 4) |
| Fax : | +1-919-287-2230 |
| Website : | http://www.cdata.com/ |
Comments (0)