DataDirect Connectors  REST API (OData) for Microsoft SQL Server

Microsoft_SQL_server
  • Get guaranteed reliability with comprehensive quality testing and true compliance to OData - the standard for RESTful APIs
  • Quickly connect to and easily implement OData connectivity from any application
  • Get real-time data movement to your cloud application with Microsoft SQL Server
Table of Contents:

    Features

    Lightweight Data Gateway

    Access back-office data behind the firewall securely using our patented on-premises connector that can be optionally deployed in the DMZ or behind the corporate firewall. Get trusted hybrid data access without requiring major network/firewall configurations such as setting up a VPN or SSH tunneling.

    Horizontal Scaling

    Hybrid Data Pipeline can be deployed in cloud and enterprise environments across multiple nodes behind a load balancer. Incoming requests can be evenly distributed across cluster nodes.

    Universal Connectivity

    Get real-time connectivity to the latest SaaS, SQL, Big Data and NoSQL data sources such as Salesforce, Apache Hive, Amazon Redshift, Oracle, SQL Server, IBM DB2, Eloqua, Google Analytics and more.

    SeeHide supported data sources
    Secure

    All customer-sensitive data elements (including remote credential or database pairings stored) are protected by encryption, both at rest (AES-256) and in transit. Read our security paper.

    Throttling

    Limits API allows administrators to set limits on how many rows can be returned for ODBC, JDBC, and OData requests. An error is returned if an application fetches rows beyond the specified limit.

    Support for OData 4 and OData 2

    You can deploy OData 4 or OData 2 or both the endpoints over any data source. Progress DataDirect is a member of the OData Technical Committee and we stay on top of the OData specification updates.


    Technical Specifications

    Progress DataDirect Hybrid Data Pipeline

    Interface Support

    • Microsoft SQL Server 2000 and higher
    • OData 2.0 (read/write)
    • Certified & tested with Salesforce lightning connect, Oracle Service Cloud

    Platform Support

    • Microsoft Windows, Linux, HP-UX, AIX, Solaris and more

    Operating System Support

    • Supports both 32-bit and 64-bit applications

    SQL Version

    • ANSI SQL-92 compliant

    Documentation

    Progress Hybrid Data Pipeline Documentation

    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.


    Videos

    Provide OData Access to SQL Server Data using DataDirect Cloud

    OData is the standard for REST / SOAP APIs. DataDirect Cloud provides simple, secure access to cloud and on-premises data sources for your business intelligence tools and other applications. This video shows you how to create data source definitions for both an on-premise and a cloud-based Microsoft SQL Server and how to use SQL Testing to run queries.

    Access SQL Server behind the firewall using our On-Premise Connector

    DataDirect Cloud comes with an on-premise connector that allows your Cloud/SaaS applications to access data behind the firewall without having to change the network configurations, or setting up VPNs or changing firewalls. This video shows you how to use our On-Premise connector to connect to a SQL Server behind the firewall.


    Related Resources

    10_reasons_you need_high_performance

    IN THE SPOTLIGHT

    Top 10 Reasons You Need High-Performance Data Connectivity

    Data Connectivity is a critical but often overlooked component of the IT infrastructure. These components have dramatic effects on application performance, reliability and portability. Learn about the top 10 reasons why high-performance data connectivity is critical for your business.

    Download the Flyer
    SQL_Server_Solutions

    Solution Page

    Learn What DataDirect can do for your SQL Server Shops

    Progress DataDirect is the trusted name in data connectivity for Microsoft SQL Server Ecosystems. Learn how to securely bind your sql server to SaaS, Relational, NoSQL and Big Data Sources using our certified ODBC, JDBC and ADO.NET Drivers and the OData API.

    SQL Server Solutions

    Expose OData

    Cloud Solutions

    Learn how we produce OData instantly

    Hybrid Connectivity Services will let you deploy OData (Standard REST) API for your data source through clicks-not-code. Learn more about how DataDirect’s Hybrid Connectivity Services can help you democratize your data in an age where data is siloed across many SaaS and On-Premises sources.

    Explore Hybrid Connectivity Services

    bg-air-dci-revamp
    Microsoft SQL Server Connectors are Part of Progress Data Connectivity & Integration Solutions
    icon-info-b

    DataDirect Connectors

    Connect any data source to any application

    icon-contact-us-b

    Contact Us

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