CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Elorus Replication to Snowflake
Use CData Sync for automated, continuous, customizable Elorus replication to Snowflake.
-
Analyze Live EnterpriseDB Data in SAS Viya
Use CData Connect AI to connect to EnterpriseDB from SAS Viya and deploy self-service analytics using live EnterpriseDB.
-
Connect to Webex Data in RapidMiner
Integrate Webex with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Tally-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Tally Data from Klipfolio and build custom visualizations using live Tally ERP.
-
Access Live Strava Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Strava in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Import Real-Time Dotmailer Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Dotmailer in ColdFusion.
-
Create Datasets from ClickUp in Domo Workbench and Build Visualizations of ClickUp Data in Domo
Use the CData Software ODBC Driver for ClickUp to create datasets from ClickUp in Domo Workbench and then build visualizations in the Domo service.
-
Connect to IBM Informix Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time IBM Informix using standard SQL.
-
Integrating Cursor CLI with MessageBird 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 SSAS Tabular Models from BambooHR Data
How to build a SQL Server Analysis Service Tabular Model from BambooHR using CData drivers.
-
Visualize eBay Analytics Data in TIBCO Spotfire through ADO.NET
Integrate eBay Analytics into dashboards in TIBCO Spotfire.
-
Automated Continuous Quaderno Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Quaderno replication to IBM DB2.
-
Automated Continuous Clari Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Clari replication to IBM DB2.
-
Build Charts with Reckon Accounts Hosted Data in Clear Analytics
Create dynamic charts and perform analytics based on Reckon Accounts Hosted in Clear Analytics.
-
Automated Continuous Bullhorn CRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to Apache Kafka.
-
Build Semantic Layer Views for Oracle Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Oracle Database.
-
How to integrate Metabase with Zoho Creator Data
Use CData Connect AI to connect to live Zoho Creator and create an interactive dashboard in Metabase from Zoho Creator.
-
Create Reports from SAP SuccessFactors LMS Data in Looker Studio
Use CData Connect AI to gain access to live SAP SuccessFactors LMS and create custom reports in Looker Studio.
-
How to Visualize DB2 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 IBM DB2 in Python.
-
Analyze MailerSend Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze MailerSend in Microsoft R Open.
-
Create Dynamic Quickbase Grids Using the Infragistics XamDataGrid
Learn how you can connect Quickbase to Infragistics XamDataGrid to build dynamic grids.
-
Build Google Ad Manager-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Ad Manager Data from Zoho Analytics and import live Google Ad Manager.
-
Import Real-Time SpaceX Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SpaceX in ColdFusion.
-
Query Microsoft Ads Data as a SQL Server Database in Node.js
Execute SQL Server queries against Microsoft Ads from Node.js.
-
Replicate ShipEngine Data from PowerShell
Write a quick PowerShell script to query ShipEngine. Use connectivity to the live data to replicate ShipEngine to SQL Server.
-
Process & Analyze Bannerbear Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Bannerbear Data.
-
How to integrate Confluence with Apache Airflow
Access and process Atlassian Confluence in Apache Airflow using the CData JDBC Driver.
-
Connect Contentful to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Contentful with IBM WebSphere for seamless data integration and connectivity.
-
How to Create Power BI Visual Reports with Real-Time Shopify Data
Use CData Power BI Connectors to visualize Shopify in Power BI.
-
Connect to ChartMogul in SpagoBI
Create reports featuring live ChartMogul in SpagoBI Studio. Host ChartMogul reports on SpagoBI Server.
-
Use Dash to Build Web Apps on Zuora Data via CData Connect AI
Build interactive Dash web apps on live Zuora using pandas and the CData Connect AI Python SDK.
-
Query Pipeline CRM Data in DataGrip
Create a Data Source for Pipeline CRM in DataGrip and use SQL to query live Pipeline CRM.
-
Build SAP Fieldglass-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP Fieldglass.
-
How to Visualize Scrapfly Data in Python with pandas
Use pandas and other modules to analyze and visualize live Scrapfly in Python.
-
How to Visualize Microsoft Entra ID 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 Microsoft Entra ID in Python.
-
Design BIRT Reports on Demio Data
Provide current Demio to your embedded analytics.
-
A PostgreSQL Interface for ShipEngine Data using the CData ODBC Driver
Use the SQL Gateway and ShipEngine ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Reply.io 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 Reply.io.
-
Create Facebook Ads-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Facebook Ads Data from Klipfolio and build custom visualizations using live Facebook Ads.
-
Import Avalara AvaTax Data Using Azure Data Factory
Use CData Connect AI to connect to Avalara AvaTax Data from Azure Data Factory and import live Avalara AvaTax.
-
Integrate Quaderno with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Quaderno with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Quaderno.
-
Connect to Real-Time Neo4J Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Neo4J and Dataflow to import and use Neo4J in Power Apps.
-
Create Informatica Mappings From/To an ODBC Data Source for Eventbrite
Create an ODBC connection to Eventbrite in Informatica and browse and transfer Eventbrite.
-
Integrating Cursor CLI with IBM Cloud Object Storage 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.
-
How to Work with Confluence Data in AWS Glue Jobs Using JDBC
Connect to Confluence from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Analyze Live Avro Data in SAS Viya
Use CData Connect AI to connect to Apache Avro from SAS Viya and deploy self-service analytics using live Apache Avro.
-
Integrating Kiro CLI with Mailjet 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 AI/ML Models with Live Autopilot Data using Dataiku
Connect Autopilot Data with Dataiku using the CData API Driver for JDBC.
-
Explore Geographical Relationships in Avro Data with Power Map
Create data visualizations with Apache Avro in Power Map.
-
Natively Connect to AdRoll Data in PHP
The CData ODBC driver for AdRoll enables you to create PHP applications with connectivity to AdRoll. Leverage the native support for ODBC in PHP.
-
Access HBase Data from MySQL in Amazon QuickSight
Connect to HBase and build visualizations of Apache HBase using a MySQL Connection in Amazon QuickSight.
-
Consume Greenhouse OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Greenhouse feeds that reflect any changes in SAP Lumira.
-
How to connect to Facebook Ads Data from IntelliJ
Integrate connectivity to Facebook Ads with wizards in IntelliJ.
-
Automated Microsoft Teams Data Replication to Teradata
Use CData Sync to Customize and automate Microsoft Teams replication to Teradata.
-
Publish Reports with SuiteCRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SuiteCRM.
-
Create Intercom Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Intercom data access from reports, embedded analytics, and more.
-
How to connect PolyBase to Instantly
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Instantly.
-
Create Informatica Mappings From/To an ODBC Data Source for AlloyDB
Create an ODBC connection to AlloyDB in Informatica and browse and transfer Google AlloyDB.
-
Automated Continuous Toggl Replication to Snowflake
Use CData Sync for automated, continuous, customizable Toggl replication to Snowflake.
-
How to publish and share Mailgun Data dashboards with Tableau Server
The CData ODBC driver for Mailgun enables you integrate Mailgun into Tableau dashboards.
-
Build Jira-Connected Apps in Choreo
Use CData Connect AI to connect to Jira Data from Choreo and build custom apps using live Atlassian Jira.
-
Query Coda Data in ColdFusion
Write standard ColdFusion data access code to connect to Coda.
-
Access Live Monday.com Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Monday.com from your Google Sheets.
-
Getting Started with the CData SSIS Components for HubSpot
Complete guide to installing, licensing, and connecting with the CData SSIS Components for HubSpot.
-
Enable the Twilio JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Twilio.
-
Query Live SAP Fieldglass 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 SAP Fieldglass directly from the development environment.
-
Integrating Claude Code with SAP Ariba Procurement Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAP Ariba Procurement within assisted coding and automated development workflows.
-
Automate LightSpeedRetail Data Replication to Azure Data Lake
Use CData Sync to customize and automate LightSpeedRetail replication to Azure Data Lake.
-
Connect to Google Tasks Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate with Deel Data in JReport Designer
Create charts and reports based on Deel in JReport Designer.
-
Use Biml to Build SSIS Tasks to Replicate Rebilly Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Rebilly to SQL Server.
-
Access Live Instantly Data in Coginiti Pro
Connect to and query live Instantly from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Oracle Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Oracle from PowerBI.com to create Power BI Dataflows with real-time data.
-
Write a Simple Go Application to work with GitLab Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to GitLab.
-
Analyze BigQuery Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google BigQuery and visualize live Google BigQuery in Infragistics Reveal.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed MarkLogic to Power BI dashboards. Simply drag and drop MarkLogic into data visuals on the Power BI canvas.
-
Import and Visualize Gumroad Data in Power View
Create data visualizations based on Gumroad in Excel.
-
Publish Crystal Reports on Monday.com Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Monday.com.
-
Automated Continuous ZohoMarketingHub Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to Azure SQL Database.
-
Build LinkedIn Ads-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for LinkedIn Ads to explore live LinkedIn Ads Data in Claude Code to assist with building LinkedIn Ads-powered applications.
-
Automated Continuous Google Ads Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Ads replication to Azure SQL Database.
-
Consume QuickBooks OData Feeds in PowerBuilder
This article demonstrates how to consume QuickBooks Desktop as OData feeds from PowerBuilder using the API Server.
-
How to Work with HubSpot Data in ETL Validator JDBC
Connect to HubSpot from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Open WebUI with Live SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP Netweaver Gateway from within the chat interface.
-
Connect to MySQL Data from AWS Glue
Use CData Connect AI to gain access to live MySQL from your AWS Glue jobs.
-
Integrating Antigravity CLI with Perigon via CData CLI
Connect Perigon to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use the CData Software JDBC Driver for Copper in MicroStrategy
Connect to Copper in MicroStrategy Developer using the CData Software JDBC Driver for Copper.
-
How to Connect to & Open Drift Data in Microsoft Excel
This article uses the CData ODBC driver for Drift to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Zoho CRM Data into Power Automate Desktop using CData Connect
CData Connect for Zoho CRM Data enables you to integrate Zoho CRM into workflows built using Microsoft Power Automate Desktop.
-
Use the CData SSIS Components to Insert New or Update Existing Greenplum Records from SQL Server
Easily push SQL Server data to Greenplum using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Greenplum or update existing records with data from a SQL Server database.
-
Prepare, Blend, and Analyze Instagram Data in Alteryx Designer (Connect AI)
Build workflows to access live Instagram for self-service data analytics.
-
Use Dash to Build Web Apps on Email Data via CData Connect AI
Build interactive Dash web apps on live Email using pandas and the CData Connect AI Python SDK.
-
How to connect and process ServiceDesk Plus from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ServiceDesk Plus.
-
Use the CData SSIS Components to Insert New or Update Existing Elasticsearch Records from SQL Server
Easily push SQL Server data to Elasticsearch using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Elasticsearch or update existing records with data from a SQL Server database.
-
Publish Neo4J-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Neo4J.
-
How to Build an ETL App for PolarTeamPro Data in Python with CData
Create ETL applications and real-time data pipelines for PolarTeamPro in Python with petl.
-
Create Dynamic Browserless Grids Using the Infragistics XamDataGrid
Learn how you can connect Browserless to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData ODBC Driver for Pushbullet from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Pushbullet to connect to Pushbullet from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Pushbullet in Excel.
-
Connect to PDFMonkey Data in HULFT Integrate
Connect to PDFMonkey as a JDBC data source in HULFT Integrate
-
Access Live Paddle Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Paddle into the statistical analysis tools available in SAS JMP. This article shows how to use Paddle in the Graph Builder and Query Builder.