datadirect-connectors-head-banner

Microsoft SharePoint JDBC Driver

Select your platform

salesforce

Table of Contents:

    Overview

    Progress DataDirect’s JDBC Driver for Microsoft SharePoint offers a high-performing, secure and reliable connectivity solution for JDBC applications to access SharePoint data. Our JDBC driver can be easily used with SQL across both 32-bit and 64-bit platforms. Enjoy real-time analytics, reporting and business intelligence (BI) capabilities with your favorite tools such as SAS, Yellowfin, SAP, Sisense, Denodo, Cognos, Jaspersoft, Tableau, Tibco, OBIEE, and more.

    • Supports SQL read-write access for JDBC applications to list resources on Microsoft SharePoint Online
    • Creates a relational map of the SharePoint data model and translates SQL statements to SharePoint requests
    • Employs a SQL engine component that provides support to SQL constructs unavailable in Microsoft SharePoint

    Features

    SQL Up Leveling/ Full ANSI SQL Support

    SQL up-leveling provides the capability to write a SQL statement that can be executed across multiple databases, regardless of the databases’ SQL implementation. For example, a SQL statement written against Oracle will also be interoperable with DB2.

    Encryption SSL 3.0, TLS 1.0, 1.1, 1.2 Compliant

    We keep our SSL version up to date. Upon identification of any security vulnerability, Progress will exercise commercially reasonable efforts to address the vulnerability in accordance with the following policy.

    Performance Tuning

    Progress DataDirect management of packet-based network communication provides unsurpassed packet transport, network round trips and data buffering optimization. (socket management). Includes performance methodology for throughput and resource utillization (CPU/memory)

    TSANet Multi-Vendor Support Channel

    We live for your next big customer. Make sure your customers are successful with 24/7 partner support and access to expertise from our engineering teams, partnerships and leading technology companies such as Microsoft, Oracle, and IBM through our TSANet multi vendor support channel.

    Day 1 Support for any new versions

    Day One Support for disruptive technologies with frequent release cycles. With this strategy - the first of its kind for any data connectivity provider - Progress DataDirect on-premises ODBC and JDBC drivers will support any new versions of supported data sources.

    High-performing Type 5 JDBC Driver

    Type 5 JDBC drivers offer the same client-side, single-tier, 100% Java architecture of Type 4 JDBC drivers, but address the limitations of many of the Type 4 JDBC drivers. Unlike a type 4 JDBC driver, our type 5 JDBC driver maximizes data throughput while using minimal amount of CPU and memory resources. You can learn more over here

    Codeless Bulk Load / Export

    Progress DataDirect JDBC drivers support bulk load through JDBC batch inserts or the DDBulkLoad object. This means existing applications, such as Apache Sqoop, can get bulk insert performance without any code changes or external tools such as bcp for SQL Server or SQL*Loader for Oracle. Refer to this blog for more details.


    Technical Specifications

    Progress DataDirect for JDBC for Microsoft SharePoint
    Version 6.0.0

    Supported Versions

    • SharePoint Online lists

    Platform Support

    • 32- and 64-bit platforms

    Software Requirements

    • Java Virtual Machine (JVM): Java SE 8 or higher (LTS version), including Oracle JDK, OpenJDK, and IBM SDK (Java) distributions.

    Documentation

    Progress DataDirect for JDBC for Microsoft SharePoint
    Version 6.0.0


    Security Vulnerability Response Policy

    Upon identification of any security vulnerability, Progress will exercise commercially reasonable efforts to address the vulnerability in accordance with the following policy

    Priority* Time Guideline Version(s)
    High Risk
    (CVSS 8+ or industry equivalent)
    30 days Active (i.e. latest shipping version) and all Supported versions
    Medium Risk
    (CVSS 5-to-8 or industry equivalent)
    180 days Active (i.e. latest shipping version)
    Low Risk
    (CVSS 0-to-5 or industry equivalent)
    Next major release or best effort Active (i.e. latest shipping version)

    * Priority is established based on the current version of the Common Vulnerability Scoring System (CVSS), an open industry standard for assessing the severity of computer system security vulnerabilities. For additional information on this scoring system, refer to https://en.wikipedia.org/wiki/CVSS.


    Related Resources

    Webinar

    Empower IT Efficiency with Easy Connectivity to Back Office Systems

    Every company maintains a back office. However, pulling the data out of back office applications for cross-system reporting can be difficult. In this webinar, see how our back office connectors help you get the data you need without burdening IT. 

    Join us for a 30-min walk-through to learn how you can help your customers:

    • Connect back office apps to a unified BI dashboard without maintaining API connections
    • Get a complete view of back office systems without custom development
    • Monitor data in real-time to spot themes and trends as they emerge

    Watch Webinar

    Webinar

    Shining the Light on Shadow Analytics with Martech Data Connectivity

    Shadow analytics presents a real problem for modern businesses. But with so many different martech tools in use and so much data being created, data connectivity obstacles can get in the way of productivity. Join us to see how you can overcome shadow analytics with instant connectivity to vital martech data.

    Watch Webinar

    Paper

    Then, Now and Beyond: The Future of Back Office Software

    Back office systems are the unsung heroes of today’s enterprises, powering many critical functions in finance, human resources, supply chain and operations. 
    Download this ebook to see how the back office landscape has evolved and how new data connectivity solutions can help you keep up with shifting needs of today’s businesses.  

    Download Paper

    Paper

    Shadow Analytics: What It Is and Why You Can’t Afford to Leave It Unchecked

    Thousands of martech solutions are being introduced every year, which makes it difficult to access the data from these solutions for reporting. Now, employees are going rogue and turning to “shadow analytics” to get what they need. So, what is shadow analytics and what can you do to stop it? Find out in our latest whitepaper.

    Download Paper

    Customer Success Stories

    Success Story

    Mizuho Bank

    DataDirect Helps Mizuho Bank Integrate Disparate Technology for Access to Real-Time Market Data. 

    Learn More

    Connect any application to any data source anywhere

    A product specialist will be glad to get in
    touch with you