CData Software - Knowledge Base
Recent Articles
-
Connect to and Query Sage Intacct Data in QlikView over ODBC
Create data visualizations with Sage Intacct data in QlikView.
-
DataBind Klipfolio Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Klipfolio data to a chart.
-
Build Dashboards with Azure Synapse Data in DBxtra
Create dynamic dashboards and perform analytics based on Azure Synapse data in DBxtra.
-
Connect to Real-Time Reply.io Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Reply.io data in Power Apps.
-
Connect to Templated Data from PowerBuilder via JDBC
This article demonstrates how to access Templated data from PowerBuilder using the Templated JDBC Driver.
-
How to Connect to AdRoll Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to AdRoll data. Leverage the pyodbc module for ODBC in Python.
-
How to Connect to Deel Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Deel data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Sage Cloud Accounting Data from Crystal Reports
Use CData Connect AI to connect to and report on live Sage Cloud Accounting data from Crystal Reports.
-
Automated Continuous Gong Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Gong replication to Azure SQL Database.
-
Build Automated Workflows with Live HBase Data in Workato
Use CData Connect AI to connect to live HBase data and build automated workflows in Workato.
-
Create Zuora-Connected Applications in Appsmith
Connect to Zuora Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Zuora data.
-
Connect to ZohoInvoice Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ZohoInvoice to connect to ZohoInvoice data and execute queries in PowerBuilder.
-
How to Connect to Live Gong Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Gong data for you.
-
DataBind Controls to Greenhouse Data in C++Builder
DataBind to Greenhouse data in C++Builder with standard components and controls.
-
Build a Singer.io Tap for Spark With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Spark data using the CData Python Connector.
-
Object-Relational Mapping (ORM) with Chargebee Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Chargebee data into a Java-based ORM framework, Hibernate.
-
Connect to Short.io Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Short.io as an External Source in Dremio.
-
Replicate Multiple EnterpriseDB Accounts
Replicate multiple EnterpriseDB accounts to one or many databases.
-
Connect to Real-Time Sugar CRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Sugar CRM and Dataflow to import and use Sugar CRM data in Power Apps.
-
Getting Started with the CData ADO.NET Provider for Instagram
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Instagram.
-
Automate Paddle Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Paddle data from PowerShell? This article demonstrates how to utilize the Paddle Cmdlets for tasks like connecting to Paddle data, automating operations, downloading data, and more.
-
Connect to HDFS Data in Google Apps Script via Connect AI
Use CData Connect AI to access HDFS data in Google Apps Script.
-
Access Live JSON Services in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to JSON services from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to use SQLAlchemy ORM to access Front Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Front data.
-
Connect to Oracle Eloqua Reporting Data from PowerBuilder via JDBC
This article demonstrates how to access Oracle Eloqua Reporting data from PowerBuilder using the Oracle Eloqua Reporting JDBC Driver.
-
Replicate SAP Hybris C4C Data to Multiple Databases via the CData Sync CLI
Replicate SAP Hybris C4C data to disparate databases with a single configuration.
-
Create Dynamics 365-Connected Applications in Appsmith
Connect to Dynamics 365 Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Dynamics 365 data.
-
Link Calendly with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Calendly data in Filemaker Pro for Mac or Windows.
-
How to integrate GitLab with Apache Airflow
Access and process GitLab data in Apache Airflow using the CData JDBC Driver.
-
Query XML Data in DataGrip
Create a Data Source for XML in DataGrip and use SQL to query live XML data.
-
Automated Continuous Smartsheet Replication to MongoDB
Use CData Sync for automated, continuous, customizable Smartsheet replication to MongoDB.
-
Stream Flowlu Data into Apache Kafka Topics
Access and stream Flowlu data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Blackbaud FE NXT Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Blackbaud FE NXT data from Informatica Cloud.
-
How to Seamlessly Import MarkLogic Data into IBM SPSS Modeler
Integrate MarkLogic data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Edit and Search External Paylocity Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Paylocity data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Paylocity Data objects that you can access from apps and the dashboard.
-
Getting Started with the CData Python Connector for Drip
Learn to install and license the CData Python Connector and configure a connection to live Drip data.
-
A PostgreSQL Interface for Optimizely Data (MySQL Remoting via JDBC)
Use the Remoting features of the Optimizely JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Biml to Build SSIS Tasks to Replicate Zoho Recruit Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoho Recruit data to SQL Server.
-
Build Retently-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Retently data and build web apps with connectivity to live Retently data.
-
Use Claude to Talk to Your SQL Analysis Services 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 SQL Analysis Services data for you.
-
How to connect to Okta Data with Squirrel SQL client
Connect to Okta data and execute queries in the Squirrel SQL Client.
-
Build Data Flows from ChartMogul to SQL Server using SSIS
Easily back up ChartMogul data to SQL Server using the SSIS components for ChartMogul.
-
Create Data Visualizations Based On ZohoPeople Data in Mode
Use CData Connect AI to connect to ZohoPeople Data from Mode and build visualizations using live ZohoPeople data.
-
How to Connect DBeaver to Timely via a JDBC Driver
Manage Timely data with visual tools in DBeaver like the query browser.
-
Integrate with Foursquare Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Foursquare data to a JSON file on disk.
-
Use CData Connect AI to Access Oracle Financials Cloud Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Oracle Financials Cloud data in the Power Pivot business intelligence tool.
-
How to create ServiceDesk Plus federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ServiceDesk Plus data in MySQL .
-
Connect to Oracle Data from PowerBuilder via ADO.NET
This article demonstrates how to access Oracle data from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle.
-
How to Build an ETL App for Klaviyo Data in Python with CData Connect AI
Build ETL pipelines that read and write live Klaviyo data in Python with petl and the CData Connect AI Python SDK.
-
Use Dash to Build Web Apps on SAP SuccessFactors LMS Data via CData Connect AI
Build interactive Dash web apps on live SAP SuccessFactors LMS data using pandas and the CData Connect AI Python SDK.
-
Build Highrise-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Highrise data.
-
Create Data Visualizations in Cognos BI with Salesloft Data
Access Salesloft data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Replicate Multiple Tally Accounts
Replicate multiple Tally accounts to one or many databases.
-
Connect and Visualize Live GitHub Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live GitHub data into the Databricks platform and create visualization dashboards with real-time GitHub data.
-
Visualize Nuclia Data in TIBCO Spotfire through ADO.NET
Integrate Nuclia data into dashboards in TIBCO Spotfire.
-
Integrate with Nuclia Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Nuclia data to a JSON file on disk.
-
Connect to Instagram Data in HULFT Integrate
Connect to Instagram as a JDBC data source in HULFT Integrate
-
Integrating Cursor with Act-On 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.
-
Integrate SAP Ariba Procurement Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAP Ariba Procurement data and integrate live SAP Ariba Procurement data into your Power Automate tasks.
-
Extract, Transform, and Load Intercom Data in Informatica PowerCenter
Create a simple Workflow for Intercom data in Informatica PowerCenter.
-
How to Connect to Live Epicor Kinetic Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Epicor Kinetic data without replication.
-
Build a PostgreSQL Interface for Trello Data using the CData JDBC Driver
Use the Remoting features of the Trello JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Shortcut Replication to MongoDB
Use CData Sync for automated, continuous, customizable Shortcut replication to MongoDB.
-
Automated Continuous Smartsheet Replication to SQLite
Use CData Sync for automated, continuous, customizable Smartsheet replication to SQLite.
-
Use the CData Software JDBC Driver for LinkedIn Ads in MicroStrategy Web
Connect to LinkedIn Ads data in MicroStrategy Web using the CData Software JDBC Driver for LinkedIn Ads.
-
Process & Analyze Salesforce Data 360 Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Salesforce Data 360 Data.
-
Use JayDeBeApi to access ClickTime Data in Python
Use standard Python scripting and the development environment of your choice to access live ClickTime data.
-
Getting Started with the CData Connect AI Python SDK for Oracle Sales
Install the CData Connect AI Python SDK to read and write live Oracle Sales data with standard DB-API 2.0 Python code.
-
Build an OLAP Cube in SSAS from Cloudflare Data
Establish a connection to Cloudflare data data from SQL Server Analysis Services, and use the Cloudflare Data Provider to build OLAP cubes for use in analytics and reporting.
-
Getting Started with the CData Python Connector for RabbitMQ
Learn to install and license the CData Python Connector and configure a connection to live RabbitMQ data.
-
How to Connect the Power BI Service to Microsoft Planner: Complete Guide
Connect to the CData Software Power BI Connector for Microsoft Planner from PowerBI.com to provide real-time Microsoft Planner data across the organization.
-
Trigger Microsoft Teams IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Microsoft Teams with standard wizards in Logic Apps.
-
Connect to Invoiced Data in HULFT Integrate
Connect to Invoiced as a JDBC data source in HULFT Integrate
-
Query PostgreSQL Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume PostgreSQL entities in PHP by modeling them as objects.
-
Integrate Klipfolio Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Klipfolio data from Informatica Cloud.
-
Integrating GitHub Copilot with Miro 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.
-
Getting Started with the CData Excel Add-In for Planio
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Planio.
-
How to connect to Sage 300 Data in DBVisualizer
Integrate Sage 300 data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Teradata Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Teradata replication to Azure SQL Database.
-
Publish Notion-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Notion data.
-
Query, Visualize, and Share live SurveyMonkey Data in Redash
Use CData Connect AI to connect to live SurveyMonkey data in Redash for querying, visualizing, and sharing.
-
Connecting GenSpark with Amazon DynamoDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Amazon DynamoDB data without any replication or custom integration required.
-
Excel Spreadsheet Automation on Freshsales Data with the QUERY Formula
Pull data from Freshsales, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Office 365 Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Office 365 replication to delimited files (CSV/TSV).
-
A PostgreSQL Interface for Sybase IQ Data using the CData ODBC Driver
Use the SQL Gateway and Sybase IQ ODBC Driver to create a PostgreSQL entry-point for data access.
-
Work with Google Spanner Data in FoxPro
Load Google Spanner data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Bright Data-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Bright Data Data from OutSystems and build custom enterprise apps using live Bright Data data.
-
Query Live MongoDB 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 MongoDB data through a conversational interface.
-
Use the CData Software JDBC Driver for Amazon Athena in MicroStrategy Web
Connect to Amazon Athena data in MicroStrategy Web using the CData Software JDBC Driver for Amazon Athena.
-
Publish MailerLite-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live MailerLite data.
-
Cloudant Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Cloudant facts in real time.
-
Automated Continuous Power BI XMLA Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Google BigQuery.
-
Integrating GitHub Copilot with Hugging Face 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.
-
Back Up OData services to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for OData. In this article, we will employ an SSIS workflow to populate a database with OData services data.
-
Analyze Zoho Projects Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Zoho Projects data with the CData JDBC Driver for Zoho Projects.
-
Connect to CloudConvert Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for CloudConvert and the SQL Gateway to access CloudConvert data from Google Apps Script.
-
Use the CData Software ODBC Driver for Copper in SAS for Real-Time Reporting and Analytics
Connect to real-time Copper data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Copper.
-
How to import Azure Table Data into Apache Solr
Use the CData Software JDBC Driver for Azure Table in Data Import Handler and create an automated import of Azure Table data to Apache Solr Enterprise Search platform.
-
Build an OLAP Cube in SSAS from Demio Data
Establish a connection to Demio data data from SQL Server Analysis Services, and use the Demio Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to work with Teamwork Data in Apache Spark using SQL
Access and process Teamwork Data in Apache Spark using the CData Software JDBC Driver.