SharePoint Excel Services ODBC/JDBC Driver from CD

Posted by: CData Software

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

Connectivity Data Integration Connectors Developer Tools

Start trial

Overview
Features
Support

Overview

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