CData Software - Knowledge Base
Recent Articles
-
How to use SQLAlchemy ORM to access CapsuleCRM Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of CapsuleCRM data.
-
Getting Started with the CData Tableau Connector for Bright Data
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build Google Calendar-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Calendar Data and create custom apps in Mendix.
-
Automated Continuous xBase Replication to AlloyDB
Use CData Sync for automated, continuous, customizable xBase replication to AlloyDB.
-
Replicate Google Directory Data from PowerShell
Write a quick PowerShell script to query Google Directory data. Use connectivity to the live data to replicate Google Directory data to SQL Server.
-
Visualize Dynamics 365 Business Central Data in TIBCO Spotfire through OData
Integrate Dynamics 365 Business Central data into dashboards in TIBCO Spotfire.
-
Connect to SendPulse Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SendPulse data.
-
Getting Started with the CData Python Connector for Parquet
Learn to install and license the CData Python Connector and configure a connection to live Parquet data.
-
A PostgreSQL Interface for Sybase Data (MySQL Remoting via JDBC)
Use the Remoting features of the Sybase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Parallel Data in HULFT Integrate
Connect to Parallel as a JDBC data source in HULFT Integrate
-
Pipedrive Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Pipedrive data through CData Connect AI using different applications and tools.
-
Connect to Microsoft OneDrive Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft OneDrive and the Script function in FileMaker Pro to connect to Microsoft OneDrive and work with Microsoft OneDrive data in your FileMaker application.
-
Access Printful 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 Printful data.
-
Troubleshooting Column Size Restrictions in Microsoft Query
Microsoft Query limits the total size of all columns selected. When all columns are selected, this may result in an error. The solution is to set the Maximum Column Size property.
-
How to Connect to & Open Onfleet Data in Microsoft Excel
This article uses the CData ODBC driver for Onfleet to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Connect Oracle Sales 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 Oracle Sales data in real time using natural language.
-
Build Visualizations of Cvent Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Cvent data in Birst.
-
Build Apps with Live Invoiced Data Using the Low-Code Development Platform of Mendix
Connect Invoiced data with Mendix to build apps using the CData API Driver for JDBC.
-
Create SSAS Tabular Models from SAP ByDesign Data
How to build a SQL Server Analysis Service Tabular Model from SAP ByDesign data using CData drivers.
-
Integrate LinkedIn Ads Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to LinkedIn Ads data and integrate live LinkedIn Ads data into your Power Automate tasks.
-
Analyze Freshdesk Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Freshdesk data and visualize Freshdesk data in SAP Analytics Cloud.
-
Integrate Goose with Live SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP Netweaver Gateway data from within the local AI agent.
-
How to Connect to Google Calendar Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Calendar data. Leverage the pyodbc module for ODBC in Python.
-
Connect to CockroachDB Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for CockroachDB Data and connect to CockroachDB data in Akorbi Digital RunMyProcess.
-
Use Dash to Build Web Apps on Odoo Data via CData Connect AI
Build interactive Dash web apps on live Odoo data using pandas and the CData Connect AI Python SDK.
-
Create SSAS Tabular Models from Highrise Data
How to build a SQL Server Analysis Service Tabular Model from Highrise data using CData drivers.
-
How to use SQLAlchemy ORM to access Azure DevOps Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure DevOps data.
-
How to connect PolyBase to FTP
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live FTP data.
-
Model, Search, and Visualize Live SurveyMonkey Data in ThoughtSpot
Use CData Connect AI to connect to live SurveyMonkey data for modeling, searching, and visualizing.
-
Connect to Salesforce Data 360 Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Salesforce Data 360 as an External Source in Dremio.
-
How to Build an ETL App for Avalara AvaTax Data in Python with CData
Create ETL applications and real-time data pipelines for Avalara AvaTax data in Python with petl.
-
How to import Bannerbear Data into Apache Solr
Use the CData Software JDBC Driver for Bannerbear in Data Import Handler and create an automated import of Bannerbear data to Apache Solr Enterprise Search platform.
-
Create AlloyDB-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to AlloyDB Data from OutSystems and build custom enterprise apps using live AlloyDB data.
-
Visualize Marketo Data in Tableau
The CData ODBC driver for Marketo enables you integrate Marketo data into Tableau dashboards.
-
Integrating LangGraph with Elasticsearch Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Elasticsearch data within automated workflows.
-
Automated Continuous Dynamics NAV Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Apache Cassandra.
-
Connect to LDAP Objects from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for LDAP to connect to LDAP objects and execute queries in PowerBuilder.
-
How to Query Microsoft Ads Data in MySQL Workbench
Execute MySQL queries against live Microsoft Ads data from MySQL Workbench.
-
Automated Continuous Google Analytics Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Analytics replication to MongoDB.
-
Connect to Real-Time Mistral AI Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Mistral AI data in Power Apps.
-
Create Power BI Reports on Real-Time ServiceNow Data
Use the CData ODBC Driver for ServiceNow to visualize ServiceNow data in Power BI Desktop.
-
How to Query LeadDesk Data in MySQL Workbench
Execute MySQL queries against live LeadDesk data from MySQL Workbench.
-
Create Cassandra Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Cassandra from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Apps with Live Testmonitor Data Using the Low-Code Development Platform of Mendix
Connect Testmonitor data with Mendix to build apps using the CData API Driver for JDBC.
-
Connecting Mastra with XML 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 XML data, no replication required.
-
Build AI Agents with Monday.com 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 Monday.com data through CData Connect AI.
-
Import and Visualize SAP ByDesign Data in Power View
Create data visualizations based on SAP ByDesign data in Excel.
-
Build Data Flows from xBase to SQL Server using SSIS
Easily back up xBase data to SQL Server using the SSIS components for xBase.
-
Connecting Pipedream with Mailgun Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Mailgun data in real time.
-
View Reports on Real-Time Microsoft OneDrive Data in Power BI Report Server
Use the CData ODBC Driver for Microsoft OneDrive to visualize Microsoft OneDrive data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Grok to Talk to Your Twilio 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 Twilio data for you.
-
How to Connect to Live ConstantContact Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your ConstantContact data through natural language.
-
Migrating data from Productboard to Snowflake using CData SSIS Components.
Easily push Productboard data to Snowflake using the CData SSIS Tasks for Productboard and Snowflake.
-
Replicate SAP ByDesign Data from PowerShell
Write a quick PowerShell script to query SAP ByDesign data. Use connectivity to the live data to replicate SAP ByDesign data to SQL Server.
-
Use Biml to Build SSIS Tasks to Replicate Parallel Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Parallel data to SQL Server.
-
Automated Continuous SurveyMonkey Replication to Databricks
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Databricks.
-
Automated Continuous Nethunt Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Nethunt replication to PostgreSQL.
-
Build AI/ML Models with Live Oracle Service Cloud Data using Dataiku
Connect Oracle Service Cloud Data with Dataiku using the CData JDBC Driver for Oracle Service Cloud.
-
Integrating OpenCode with Google Ads 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.
-
Analyze Placid Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Placid from Power Pivot. You will use the Table Import Wizard to load Placid data. You can visually build the import query or use any SQL supported by the driver.
-
Build Automated Jira Assets-Connected Workflows in Zapier
Use CData Connect AI to connect to live Jira Assets data and build automated workflows in Zapier.
-
Trigger Epicor Kinetic IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Epicor Kinetic with standard wizards in Logic Apps.
-
ETL Gmail in Oracle Data Integrator
This article shows how to transfer Gmail data into a data warehouse using Oracle Data Integrator.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for BigQuery
Provide connectivity to BigQuery data through an SAP BusinessObjects universe.
-
Build Charts with Google Forms Data in Clear Analytics
Create dynamic charts and perform analytics based on Google Forms data in Clear Analytics.
-
Create DB2-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to DB2 Data from OutSystems and build custom enterprise apps using live DB2 data.
-
Integrate with Live Oracle Sales Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Oracle Sales from the MuleSoft Anypoint Platform to integrate live Oracle Sales data into custom reports and dashboards.
-
Back Up Facebook Ads data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Facebook Ads. In this article, we will employ an SSIS workflow to populate a database with Facebook Ads data data.
-
Create Informatica Mappings From/To a JDBC Data Source for Airtable
Create Airtable data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Model Presto Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Presto, enabling the direct import of real-time Presto data.
-
Getting Started with the CData JDBC Driver for AgileCRM
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for AgileCRM.
-
Work with ZohoInvoice Data in FoxPro
Load ZohoInvoice data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Clari Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Clari replication to Google Cloud SQL.
-
Connect to Excel Data in RazorSQL
Connect to Excel from wizards and query Excel data from the GUI in the RazorSQL database management tool.
-
How to Connect DBeaver to REST via a JDBC Driver
Manage REST data with visual tools in DBeaver like the query browser.
-
Edit and Search External Dynamics 365 Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Dynamics 365 data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Dynamics 365 Data objects that you can access from apps and the dashboard.
-
How to Work with Dynamics 365 Data in AWS Glue Jobs Using JDBC
Connect to Dynamics 365 from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Semantic Layer Views for Cvent Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Cvent data.
-
Prepare, Blend, and Analyze Factorial Data in Alteryx Designer (ODBC)
Build workflows to access live Factorial data for self-service data analytics.
-
Build Automated Workflows with Live SAP HANA XS Advanced Data in Workato
Use CData Connect AI to connect to live SAP HANA XS Advanced data and build automated workflows in Workato.
-
Build Charts with Impala Data in Clear Analytics
Create dynamic charts and perform analytics based on Impala data in Clear Analytics.
-
Query Google Search Results using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Search entities in PHP by modeling them as objects.
-
Connect GraphQL to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live GraphQL data using the CData Python MCP Server.
-
Connect to Neo4J Data from PowerBuilder via JDBC
This article demonstrates how to access Neo4J data from PowerBuilder using the Neo4J JDBC Driver.
-
Automate Zuora Data Replication to Couchbase
Use CData Sync to Customize and automate Zuora data replication to Couchbase.
-
Use CData Connect AI to Access Snowflake Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Snowflake data in the Power Pivot business intelligence tool.
-
Visualize Live Salesforce Data 360 Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Salesforce Data 360 data.
-
How to load Deel data into Elasticsearch via Logstash
Introducing a simple method to load Deel data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to SAP Business Warehouse Data in ACL Analytics
Connect to SAP Business Warehouse data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP Business Warehouse data.
-
Build Dashboards with Reply.io Data in Dundas BI
Create dynamic dashboards and perform analytics based on Reply.io data in Dundas BI.
-
Connect to Wistia Data in DBeaver
Use the CData ODBC Driver to connect to Wistia data in DBeaver.
-
Front Reporting in OBIEE with the Front JDBC Driver
Deploy the Front JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automate Stripe Data Replication to Couchbase
Use CData Sync to Customize and automate Stripe data replication to Couchbase.
-
Natively Connect to Factorial Data in PHP
The CData ODBC driver for Factorial enables you to create PHP applications with connectivity to Factorial data. Leverage the native support for ODBC in PHP.
-
Connect Paddle to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Paddle data using the CData Python MCP Server.
-
Provide OData Services of Databricks Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Databricks data by developing a WCF Service Application.
-
Access Live VWO Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live VWO data from your Google Sheets.
-
Link ChartMogul with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ChartMogul data in Filemaker Pro for Mac or Windows.
-
Work with Live Avalara AvaTax Data in Power Query
Use CData Connect AI to connect to Avalara AvaTax data and work with live Avalara AvaTax data in Microsoft Power Query.
-
Create Data Visualizations Based On CouchDB Data in Mode
Use CData Connect AI to connect to CouchDB Data from Mode and build visualizations using live CouchDB data.