CData Software - Knowledge Base
Recent Articles
-
Build a Singer.io Tap for Freshdesk With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Freshdesk data using
-
Back Up SpaceX 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 SpaceX data.
-
Create Data Visualizations in Cognos BI with AlloyDB Data
Access Google AlloyDB as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Ontraport Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Ontraport and work with Ontraport in your FileMaker application.
-
Deploy the ADO.NET Provider for Azure Synapse on an SSRS Report Server
Connect to Azure Synapse 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.
-
Build Automated Sage Intacct-Connected Workflows in Zapier
Use CData Connect AI to connect to live Sage Intacct and build automated workflows in Zapier.
-
Access Live Google Contacts Data in TIBCO Data Virtualization
Use the Google Contacts Tibco DV Adapter to create a Google Contacts data source in TIBCO Data Virtualization Studio and gain access to live Google Contacts from your TDV Server.
-
Connect Okta to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Okta using the CData Python MCP Server.
-
Work with Beeminder Data in FoxPro
Load Beeminder into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Bannerbear Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Bannerbear and the SQL Gateway to access Bannerbear from Google Apps Script.
-
Connect to SAS xpt 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 SAS XPORT.
-
Automated Continuous eBay Analytics Replication to Amazon S3
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Amazon S3.
-
Work with Webex Data in FoxPro
Load Webex into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Live eBay Data in PostGresSQL Interface through CData Connect AI
Create a live connection to eBay in CData Connect AI and connect to your eBay from PostgreSQL.
-
Connecting Pipedream with SAS Data Sets Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on SAS Data Sets data in real time.
-
Work with Elorus Data in FoxPro
Load Elorus into a FoxPro database. This article includes full code and a walk-through of the process.
-
Process & Analyze Avalara AvaTax Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Avalara AvaTax Data.
-
Use the CData Software JDBC Driver for AlloyDB in MicroStrategy Web
Connect to Google AlloyDB in MicroStrategy Web using the CData Software JDBC Driver for AlloyDB.
-
How to import Printify Data into Apache Solr
Use the CData Software JDBC Driver for Printify in Data Import Handler and create an automated import of Printify to Apache Solr Enterprise Search platform.
-
Use the CData API Server to Access Shopify Data in Microsoft PowerPivot
Use the CData API Server to connect to live Shopify in the Power Pivot business intelligence tool.
-
Connect to SAP SuccessFactors Data in ACL Analytics
Connect to SAP SuccessFactors via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP SuccessFactors.
-
Build a Simple VCL Application for Box Data
How to build a simple VCL Application to view Box in RAD Studio using the CData ODBC Driver for Box.
-
Natively Connect to SuiteCRM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SuiteCRM. Leverage the native support for ODBC in PHP.
-
Integrate Cloudant with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Cloudant with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to IBM Cloudant.
-
Create Dynamic Spark Grids Using the Infragistics XamDataGrid
Learn how you can connect Spark to Infragistics XamDataGrid to build dynamic grids.
-
Import and Visualize Splunk Data in Power View
Create data visualizations based on Splunk in Excel.
-
How to connect and process Coinbase from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Coinbase.
-
Integrating LangChain with Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Ads within automated workflows.
-
Create Informatica Mappings From/To an ODBC Data Source for LinkedIn
Create an ODBC connection to LinkedIn in Informatica and browse and transfer LinkedIn.
-
How to Access Live Zendesk Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Zendesk enables you to integrate Zendesk into workflows built using Microsoft Power Automate Desktop.
-
Create SSAS Tabular Models from SAS Data Sets Data
How to build a SQL Server Analysis Service Tabular Model from SAS Data Sets using CData drivers.
-
Use JayDeBeApi to access Freshservice Data in Python
Use standard Python scripting and the development environment of your choice to access live Freshservice.
-
Use the CData Software JDBC Driver for SharePoint in MicroStrategy Web
Connect to Microsoft SharePoint in MicroStrategy Web using the CData Software JDBC Driver for SharePoint.
-
Using the CData Software ODBC Driver for MariaDB in PyCharm
Connect to MariaDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for MariaDB.
-
Automated Continuous SendInBlue Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SendInBlue replication to Apache Cassandra.
-
Access Instantly Data from MySQL in PHP
Connect to Instantly through the standard MySQL libraries in PHP.
-
Connect to Live Impala Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Impala in CData Connect AI and connect to your Apache Impala from PostgreSQL.
-
How to work with Tanda Data in Apache Spark using SQL
Access and process Tanda Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating OpenCode Terminal with Scrapfly 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.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Spanner
Create Google Spanner data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connecting Moonlit Workflow with Google Ad Manager Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Google Ad Manager in real time.
-
Extract, Transform, and Load PayPal Data in Informatica PowerCenter
Create a simple Workflow for PayPal in Informatica PowerCenter.
-
Work with Live Shopify Data in Power Query
Use CData Connect AI to connect to Shopify and work with live Shopify in Microsoft Power Query.
-
Build a Singer.io Tap for AgileCRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live AgileCRM data using
-
Build Semantic Layer Views for Odoo Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Odoo ERP.
-
How to Seamlessly Import Greenhouse Data into IBM SPSS Modeler
Integrate Greenhouse data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating Claude Code with SingleStore Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SingleStore within assisted coding and automated development workflows.
-
Connect to and Visualize Live PivotalTracker Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live PivotalTracker.
-
Use the CData Software ODBC Driver for ZohoExpense in MicroStrategy Web
Connect to ZohoExpense in MicroStrategy Web using the CData Software ODBC Driver for ZohoExpense.
-
Visualize Outlook Data in Sisense
Create an ElastiCube in Sisense app with access to Outlook.
-
Create Datasets from GitHub in Domo Workbench and Build Visualizations of GitHub Data in Domo
Use the CData Software ODBC Driver for GitHub to create datasets from GitHub in Domo Workbench and then build visualizations in the Domo service.
-
Publish SAS Data Sets-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAS Data Sets.
-
How to use SQLAlchemy ORM to access PostgreSQL Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of PostgreSQL.
-
Back Up Pivotal GreenPlum to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Greenplum. In this article, we will employ an SSIS workflow to populate a database with Pivotal GreenPlum data.
-
How to work with Coinbase Data in Apache Spark using SQL
Access and process Coinbase Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Trello Data in HULFT Integrate
Connect to Trello as a JDBC data source in HULFT Integrate
-
Connect to Postmark Data in Jaspersoft Studio
Execute SQL to remote Postmark in Jaspersoft Studio.
-
Replicate Asana Data to Multiple Databases via the CData Sync CLI
Replicate Asana to disparate databases with a single configuration.
-
Automated Continuous Wrike Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Wrike replication to Google Cloud SQL.
-
Integrating LangGraph with Amazon S3 Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Amazon S3 within automated workflows.
-
Connect Google Ads Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google Ads using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create SAP Ariba Procurement-Connected Applications in Appsmith
Connect to SAP Ariba Procurement Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Ariba Procurement.
-
How to integrate Zoho Recruit with Apache Airflow
Access and process Zoho Recruit in Apache Airflow using the CData JDBC Driver.
-
Bridge JSON Connectivity with Apache NiFi
Access and process JSON in Apache NiFi using the CData JDBC Driver.
-
Getting Started with the CData ODBC Driver for Freshsales
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Freshsales.
-
Build AI/ML Models with Live BigQuery Data using Dataiku
Connect BigQuery Data with Dataiku using the CData JDBC Driver for BigQuery.
-
Automate Spark Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Apache Spark SQL and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Migrating data from MailerSend to Databricks using CData SSIS Components.
Easily push MailerSend to Databricks using the CData SSIS Tasks for MailerSend and Databricks.
-
Integrating Kiro CLI with Elorus 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.
-
Build Excel Online-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft Excel Online and build web apps with connectivity to live Microsoft Excel Online.
-
Connect to Authorize.Net Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Authorize.Net Data and connect to Authorize.Net in Akorbi Digital RunMyProcess.
-
Connect to SageHR Data in DBArtisan
Use wizards in DBArtisan to configure SageHR as a data source.
-
Use Dash to Build to Web Apps on MYOB AccountRight Data
Create Python applications that use pandas and Dash to build MYOB AccountRight-connected web apps.
-
Connect to and Query Customer.io Data in QlikView over ODBC
Create data visualizations with Customer.io in QlikView.
-
Automate TaxJar Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live TaxJar and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Consume Sybase IQ OData Feeds in PowerBuilder
This article demonstrates how to consume Sybase IQ as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous Pingdom Replication to SQL Server
Use CData Sync for automated, continuous, customizable Pingdom replication to SQL Server.
-
Automate Zoho Projects Data Replication to Azure Synapse
Use CData Sync to customize and automate Zoho Projects replication to Azure Synapse.
-
Connect and Query Live Twilio Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Twilio into Databricks
-
Automated Continuous SAP Ariba Source Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Snowflake.
-
Use the CData Software ODBC Driver for Copper in MicroStrategy
Connect to Copper in MicroStrategy Developer using the CData Software ODBC Driver for Copper.
-
Automated Continuous ZohoMarketingHub Replication to MongoDB
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to MongoDB.
-
Use the CData Software JDBC Driver for Microsoft Entra ID in MicroStrategy Web
Connect to Microsoft Entra ID in MicroStrategy Web using the CData Software JDBC Driver for Microsoft Entra ID.
-
How to connect PolyBase to Google Cloud Storage
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Cloud Storage.
-
Create Data Visualizations Based On Cvent Data in Mode
Use CData Connect AI to connect to Cvent Data from Mode and build visualizations using live
-
Connect to Stack Exchange Data from PowerBuilder via JDBC
This article demonstrates how to access Stack Exchange from PowerBuilder using the Stack Exchange JDBC Driver.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Microsoft Entra ID using the Model Context Protocol.
-
Connect to Microsoft Teams Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft Teams in Airbyte.
-
How to Work with SAP HANA XS Advanced Data in AWS Glue Jobs Using JDBC
Connect to SAP HANA XS Advanced from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access GetResponse Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for GetResponse.
-
Visualize Access Data in TIBCO Spotfire through ADO.NET
Integrate Microsoft Access into dashboards in TIBCO Spotfire.
-
Use the CData Software ODBC Driver for SharePoint in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft SharePoint in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SharePoint.
-
Connect to IBM Informix Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for IBM Informix and the SQL Gateway to access IBM Informix from Google Apps Script.
-
Build a Singer.io Tap for FormSite With the CData Python Connector
Learn how to easily build a Singer.io Tap for live FormSite data using
-
Automated Continuous LionDesk Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable LionDesk replication to delimited files (CSV/TSV).
-
Access SFTP Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SFTP from HeidiSQL.
-
Write a Simple Go Application to work with Moosend Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Moosend.
-
How to import eBay Data into Apache Solr
Use the CData Software JDBC Driver for eBay in Data Import Handler and create an automated import of eBay to Apache Solr Enterprise Search platform.
-
Integrate Okta Data in Pentaho Data Integration
Build ETL pipelines based on Okta in the Pentaho Data Integration tool.
-
Back Up Clari 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 Clari data.