CData Software - Knowledge Base
Recent Articles
-
Replicate LightSpeedRetail Data to Multiple Databases
Replicate LightSpeedRetail to disparate databases with a point-and-click configuration.
-
Rapidly Develop Airtable-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Airtable.
-
Design BIRT Reports on Kintone Data
Provide current Kintone to your embedded analytics.
-
How to integrate Onfleet with Apache Airflow
Access and process Onfleet in Apache Airflow using the CData JDBC Driver.
-
How to create Visio diagrams from Adobe Commerce Data
Automatically update Adobe Commerce with the changes you make to Visio master shapes.
-
Connect to JobNimbus Data in Jaspersoft Studio
Execute SQL to remote JobNimbus in Jaspersoft Studio.
-
Integrate Live Zoho Projects Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Zoho Projects from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zoho Projects.
-
Integrating Cursor CLI with Airtable 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 the CData Software JDBC Driver for Twitter Ads in MicroStrategy Desktop
Connect to Twitter Ads in MicroStrategy Desktop using the CData Software JDBC Driver for Twitter Ads.
-
Build Charts with MessageBird Data in Clear Analytics
Create dynamic charts and perform analytics based on MessageBird in Clear Analytics.
-
Automate EnterpriseDB Data Replication to Couchbase
Use CData Sync to Customize and automate EnterpriseDB replication to Couchbase.
-
Explore Geographical Relationships in Teamgate Data with Power Map
Create data visualizations with Teamgate in Power Map.
-
How to Connect to Live LinkedIn 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 LinkedIn for you.
-
Getting Started with the CData ODBC Driver for Google Analytics
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Analytics.
-
Natively Connect to Pipedrive Data in PHP
The CData ODBC driver for Pipedrive enables you to create PHP applications with connectivity to Pipedrive. Leverage the native support for ODBC in PHP.
-
Build Automated Workflows with Live Bullhorn CRM Data in Workato
Use CData Connect AI to connect to live Bullhorn CRM and build automated workflows in Workato.
-
How to Seamlessly Import SAP Business Warehouse Data into IBM SPSS Modeler
Integrate SAP Business Warehouse data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create Highrise-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Highrise Data from Klipfolio and build custom visualizations using live Highrise CRM.
-
Connect to Google Forms Data in NetBeans
Connect to Google Forms in NetBeans with the data source configuration wizard.
-
Build Data Flows from WooCommerce to SQL Server using SSIS
Easily back up WooCommerce to SQL Server using the SSIS components for WooCommerce.
-
Connect to Blackbaud FE NXT Data from a Connection Pool in JBoss
Integrate Blackbaud FE NXT into Java servlets: Use the Management Console in JBoss to install the Blackbaud FE NXT JDBC Driver.
-
How to Connect the Power BI Service to Moosend: Complete Guide
Connect to the CData Software Power BI Connector for Moosend from PowerBI.com to provide real-time Moosend across the organization.
-
Visualize Live Gmail Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Gmail.
-
Getting Started with the CData ADO.NET Provider for Invoiced
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Access Live Reckon Accounts Hosted 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 Reckon Accounts Hosted through MCP integration.
-
Integrating Boomi Agentstudio with Snowflake Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Snowflake, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Dashboards with SAP Netweaver Gateway Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Netweaver Gateway in Dundas BI.
-
Connect to Webflow Data from PowerBuilder via ADO.NET
This article demonstrates how to access Webflow from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Using the CData Software ODBC Driver for Reckon Accounts Hosted in PyCharm
Connect to Reckon Accounts Hosted as an ODBC data source in PyCharm using the CData Software ODBC Driver for Reckon Accounts Hosted.
-
Connect to SAS xpt Data in Jaspersoft Studio
Execute SQL to remote SAS XPORT in Jaspersoft Studio.
-
How to integrate Metabase with Sybase IQ Data
Use CData Connect AI to connect to live Sybase IQ and create an interactive dashboard in Metabase from Sybase IQ.
-
Getting Started with the CData Power BI Connector for Webflow
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build Charts with Freshteam Data in Clear Analytics
Create dynamic charts and perform analytics based on Freshteam in Clear Analytics.
-
Connect to Testmonitor Data in HULFT Integrate
Connect to Testmonitor as a JDBC data source in HULFT Integrate
-
Connect to Quaderno Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Analyze SAS xpt Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAS xpt from Power Pivot. You will use the Table Import Wizard to load SAS XPORT. You can visually build the import query or use any SQL supported by the driver.
-
How to Work with Yelp Data in AWS Glue Jobs Using JDBC
Connect to Yelp from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Azure DevOps Data in Sisense
Create an ElastiCube in Sisense app with access to Azure DevOps.
-
Access Live SpaceX Data in AWS Lambda
Connect to live SpaceX in AWS Lambda using the CData JDBC Driver.
-
Integrate with live Snowflake Data in Jitterbit
Use CData Connect AI to connect to and integrate live Snowflake in Jitterbit.
-
Consume Pinterest OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Pinterest feeds that reflect any changes in SAP Lumira.
-
Excel Spreadsheet Automation on Email Data with the QUERY Formula
Pull data from Email, automate spreadsheets, and more with the QUERY formula.
-
Connect to Dynamics 365 Business Central Data from Crystal Reports
Use CData Connect AI to connect to and report on live Dynamics 365 Business Central from Crystal Reports.
-
Integrate with Snowflake Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Snowflake to a JSON file on disk.
-
Operational Reporting on ClickTime Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ClickTime.
-
Build Google Search-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Search Results from Zoho Analytics and import live Google Search.
-
How to create an RPA flow for Excel Online Data in UiPath Studio
Use the Excel Online ODBC Driver to create workflows that access real-time Microsoft Excel Online without any coding.
-
How to Query Live Amazon Athena Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Amazon Athena data in natural language using Python.
-
Build Azure Data Lake Storage-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Azure Data Lake Storage.
-
ETL FreeAgent in Oracle Data Integrator
This article shows how to transfer FreeAgent into a data warehouse using Oracle Data Integrator.
-
Use the CData Software ODBC Driver for Epicor Kinetic in MicroStrategy Web
Connect to Epicor Kinetic in MicroStrategy Web using the CData Software ODBC Driver for Epicor Kinetic.
-
Getting Started with the CData ODBC Driver for PayPal
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for PayPal.
-
Replicate Multiple Parquet Accounts
Replicate multiple Parquet accounts to one or many databases.
-
Build Data Flows from Phoenix to SQL Server using SSIS
Easily back up Apache Phoenix to SQL Server using the SSIS components for Phoenix.
-
How to Connect DBeaver to Stack Exchange via a JDBC Driver
Manage Stack Exchange with visual tools in DBeaver like the query browser.
-
Explore Geographical Relationships in REST Data with Power Map
Create data visualizations with REST in Power Map.
-
Visualize Raisers Edge NXT Data in TIBCO Spotfire through ADO.NET
Integrate Raisers Edge NXT into dashboards in TIBCO Spotfire.
-
Integrate MailerLite with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate MailerLite with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to MailerLite.
-
Use the CData Software ODBC Driver for SFTP in SAS for Real-Time Reporting and Analytics
Connect to real-time SFTP in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SFTP.
-
Create Reports with Shopify Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Shopify.
-
Write a Simple Go Application to work with RSS Feeds on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to RSS Feeds.
-
Query Raisers Edge NXT Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Raisers Edge NXT and perform CRUD operations on Raisers Edge NXT from Node.js.
-
Build Semantic Layer Views for xBase Data in APOS Live Data Gateway
Use the CData Connector for xBase in APOS Live Data Gateway to build Semantic Layer Views for xBase.
-
Automated Continuous Amazon Marketplace Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to AlloyDB.
-
Integrating Kiro CLI with ADP 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 Retrieve Salesforce Formula Fields in Tableau
Learn how to retrieve Salesforce formula fields directly in Tableau using the CData Salesforce Tableau Connector. Eliminate manual recalculation and simplify real-time CRM analytics and visualization.
-
Connect to Acumatica Data in Google Apps Script via Connect AI
Use CData Connect AI to access Acumatica ERP in Google Apps Script.
-
Design BIRT Reports on Pushbullet Data
Provide current Pushbullet to your embedded analytics.
-
Automated Continuous Azure Data Catalog Replication to Vertica
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Vertica.
-
Connect to NASA from Asprova with CData Software ODBC Driver for NASA
This article shows how to connect faster to NASA data from Asprova.
-
How to connect to TigerGraph Data from IntelliJ
Integrate connectivity to TigerGraph with wizards in IntelliJ.
-
Connect to CSV Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live CSV/TSV Files.
-
Build REST-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for REST to explore live REST Data in Claude Code to assist with building REST-powered applications.
-
Explore Geographical Relationships in Postmark Data with Power Map
Create data visualizations with Postmark in Power Map.
-
Enable the Eventbrite JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Eventbrite.
-
Integrating Kiro CLI with CapsuleCRM 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.
-
Getting Started with the CData Excel Add-In for Productboard
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Productboard.
-
Automated Salesforce Marketing Data Replication to Teradata
Use CData Sync to Customize and automate Salesforce Marketing Cloud replication to Teradata.
-
Access Live Avro 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 Apache Avro through MCP integration.
-
Using the CData Software ODBC Driver for Sybase IQ in PyCharm
Connect to Sybase IQ as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sybase IQ.
-
Use the CData Software JDBC Driver for Instagram in MicroStrategy Web
Connect to Instagram in MicroStrategy Web using the CData Software JDBC Driver for Instagram.
-
Analyze WooCommerce Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for WooCommerce from Power Pivot. You will use the Table Import Wizard to load WooCommerce. You can visually build the import query or use any SQL supported by the driver.
-
ETL Microsoft Planner in Oracle Data Integrator
This article shows how to transfer Microsoft Planner into a data warehouse using Oracle Data Integrator.
-
Viewing Microsoft Planner Data in RAD Studio Data Explorer
How to view Microsoft Planner in RAD Studio Data Explorer using the CData ODBC Driver for Microsoft Planner.
-
DataBind Controls to Microsoft Teams Data in Delphi
DataBind to Microsoft Teams in Delphi with standard data access components and controls.
-
Publish Reply.io-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Reply.io.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Snowflake
Provide connectivity to Snowflake through an SAP BusinessObjects universe.
-
Use the CData Software JDBC Driver for PhantomBuster in MicroStrategy Desktop
Connect to PhantomBuster in MicroStrategy Desktop using the CData Software JDBC Driver for PhantomBuster.
-
Migrating data from Drip to Google BigQuery using CData SSIS Components.
Easily push Drip to Google BigQuery using the CData SSIS Tasks for Drip and Google BigQuery.
-
Work with CampaignMonitor Data in FoxPro
Load CampaignMonitor into a FoxPro database. This article includes full code and a walk-through of the process.
-
Configure the CData JDBC Driver for EnterpriseDB in a Connection Pool in Tomcat
Connect to EnterpriseDB from a connection pool in Tomcat.
-
Automate Bugsnag Data Replication to SAP HANA
Use CData Sync to customize and automate Bugsnag replication to SAP HANA.
-
Connect to WordPress Data in DBeaver
Use the CData ODBC Driver to connect to WordPress in DBeaver.
-
Create PostgreSQL-Connected Nintex Workflows
Use CData Connect AI to connect to PostgreSQL Data from Nintex Workflow Cloud and build custom workflows using live PostgreSQL.
-
Access Live SAP Fieldglass Data in TIBCO Data Virtualization
Use the SAP Fieldglass Tibco DV Adapter to create a SAP Fieldglass data source in TIBCO Data Virtualization Studio and gain access to live SAP Fieldglass from your TDV Server.
-
Automate SendGrid Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SendGrid from PowerShell? This article demonstrates how to utilize the SendGrid Cmdlets for tasks like connecting to SendGrid, automating operations, downloading data, and more.
-
How to Access Live SAP Ariba Source Data in Visual Studio Code via Cline
Run CData MCP Server for SAP Ariba Source on Windows Subsytem for Linux (WSL) and connect to live SAP Ariba Source from the Cline extension in Visual Studio Code.
-
How to Query Contentful Data in MySQL Workbench
Execute MySQL queries against live Contentful from MySQL Workbench.
-
Build Certinia Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Certinia and build visualizations in Tableau Cloud.
-
Build MVC Applications with Connectivity to MessageBird Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access MessageBird from an ASP.NET MVC application.