JerodJ


SQLServerCentral Article

SQL Access to Redis Data

Traditionally, importing key-value data stores such as Redis into BI, reporting, and ETL tools is problematic, if not impossible. With the CData Drivers, there are several different ways to building a traditional database model to easily work with Redis data in the BI, reporting, ETL, and custom applications of your choice. In this article, we discuss […]

5 (1)

2021-11-12

626 reads

SQLServerCentral Article

Perform API Operations Using Stored Procedures in CData SSIS Components

APIs require up-to-date and strong documentation, increased security levels, comprehensive testing, routine versioning, and high-reliability to be appropriately utilized. With the CData SSIS Data Flow components you can import and export data from various data sources. However, in some cases the type of operation you need does not fit the SSIS Source or the SSIS Destination model. The […]

2021-11-08

722 reads

SQLServerCentral Article

CData AWS Glue Connector for Salesforce Deployment Guide

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 […]

2021-11-05

200 reads

SQLServerCentral Article

Configure the CData Cloud Add-On for Google Sheets

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 […]

2021-11-01

462 reads

SQLServerCentral Article

Connecting to Amazon DocumentDB with MongoDB Drivers

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 […]

2021-10-27

327 reads

SQLServerCentral Article

CData Connect: Derived Views and Query Federation

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 […]

2021-10-22

208 reads

SQLServerCentral Article

Connect to PostgreSQL as an External Data Source using PolyBase

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 […]

2021-10-18

1,705 reads

SQLServerCentral Article

Connect to SAP HANA Data as a Linked Server

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 […]

2021-09-29

1,346 reads

SQLServerCentral Article

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

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 […]

2021-09-24

607 reads

Blogs

Working with Neo4j Imports–I HATE CASE SENSITIVITY

By

I’ve been working to better understand graph databases and where they can be useful....

Daily Coping 8 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Azure DevOps: Deploying Power BI reports with a parameterized gateway-based Data Source

By

(2022-Aug-08) You have developed your Power BI report, by connecting one or more sourcing datasets,...

Read the latest Blogs

Forums

SCOM alert : Other processes use too much memory

By ramana3327

Hi , We have several SQL instances (200 servers). Some of them have SSRS...

Identifying Driver it is using

By ramana3327

Hi, We have SQL server installed on one server & SSAS stand-alone installation on...

Any BIxPress users out there?

By latkinson

We use a third party logging framework from what is now SolarWinds (originally PragmaticWorks)....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

DATETRUNC

See possible answers