CData Software - Knowledge Base
Recent Articles
-
Write a Simple Go Application to work with ShipStation Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ShipStation data.
-
Automated Continuous Optimizely Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Optimizely data replication to OneLake in Microsoft Fabric.
-
Create Box-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Box Data from Klipfolio and build custom visualizations using live Box data.
-
Optimizely Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Optimizely data through CData Connect AI using different applications and tools.
-
How to connect to Sage 200 Data from Spring Boot
Connect to Sage 200 in a Spring Boot Application using the CData JDBC Driver for Sage 200
-
Use Biml to Build SSIS Tasks to Replicate MailerSend Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate MailerSend data to SQL Server.
-
Access Live Spark Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Spark data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use the CData Software ODBC Driver for Bright Data in MicroStrategy Web
Connect to Bright Data data in MicroStrategy Web using the CData Software ODBC Driver for Bright Data.
-
How to Access Live ScrapingBee Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ScrapingBee enables you to integrate ScrapingBee data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Codat in SpagoBI
Create reports featuring live Codat data in SpagoBI Studio. Host Codat reports on SpagoBI Server.
-
Consume Amazon Marketplace OData Feeds in PowerBuilder
This article demonstrates how to consume Amazon Marketplace data as OData feeds from PowerBuilder using the API Server.
-
How to work with YouTube Analytics Data in Apache Spark using SQL
Access and process YouTube Analytics Data in Apache Spark using the CData Software JDBC Driver.
-
How to connect PolyBase to Quickbase
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Quickbase data.
-
Connect to WooCommerce Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to WooCommerce.
-
Import Real-Time Okta Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Okta data in ColdFusion.
-
Connect to Outlook Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Outlook data.
-
Access Live Ontraport Data in AWS Lambda
Connect to live Ontraport data in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Front Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Front replication to Google Cloud SQL.
-
Visualize Teamgate Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Teamgate data.
-
Natively Connect to Testmonitor Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Testmonitor data. Leverage the native support for ODBC in PHP.
-
Connect SAP Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Publish CampaignMonitor-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live CampaignMonitor data.
-
Extract, Transform, and Load Dynamics 365 Business Central Data in Informatica PowerCenter
Create a simple Workflow for Dynamics 365 Business Central data in Informatica PowerCenter.
-
Integrating GitHub Copilot with Blackbaud FE NXT 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 ChatGPT to Talk to Your Bitbucket 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 Bitbucket data for you.
-
How to Query Live Reckon Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Reckon data data in natural language using Python.
-
How to Create Power BI Visual Reports with Real-Time Airtable Data
Use CData Power BI Connectors to visualize Airtable data in Power BI.
-
Publish Crystal Reports on Jodoo Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Jodoo data.
-
Visualize Twilio Data in Tableau
The CData ODBC driver for Twilio enables you integrate Twilio data into Tableau dashboards.
-
Working with Spark Data in LINQPad
Execute LINQ queries to Spark data in LINQPad.
-
Create a Data Access Object for Teamwork Data using JDBI
A brief overview of creating a SQL Object API for Teamwork data in JDBI.
-
How to integrate Shopify with Apache Airflow
Access and process Shopify data in Apache Airflow using the CData JDBC Driver.
-
How to Connect to SageHR Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SageHR data. Leverage the pyodbc module for ODBC in Python.
-
Design BIRT Reports on PDFMonkey Data
Provide current PDFMonkey data to your embedded analytics.
-
Load CloudConvert Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load CloudConvert data to a database.
-
Publish Crystal Reports on Procore Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Procore data.
-
Migrating data from Wrike to Google BigQuery using CData SSIS Components.
Easily push Wrike data to Google BigQuery using the CData SSIS Tasks for Wrike and Google BigQuery.
-
Use Claude to Talk to Your Discord Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Discord data for you.
-
Access ZarMoney 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 ZarMoney data.
-
Automated Continuous Azure Data Lake Storage Replication to Databricks
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Databricks.
-
Replicate Multiple GraphQL Accounts via the CData Sync CLI
Replicate multiple GraphQL accounts to one or many databases.
-
Analyze Freshservice Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Freshservice data and visualize Freshservice data in SAP Analytics Cloud.
-
Build Charts with Productboard Data in Clear Analytics
Create dynamic charts and perform analytics based on Productboard data in Clear Analytics.
-
Connect to Adobe Commerce Data in NetBeans
Connect to Adobe Commerce data in NetBeans with the data source configuration wizard.
-
Connect to DB2 Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live DB2 data.
-
Connecting Agentforce with Sybase Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Sybase data for you.
-
Connect to Egnyte Data in Ruby
Connect to Egnyte data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Prepare, Blend, and Analyze SuiteCRM Data in Alteryx Designer (ODBC)
Build workflows to access live SuiteCRM data for self-service data analytics.
-
How to connect PolyBase to Google Directory
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Directory data.
-
How to connect PolyBase to Gong
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Gong data.
-
How to Build an ETL App for Suadeo Data in Python with CData
Create ETL applications and real-time data pipelines for Suadeo data in Python with petl.
-
Use the CData ODBC Driver for iContact in Microsoft Power Query
You can use the CData iContact ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import iContact data into Microsoft Power Query.
-
Build MongoDB-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for MongoDB Data and create custom apps in Bubble.
-
Create Datasets from Zoho CRM in Domo Workbench and Build Visualizations of Zoho CRM Data in Domo
Use the CData Software ODBC Driver for Zoho CRM to create datasets from Zoho CRM data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to and Query Egnyte Data in QlikView over ODBC
Create data visualizations with Egnyte data in QlikView.
-
Integrate Cursor with Live VWO Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live VWO data from within the editor.
-
Connect Onfleet to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Onfleet with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous SparkPost Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SparkPost replication to IBM DB2.
-
Import Optimizely Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Optimizely Data and provide access to live Optimizely data for custom reports in the Power BI Service.
-
Migrating data from Microsoft Ads to Google BigQuery using CData SSIS Components.
Easily push Microsoft Ads data to Google BigQuery using the CData SSIS Tasks for Microsoft Ads and Google BigQuery.
-
Automated Continuous Twitter Ads Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Twitter Ads replication to IBM DB2.
-
Use the CData ODBC Driver for Rebilly in Microsoft Power Query
You can use the CData Rebilly ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Rebilly data into Microsoft Power Query.
-
ETL Insightly in Oracle Data Integrator
This article shows how to transfer Insightly data into a data warehouse using Oracle Data Integrator.
-
Publish Crystal Reports on Drip Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Drip data.
-
Getting Started with the CData Tableau Connector for HelloSign
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Connect to Live Google Sheets Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Google Sheets data for you.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Autopilot
Provide connectivity to Autopilot data through an SAP BusinessObjects universe.
-
Create Power BI Reports on Real-Time Planio Data
Use the CData ODBC Driver for Planio to visualize Planio data in Power BI Desktop.
-
Moving Data from Google Cloud Storage to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Cloud Storage data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create SSAS Tabular Models from Certinia Data
How to build a SQL Server Analysis Service Tabular Model from Certinia data using CData drivers.
-
Publish Crystal Reports on Printful Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Printful data.
-
Automated Continuous MYOB AccountRight Replication to Snowflake
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Snowflake.
-
Access Live Optimizely Data in Coginiti Pro
Connect to and query live Optimizely data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect to Live Perplexity Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Perplexity data securely in real time.
-
Automated Continuous Jira Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Jira replication to Apache Kafka.
-
Connect to LeadDesk Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to LeadDesk and work with LeadDesk data in your FileMaker applications.
-
Integrate Dify with Live SharePoint Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live SharePoint data.
-
Access Jumpseller Data from MySQL in Amazon QuickSight
Connect to Jumpseller and build visualizations of Jumpseller data using a MySQL Connection in Amazon QuickSight.
-
Validate QuickBooks Online Data with QuerySurge
Access and validate QuickBooks Online data in QuerySurge using the CData JDBC Driver.
-
How to Connect to Live SAP Ariba Source Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your SAP Ariba Source data for you.
-
Query, Visualize, and Share live AgileCRM Data in Redash
Use CData Connect AI to connect to live AgileCRM data in Redash for querying, visualizing, and sharing.
-
How to create MailChimp federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for MailChimp data in MySQL .
-
How to Connect to Live Impala 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 Impala data for you.
-
How to Connect DBeaver to Hive via a JDBC Driver
Manage Hive data with visual tools in DBeaver like the query browser.
-
Visualize Oracle Sales Data in Tableau
The CData ODBC driver for Oracle Sales enables you integrate Oracle Sales data into Tableau dashboards.
-
Automated Continuous Harvest Replication to SingleStore
Use CData Sync for automated, continuous, customizable Harvest replication to SingleStore.
-
Automated Continuous PhantomBuster Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable PhantomBuster replication to Amazon Redshift.
-
Deploy the ADO.NET Provider for Trello on an SSRS Report Server
Connect to Trello data 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.
-
Query Live ZohoPeople Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live ZohoPeople data directly from the development environment.
-
Explore Geographical Relationships in Twilio Data with Power Map
Create data visualizations with Twilio data in Power Map.
-
Integrate Goose with Live Mailjet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Mailjet data from within the local AI agent.
-
Access Live Google Drive Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google Drive data into the statistical analysis tools available in SAS JMP. This article shows how to use Google Drive data in the Graph Builder and Query Builder.
-
Connecting Pipedream with Oracle Financials Cloud 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 Oracle Financials Cloud data in real time.
-
Integrate AfterShip Data in the Pentaho Report Designer
Publish reports based on AfterShip data in the Pentaho BI tool.
-
Publish SAP Business Warehouse-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP Business Warehouse data.
-
How to Query ConvertKit Data in MySQL Workbench
Execute MySQL queries against live ConvertKit data from MySQL Workbench.
-
Integrate with Live Oracle Eloqua Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Oracle Eloqua from the MuleSoft Anypoint Platform to integrate live Oracle Eloqua data into custom reports and dashboards.
-
Using the CData Software ODBC Driver for Harvest in PyCharm
Connect to Harvest as an ODBC data source in PyCharm using the CData Software ODBC Driver for Harvest.
-
Model Facebook Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Facebook, enabling the direct import of real-time Facebook data.
-
Publish Perplexity-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Perplexity data.