Show articles by: Integration Technology | Driver Technology | Recent Articles

CData Software - Knowledge Base

Recent Articles

Build a Singer.io Tap for Redshift With the CData Python Connector

Learn how to easily build a Singer.io Tap for live Redshift data using
How to Access Data from a SharePoint List Based on a Custom View

We use Server Explorer in Visual Studio to show how the CData provider data model exposes custom views of SharePoint lists.
Object-Relational Mapping (ORM) with SAP Concur Entities in Java

Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SAP Concur into a Java-based ORM framework, Hibernate.
Analyze Avro in Slingshot with CData API Server

Use the CData API Server to build an OData API on top of Apache Avro and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
Integrate Access in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Access from Informatica Cloud.
Use the CData Software ODBC Driver for SQL Server in SAS for Real-Time Reporting and Analytics

Connect to real-time Microsoft SQL Server in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SQL Server.
Build Data Flows from SQL Server to MarkLogic through SSIS

Easily push SQL Server data to MarkLogic using the CData SSIS Tasks for MarkLogic.
How to Connect the Power BI Service to Dynamics CRM: Complete Guide

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
How to Work with Trello in AWS Glue Jobs Using JDBC

Connect to Trello from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
Automated Continuous Sage 300 Replication to Google BigQuery

Use CData Sync for automated, continuous, customizable Sage 300 replication to Google BigQuery.
Use the CData Software JDBC Driver for CSV in MicroStrategy Web

Connect to CSV/TSV Files in MicroStrategy Web using the CData Software JDBC Driver for CSV.
Integrate Smartsheet with External Services using SnapLogic

Use CData JDBC drivers in SnapLogic to integrate Smartsheet with External Services.
Connect to and Visualize Live SAS Data Sets in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAS Data Sets.
Use the CData Software JDBC Driver for Azure Table in MicroStrategy Web

Connect to Azure Table Storage in MicroStrategy Web using the CData Software JDBC Driver for Azure Table.
Connect to Live Outreach.io in PostGresSQL Interface through CData Connect AI

Create a live connection to Outreach.io in CData Connect AI and connect to your Outreach.io from PostgreSQL.
Connect to Aha in CloverDX (formerly CloverETL)

Transfer Aha! using the visual workflow in the CloverDX data integration tool.
Integrate Confluence into Power Automate Desktop using CData Connect

CData Connect for Confluence enables you to integrate Atlassian Confluence into workflows built using Microsoft Power Automate Desktop.
Use the CData Software JDBC Driver for Sage Intacct in MicroStrategy Web

Connect to Sage Intacct in MicroStrategy Web using the CData Software JDBC Driver for Sage Intacct.
Natively Connect to SAP in PHP

The CData ODBC driver for SAP enables you to create PHP applications with connectivity to SAP ERP/NetWeaver. Leverage the native support for ODBC in PHP.
Connect to Sybase in Ruby

Connect to Sybase in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
How to create Reckon federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Reckon in MySQL .
How to Connect to Live QuickBooks Time from OpenAI Python Applications (via CData Connect AI)

Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your QuickBooks Time through natural language.
Connect to Exact Online from Asprova with CData Software ODBC Driver for Exact Online

This article shows how to connect faster to Exact Online data from Asprova.
Using the CData Software ODBC Driver for MYOB AccountRight in PyCharm

Connect to MYOB AccountRight as an ODBC data source in PyCharm using the CData Software ODBC Driver for MYOB AccountRight.
Analyze SingleStore with Power Pivot

This article walks you through the process of using the CData ODBC Driver for SingleStore from Power Pivot. You will use the Table Import Wizard to load SingleStore. You can visually build the import query or use any SQL supported by the driver.
Publish Cvent-Connected Dashboards in Tableau Server via JDBC

Use CData JDBC drivers and Tableau Server to visualize live Cvent.
How to connect PolyBase to SFTP

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SFTP.
Automated Continuous Basecamp Replication to Databricks

Use CData Sync for automated, continuous, customizable Basecamp replication to Databricks.
Automated Continuous Twitter Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable Twitter replication to delimited files (CSV/TSV).
Query Salesforce Marketing in ColdFusion

Write standard ColdFusion data access code to connect to Salesforce Marketing Cloud.
Connect to Live Sage Intacct in PostGresSQL Interface through CData Connect AI

Create a live connection to Sage Intacct in CData Connect AI and connect to your Sage Intacct from PostgreSQL.
How to load DocuSign data into Elasticsearch via Logstash

Introducing a simple method to load DocuSign data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
Connect to Live Google Campaign Manager 360 in PostGresSQL Interface through CData Connect AI

Create a live connection to Google Campaign Manager 360 in CData Connect AI and connect to your Google Campaign Manager 360 from PostgreSQL.
Rapidly Develop Azure Table-Driven Apps with Active Query Builder

Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
Access BigQuery from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live Google BigQuery from HeidiSQL.
Connect to TigerGraph in SpagoBI

Create reports featuring live TigerGraph in SpagoBI Studio. Host TigerGraph reports on SpagoBI Server.
Connect to Real-Time Parquet Data in Power Apps Using Dataflows to Build Custom Applications