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

CData Software - Knowledge Base

Recent Articles

Automated Continuous Invoiced Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable Invoiced replication to delimited files (CSV/TSV).
How to publish and share Sage Cloud Accounting dashboards with Tableau Server

The CData ODBC driver for Sage Cloud Accounting enables you integrate Sage Business Cloud Accounting into Tableau dashboards.
PowerShell Scripting to Replicate DocuSign to MySQL

Write a simple PowerShell script to replicate DocuSign to a MySQL database.
Viewing MarkLogic in RAD Studio Data Explorer

How to view MarkLogic in RAD Studio Data Explorer using the CData ODBC Driver for MarkLogic.
How to connect to Shippo in DBVisualizer

Integrate Shippo with visual data analysis tools and data connection wizards in DBVisualizer
Create Trello-Connected Dashboards in Grafana

Connect to Trello via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Trello.
Automated Continuous Acumatica Replication to MySQL

Use CData Sync for automated, continuous, customizable Acumatica replication to MySQL.
Create Outreach.io Reports on JasperReports Server

Deploy the CData JDBC Driver on JasperReports Server to provide real-time Outreach.io data access from reports, embedded analytics, and more.
How to use SQLAlchemy ORM to access Excel Online in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Excel Online.
Connect to MYOB AccountRight in RunMyProcess through Connect Cloud

Use CData Connect Cloud to create on OData API for MYOB AccountRight and connect to MYOB AccountRight in Akorbi Digital RunMyProcess.
Using the CData Software ODBC Driver for Oracle HCM Cloud in PyCharm

Connect to Oracle HCM Cloud as an ODBC data source in PyCharm using the CData Software ODBC Driver for Oracle HCM Cloud.
Analyze API in Cognos Analytics

Use CData Connect Cloud to connect to API from Cognos Analytics and analyze live API.
Connect to Greenplum in the Denodo Platform

Use CData driver technologies to create a virtual data source for Pivotal GreenPlum in the Denodo Virtual DataPort Administrator.
LINQ to Zenefits

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Zenefits Data Provider.
Connect to Drip in DBeaver

Use the CData ODBC Driver to connect to Drip in DBeaver.
Deploy the ADO.NET Provider for Oracle Eloqua on an SSRS Report Server

Connect to Oracle Eloqua from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
Use JayDeBeApi to access Zoho Inventory in Python

Use standard Python scripting and the development environment of your choice to access live Zoho Inventory.
Connect to Dynamics 365 in Google Apps Script via SQL Gateway

Use the ODBC Driver for Dynamics 365 and the SQL Gateway to access Microsoft Dynamics 365 from Google Apps Script.
How to Connect the Power BI Service to ShipStation: Complete Guide

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
Publish Reports with Impala in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Apache Impala.
Create Blackbaud FE NXT-Connected Dashboards in Grafana

Connect to Blackbaud FE NXT via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Blackbaud FE NXT.
Visualize Live SAP SuccessFactors of Power BI Report Builder in Power BI Service

Use CData Power BI Connectors to connect to live SAP SuccessFactors using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
How to Use a Microsoft Access Database to Update Cassandra in Real Time

Update Cassandra data by creating a linked table in Microsoft Access with the CData Cassandra ODBC Driver.
Build HCL Domino-Connected Apps in Bubble

Use CData Connect Cloud to create an OData feed for HCL Domino and create custom apps in Bubble.
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Drive

Provide connectivity to Google Drive through an SAP BusinessObjects universe.
Connect to Act CRM from Crystal Reports

Use CData Connect Cloud to connect to and report on live Act CRM from Crystal Reports.
Connect to Zoho CRM from Asprova with CData Software ODBC Driver for Zoho CRM

This article shows how to connect faster to Zoho CRM data from Asprova.
Connect to Live Google Ad Manager in MicroStrategy through CData Software Connect Server

Create a virtual database for Google Ad Manager in CData Software Connect Server and connect to it from MicroStrategy.
Create Microsoft Planner-Connected Business Apps in AppSheet

Connect to Microsoft Planner via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Microsoft Planner.
Integrate Live Sugar CRM into Amazon SageMaker Canvas with RDS

Use CData Connect Cloud to connect to Sugar CRM from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Sugar CRM.
Connect to Microsoft Dataverse from a Connection Pool in Jetty

The Microsoft Dataverse JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Dataverse (CDS) from Web apps in Jetty.
How to Connect to Quickbase in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Quickbase. Leverage the pyodbc module for ODBC in Python.
Natively Connect to Google Data Catalog in PHP

The CData ODBC driver for Google Data Catalog enables you to create PHP applications with connectivity to Google Data Catalog. Leverage the native support for ODBC in PHP.
Connect to Acumatica from HeidiSQL

Use CData Connect Cloud to connect to and query live Acumatica ERP from HeidiSQL.
Build Data Flows from SQL Server to Zoho Projects through SSIS

Easily push SQL Server data to Zoho Projects using the CData SSIS Tasks for Zoho Projects.
Automated Continuous SAP Concur Replication to Oracle

Use CData Sync for automated, continuous, customizable SAP Concur replication to Oracle.
Access Live Salesforce Pardot in SAS JMP via ODBC

You can use the CData ODBC Driver to integrate Salesforce Pardot into the statistical analysis tools available in SAS JMP. This article shows how to use Salesforce Pardot in the Graph Builder and Query Builder.
How to connect PolyBase to Google Contacts

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Contacts.
Analyze Twilio in R via JDBC

Use standard R functions and the development environment of your choice to analyze Twilio with the CData JDBC Driver for Twilio.
Use the CData ODBC Driver for ClickUp in Microsoft Power Query

You can use the CData ClickUp ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ClickUp into Microsoft Power Query.
How to publish and share SQL Server dashboards with Tableau Server

The CData ODBC driver for SQL Server enables you integrate Microsoft SQL Server into Tableau dashboards.
Analyze Reckon Accounts Hosted with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Reckon Accounts Hosted from Power Pivot. You will use the Table Import Wizard to load Reckon Accounts Hosted. You can visually build the import query or use any SQL supported by the driver.
Connect to Real-Time Basecamp Data in Power Apps Using Dataflows to Build Custom Applications