CData Software - Knowledge Base
Recent Articles
-
Connect to Teradata Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Teradata Data and connect to Teradata data in Akorbi Digital RunMyProcess.
-
Create FHIR-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to FHIR Data from OutSystems and build custom enterprise apps using live FHIR data.
-
Replicate Multiple Printful Accounts via the CData Sync CLI
Replicate multiple Printful accounts to one or many databases.
-
Automated IBM Informix Data Replication to Teradata
Use CData Sync to Customize and automate IBM Informix data replication to Teradata.
-
Access Google Ads Data from MySQL in PHP
Connect to Google Ads through the standard MySQL libraries in PHP.
-
Create a Data Access Object for HCL Domino Data using JDBI
A brief overview of creating a SQL Object API for HCL Domino data in JDBI.
-
SQL Access to Redis Data
An article highlighting the available features and functionality of CData Software Drivers for Redis.
-
Connect to Jodoo Data in NetBeans
Connect to Jodoo data in NetBeans with the data source configuration wizard.
-
How to integrate Epicor Kinetic with Apache Airflow
Access and process Epicor Kinetic data in Apache Airflow using the CData JDBC Driver.
-
Getting Started with the CData JDBC Driver for DocuSign
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for DocuSign.
-
Create Power BI Reports on Real-Time Salesforce Marketing Data
Use the CData ODBC Driver for Salesforce Marketing to visualize Salesforce Marketing data in Power BI Desktop.
-
Automated Continuous Impala Replication to Oracle
Use CData Sync for automated, continuous, customizable Impala replication to Oracle.
-
Connect to Reckon Data from PowerBuilder via ADO.NET
This article demonstrates how to access Reckon data from Appeon PowerBuilder using the CData ADO.NET Provider for Reckon.
-
Create Informatica Mappings From/To a JDBC Data Source for Coda
Create Coda data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Apps with Live Avro Data Using the Low-Code Development Platform of Mendix
Connect Avro data with Mendix to build apps using the CData JDBC Driver for Avro.
-
Access Live Neo4J Data in Excel 365 Online (Excel for the web)
Connect to Neo4J data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Process & Analyze Active Directory Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Active Directory Data.
-
How to create Superchat federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Superchat data in MySQL .
-
Add YouTube Analytics Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for YouTube Analytics with the Informatica Enterprise Data Catalog to classify and organize data.
-
Bridge SAS xpt Connectivity with Apache NiFi
Access and process SAS xpt data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Airtable Replication to SingleStore
Use CData Sync for automated, continuous, customizable Airtable replication to SingleStore.
-
Visualize Google Contacts Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Contacts data.
-
Replicate NetSuite Data in Heroku for Use in Salesforce Connect
Replicate NetSuite data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Analyze Procore Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Procore data and visualize live Procore data in Infragistics Reveal.
-
Migrating data from Dynamics CRM to Databricks using CData SSIS Components.
Easily push Dynamics CRM data to Databricks using the CData SSIS Tasks for Dynamics CRM and Databricks.
-
Configure the CData JDBC Driver for Adobe Target in a Connection Pool in Tomcat
Connect to Adobe Target data from a connection pool in Tomcat.
-
How to Connect to Microsoft Exchange Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft Exchange data. Leverage the pyodbc module for ODBC in Python.
-
DataBind Charts to Coinbase Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Coinbase 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.
-
Query Qualaroo Data as a MySQL Database in Node.js
Execute MySQL queries against Qualaroo data from Node.js.
-
Use Microsoft Copilot Studio to talk to your Facebook 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 Facebook data for you.
-
Build Pipelines with Live Basecamp Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Basecamp from Google Cloud Data Fusion, enabling the integration of live Basecamp data into the building and management of effective data pipelines.
-
Load Adobe Analytics Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Adobe Analytics data to a database.
-
How to Connect to Act CRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Act CRM data. Leverage the pyodbc module for ODBC in Python.
-
Integrate with PingOne Data in JReport Designer
Create charts and reports based on PingOne data in JReport Designer.
-
How to Work with YouTube Analytics Data in ETL Validator JDBC
Connect to YouTube Analytics from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Dynamics 365 Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Azure SQL Database.
-
Connect to SAP Business Warehouse from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP Business Warehouse data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create Power BI Reports on Real-Time Yelp Data
Use the CData ODBC Driver for Yelp to visualize Yelp data in Power BI Desktop.
-
Replicate eBay Data from PowerShell
Write a quick PowerShell script to query eBay data. Use connectivity to the live data to replicate eBay data to SQL Server.
-
Natively Connect to Dynamics 365 Business Central Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Dynamics 365 Business Central data. Leverage the native support for ODBC in PHP.
-
How to connect and process Superchat data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Superchat data.
-
Use Biml to Build SSIS Tasks to Replicate DB2 Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate DB2 data to SQL Server.
-
Access ADP Data from MySQL in Amazon QuickSight
Connect to ADP and build visualizations of ADP data using a MySQL Connection in Amazon QuickSight.
-
Consume Confluence OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Confluence feeds that reflect any changes in SAP Lumira.
-
Create FTP Dataflows on PowerBI.com
Connect to the CData Power BI Connector for FTP from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Google Ad Manager Data in DBeaver
Use the CData ODBC Driver to connect to Google Ad Manager data in DBeaver.
-
How to Connect to Pipeliner CRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Pipeliner CRM data. Leverage the pyodbc module for ODBC in Python.
-
Analyze Salesforce Pardot Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Salesforce Pardot data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Data Visualizations in Cognos BI with Snapchat Ads Data
Access Snapchat Ads data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Analyze CouchDB Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze CouchDB data in Microsoft R Open.
-
Use Databricks Agent Bricks to Talk to Your PayPal Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your PayPal data for you.
-
Access Live iContact Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate iContact data into the statistical analysis tools available in SAS JMP. This article shows how to use iContact data in the Graph Builder and Query Builder.
-
Visualize Perplexity Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Perplexity data.
-
Connect to XML Data in RazorSQL
Connect to XML from wizards and query XML data from the GUI in the RazorSQL database management tool.
-
How to Query Live Retently Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Retently data data in natural language using Python.
-
Connect to and Query Slack Data in QlikView over ODBC
Create data visualizations with Slack data in QlikView.
-
Connect to SendPulse Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SendPulse data using standard SQL.
-
How to Access Live SAP Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP enables you to integrate SAP data into workflows built using Microsoft Power Automate Desktop.
-
Integrating Kiro with Certinia 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.
-
Replicate Multiple Spotify Accounts via the CData Sync CLI
Replicate multiple Spotify accounts to one or many databases.
-
Connect to RSS Feeds in ACL Analytics
Connect to RSS feeds via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to RSS feeds.
-
How to Work with AgileCRM Data in AWS Glue Jobs Using JDBC
Connect to AgileCRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Analyze Freshteam Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Freshteam data with the CData JDBC Driver for Freshteam.
-
How to Seamlessly Import Freshsales Data into IBM SPSS Modeler
Integrate Freshsales data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Replicate Wistia Data from PowerShell
Write a quick PowerShell script to query Wistia data. Use connectivity to the live data to replicate Wistia data to SQL Server.
-
Automated Continuous Paddle Replication to MongoDB
Use CData Sync for automated, continuous, customizable Paddle replication to MongoDB.
-
Prepare, Blend, and Analyze Jira Data in Alteryx Designer (Connect AI)
Build workflows to access live Jira data for self-service data analytics.
-
ETL Google Search in Oracle Data Integrator
This article shows how to transfer Google Search results into a data warehouse using Oracle Data Integrator.
-
How to connect to xBase Data with Squirrel SQL client
Connect to xBase data and execute queries in the Squirrel SQL Client.
-
Build Voice Agents in ElevenLabs with access to Live Adobe Target Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Adobe Target data.
-
Automated Continuous Tanda Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Tanda replication to Amazon Redshift.
-
Create Reports from Sage Cloud Accounting Data in Looker Studio
Use CData Connect AI to gain access to live Sage Cloud Accounting data and create custom reports in Looker Studio.
-
Integrating Missive Data in Talend Cloud Data Management Platform
Connect Missive Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Getting Started with the CData JDBC Driver for ShipEngine
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ShipEngine.
-
Use the CData Software JDBC Driver for Datadog in MicroStrategy Web
Connect to Datadog data in MicroStrategy Web using the CData Software JDBC Driver for Datadog.
-
Integrating Boomi Agentstudio with YouTube Analytics Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to YouTube Analytics data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Work with Cloudant Data in FoxPro
Load Cloudant data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Google Sheets Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Sheets data in Airbyte.
-
Import Real-Time QuickBooks Online Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use QuickBooks Online data in ColdFusion.
-
Creating Active Directory-Connected Applications in Unqork
You can use CData Connect AI to feed Active Directory data to Unqork and build custom business apps.
-
Use the CData Software ODBC Driver for GraphQL in MicroStrategy Web
Connect to GraphQL data in MicroStrategy Web using the CData Software ODBC Driver for GraphQL.
-
Build Apps with Live Reckon Data Using the Low-Code Development Platform of Mendix
Connect Reckon data with Mendix to build apps using the CData JDBC Driver for Reckon.
-
Work with SAP Business Warehouse Data in FoxPro
Load SAP Business Warehouse data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate with Vault CRM Data in JReport Designer
Create charts and reports based on Vault CRM data in JReport Designer.
-
Automated Continuous SAP Ariba Source Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to AlloyDB.
-
Automated Continuous SAP Hybris C4C Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to SingleStore.
-
Connect to Apify Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Apify and work with Apify data in your FileMaker applications.
-
Build SAP Business One Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP Business One data and build visualizations in Tableau.
-
ETL Google Campaign Manager 360 in Oracle Data Integrator
This article shows how to transfer Google Campaign Manager 360 data into a data warehouse using Oracle Data Integrator.
-
Integrate OpenCode with Live Xero Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Xero data from within your AI coding agent.
-
How to work with Jira Data in Apache Spark using SQL
Access and process Jira Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Cvent Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Cvent as an External Source in Dremio.
-
How to Create Power BI Visual Reports with Real-Time SAP Business One Data
Use CData Power BI Connectors to visualize SAP Business One data in Power BI.
-
How to Connect Flowise AI Agents to Live Oracle SCM 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 Oracle SCM data without replication.
-
Create Reports with ZeroBounce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZeroBounce data.
-
How to work with Reckon Accounts Hosted Data in Apache Spark using SQL
Access and process Reckon Accounts Hosted Data in Apache Spark using the CData Software JDBC Driver.
-
Process & Analyze ZarMoney Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ZarMoney Data.
-
How to integrate Metabase with Mailgun Data
Use CData Connect AI to connect to live Mailgun data and create an interactive dashboard in Metabase from Mailgun data.
-
How to Build an ETL App for ZohoDesk Data in Python with CData
Create ETL applications and real-time data pipelines for ZohoDesk data in Python with petl.
-
How to connect to Facebook Data from Spring Boot
Connect to Facebook in a Spring Boot Application using the CData JDBC Driver for Facebook