integration

SQLServerCentral Article

Easily Integrate with Any RESTful API Using the CData API Driver

  • Article

The evolution of APIs has opened up exciting opportunities for businesses. RESTful APIs are a consistent, straightforward way that enables businesses to work with external data and offer access to their own data. In May 2021, the number of public APIs grew beyond 24,000, with about 2,000 APIs added just since 2019.  APIs continue to be beneficial to businesses and developers, and with the CData API Driver, it […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2021-11-15

1,182 reads

SQLServerCentral Article

CData AWS Glue Connector for Salesforce Deployment Guide

  • Article

AWS Glue is an ETL service from Amazon that enables you to prepare and load your data for storage and analytics. With Glue Studio, you can create no-code and low-code ETL jobs that work with data through CData Glue Connectors. In this article, we walk through configuring the CData Glue Connector for Salesforce and creating and […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2021-11-05

319 reads

SQLServerCentral Article

Configure the CData Cloud Add-On for Google Sheets

  • Article

With Google Sheets you can create branded reports with data visualizations to share with your clients. Combined with CData Cloud, Google Sheets give you cloud-to-cloud access to data from the supported SaaS, Big Data and NoSQL sources for visualizations, dashboards, and more. In this article we explain how to use the CData Cloud Add-On to […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2021-11-01

580 reads

SQLServerCentral Article

Connecting to Amazon DocumentDB with MongoDB Drivers

  • Article

With Amazon DocumentDB developers and DBAs can balance availability, read scalability, and latency with five pre-configured consistency levels. The data in an Amazon DocumentDB cluster is accessible just like a MongoDB 3.6 cluster. The CData Software Drivers for MongoDB provide a SQL-like interface to MongoDB data through standards-based drivers. This allows users to see their data in the […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2021-10-27

437 reads

SQLServerCentral Article

CData Connect: Derived Views and Query Federation

  • Article

Big data plays a key role in promoting both manufacturing and scientific development through industrial digitization and emerging research. Integrating big data demands scalable tools for enabling not only big data ingestion and curation but also efficient large-scale exploration and discovery. There is a solution to scale up to large volumes of data distributed across multiple […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2021-10-22

255 reads

SQLServerCentral Article

Connect to PostgreSQL as an External Data Source using PolyBase

  • Article

PolyBase is a new feature of SQL Server that allows you to connect to relational and non-relational data. You can run queries on any external data sources you might have, such as Oracle, PostgreSQL, Salesforce, MongoDB, Hadoop, etc. When paired with the CData ODBC Driver for PostgreSQL, you get access to your PostgreSQL data directly […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2021-10-18

2,347 reads

SQLServerCentral Article

Connect to SAP HANA Data as a Linked Server

  • Article

The SQL Gateway enables you to configure a TDS (SQL Server) remoting service and set up a linked server for SAP HANA data.  After you have started the service, you can use the UI in SQL Server Management Studio or call stored procedures to create the linked server. You can then work with SAP HANA data just […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2021-09-29

4,100 reads

SQLServerCentral Article

Create an RPA Flow that Connects to Oracle Data in UiPath Studio

  • Article

If your company uses legacy technology systems, you can use the UiPath RPA platform to extend your process automation capabilities to these systems and eliminate repetitive, error-prone tasks of manually updating them. By using UiPath Studio, you can build an RPA program just like drawing a diagram.  With the CData ODBC Driver for Oracle, users can embed Oracle data in the workflow.  Let’s […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2021-09-24

1,369 reads

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

Need to group the same valued ID fields to run an aggregate average over them

By Zososql

I have data that contains poll results, with the poll_id consistuting a single row...

SSIS Question

By water490

Hi everyone.  I am re-writing a portion of my SSIS logic.  My SSIS package...

How are statistics stored?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How are statistics stored?

Visit the forum

Question of the Day

How are statistics stored?

How are the statistics for query optimization stored in SQL Server?

See possible answers