CData Software - Knowledge Base
Recent Articles
-
Build a Singer.io Tap for BigQuery With the CData Python Connector
Learn how to easily build a Singer.io Tap for live BigQuery data using the CData Python Connector.
-
Analyze Mailjet Data in Looker
Use CData Connect AI to connect to Mailjet Data from Looker and build custom apps using live Mailjet data.
-
Use the CData ODBC Driver for Gorgias in Microsoft Power Query
You can use the CData Gorgias ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Gorgias data into Microsoft Power Query.
-
Onfleet Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Onfleet facts in real time.
-
Automated Continuous Oracle Service Cloud Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Google Cloud SQL.
-
Connecting Mastra with Elasticsearch Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Elasticsearch data, no replication required.
-
How to connect and process HCL Domino data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live HCL Domino data.
-
Explore Geographical Relationships in Perplexity Data with Power Map
Create data visualizations with Perplexity data in Power Map.
-
Replicate PostgreSQL Data from PowerShell
Write a quick PowerShell script to query PostgreSQL data. Use connectivity to the live data to replicate PostgreSQL data to SQL Server.
-
Connect to Tickspot 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 Tickspot and work with Tickspot data in your FileMaker application.
-
Natively Connect to PingOne Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to PingOne data. Leverage the native support for ODBC in PHP.
-
How to Access Live SAS Data Sets Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAS Data Sets enables you to integrate SAS Data Sets data into workflows built using Microsoft Power Automate Desktop.
-
Use Agno to Talk to Your Slack 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 Slack data for you.
-
Create Dynamic ZohoMarketingHub Grids Using the Infragistics XamDataGrid
Learn how you can connect ZohoMarketingHub to Infragistics XamDataGrid to build dynamic grids.
-
Use Biml to Build SSIS Tasks to Replicate Google Directory Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Directory data to SQL Server.
-
Replicate Multiple Pushbullet Accounts via the CData Sync CLI
Replicate multiple Pushbullet accounts to one or many databases.
-
Integrate LibreChat with Live Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google Sheets data from within the chat interface.
-
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 data into Microsoft Power Query.
-
How to Create Power BI Visual Reports with Real-Time CloudConvert Data
Use CData Power BI Connectors to visualize CloudConvert data in Power BI.
-
Import Google Forms Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Forms Data and provide access to live Google Forms data for custom reports in the Power BI Service.
-
How to connect and process Cosmos DB data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Cosmos DB data.
-
How to integrate Metabase with Zoho Inventory Data
Use CData Connect AI to connect to live Zoho Inventory data and create an interactive dashboard in Metabase from Zoho Inventory data.
-
Migrating data from Google Tasks to Google BigQuery using CData SSIS Components.
Easily push Google Tasks data to Google BigQuery using the CData SSIS Tasks for Google Tasks and Google BigQuery.
-
Build Automated Cloudant-Connected Workflows in Zapier
Use CData Connect AI to connect to live Cloudant data and build automated workflows in Zapier.
-
Natively Connect to Suadeo Data in PHP
The CData ODBC driver for Suadeo enables you to create PHP applications with connectivity to Suadeo data. Leverage the native support for ODBC in PHP.
-
Use the CData Software ODBC Driver for LinkedIn Ads in MicroStrategy
Connect to LinkedIn Ads data in MicroStrategy Developer using the CData Software ODBC Driver for LinkedIn Ads.
-
Manage JDBC-ODBC Bridge Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for JDBC-ODBC Bridge.
-
How to Access Sendwithus Data Using Entity Framework
This article shows how to access Sendwithus data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate API Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to API data and integrate live API data into your Power Automate tasks.
-
Migrating data from QuickBooks Online to Snowflake using CData SSIS Components.
Easily push QuickBooks Online data to Snowflake using the CData SSIS Tasks for QuickBooks Online and Snowflake.
-
How to Easily Query Bullhorn CRM Data in OpenOffice Base
Connect to Bullhorn CRM data in OpenOffice Base using the CData ODBC Driver for Bullhorn CRM and generate reports with live data insights.
-
Automated Continuous ChartMogul Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ChartMogul replication to Apache Cassandra.
-
Create MYOB AccountRight-Connected Nintex Workflows
Use CData Connect AI to connect to MYOB AccountRight Data from Nintex Workflow Cloud and build custom workflows using live MYOB AccountRight data.
-
Publish Reports with HCL Domino Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date HCL Domino data.
-
Explore Geographical Relationships in Foursquare Data with Power Map
Create data visualizations with Foursquare data in Power Map.
-
Access Live SendGrid Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SendGrid data from your Google Sheets.
-
Create Data Visualizations in Cognos BI with GitHub Data
Access GitHub data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to ZohoPeople Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ZohoPeople to connect to ZohoPeople data and execute queries in PowerBuilder.
-
Integrating Kiro with Wrike 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.
-
Automated Continuous MariaDB Replication to MongoDB
Use CData Sync for automated, continuous, customizable MariaDB replication to MongoDB.
-
Import Act-On Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Act-On Data and provide access to live Act-On data for custom reports in the Power BI Service.
-
Connect to Retently Data from PowerBuilder via ADO.NET
This article demonstrates how to access Retently data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Natively Connect to Moosend Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Moosend data. Leverage the native support for ODBC in PHP.
-
Integrate with Clio Data in JReport Designer
Create charts and reports based on Clio data in JReport Designer.
-
Replicate Shortcut Data from PowerShell
Write a quick PowerShell script to query Shortcut data. Use connectivity to the live data to replicate Shortcut data to SQL Server.
-
Getting Started with the CData SSIS Components for Jumpseller
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Jumpseller.
-
Use Dash to Build Web Apps on Quickbase Data via CData Connect AI
Build interactive Dash web apps on live Quickbase data using pandas and the CData Connect AI Python SDK.
-
Use Microsoft Copilot Studio to talk to your Google Drive 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 Google Drive data for you.
-
Integrating Codex with SAP SuccessFactors 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.
-
Prepare, Blend, and Analyze Bitly Data in Alteryx Designer (ODBC)
Build workflows to access live Bitly data for self-service data analytics.
-
Access DB2 Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access DB2 data from your Oracle system.
-
How to work with Google Ads Data in Apache Spark using SQL
Access and process Google Ads Data in Apache Spark using the CData Software JDBC Driver.
-
Access NetSuite RESTlets as Views
Use CData Data Providers for NetSuite to access RESTlets from third-party tools.
-
Use the CData Software ODBC Driver for Todoist in MicroStrategy
Connect to Todoist data in MicroStrategy Developer using the CData Software ODBC Driver for Todoist.
-
View Reports on Real-Time Brex Data in Power BI Report Server
Use the CData ODBC Driver for Brex to visualize Brex data in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Gorgias Replication to SQL Server
Use CData Sync for automated, continuous, customizable Gorgias replication to SQL Server.
-
Create Basecamp-Connected Nintex Workflows
Use CData Connect AI to connect to Basecamp Data from Nintex Workflow Cloud and build custom workflows using live Basecamp data.
-
Build Zoho Projects-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Zoho Projects data and build web apps with connectivity to live Zoho Projects data.
-
Access Live Office 365 Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Office 365 data through MCP integration.
-
Publish Crystal Reports on Google Tasks Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Tasks data.
-
Migrating data from CouchDB to Google BigQuery using CData SSIS Components.
Easily push CouchDB data to Google BigQuery using the CData SSIS Tasks for CouchDB and Google BigQuery.
-
Integrate LibreChat with Live AfterShip Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live AfterShip data from within the chat interface.
-
Use Azure AI Foundry to Talk to Your Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Oracle SCM data for you.
-
Build Visualizations of Zoho Projects Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoho Projects data in Birst.
-
Import Real-Time Helpscout Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Helpscout data in ColdFusion.
-
Analyze IBM Informix Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze IBM Informix data in Microsoft R Open.
-
Bridge Attio Connectivity with Apache NiFi
Access and process Attio data in Apache NiFi using the CData JDBC Driver.
-
Visualize Live Parallel Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Parallel data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Instagram 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 Instagram data.
-
Explore Geographical Relationships in SAP Data with Power Map
Create data visualizations with SAP data in Power Map.
-
Connect to Bright Data Data in RapidMiner
Integrate Bright Data data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Gorgias with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Gorgias with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Gorgias data.
-
Integrate with PagerDuty Data in JReport Designer
Create charts and reports based on PagerDuty data in JReport Designer.
-
Use Grok to Talk to Your DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your DB2 data for you.
-
Integrate Live Oracle Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Oracle data and integrate live Oracle data into apps built in Microsoft Power Apps.
-
Create Apps from Guru Data in Qlik Sense Cloud
Use CData Connect AI to connect to Guru Data and build apps from live Guru data in Qlik Sense Cloud.
-
Analyze Cassandra Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Cassandra from Power Pivot. You will use the Table Import Wizard to load Cassandra data. You can visually build the import query or use any SQL supported by the driver.
-
How to connect and process Optimizely data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Optimizely data.
-
Connect to Stripe Data from a Connection Pool in Jetty
The Stripe JDBC Driver supports connection pooling: This article shows how to connect faster to Stripe data from Web apps in Jetty.
-
Connect to Databricks Data from PowerBuilder via ADO.NET
This article demonstrates how to access Databricks data from Appeon PowerBuilder using the CData ADO.NET Provider for Databricks.
-
Connect to Okta Data in DBArtisan
Use wizards in DBArtisan to configure Okta data as a data source.
-
Publish Apify-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Apify data.
-
Integrate Microsoft OneDrive Data in the Pentaho Report Designer
Publish reports based on Microsoft OneDrive data in the Pentaho BI tool.
-
Visualize Live Mode Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Mode data.
-
Integrate Dify with Live Bitbucket 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 Bitbucket data.
-
Connect to IBM Informix Data in DBArtisan
Use wizards in DBArtisan to configure IBM Informix data as a data source.
-
Automated Continuous Shopify Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Shopify replication to IBM DB2.
-
How to connect to Rootly Data in DBVisualizer
Integrate Rootly data with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData Software ODBC Driver for Harvest in MicroStrategy Desktop
Connect to Harvest data in MicroStrategy Desktop using the CData Software ODBC Driver for Harvest.
-
Import Real-Time Dropbox Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Dropbox data in ColdFusion.
-
How to publish and share Microsoft Planner Data dashboards with Tableau Server
The CData ODBC driver for Microsoft Planner enables you integrate Microsoft Planner data into Tableau dashboards.
-
Build Visualizations of Pinterest Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Pinterest data in Birst.
-
Connecting Moonlit Workflow with Testmonitor 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 Testmonitor data in real time.
-
Integrate Microsoft Planner Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Microsoft Planner data and integrate live Microsoft Planner data into your Power Automate tasks.
-
Use the CData Software ODBC Driver for Zoom in SAS for Real-Time Reporting and Analytics
Connect to real-time Zoom data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Zoom.
-
Visualize Live Wave Financial Data in the Power BI Service
Use CData Connect AI to connect to live Wave Financial data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect the Power BI Service to SAP Business One: Complete Guide
Connect to the CData Software Power BI Connector for SAP Business One from PowerBI.com to provide real-time SAP Business One data across the organization.
-
Use the CData Software ODBC Driver for Facebook Ads in MicroStrategy Web
Connect to Facebook Ads data in MicroStrategy Web using the CData Software ODBC Driver for Facebook Ads.
-
Connect to Oracle Data in ACL Analytics
Connect to Oracle data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Oracle data.
-
Connect and Query Live IBM Cloud Object Storage Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live IBM Cloud Object Storage data into Databricks and enable direct, live querying and analysis without replication.