CData Software - Knowledge Base
Recent Articles
-
Connect to eBay Data in DBArtisan
Use wizards in DBArtisan to configure eBay data as a data source.
-
Automated Continuous Invoiced Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Invoiced replication to Google Cloud SQL.
-
How to Connect Flowise AI Agents to Live Exact Online Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Exact Online data without replication.
-
Seamlessly Bring Google Ads Data into Retool Using CData Connect AI
Integrate Google Ads data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous Dynamics NAV Replication to Snowflake
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Snowflake.
-
How to load Kintone data into Elasticsearch via Logstash
Introducing a simple method to load Kintone data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query Xero Data in DataGrip
Create a Data Source for Xero in DataGrip and use SQL to query live Xero data.
-
Use Grok to Talk to Your Coda 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 Coda data for you.
-
Integrate Short.io Data in Pentaho Data Integration
Build ETL pipelines based on Short.io data in the Pentaho Data Integration tool.
-
Integrating OpenCode with Cohere 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 Twilio Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Twilio replication to Apache Kafka.
-
Automated Continuous HubSpot Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable HubSpot replication to Amazon Redshift.
-
Use Grok to Talk to Your Trello 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 Trello data for you.
-
Deploy the ADO.NET Provider for Mistral AI on an SSRS Report Server
Connect to Mistral AI data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to connect SharePoint with LinkedIn Ads Data through external lists
Provide LinkedIn Ads data to SharePoint users as an external list.
-
Access Keap Data from MySQL in Amazon QuickSight
Connect to Keap and build visualizations of Keap data using a MySQL Connection in Amazon QuickSight.
-
Importing Referenced Files in AWS Glue with Boto3
In this entry, you will learn how to use boto3 to download referenced files, such as RSD files, from S3 to the AWS Glue executor. Doing so will allow the JDBC driver to reference and use the necessary files.
-
Explore Geographical Relationships in Sentry Data with Power Map
Create data visualizations with Sentry data in Power Map.
-
Integrate with live Smartsheet Data in Jitterbit
Use CData Connect AI to connect to and integrate live Smartsheet data in Jitterbit.
-
Use Dash to Build Web Apps on Spark Data via CData Connect AI
Build interactive Dash web apps on live Spark data using pandas and the CData Connect AI Python SDK.
-
Provide OData Services of ZeroBounce Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ZeroBounce data by developing a WCF Service Application.
-
DataBind Controls to Azure Data Catalog Data in Delphi
DataBind to Azure Data Catalog data in Delphi with standard data access components and controls.
-
How to connect to Certinia Data with Squirrel SQL client
Connect to Certinia data and execute queries in the Squirrel SQL Client.
-
Back Up QuickBooks Time data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for QuickBooks Time. In this article, we will employ an SSIS workflow to populate a database with QuickBooks Time data data.
-
Build Semantic Layer Views for Power BI XMLA Data in APOS Live Data Gateway
Use the CData Connector for Power BI XMLA in APOS Live Data Gateway to build Semantic Layer Views for Power BI XMLA data.
-
Analyze HubSpot Data in Looker
Use CData Connect AI to connect to HubSpot Data from Looker and build custom apps using live HubSpot data.
-
Use the CData Software ODBC Driver for IBM Informix in MicroStrategy Web
Connect to IBM Informix data in MicroStrategy Web using the CData Software ODBC Driver for IBM Informix.
-
Query RabbitMQ Data through ODBC in Node.js
Use node-odbc to execute SQL queries against RabbitMQ data from Node.js.
-
Integrate Toggl with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Toggl with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Toggl data.
-
Natively Connect to Perplexity Data in PHP
The CData ODBC driver for Perplexity enables you to create PHP applications with connectivity to Perplexity data. Leverage the native support for ODBC in PHP.
-
Connect to and Visualize Live Salesforce Marketing Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Salesforce Marketing data.
-
How to work with Salesforce Data in Apache Spark using SQL
Access and process Salesforce Data in Apache Spark using the CData Software JDBC Driver.
-
Stream Spotify Data into Apache Kafka Topics
Access and stream Spotify data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to use SQLAlchemy ORM to access SendPulse Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SendPulse data.
-
How to Connect to Live Google Search Results from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Google Search results for you.
-
Choosing the Best Method to Connect Adobe Commerce to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Adobe Commerce data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create SAP SuccessFactors LMS-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP SuccessFactors LMS Data from OutSystems and build custom enterprise apps using live SAP SuccessFactors LMS data.
-
Build AI Agents with Figshare 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 Figshare data through CData Connect AI.
-
Query Sugar CRM Data in DataGrip
Create a Data Source for Sugar CRM in DataGrip and use SQL to query live Sugar CRM data.
-
Migrating data from DocuSign to Snowflake using CData SSIS Components.
Easily push DocuSign data to Snowflake using the CData SSIS Tasks for DocuSign and Snowflake.
-
Add Microsoft Teams Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Microsoft Teams with the Informatica Enterprise Data Catalog to classify and organize data.
-
Query, Visualize, and Share live Microsoft Dataverse Data in Redash
Use CData Connect AI to connect to live Microsoft Dataverse data in Redash for querying, visualizing, and sharing.
-
Import Real-Time ConvertKit Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ConvertKit data in ColdFusion.
-
Query, Visualize, and Share live Bright Data Data in Redash
Use CData Connect AI to connect to live Bright Data data in Redash for querying, visualizing, and sharing.
-
Access Live API 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 API data through MCP integration.
-
Automated Continuous Unbounce Replication to MySQL
Use CData Sync for automated, continuous, customizable Unbounce replication to MySQL.
-
Visualize Live RabbitMQ Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live RabbitMQ data.
-
ETL Gumroad in Oracle Data Integrator
This article shows how to transfer Gumroad data into a data warehouse using Oracle Data Integrator.
-
Connect to and Query Intercom Data in QlikView over ODBC
Create data visualizations with Intercom data in QlikView.
-
Use Claude to Talk to Your Shippo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Shippo data for you.
-
Connect to PDFMonkey from a Connection Pool in WebLogic
Use the CData JDBC Driver for PDFMonkey to connect to PDFMonkey data from Web applications running on WebLogic.
-
Create Informatica Mappings From/To an ODBC Data Source for Discord
Create an ODBC connection to Discord in Informatica and browse and transfer Discord data.
-
Automated Continuous Mailjet Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Mailjet replication to PostgreSQL.
-
Integrate Office 365 Data in Pentaho Data Integration
Build ETL pipelines based on Office 365 data in the Pentaho Data Integration tool.
-
Connect to OneNote Data from HeidiSQL
Use CData Connect AI to connect to and query live OneNote data from HeidiSQL.
-
A PostgreSQL Interface for REST Data using the CData ODBC Driver
Use the SQL Gateway and REST ODBC Driver to create a PostgreSQL entry-point for data access.
-
Extract, Transform, and Load SAP BusinessObjects BI Data in Informatica PowerCenter
Create a simple Workflow for SAP BusinessObjects BI data in Informatica PowerCenter.
-
Build Semantic Layer Views for Zoho Projects Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Zoho Projects data.
-
Getting Started with the CData Python Connector for Avalara AvaTax
Learn to install and license the CData Python Connector and configure a connection to live Avalara AvaTax data.
-
Create SSAS Tabular Models from Dynamics CRM Data
How to build a SQL Server Analysis Service Tabular Model from Dynamics CRM data using CData drivers.
-
How to Connect Sage 300 Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Sage 300 data in real time using natural language.
-
Create Avro-Connected Applications in Appsmith
Connect to Avro Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Avro data.
-
Automated Continuous Beeminder Replication to Databricks
Use CData Sync for automated, continuous, customizable Beeminder replication to Databricks.
-
Access Live PingOne Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to PingOne data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create Data Visualizations in Cognos BI with QuickBooks Online Data
Access QuickBooks Online data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect Opsgenie to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Opsgenie with IBM WebSphere for seamless data integration and connectivity.
-
Operational Reporting on Azure Table Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Azure Table data.
-
How to Connect to Campaigner Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Campaigner data. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous CircleCI Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable CircleCI data replication to OneLake in Microsoft Fabric.
-
DataBind Charts to iContact Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to iContact data 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.
-
Automate Splunk Data Replication to Couchbase
Use CData Sync to Customize and automate Splunk data replication to Couchbase.
-
Access Live NetSuite SuiteAnalytics Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to NetSuite SuiteAnalytics data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Migrating data from Wistia to Snowflake using CData SSIS Components.
Easily push Wistia data to Snowflake using the CData SSIS Tasks for Wistia and Snowflake.
-
Migrating data from LinkedIn Ads to Snowflake using CData SSIS Components.
Easily push LinkedIn Ads data to Snowflake using the CData SSIS Tasks for LinkedIn Ads and Snowflake.
-
Natively Connect to Google Search Results in PHP
The CData ODBC driver for Google Search enables you to create PHP applications with connectivity to Google Search results. Leverage the native support for ODBC in PHP.
-
Connect to SAS xpt Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAS xpt data from Appeon PowerBuilder using the CData ADO.NET Provider for SAS xpt.
-
Create Data Visualizations in Cognos BI with Retently Data
Access Retently data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Dynamics 365 Data in Talend Cloud Data Management Platform
Connect Dynamics 365 Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Dynamics 365.
-
Integrate Trae with Live Toggl Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Toggl data from within the AI-powered IDE.
-
Query OpenWeatherMap Data in DataGrip
Create a Data Source for OpenWeatherMap in DataGrip and use SQL to query live OpenWeatherMap data.
-
Connect to LinkedIn Data in Claris FileMaker Pro
Use the CData ODBC Driver for LinkedIn in FileMaker Pro to connect to LinkedIn and work with LinkedIn data in your FileMaker applications.
-
Visualize Access Data in Tableau
The CData ODBC driver for Access enables you integrate Access data into Tableau dashboards.
-
Automate Mailgun Data Replication to Azure Synapse
Use CData Sync to customize and automate Mailgun data replication to Azure Synapse.
-
Analyze Odoo Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Odoo data and visualize live Odoo data in Infragistics Reveal.
-
Visualize Live PDFMonkey Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live PDFMonkey data.
-
Create Adobe Target Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Adobe Target from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Google Cloud Storage Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to Apache Cassandra.
-
Query Trello Data as a MySQL Database in Node.js
Execute MySQL queries against Trello data from Node.js.
-
Create OneNote-Connected Nintex Workflows
Use CData Connect AI to connect to OneNote Data from Nintex Workflow Cloud and build custom workflows using live OneNote data.
-
Integrate Basecamp Data in the Pentaho Report Designer
Publish reports based on Basecamp data in the Pentaho BI tool.
-
Create Tally-Connected Applications in Appsmith
Connect to Tally Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Tally data.
-
Build Automated Sendwithus-Connected Workflows in Zapier
Use CData Connect AI to connect to live Sendwithus data and build automated workflows in Zapier.
-
Manage Outreach.io Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Outreach.io.
-
ConstantContact Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ConstantContact facts in real time.
-
Build a Simple VCL Application for Telegram Data
How to build a simple VCL Application to view Telegram data in RAD Studio using the CData ODBC Driver for Telegram.
-
Import and Visualize LinkedIn Data in Power View
Create data visualizations based on LinkedIn data in Excel.
-
How to publish and share CircleCI Data dashboards with Tableau Server
The CData ODBC driver for CircleCI enables you integrate CircleCI data into Tableau dashboards.
-
Create Redshift-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Redshift Data from Klipfolio and build custom visualizations using live Redshift data.
-
How to Connect to & Open SparkPost Data in Microsoft Excel
This article uses the CData ODBC driver for SparkPost to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Dynamic Gorgias Grids Using the Infragistics XamDataGrid
Learn how you can connect Gorgias to Infragistics XamDataGrid to build dynamic grids.