CData Software - Knowledge Base
Recent Articles
-
Use Dash to Build to Web Apps on Snapchat Ads Data
Create Python applications that use pandas and Dash to build Snapchat Ads-connected web apps.
-
Query Live PingOne 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 PingOne data directly from the development environment.
-
Seamlessly Bring Splunk Data into Retool Using CData Connect AI
Integrate Splunk data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to and Visualize Live PingOne Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live PingOne data.
-
Connect to Freshdesk Data in HULFT Integrate
Connect to Freshdesk as a JDBC data source in HULFT Integrate
-
Replicate ConvertAPI Data from PowerShell
Write a quick PowerShell script to query ConvertAPI data. Use connectivity to the live data to replicate ConvertAPI data to SQL Server.
-
Getting Started with the CData ODBC Driver for Sage Intacct
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Sage Intacct.
-
A PostgreSQL Interface for ScrapingBee Data (MySQL Remoting via JDBC)
Use the Remoting features of the ScrapingBee JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Odoo Data in Google Apps Script via Connect AI
Use CData Connect AI to access Odoo data in Google Apps Script.
-
Create Informatica Mappings From/To a JDBC Data Source for Spotify
Create Spotify data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Jodoo Data in DBArtisan
Use wizards in DBArtisan to configure Jodoo data as a data source.
-
Design BIRT Reports on Aircall Data
Provide current Aircall data to your embedded analytics.
-
Getting Started with the CData Excel Add-In for GraphQL
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for GraphQL.
-
Getting Started with the CData Power BI Connector for Google Contacts
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Contacts.
-
DataBind Charts to Mode Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Mode 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.
-
Build Jira Assets-Connected Apps in Choreo
Use CData Connect AI to connect to Jira Assets Data from Choreo and build custom apps using live Jira Assets data.
-
Query Live FTP Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live FTP data through a conversational interface.
-
Create Power BI Reports on Real-Time Parallel Data
Use the CData ODBC Driver for Parallel to visualize Parallel data in Power BI Desktop.
-
Query Google Search Results as a SQL Server Database in Node.js
Execute SQL Server queries against Google Search results from Node.js.
-
Create a Data Access Object for Kintone Data using JDBI
A brief overview of creating a SQL Object API for Kintone data in JDBI.
-
Create Datasets from Raisers Edge NXT in Domo Workbench and Build Visualizations of Raisers Edge NXT Data in Domo
Use the CData Software ODBC Driver for Raisers Edge NXT to create datasets from Raisers Edge NXT data in Domo Workbench and then build visualizations in the Domo service.
-
Create Perigon Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Perigon from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Figshare Data in TIBCO Spotfire through ADO.NET
Integrate Figshare data into dashboards in TIBCO Spotfire.
-
Integrating Claude Code CLI with JSON Services 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.
-
Automate Freshdesk Data Replication to Couchbase
Use CData Sync to Customize and automate Freshdesk data replication to Couchbase.
-
Integrating Claude Code CLI with SQL Analysis Services 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 GitLab Data from PowerBuilder via ADO.NET
This article demonstrates how to access GitLab data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrating Antigravity CLI with Chargebee data via CData CLI
Connect Chargebee data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to use SQLAlchemy ORM to access Insightly Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Insightly data.
-
Consume Oracle Eloqua Reporting OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Oracle Eloqua Reporting feeds that reflect any changes in SAP Lumira.
-
Access RabbitMQ Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for RabbitMQ data.
-
Analyze Jira Assets Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Jira Assets data and visualize Jira Assets data in SAP Analytics Cloud.
-
Automated Continuous Vercel Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Vercel replication to Google BigQuery.
-
Access Live Phoenix Data in Coginiti Pro
Connect to and query live Phoenix data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create ADP-Connected Nintex Workflows
Use CData Connect AI to connect to ADP Data from Nintex Workflow Cloud and build custom workflows using live ADP data.
-
Import and Visualize SuiteCRM Data in Power View
Create data visualizations based on SuiteCRM data in Excel.
-
Process & Analyze Aha! Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Aha! Data.
-
Build Semantic Layer Views for LinkedIn Ads Data in APOS Live Data Gateway
Use the CData Connector for LinkedIn Ads in APOS Live Data Gateway to build Semantic Layer Views for LinkedIn Ads data.
-
Use the CData SSIS Components to Insert New or Update Existing Amazon Athena Records from SQL Server
Easily push SQL Server data to Amazon Athena using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Amazon Athena or update existing records with data from a SQL Server database.
-
Access CSV Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live CSV data from HeidiSQL.
-
Connect to Apollo in SpagoBI
Create reports featuring live Apollo data in SpagoBI Studio. Host Apollo reports on SpagoBI Server.
-
Use Dash to Build to Web Apps on Apify Data
Create Python applications that use pandas and Dash to build Apify-connected web apps.
-
Getting Started with the CData Connect AI Python SDK for Azure Data Catalog
Install the CData Connect AI Python SDK to read live Azure Data Catalog data with standard DB-API 2.0 Python code.
-
Query Clari Data as a MySQL Database in Node.js
Execute MySQL queries against Clari data from Node.js.
-
Easily Integrate BigCommerce Data in Lazarus Pascal IDE
Learn how to easily integrate live BigCommerce data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to HubDB Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for HubDB and the Script function in FileMaker Pro to connect to HubDB and work with HubDB data in your FileMaker application.
-
Visualize Live CloudConvert Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live CloudConvert data.
-
Work with SAS Data Sets Data in FoxPro
Load SAS Data Sets data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData JDBC Driver for Pipedrive
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Pipedrive.
-
Build CockroachDB Visualizations in Tableau Desktop
Use CData Connect AI to connect to live CockroachDB data and build visualizations in Tableau.
-
Connect to Workday Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Workday and the Script function in FileMaker Pro to connect to Workday and work with Workday data in your FileMaker application.
-
Link Aweber with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Aweber data in Filemaker Pro for Mac or Windows.
-
Connect to GraphQL Data as an External Source in Dremio
Use the CData JDBC Driver to connect to GraphQL as an External Source in Dremio.
-
Query Pingdom Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Pingdom data from Node.js.
-
Automated Continuous Parquet Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Parquet replication to Amazon S3.
-
Integrating Antigravity CLI with Freshteam data via CData CLI
Connect Freshteam data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Replicate Azure Synapse Data in Heroku for Use in Salesforce Connect
Replicate Azure Synapse data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Datasets from Suadeo in Domo Workbench and Build Visualizations of Suadeo Data in Domo
Use the CData Software ODBC Driver for Suadeo to create datasets from Suadeo data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Trello Replication to Snowflake
Use CData Sync for automated, continuous, customizable Trello replication to Snowflake.
-
Automated Continuous ZohoExpense Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Amazon Redshift.
-
Miro Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Miro facts in real time.
-
Building Dynamic Web Pages with WordPress Data Using AngularJS
Create single-page applications with live connectivity to WordPress using the CData API Server.
-
Automated Continuous Oracle Eloqua Replication to SQL Server
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to SQL Server.
-
How to import Sendwithus Data into Apache Solr
Use the CData Software JDBC Driver for Sendwithus in Data Import Handler and create an automated import of Sendwithus data to Apache Solr Enterprise Search platform.
-
How to create an RPA flow for Cloudflare Data in UiPath Studio
Use the Cloudflare ODBC Driver to create workflows that access real-time Cloudflare data without any coding.
-
Connect to SAP Concur Data in DBArtisan
Use wizards in DBArtisan to configure SAP Concur data as a data source.
-
Access Live Azure DevOps Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Azure DevOps data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate SharePoint Data into Power Automate Desktop using CData Connect
CData Connect for SharePoint Data enables you to integrate SharePoint data into workflows built using Microsoft Power Automate Desktop.
-
How to publish and share OData Services dashboards with Tableau Server
The CData ODBC driver for OData enables you integrate OData services into Tableau dashboards.
-
Integrating Claude Code CLI with Pipedrive 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.
-
Integrating Gumloop with Coda Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Coda data within automated workflows.
-
Build Dashboards with Reply.io Data in DBxtra
Create dynamic dashboards and perform analytics based on Reply.io data in DBxtra.
-
Getting Started with the CData SSIS Components for Amplitude
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Amplitude.
-
Import and Visualize Tavily Data in Power View
Create data visualizations based on Tavily data in Excel.
-
Trigger Microsoft Exchange IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Microsoft Exchange with standard wizards in Logic Apps.
-
Prepare, Blend, and Analyze Sendwithus Data in Alteryx Designer (Connect AI)
Build workflows to access live Sendwithus data for self-service data analytics.
-
Connect to and Visualize Live ZarMoney Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ZarMoney data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Amplitude
Provide connectivity to Amplitude data through an SAP BusinessObjects universe.
-
Integrate Google Translate Data in the Pentaho Report Designer
Publish reports based on Google Translate data in the Pentaho BI tool.
-
Access Live CloudConvert Data in Coginiti Pro
Connect to and query live CloudConvert data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Phoenix-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Phoenix Data from Klipfolio and build custom visualizations using live Phoenix data.
-
Automated Continuous Gorgias Replication to MongoDB
Use CData Sync for automated, continuous, customizable Gorgias replication to MongoDB.
-
Prepare, Blend, and Analyze SAP Business Warehouse Data in Alteryx Designer (ODBC)
Build workflows to access live SAP Business Warehouse data for self-service data analytics.
-
Use the CData Software JDBC Driver for SparkPost in MicroStrategy Desktop
Connect to SparkPost data in MicroStrategy Desktop using the CData Software JDBC Driver for SparkPost.
-
Automated Continuous MailChimp Replication to Snowflake
Use CData Sync for automated, continuous, customizable MailChimp replication to Snowflake.
-
Use the CData ODBC Driver for Nethunt from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Nethunt to connect to Nethunt data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Nethunt data in Excel.
-
Teradata Reporting in OBIEE with the Teradata JDBC Driver
Deploy the Teradata JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build MVC Applications with Connectivity to Missive Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Missive from an ASP.NET MVC application.
-
Build CockroachDB-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for CockroachDB Data and create custom apps in Mendix.
-
Integrate Instagram Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Instagram data from Informatica Cloud.
-
How to connect Amazon QuickSight to Exact Online Data
Create a connection to Exact Online data in CData Connect AI and insert Exact Online data into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrating LlamaIndex with Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Lakebase data in real time.
-
Automated Continuous Scrapfly Replication to Databricks
Use CData Sync for automated, continuous, customizable Scrapfly replication to Databricks.
-
Rapidly Develop Ontraport-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 Ontraport.
-
Stream Amazon S3 Data into Apache Kafka Topics
Access and stream Amazon S3 data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Freshdesk Data in the Pentaho Report Designer
Publish reports based on Freshdesk data in the Pentaho BI tool.
-
Automated Continuous Intercom Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Intercom replication to PostgreSQL.
-
Use the CData ODBC Driver for WooCommerce from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for WooCommerce to connect to WooCommerce data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring WooCommerce data in Excel.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Email
Provide connectivity to Email data through an SAP BusinessObjects universe.
-
How to Connect ZohoExpense 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 ZohoExpense data in real time using natural language.