CData Software - Knowledge Base
Recent Articles
-
Connect to CouchDB Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for CouchDB Data and connect to Apache CouchDB in Akorbi Digital RunMyProcess.
-
Create Informatica Mappings From/To a JDBC Data Source for Pushbullet
Create Pushbullet data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Query Live Google Contacts Data in Perplexity MacOS Desktop
Connect to and query live Google Contacts Data in Perplexity Desktop using CData MCP Server.
-
Automate Printful Data Replication to Couchbase
Use CData Sync to Customize and automate Printful replication to Couchbase.
-
Automated Continuous Google Ads Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Ads replication to Apache Cassandra.
-
Replicate Drift Data to Multiple Databases via the CData Sync CLI
Replicate Drift to disparate databases with a single configuration.
-
Publish Crystal Reports on Reckon Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Reckon.
-
How to Use a Microsoft Access Database to Update NetSuite Data in Real Time
Update NetSuite data by creating a linked table in Microsoft Access with the CData NetSuite ODBC Driver.
-
Build Anaplan-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Anaplan.
-
Connect to and Visualize Live Presto Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Presto.
-
DataBind Charts to Dynamics 365 Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Dynamics 365 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.
-
TaxJar Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on TaxJar facts in real time.
-
Connect to Typeform Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Typeform to connect to Typeform and execute queries in PowerBuilder.
-
Connect to NASA Data in DBArtisan
Use wizards in DBArtisan to configure NASA as a data source.
-
How to Easily Query WooCommerce Data in OpenOffice Base
Connect to WooCommerce data in OpenOffice Base using the CData ODBC Driver for WooCommerce and generate reports with live data insights.
-
Work with Live Couchbase Data in Power Query
Use CData Connect AI to connect to Couchbase and work with live Couchbase in Microsoft Power Query.
-
View Reports on Real-Time Shippo Data in Power BI Report Server
Use the CData ODBC Driver for Shippo to visualize Shippo in Power BI Desktop and then publish them to Power BI Report Server.
-
Migrating data from Placid to Databricks using CData SSIS Components.
Easily push Placid to Databricks using the CData SSIS Tasks for Placid and Databricks.
-
Integrating OpenCode Terminal with Procore 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.
-
Connect to NASA Data from PowerBuilder via ADO.NET
This article demonstrates how to access NASA from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automated Continuous AfterShip Replication to SingleStore
Use CData Sync for automated, continuous, customizable AfterShip replication to SingleStore.
-
Automate Sybase Data Replication to Couchbase
Use CData Sync to Customize and automate Sybase replication to Couchbase.
-
How to use SQLAlchemy ORM to access Google Sheets Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Sheets.
-
Integrating DB2 Data in Talend Cloud Data Management Platform
Connect DB2 Data with Talend Cloud Data Management Platform using the CData JDBC Driver for DB2.
-
Process & Analyze Tanda Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Tanda Data.
-
Integrate LibreChat with Live Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Atlassian Jira from within the chat interface.
-
Build Automated Workflows with Live Certinia Data in Workato
Use CData Connect AI to connect to live Certinia and build automated workflows in Workato.
-
How to load Close data into Elasticsearch via Logstash
Introducing a simple method to load Close data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Figshare from Asprova with CData Software ODBC Driver for Figshare
This article shows how to connect faster to Figshare data from Asprova.
-
How to create an RPA flow for Parquet Data in UiPath Studio
Use the Parquet ODBC Driver to create workflows that access real-time Apache Parquet without any coding.
-
Access Live LDAP Objects in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate LDAP into the statistical analysis tools available in SAS JMP. This article shows how to use LDAP in the Graph Builder and Query Builder.
-
Create Google Calendar-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Google Calendar Data from Klipfolio and build custom visualizations using live Google Calendar.
-
Build AI Agents with Spark Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Apache Spark SQL through CData Connect AI.
-
Integrating Gumloop with Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Basecamp within automated workflows.
-
Access CSV Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access CSV/TSV Files from your Oracle system.
-
Query Live Office 365 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 Microsoft Office 365 directly from the development environment.
-
Bridge HBase Connectivity with Apache NiFi
Access and process Apache HBase in Apache NiFi using the CData JDBC Driver.
-
Integrating Cursor CLI with Bugsnag 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 Dynamic Salesforce CRM Analytics Grids Using the Infragistics XamDataGrid
Learn how you can connect Salesforce CRM Analytics to Infragistics XamDataGrid to build dynamic grids.
-
Download files from a SharePoint site using the CData SSIS Components
The CData SSIS data flow components allow you to easily import and export data from various data sources. However in some cases the type of operation you need does not fit the SSIS Data Source or the SSIS Data Destination model. In this article, we will demonstrate how to use a CData stored procedure in your SSIS data flow.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live eBay using the Model Context Protocol.
-
Automate AgileCRM Data Replication to Couchbase
Use CData Sync to Customize and automate AgileCRM replication to Couchbase.
-
Build Charts with ZohoSubscriptions Data in Clear Analytics
Create dynamic charts and perform analytics based on ZohoSubscriptions in Clear Analytics.
-
Automated Continuous MarkLogic Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable MarkLogic replication to Apache Cassandra.
-
Automated Continuous Microsoft Ads Replication to Databricks
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to Databricks.
-
Connect FTP Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your FTP Servers using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Analyze JotForm Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for JotForm from Power Pivot. You will use the Table Import Wizard to load JotForm. You can visually build the import query or use any SQL supported by the driver.
-
Back Up DocuSign to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for DocuSign. In this article, we will employ an SSIS workflow to populate a database with DocuSign data.
-
Connect to SpaceX Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SpaceX.
-
Use the CData Software JDBC Driver for Qualaroo in MicroStrategy Desktop
Connect to Qualaroo in MicroStrategy Desktop using the CData Software JDBC Driver for Qualaroo.
-
Use the CData Software ODBC Driver for Salesforce Pardot in MicroStrategy Desktop
Connect to Salesforce Pardot in MicroStrategy Desktop using the CData Software ODBC Driver for Salesforce Pardot.
-
Build Apps with Live LeadDesk Data Using the Low-Code Development Platform of Mendix
Connect LeadDesk with Mendix to build apps using the CData API Driver for JDBC.
-
How to work with Google Tasks Data in Apache Spark using SQL
Access and process Google Tasks Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Workday to Power BI dashboards. Simply drag and drop Workday into data visuals on the Power BI canvas.
-
Build Data Flows from CSV to SQL Server using SSIS
Easily back up CSV/TSV Files to SQL Server using the SSIS components for CSV.
-
Use the CData ODBC Driver for CapsuleCRM in Microsoft Power Query
You can use the CData CapsuleCRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import CapsuleCRM into Microsoft Power Query.
-
Connect to SendGrid from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SendGrid, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous Tally Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Tally replication to Google BigQuery.
-
Publish Crystal Reports on Suadeo Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Suadeo.
-
Connect to Azure DevOps Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Azure DevOps and the SQL Gateway to access Azure DevOps from Google Apps Script.
-
Use the CData Software JDBC Driver for ZarMoney in MicroStrategy Web
Connect to ZarMoney in MicroStrategy Web using the CData Software JDBC Driver for ZarMoney.
-
Build Semantic Layer Views for Blackbaud FE NXT Data in APOS Live Data Gateway
Use the CData Connector for Blackbaud FE NXT in APOS Live Data Gateway to build Semantic Layer Views for Blackbaud FE NXT.
-
Access CSV Data from MySQL in Amazon QuickSight
Connect to CSV and build visualizations of CSV/TSV Files using a MySQL Connection in Amazon QuickSight.
-
Excel Spreadsheet Automation on Codat Data with the QUERY Formula
Pull data from Codat, automate spreadsheets, and more with the QUERY formula.
-
Build Apps with Live Discord Data Using the Low-Code Development Platform of Mendix
Connect Discord with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Email Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Email replication to Amazon S3.
-
Operational Reporting on NASA Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote NASA.
-
Establish a Live Connection with Certinia Data using Tableau Bridge
The CData ODBC Driver for Certinia enables you to integrate live Certinia into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Oracle HCM Cloud Data in HULFT Integrate
Connect to Oracle HCM Cloud as a JDBC data source in HULFT Integrate
-
Migrating data from Testmonitor to Google BigQuery using CData SSIS Components.
Easily push Testmonitor to Google BigQuery using the CData SSIS Tasks for Testmonitor and Google BigQuery.
-
Automate Timely Data Replication to Couchbase
Use CData Sync to Customize and automate Timely replication to Couchbase.
-
Access Live Templated Data in AWS Lambda
Connect to live Templated in AWS Lambda using the CData JDBC Driver.
-
How to Query Live Exact Online Data in Perplexity MacOS Desktop
Connect to and query live Exact Online Data in Perplexity Desktop using CData MCP Server.
-
Automated Continuous Certinia Replication to SQLite
Use CData Sync for automated, continuous, customizable Certinia replication to SQLite.
-
Use the CData API Server to Access Basecamp Data in Microsoft PowerPivot
Use the CData API Server to connect to live Basecamp in the Power Pivot business intelligence tool.
-
Query Neo4J Data in DataGrip
Create a Data Source for Neo4J in DataGrip and use SQL to query live Neo4J.
-
Integrate QuickBooks Time Data in the Pentaho Report Designer
Publish reports based on QuickBooks Time in the Pentaho BI tool.
-
Getting Started with the CData Python Connector for Phoenix
Learn to install and license the CData Python Connector
-
Build AI/ML Models with Live OneNote Data using Dataiku
Connect OneNote Data with Dataiku using the CData JDBC Driver for OneNote.
-
Use the CData Software ODBC Driver for ZendeskSell in MicroStrategy
Connect to ZendeskSell in MicroStrategy Developer using the CData Software ODBC Driver for ZendeskSell.
-
Connect to Acumatica Data in RazorSQL
Connect to Acumatica from wizards and query Acumatica ERP from the GUI in the RazorSQL database management tool.
-
How to integrate Browserless with Apache Airflow
Access and process Browserless in Apache Airflow using the CData JDBC Driver.
-
Integrate Live SAP Hybris C4C Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP Hybris C4C to Blue Prism using the CData ODBC Driver for SAP Hybris C4C to create automated workflows for repetitive business tasks.
-
How to connect to Raisers Edge NXT Data from Spring Boot
Connect to Raisers Edge NXT in a Spring Boot Application using the CData JDBC Driver for Raisers Edge NXT
-
Moving Data from Zoho Recruit to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Zoho Recruit data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Sage Intacct actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
How to Visualize IBM Informix Data in Python with pandas
Use pandas and other modules to analyze and visualize live IBM Informix in Python.
-
Import and Visualize Dotmailer Data in Power View
Create data visualizations based on Dotmailer in Excel.
-
Migrating data from Copper to Snowflake using CData SSIS Components.
Easily push Copper to Snowflake using the CData SSIS Tasks for Copper and Snowflake.
-
Query GetResponse Data as a MySQL Database in Node.js
Execute MySQL queries against GetResponse from Node.js.
-
Connect to Live AlloyDB Data in MicroStrategy through CData Connect AI
Create a live connection to AlloyDB Data in CData Connect AI and connect to your Google AlloyDB from MicroStrategy.
-
How to Connect to Live Redshift Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Amazon Redshift through natural language.
-
Getting Started with the CData Connect AI Python SDK for Jira
Install the CData Connect AI Python SDK to read and write live Atlassian Jira with standard DB-API 2.0 Python code.
-
Create Dynamic Act-On Grids Using the Infragistics XamDataGrid
Learn how you can connect Act-On to Infragistics XamDataGrid to build dynamic grids.
-
Access Live Workday Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Workday through MCP integration.
-
Integrate Live Testmonitor Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Testmonitor to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Add ZohoPeople Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ZohoPeople with the Informatica Enterprise Data Catalog to classify and organize data.
-
Back Up Google BigQuery to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for BigQuery. In this article, we will employ an SSIS workflow to populate a database with Google BigQuery data.
-
How to create an RPA flow for Freshservice Data in UiPath Studio
Use the Freshservice ODBC Driver to create workflows that access real-time Freshservice without any coding.
-
Integrate Open WebUI with Live Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Sybase IQ from within the chat interface.