CData Software - Knowledge Base
Recent Articles
-
Connect to GitLab Data in DBArtisan
Use wizards in DBArtisan to configure GitLab as a data source.
-
Replicate Multiple Salesforce Pardot Accounts via the CData Sync CLI
Replicate multiple Salesforce Pardot accounts to one or many databases.
-
Analyze FHIR Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of FHIR and visualize live FHIR in Infragistics Reveal.
-
Back Up Toggl to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Toggl data.
-
Connect to Apollo Data in HULFT Integrate
Connect to Apollo as a JDBC data source in HULFT Integrate
-
Replicate Multiple Typeform Accounts
Replicate multiple Typeform accounts to one or many databases.
-
DataBind Hive Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Hive with the DevExpress Windows Forms and Web controls to provide Apache Hive to a chart.
-
Build a Simple VCL Application for Mouseflow Data
How to build a simple VCL Application to view Mouseflow in RAD Studio using the CData ODBC Driver for Mouseflow.
-
Create SSAS Tabular Models from Workday Data
How to build a SQL Server Analysis Service Tabular Model from Workday using CData drivers.
-
Integrating Antigravity CLI with Cloudflare via CData CLI
Connect Cloudflare to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to HubSpot Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live HubSpot.
-
Extend Google Sheets with MYOB AccountRight Data
Make calls to MYOB AccountRight from Google Apps Script via the API Server.
-
Query Zoho Projects Data in DataGrip
Create a Data Source for Zoho Projects in DataGrip and use SQL to query live Zoho Projects.
-
Perform Batch Operations with Oracle Service Cloud Data in Apache NiFi
Connect to Oracle Service Cloud and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Working with Blackbaud FE NXT Data in LINQPad
Execute LINQ queries to Blackbaud FE NXT in LINQPad.
-
How to Connect to Live CSV Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your CSV/TSV Files for you.
-
Connect to SAP Business Warehouse Data in HULFT Integrate
Connect to SAP Business Warehouse as a JDBC data source in HULFT Integrate
-
Integrate SparkPost Data in the Pentaho Report Designer
Publish reports based on SparkPost in the Pentaho BI tool.
-
How to Create Power BI Visual Reports with Real-Time Humanity Data
Use CData Power BI Connectors to visualize Humanity in Power BI.
-
Access Live SendGrid Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SendGrid data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Extract, Transform, and Load Webflow Data in Informatica PowerCenter
Create a simple Workflow for Webflow in Informatica PowerCenter.
-
Import LinkedIn Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access LinkedIn. In this article, you will use the OData format to import LinkedIn into Microsoft Power Query.
-
Automated Continuous ChargeOver Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ChargeOver replication to IBM DB2.
-
Process & Analyze SAP Fieldglass Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Fieldglass Data.
-
Integrating Dataiku with Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Jira Assets.
-
Process & Analyze SurveyMonkey Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SurveyMonkey Data.
-
Use ChatGPT to Talk to Your Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Google Ads for you.
-
Use the CData SSIS Components to Insert New or Update Existing Google Calendar Records from SQL Server
Easily push SQL Server data to Google Calendar using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Calendar or update existing records with data from a SQL Server database.
-
Feed Clari Data into FineReport
How to set Clari as a JDBC data source in FineReport.
-
How to Create Power BI Visual Reports with Real-Time ConvertKit Data
Use CData Power BI Connectors to visualize ConvertKit in Power BI.
-
Create Informatica Mappings From/To a JDBC Data Source for Zuora
Create Zuora data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automate Dynamics CRM Data Replication to Azure Data Lake
Use CData Sync to customize and automate Microsoft Dynamics CRM replication to Azure Data Lake.
-
Build Pipelines with Live Greenplum Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Greenplum from Google Cloud Data Fusion, enabling the integration of live Pivotal GreenPlum into the building and management of effective data pipelines.
-
Use the CData Software ODBC Driver for Pinterest in MicroStrategy Desktop
Connect to Pinterest in MicroStrategy Desktop using the CData Software ODBC Driver for Pinterest.
-
How to Connect to Live Greenplum Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Pivotal GreenPlum for you.
-
Deploy the ADO.NET Provider for Todoist on an SSRS Report Server
Connect to Todoist 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.
-
Access SharePoint Excel Services Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SharePoint Excel Services from your Oracle system.
-
Connect to Klipfolio Data in Aqua Data Studio
Access Klipfolio from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Visualize Google Sheets Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Google Sheets in Python.
-
How to import Klipfolio Data into Apache Solr
Use the CData Software JDBC Driver for Klipfolio in Data Import Handler and create an automated import of Klipfolio to Apache Solr Enterprise Search platform.
-
How to create an RPA flow for Paymo Data in UiPath Studio
Use the Paymo ODBC Driver to create workflows that access real-time Paymo without any coding.
-
Prepare, Blend, and Analyze Perplexity Data in Alteryx Designer (ODBC)
Build workflows to access live Perplexity for self-service data analytics.
-
View Reports on Real-Time Phoenix Data in Power BI Report Server
Use the CData ODBC Driver for Phoenix to visualize Apache Phoenix in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect to Egnyte Data from IntelliJ
Integrate connectivity to Egnyte with wizards in IntelliJ.
-
Connect to TaxJar Data in Aqua Data Studio
Access TaxJar from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Feed Demio Data into FineReport
How to set Demio as a JDBC data source in FineReport.
-
Import Real-Time Amplitude Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Amplitude in ColdFusion.
-
How to Work with BambooHR Data in ETL Validator JDBC
Connect to BambooHR from ETL Validator jobs using the CData Software JDBC Driver.
-
Replicate Multiple Sendwithus Accounts
Replicate multiple Sendwithus accounts to one or many databases.
-
Use Dash to Build to Web Apps on ShipStation Data
Create Python applications that use pandas and Dash to build ShipStation-connected web apps.
-
How to integrate Facebook Ads with Apache Airflow
Access and process Facebook Ads in Apache Airflow using the CData JDBC Driver.
-
Access Live Facebook Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Facebook into the statistical analysis tools available in SAS JMP. This article shows how to use Facebook in the Graph Builder and Query Builder.
-
How to Access Live HBase Data in Power Automate Desktop via ODBC
The CData ODBC Driver for HBase enables you to integrate Apache HBase into workflows built using Microsoft Power Automate Desktop.
-
Connect to PolarTeamPro Data from a Connection Pool in Jetty
The PolarTeamPro JDBC Driver supports connection pooling: This article shows how to connect faster to PolarTeamPro from Web apps in Jetty.
-
Viewing Kintone Data in RAD Studio Data Explorer
How to view Kintone in RAD Studio Data Explorer using the CData ODBC Driver for Kintone.
-
Natively Connect to Access Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Access. Leverage the native support for ODBC in PHP.
-
Connect to Mailjet Data in JRuby
Create a simple JRuby app with access to live Mailjet.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for QuickBooks
Provide connectivity to QuickBooks Desktop through an SAP BusinessObjects universe.
-
Publish Reports with Todoist Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Todoist.
-
Integrating Cursor CLI with Bitbucket Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Use Microsoft Copilot Studio to talk to your SAS Data Sets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your SAS Data Sets for you.
-
Connect to Xero Data in Google Apps Script via Connect AI
Use CData Connect AI to access Xero Accounting in Google Apps Script.
-
Establish a Live Connection with Miro Data using Tableau Bridge
The CData ODBC Driver for Miro enables you to integrate live Miro into Tableau Cloud dashboards using the Tableau Bridge.
-
Natively Connect to CampaignMonitor Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to CampaignMonitor. Leverage the native support for ODBC in PHP.
-
Build a Simple VCL Application for Smartsheet Data
How to build a simple VCL Application to view Smartsheet in RAD Studio using the CData ODBC Driver for Smartsheet.
-
Use the CData Software ODBC Driver for Google Ads in MicroStrategy Desktop
Connect to Google Ads in MicroStrategy Desktop using the CData Software ODBC Driver for Google Ads.
-
Connect to and Visualize Live Clari Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Clari.
-
Use CData Connect AI to Access Oracle Eloqua Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Oracle Eloqua in the Power Pivot business intelligence tool.
-
Getting Started with the CData JDBC Driver for Instantly
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Instantly.
-
Connect to and Query Smartsheet Data in QlikView over ODBC
Create data visualizations with Smartsheet in QlikView.
-
View Reports on Real-Time Klipfolio Data in Power BI Report Server
Use the CData ODBC Driver for Klipfolio to visualize Klipfolio in Power BI Desktop and then publish them to Power BI Report Server.
-
Using the CData Software ODBC Driver for LinkedIn in PyCharm
Connect to LinkedIn as an ODBC data source in PyCharm using the CData Software ODBC Driver for LinkedIn.
-
Create Apps from Outreach.io Data in Qlik Sense Cloud
Use CData Connect AI to connect to Outreach.io Data and build apps from live Outreach.io in Qlik Sense Cloud.
-
Getting Started with the CData Python Connector for PagerDuty
Learn to install and license the CData Python Connector
-
Bind Live Dropbox Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Dropbox data
-
Connect to Timely Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Timely as an External Source in Dremio.
-
Automated Square Data Replication to Teradata
Use CData Sync to Customize and automate Square replication to Teradata.
-
Viewing HubSpot Data in RAD Studio Data Explorer
How to view HubSpot in RAD Studio Data Explorer using the CData ODBC Driver for HubSpot.
-
Analyze ZohoExpense Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ZohoExpense with the CData JDBC Driver for ZohoExpense.
-
Connect to Greenhouse Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Greenhouse in the Denodo Virtual DataPort Administrator.
-
Connect to Teradata Data from PowerBuilder via ADO.NET
This article demonstrates how to access Teradata from Appeon PowerBuilder using the CData ADO.NET Provider for Teradata.
-
Connect to Harvest Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrating Drift Data in Talend Cloud Data Management Platform
Connect Drift Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous Toggl Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Toggl replication to Apache Kafka.
-
Automated Continuous Datadog Replication to MongoDB
Use CData Sync for automated, continuous, customizable Datadog replication to MongoDB.
-
Outreach.io Reporting in OBIEE with the Outreach.io JDBC Driver
Deploy the Outreach.io JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize LightSpeedRetail Data in Sisense
Create an ElastiCube in Sisense app with access to LightSpeedRetail.
-
How to Query Invoiced Data in MySQL Workbench
Execute MySQL queries against live Invoiced from MySQL Workbench.
-
Getting Started with the CData JDBC Driver for Adobe Analytics
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Adobe Analytics.
-
Working with Egnyte Data in LINQPad
Execute LINQ queries to Egnyte in LINQPad.
-
Use the CData Software JDBC Driver for SAP SuccessFactors LMS in MicroStrategy
Connect to SAP SuccessFactors LMS in MicroStrategy Developer using the CData Software JDBC Driver for SAP SuccessFactors LMS.
-
Publish Wrike-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Wrike.
-
How to Connect to Salesforce Pardot Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Salesforce Pardot. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Active Directory Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Active Directory replication to Google Cloud SQL.
-
Getting Started with the CData ADO.NET Provider for Cassandra
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Cassandra.
-
Integrate Opsgenie with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Opsgenie with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Opsgenie.
-
Use Agno to Talk to Your Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Airtable for you.
-
How to connect to Workday Data from IntelliJ
Integrate connectivity to Workday with wizards in IntelliJ.
-
Automated Continuous Google Forms Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Forms replication to IBM DB2.
-
Build a PostgreSQL Interface for Aircall Data using the CData JDBC Driver
Use the Remoting features of the Aircall JDBC Driver to create a PostgreSQL entry-point for data access.