CData Software - Knowledge Base
Recent Articles
-
Rapidly Develop Teamgate-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 Teamgate.
-
Automated Continuous Freshservice Replication to MySQL
Use CData Sync for automated, continuous, customizable Freshservice replication to MySQL.
-
Connect to Vercel Data in DBArtisan
Use wizards in DBArtisan to configure Vercel as a data source.
-
Create SAP Ariba Source-Connected Applications in Appsmith
Connect to SAP Ariba Source Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Ariba Source.
-
Analyze eBay Analytics Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze eBay Analytics with the CData JDBC Driver for eBay Analytics.
-
Connect to Facebook Ads from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Facebook Ads, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Klaviyo to Power BI dashboards. Simply drag and drop Klaviyo into data visuals on the Power BI canvas.
-
Rapidly Develop Notion-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 Notion.
-
DataBind Controls to Cloudant Data in Delphi
DataBind to IBM Cloudant in Delphi with standard data access components and controls.
-
Connect to CouchDB Data in NetBeans
Connect to Apache CouchDB in NetBeans with the data source configuration wizard.
-
Automated Amplitude Data Replication to Teradata
Use CData Sync to Customize and automate Amplitude replication to Teradata.
-
Build Visualizations of Insightly Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Insightly in Birst.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Adobe Target
Provide connectivity to Adobe Target through an SAP BusinessObjects universe.
-
How to Work with Amazon Athena Data in AWS Glue Jobs Using JDBC
Connect to Amazon Athena from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live SAP Ariba Source Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP Ariba Source in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Back Up NASA 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 NASA data.
-
Automated Continuous Quickbase Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Quickbase replication to Amazon Redshift.
-
How to load Invoiced data into Elasticsearch via Logstash
Introducing a simple method to load Invoiced data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use ChatGPT to Talk to Your Adobe Commerce 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 Adobe Commerce for you.
-
How to connect to Contentful Data with Squirrel SQL client
Connect to Contentful and execute queries in the Squirrel SQL Client.
-
Visualize DB2 Data in Tableau
The CData ODBC driver for DB2 enables you integrate IBM DB2 into Tableau dashboards.
-
Connect SAP Hybris C4C to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP Hybris C4C with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Live Azure Analysis Services Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Azure Analysis Services from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Azure Analysis Services.
-
Visualize Box Data in Sisense
Create an ElastiCube in Sisense app with access to Box.
-
A PostgreSQL Interface for Google Spanner Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Spanner JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Seamlessly Import Invoiced Data into IBM SPSS Modeler
Integrate Invoiced data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Import Real-Time Exa Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Exa in ColdFusion.
-
How to import Databricks Data into Apache Solr
Use the CData Software JDBC Driver for Databricks in Data Import Handler and create an automated import of Databricks to Apache Solr Enterprise Search platform.
-
Access ActiveCampaign Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ActiveCampaign from HeidiSQL.
-
Connecting Mastra with Confluence 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 Atlassian Confluence, no replication required.
-
Connect to Eventbrite Data in NetBeans
Connect to Eventbrite in NetBeans with the data source configuration wizard.
-
How to Connect to Live Cassandra 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 Apache Cassandra for you.
-
Integrating Cursor CLI with Reckon Accounts Hosted 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.
-
Integrate with CloudConvert Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy CloudConvert to a JSON file on disk.
-
Integrate Google Analytics Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Analytics from Informatica Cloud.
-
Automated Continuous PostgreSQL Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable PostgreSQL replication to Apache Cassandra.
-
Create Azure Synapse-Connected Applications in Appsmith
Connect to Azure Synapse Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Azure Synapse.
-
Connect to Procore Data in RazorSQL
Connect to Procore from wizards and query Procore from the GUI in the RazorSQL database management tool.
-
How to Query Live Instagram Data in Claude Desktop
Connect to and query live Instagram Data in Claude Desktop using CData MCP Server.
-
Build Dashboards with Gumroad Data in Dundas BI
Create dynamic dashboards and perform analytics based on Gumroad in Dundas BI.
-
Create SSAS Tabular Models from Raisers Edge NXT Data
How to build a SQL Server Analysis Service Tabular Model from Raisers Edge NXT using CData drivers.
-
Use the CData Software ODBC Driver for Bugsnag in MicroStrategy Web
Connect to Bugsnag in MicroStrategy Web using the CData Software ODBC Driver for Bugsnag.
-
Work with Billsby Data in FoxPro
Load Billsby into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build a Singer.io Tap for Testmonitor With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Testmonitor data using
-
Automated Continuous Zoho Inventory Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to Apache Kafka.
-
Validate Foursquare Data with QuerySurge
Access and validate Foursquare in QuerySurge using the CData JDBC Driver.
-
Publish Crystal Reports on QuickBooks Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date QuickBooks Desktop.
-
Add Webflow Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Webflow with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build a Singer.io Tap for FreshBooks With the CData Python Connector
Learn how to easily build a Singer.io Tap for live FreshBooks data using
-
How to work with Drift Data in Apache Spark using SQL
Access and process Drift Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to and Visualize Live Confluence Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Atlassian Confluence.
-
Seamlessly Bring Power BI XMLA Data into Retool Using CData Connect AI
Integrate Power BI XMLA data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrating Shopify Data in Talend Cloud Data Management Platform
Connect Shopify Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Shopify.
-
Create Data Visualizations in Cognos BI with Microsoft Exchange Data
Access Microsoft Exchange as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Nethunt in SpagoBI
Create reports featuring live Nethunt in SpagoBI Studio. Host Nethunt reports on SpagoBI Server.
-
Automate Sendwithus Data Replication to Couchbase
Use CData Sync to Customize and automate Sendwithus replication to Couchbase.
-
How to connect to SharePoint Data with Squirrel SQL client
Connect to Microsoft SharePoint and execute queries in the Squirrel SQL Client.
-
Automated Continuous Moosend Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Moosend replication to IBM DB2.
-
Mixpanel Reporting in OBIEE with the Mixpanel JDBC Driver
Deploy the Mixpanel JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build CSV-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live CSV/TSV Files.
-
Build a Singer.io Tap for Figshare With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Figshare data using
-
Working with JotForm Data in LINQPad
Execute LINQ queries to JotForm in LINQPad.
-
Building Dynamic Web Pages with Spark Data Using AngularJS
Create single-page applications with live connectivity to Spark using the CData API Server.
-
Connect to Avro Data in JRuby
Create a simple JRuby app with access to live Apache Avro.
-
Access Live Marketo Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Marketo from your Excel spreadsheets.
-
Create Dynamic Vimeo Grids Using the Infragistics XamDataGrid
Learn how you can connect Vimeo to Infragistics XamDataGrid to build dynamic grids.
-
Visualize Live ActiveCampaign Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live ActiveCampaign into custom reports in Power BI.
-
Access Gmail Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Gmail from HeidiSQL.
-
Viewing Zoho Projects Data in RAD Studio Data Explorer
How to view Zoho Projects in RAD Studio Data Explorer using the CData ODBC Driver for Zoho Projects.
-
Build Azure Data Lake Storage-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Azure Data Lake Storage to explore live Azure Data Lake Storage Data in Claude Code to assist with building Azure Data Lake Storage-powered applications.
-
Create xBase Dataflows on PowerBI.com
Connect to the CData Power BI Connector for xBase from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Shippo Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Shippo replication to IBM DB2.
-
Create Informatica Mappings From/To an ODBC Data Source for Azure Data Lake Storage
Create an ODBC connection to Azure Data Lake Storage in Informatica and browse and transfer Azure Data Lake Storage.
-
Explore Geographical Relationships in Apify Data with Power Map
Create data visualizations with Apify in Power Map.
-
Use JayDeBeApi to access Simplesat Data in Python
Use standard Python scripting and the development environment of your choice to access live Simplesat.
-
Connect to Jodoo Data in HULFT Integrate
Connect to Jodoo as a JDBC data source in HULFT Integrate
-
How to use SQLAlchemy ORM to access FreshBooks Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of FreshBooks.
-
Moving Data from Office 365 to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Office 365 data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate Goose with Live DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live DocuSign from within the local AI agent.
-
Automated Continuous ZohoInvoice Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to Apache Kafka.
-
Automated Continuous Mouseflow Replication to SQLite
Use CData Sync for automated, continuous, customizable Mouseflow replication to SQLite.
-
Access CircleCI Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access CircleCI from your Oracle system.
-
View Reports on Real-Time BigQuery Data in Power BI Report Server
Use the CData ODBC Driver for BigQuery to visualize Google BigQuery in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Live FTP Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live FTP Servers from your Google Sheets.
-
Rapidly Develop Azure Table-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 Azure Table.
-
Use the CData Software JDBC Driver for Parallel in MicroStrategy
Connect to Parallel in MicroStrategy Developer using the CData Software JDBC Driver for Parallel.
-
Create Reports from Sybase Data in Looker Studio
Use CData Connect AI to gain access to live Sybase and create custom reports in Looker Studio.
-
How to connect to Sybase Data from Spring Boot
Connect to Sybase in a Spring Boot Application using the CData JDBC Driver for Sybase
-
Analyze Discord Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Discord with the CData JDBC Driver for Discord.
-
How to work with eBay Data in Apache Spark using SQL
Access and process eBay Data in Apache Spark using the CData Software JDBC Driver.
-
Build AI/ML Models with Live Vercel Data using Dataiku
Connect Vercel Data with Dataiku using the CData API Driver for JDBC.
-
Build Google Calendar Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Calendar and build visualizations in Tableau Cloud.
-
Connect to Excel Online from Asprova with CData Software ODBC Driver for Excel Online
This article shows how to connect faster to Excel Online data from Asprova.
-
DataBind Charts to SurveyMonkey Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SurveyMonkey from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Build an OLAP Cube in SSAS from Vault CRM Data
Establish a connection to Veeva Vault & Vault CRM data from SQL Server Analysis Services, and use the Vault CRM Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automate Vertica Data Replication to SAP HANA
Use CData Sync to customize and automate Vertica replication to SAP HANA.
-
Working with Postmark Data in LINQPad
Execute LINQ queries to Postmark in LINQPad.
-
Build Microsoft OneDrive-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Microsoft OneDrive Data from Zoho Analytics and import live Microsoft OneDrive.
-
Back Up Todoist 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 Todoist data.
-
Build an OLAP Cube in SSAS from SAP BusinessObjects BI Data
Establish a connection to SAP BusinessObjects BI data from SQL Server Analysis Services, and use the SAP BusinessObjects BI Data Provider to build OLAP cubes for use in analytics and reporting.