CData Software - Knowledge Base
Recent Articles
-
Automated Continuous SuiteCRM Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Azure SQL Database.
-
Build SingleStore-Connected Apps in Choreo
Use CData Connect AI to connect to SingleStore Data from Choreo and build custom apps using live SingleStore.
-
Create Dashboards and Visualize Live Epicor Kinetic Data in Geckoboard
Use CData Connect AI to connect to live Epicor Kinetic and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Publish NASA-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live NASA.
-
Automated Continuous Microsoft Ads Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to Apache Cassandra.
-
How to connect to Microsoft Exchange Data from Spring Boot
Connect to Microsoft Exchange in a Spring Boot Application using the CData JDBC Driver for Microsoft Exchange
-
Publish Avro-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Apache Avro.
-
Visualize Recurly Data in Sisense
Create an ElastiCube in Sisense app with access to Recurly.
-
Build Semantic Layer Views for JSON Services in APOS Live Data Gateway
Use the CData Connector for JSON in APOS Live Data Gateway to build Semantic Layer Views for JSON.
-
Integrating Kiro CLI with Instagram 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.
-
Bidirectional Access to ZohoExpense Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ZohoExpense in Filemaker Pro for Mac or Windows.
-
DataBind Controls to Teradata Data in Delphi
DataBind to Teradata in Delphi with standard data access components and controls.
-
Access Okta Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Okta from HeidiSQL.
-
How to create an RPA flow for Billsby Data in UiPath Studio
Use the Billsby ODBC Driver to create workflows that access real-time Billsby without any coding.
-
Process & Analyze Templated Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Templated Data.
-
Connect to and Query Zoho Projects Data in QlikView over ODBC
Create data visualizations with Zoho Projects in QlikView.
-
Edit and Search External Kintone Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Kintone to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Kintone Data objects that you can access from apps and the dashboard.
-
Build Amazon S3-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Amazon S3 Data and create custom apps in Mendix.
-
Integrating Kiro CLI with Superchat 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 Informatica Mappings From/To an ODBC Data Source for SQL Server
Create an ODBC connection to SQL Server in Informatica and browse and transfer Microsoft SQL Server.
-
How to connect PolyBase to Epicor Kinetic
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Epicor Kinetic.
-
Integrating Antigravity CLI with Nethunt via CData CLI
Connect Nethunt to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect Box to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Box using the CData Python MCP Server.
-
Excel Spreadsheet Automation on Scrapfly Data with the QUERY Formula
Pull data from Scrapfly, automate spreadsheets, and more with the QUERY formula.
-
Integrate with live Snapchat Ads Data in Jitterbit
Use CData Connect AI to connect to and integrate live Snapchat Ads in Jitterbit.
-
Integrating Cursor CLI with Apollo 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.
-
Using the CData Software ODBC Driver for Parquet in PyCharm
Connect to Parquet as an ODBC data source in PyCharm using the CData Software ODBC Driver for Parquet.
-
Replicate Adobe Target Data in Heroku for Use in Salesforce Connect
Replicate Adobe Target to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Excel Spreadsheet Automation on Teamgate Data with the QUERY Formula
Pull data from Teamgate, automate spreadsheets, and more with the QUERY formula.
-
Create Reports from FHIR Data in Looker Studio
Use CData Connect AI to gain access to live FHIR and create custom reports in Looker Studio.
-
Use the CData Software JDBC Driver for Vercel in MicroStrategy Web
Connect to Vercel in MicroStrategy Web using the CData Software JDBC Driver for Vercel.
-
Visualize Live Amazon Marketplace Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Amazon Marketplace using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData Power BI Connector for SharePoint
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SharePoint.
-
Integrate PhantomBuster with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PhantomBuster with External Services.
-
Getting Started with the CData Power BI Connector for Factorial
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Seamlessly Bring ADP Data into Retool Using CData Connect AI
Integrate ADP data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automate Active Directory Data Replication to Couchbase
Use CData Sync to Customize and automate Active Directory replication to Couchbase.
-
Use the CData Software ODBC Driver for Pipeline CRM in MicroStrategy Web
Connect to Pipeline CRM in MicroStrategy Web using the CData Software ODBC Driver for Pipeline CRM.
-
Connect Jira Assets Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Jira Assets using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Perigon Data in Pentaho Data Integration
Build ETL pipelines based on Perigon in the Pentaho Data Integration tool.
-
Getting Started with the CData Python Connector for Pushbullet
Learn to install and license the CData Python Connector
-
Connect to SAP HANA XS Advanced Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP HANA XS Advanced as an External Source in Dremio.
-
Analyze Azure DevOps Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Azure DevOps in Microsoft R Open.
-
Access Live Azure Analysis Services Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure Analysis Services from your Excel spreadsheets.
-
DataBind Charts to Coda Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Coda 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.
-
Visualize Pushbullet Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Pushbullet into TIBCO Spotfire.
-
Create Informatica Mappings From/To an ODBC Data Source for Dynamics 365 Business Central
Create an ODBC connection to Dynamics 365 Business Central in Informatica and browse and transfer Dynamics 365 Business Central.
-
Automated Continuous ADP Replication to Databricks
Use CData Sync for automated, continuous, customizable ADP replication to Databricks.
-
How to load ConvertAPI data into Elasticsearch via Logstash
Introducing a simple method to load ConvertAPI data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use Claude to Talk to Your Pipedrive 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 Pipedrive for you.
-
Visualize Adobe Analytics Data in Sisense
Create an ElastiCube in Sisense app with access to Adobe Analytics.
-
How to Create Power BI Visual Reports with Real-Time OneNote Data
Use CData Power BI Connectors to visualize Microsoft OneNote in Power BI.
-
Build a Simple VCL Application for Monday.com Data
How to build a simple VCL Application to view Monday.com in RAD Studio using the CData ODBC Driver for Monday.com.
-
Getting Started with the CData Python Connector for Postmark
Learn to install and license the CData Python Connector
-
Write a Simple Go Application to work with MailChimp Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to MailChimp.
-
Query NASA Data in ColdFusion
Write standard ColdFusion data access code to connect to NASA.
-
Create Reports with ClickUp Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ClickUp.
-
Create Slack-Connected Nintex Workflows
Use CData Connect AI to connect to Slack Data from Nintex Workflow Cloud and build custom workflows using live Slack.
-
Create Power BI Reports on Real-Time PayPal Data
Use the CData ODBC Driver for PayPal to visualize PayPal in Power BI Desktop.
-
Automated Continuous SendGrid Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SendGrid replication to Amazon S3.
-
Integrate Google Cloud Storage Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Cloud Storage and integrate live Google Cloud Storage into your Power Automate tasks.
-
Using the CData Software ODBC Driver for HBase in PyCharm
Connect to HBase as an ODBC data source in PyCharm using the CData Software ODBC Driver for HBase.
-
DataBind Controls to Pinecone Data in Delphi
DataBind to Pinecone in Delphi with standard data access components and controls.
-
Automate LionDesk Data Replication to SAP HANA
Use CData Sync to customize and automate LionDesk replication to SAP HANA.
-
Connect Ontraport to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Ontraport with IBM WebSphere for seamless data integration and connectivity.
-
How to Visualize LightSpeedRetail Data in Python with pandas
Use pandas and other modules to analyze and visualize live LightSpeedRetail in Python.
-
Use Microsoft Copilot Studio to talk to your LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your LinkedIn Ads for you.
-
Visualize Sendwithus Data in Tableau
The CData ODBC driver for Sendwithus enables you integrate Sendwithus into Tableau dashboards.
-
Use the CData Software ODBC Driver for Foursquare in MicroStrategy Desktop
Connect to Foursquare in MicroStrategy Desktop using the CData Software ODBC Driver for Foursquare.
-
Use the CData Software ODBC Driver for Pipedrive in MicroStrategy Web
Connect to Pipedrive in MicroStrategy Web using the CData Software ODBC Driver for Pipedrive.
-
Connect to NetSuite Data in CloverDX (formerly CloverETL)
Transfer NetSuite CRM & ERP using the visual workflow in the CloverDX data integration tool.
-
How to Visualize HCL Domino Data in Python with pandas
Use pandas and other modules to analyze and visualize live HCL Domino in Python.
-
Automate Avaza Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Avaza from PowerShell? This article demonstrates how to utilize the Avaza Cmdlets for tasks like connecting to Avaza, automating operations, downloading data, and more.
-
Create Reports from GitHub Data in Looker Studio
Use CData Connect AI to gain access to live GitHub and create custom reports in Looker Studio.
-
Automated Continuous Moosend Replication to MongoDB
Use CData Sync for automated, continuous, customizable Moosend replication to MongoDB.
-
Prepare, Blend, and Analyze Placid Data in Alteryx Designer (ODBC)
Build workflows to access live Placid for self-service data analytics.
-
Viewing Sybase IQ Data in RAD Studio Data Explorer
How to view Sybase IQ in RAD Studio Data Explorer using the CData ODBC Driver for Sybase IQ.
-
ETL Certinia in Oracle Data Integrator
This article shows how to transfer Certinia into a data warehouse using Oracle Data Integrator.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Jodoo
Provide connectivity to Jodoo through an SAP BusinessObjects universe.
-
Connecting Mastra with Freshdesk 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 Freshdesk, no replication required.
-
Integrating GitHub Copilot CLI with ZarMoney 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.
-
A PostgreSQL Interface for SurveyMonkey Data (MySQL Remoting via JDBC)
Use the Remoting features of the SurveyMonkey JDBC Driver to create a PostgreSQL entry-point for data access.
-
Stream SAP Data into Apache Kafka Topics
Access and stream SAP ERP/NetWeaver in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Avalara AvaTax Data in RapidMiner
Integrate Avalara AvaTax with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Informatica Mappings From/To a JDBC Data Source for Omnisend
Create Omnisend data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Mouseflow Data in AWS Lambda
Connect to live Mouseflow in AWS Lambda using the CData JDBC Driver.
-
Bridge Todoist Connectivity with Apache NiFi
Access and process Todoist in Apache NiFi using the CData JDBC Driver.
-
Publish Reports with Beeminder Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Beeminder.
-
DataBind Controls to QuickBooks Data in Delphi
DataBind to QuickBooks Desktop in Delphi with standard data access components and controls.
-
How to Create Power BI Visual Reports with Real-Time SAS xpt Data
Use CData Power BI Connectors to visualize SAS XPORT in Power BI.
-
Create Informatica Mappings From/To an ODBC Data Source for Oracle Financials Cloud
Create an ODBC connection to Oracle Financials Cloud in Informatica and browse and transfer Oracle Financials Cloud.
-
Feed MailChimp Data into FineReport
How to set MailChimp as a JDBC data source in FineReport.
-
Query MongoDB Data as a SQL Server Database in Node.js
Execute SQL Server queries against MongoDB from Node.js.
-
How to Easily Query Pushbullet Data in OpenOffice Base
Connect to Pushbullet data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Publish BambooHR-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live BambooHR.
-
Design BIRT Reports on Missive Data
Provide current Missive to your embedded analytics.
-
Integrate Cvent Data in the Pentaho Report Designer
Publish reports based on Cvent in the Pentaho BI tool.
-
Seamlessly Bring Microsoft Ads Data into Retool Using CData Connect AI
Integrate Microsoft Ads data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Semantic Layer Views for BambooHR Data in APOS Live Data Gateway
Use the CData Connector for BambooHR in APOS Live Data Gateway to build Semantic Layer Views for BambooHR.
-
Import and Visualize Cohere Data in Power View
Create data visualizations based on Cohere in Excel.