Google Sheets ODBC/JDBC Driver from CData

Google Sheets ODBC/JDBC Driver from CData

Posted by: Informatica Cloud

With the CData Driver you can access Google Sheets 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 Google Sheets data through any ODBC/JDBC capable application or tool!The CData ODBC/JDBC Driver for Google Sheets is a standards based pure Java type 4 ODBC/JDBC driver.

Overview

ODBC Driver:The Google Sheets Driver allows you to connect with live Google Sheets data directly from any application that supports ODBC connectivity. ODBC 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, including Informatica.The Google Sheets Driver wraps the complexity of accessing Google Sheets 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 Google Sheets JDBC Driver allows you to connect to Google Sheets 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 Google Sheets from the BI, ETL, or reporting tool of your choice, including Informatica.The Google Sheets Driver wraps the complexity of accessing Google Sheets services in an easy-to-integrate, pure Java JDBC Driver. Applications then access Google Sheets data through the Google Sheets 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.

ODBC Driver:

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.. Headquarters CData Software Suite 300, 600 Market St. Chapel Hill, NC 27516 United States www.cdata.com

support@cdata.com Phone No : US: 1-800-235-7250 (Option 4) Int?l: +1-919-928-5214 (Option 4) Fax : 1-919-287-2230 http://www.cdata.com/

Comments (0) Comment can only be posted by Signed/Logged in user