CData Software - Knowledge Base
Recent Articles
-
Integrating Cursor with OnePageCrm 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 Reckon Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Reckon and the SQL Gateway to access Reckon data from Google Apps Script.
-
Integrate Devin with Live Instagram Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Instagram data.
-
Use the CData ODBC Driver for Mailgun in Microsoft Power Query
You can use the CData Mailgun ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Mailgun data into Microsoft Power Query.
-
Migrating data from Front to Snowflake using CData SSIS Components.
Easily push Front data to Snowflake using the CData SSIS Tasks for Front and Snowflake.
-
Getting Started with the CData JDBC Driver for Ontraport
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Ontraport.
-
Build Certinia-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Certinia Data and create custom apps in Mendix.
-
SpaceX Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SpaceX facts in real time.
-
Integrating OpenCode with Moosend 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.
-
Build Apps with Live MarkLogic data in Adalo using CData Connect AI
Use CData Connect AI to integrate live MarkLogic data into the Adalo platform and build custom mobile and web applications with real-time MarkLogic data.
-
Getting Started with the CData ODBC Driver for JSON
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for JSON.
-
Automated Continuous SAP Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAP replication to MongoDB.
-
How to Access Live Qualaroo Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Qualaroo enables you to integrate Qualaroo data into workflows built using Microsoft Power Automate Desktop.
-
Validate Tickspot Data with QuerySurge
Access and validate Tickspot data in QuerySurge using the CData JDBC Driver.
-
Access Microsoft Exchange Data from MySQL in PHP
Connect to Microsoft Exchange through the standard MySQL libraries in PHP.
-
How to connect PolyBase to DocuSign
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live DocuSign data.
-
Automate Amazon S3 Data Replication to Azure Synapse
Use CData Sync to customize and automate Amazon S3 data replication to Azure Synapse.
-
Create Dynamic ChartMogul Grids Using the Infragistics XamDataGrid
Learn how you can connect ChartMogul to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Devin with Live HubSpot Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live HubSpot data.
-
How to Work with SAP Business One Data in AWS Glue Jobs Using JDBC
Connect to SAP Business One from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Load Perplexity Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Perplexity data to a database.
-
Build Lakebase-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Lakebase Data and create custom apps in Mendix.
-
Getting Started with the CData ADO.NET Provider for CockroachDB
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for CockroachDB.
-
Create Informatica Mappings From/To a JDBC Data Source for Cloudant
Create Cloudant data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query Live Active Directory 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 Active Directory data directly from the development environment.
-
Connect to Avaza Data in Aqua Data Studio
Access Avaza data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData SSIS Components for Shortcut
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Shortcut.
-
Use Manus AI to Talk to Your Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Microsoft Planner data.
-
Automated Continuous Jumpseller Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Jumpseller replication to AlloyDB.
-
Stream Jira Data into Apache Kafka Topics
Access and stream Jira data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect OnePageCrm Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your OnePageCrm data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrating Suadeo Data in Talend Cloud Data Management Platform
Connect Suadeo Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Suadeo.
-
Build Bitbucket-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Bitbucket data.
-
Automate Sugar CRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Sugar CRM data from PowerShell? This article demonstrates how to utilize the Sugar CRM Cmdlets for tasks like connecting to Sugar CRM data, automating operations, downloading data, and more.
-
Excel Spreadsheet Automation on HDFS Data with the QUERY Formula
Pull data from HDFS, automate spreadsheets, and more with the QUERY formula.
-
Build Semantic Layer Views for Google Ad Manager Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Ad Manager data.
-
Integrating Antigravity CLI with Placid data via CData CLI
Connect Placid data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Datasets from Google Translate in Domo Workbench and Build Visualizations of Google Translate Data in Domo
Use the CData Software ODBC Driver for Google Translate to create datasets from Google Translate data in Domo Workbench and then build visualizations in the Domo service.
-
How to Create Power BI Visual Reports with Real-Time Cassandra Data
Use CData Power BI Connectors to visualize Cassandra data in Power BI.
-
Create Data Visualizations in Cognos BI with Gorgias Data
Access Gorgias data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Rapidly Develop iContact-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 iContact.
-
Visualize LDAP Objects in Sisense
Create an ElastiCube in Sisense app with access to LDAP objects.
-
Natively Connect to Close Data in PHP
The CData ODBC driver for Close enables you to create PHP applications with connectivity to Close data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Marketo Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Marketo replication to Amazon Redshift.
-
Connect to Microsoft Planner Data from AWS Glue
Use CData Connect AI to gain access to live Microsoft Planner data from your AWS Glue jobs.
-
Connecting Agentforce with Adobe Target Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Adobe Target data for you.
-
Automated Continuous ConstantContact Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ConstantContact replication to Apache Cassandra.
-
Design BIRT Reports on JDBC-ODBC Bridge Data
Provide current JDBC-ODBC Bridge data to your embedded analytics.
-
Zoho Creator Reporting in OBIEE with the Zoho Creator JDBC Driver
Deploy the Zoho Creator JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use Claude to Talk to Your Azure Synapse 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 Azure Synapse data for you.
-
Build Apps with Live iContact Data Using the Low-Code Development Platform of Mendix
Connect iContact data with Mendix to build apps using the CData API Driver for JDBC.
-
Build Mailjet-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Mailjet Data and create custom apps in Bubble.
-
Use the CData Software ODBC Driver for Google Forms in MicroStrategy Web
Connect to Google Forms data in MicroStrategy Web using the CData Software ODBC Driver for Google Forms.
-
Automated Continuous Dotmailer Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Dotmailer data replication to OneLake in Microsoft Fabric.
-
Automated Continuous Insightly Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Insightly replication to Google BigQuery.
-
Integrating GitHub Copilot with SAP SuccessFactors 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 FormSite Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your FormSite data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect to & Open Google Spanner Data in Microsoft Excel
This article uses the CData ODBC driver for Google Spanner to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Nethunt Replication to Databricks
Use CData Sync for automated, continuous, customizable Nethunt replication to Databricks.
-
Replicate Vertica Data in Heroku for Use in Salesforce Connect
Replicate Vertica data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Informatica Mappings From/To an ODBC Data Source for Pingdom
Create an ODBC connection to Pingdom in Informatica and browse and transfer Pingdom data.
-
Provide OData Services of Zuora Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Zuora data by developing a WCF Service Application.
-
Access GraphQL Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access GraphQL data from your Oracle system.
-
Integrating Claude Code CLI with Freshdesk 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.
-
Connecting GenSpark with Databricks Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Databricks data without any replication or custom integration required.
-
Connect to Paylocity Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Paylocity and the Script function in FileMaker Pro to connect to Paylocity and work with Paylocity data in your FileMaker application.
-
How to Connect to Live Stripe 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 Stripe data without replication.
-
Query Beeminder Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Beeminder data from Node.js.
-
Connect to Blackbaud FE NXT Data in Aqua Data Studio
Access Blackbaud FE NXT data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Calendly Replication to SQLite
Use CData Sync for automated, continuous, customizable Calendly replication to SQLite.
-
Create a Data Access Object for DocuSign Data using JDBI
A brief overview of creating a SQL Object API for DocuSign data in JDBI.
-
How to connect and process Microsoft Teams data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Teams data.
-
Viewing Missive Data in RAD Studio Data Explorer
How to view Missive data in RAD Studio Data Explorer using the CData ODBC Driver for Missive.
-
Access Jodoo Data from MySQL in Amazon QuickSight
Connect to Jodoo and build visualizations of Jodoo data using a MySQL Connection in Amazon QuickSight.
-
How to Connect DBeaver to Close via a JDBC Driver
Manage Close data with visual tools in DBeaver like the query browser.
-
Connect to SAP SuccessFactors LMS Data from PowerBuilder via JDBC
This article demonstrates how to access SAP SuccessFactors LMS data from PowerBuilder using the SAP SuccessFactors LMS JDBC Driver.
-
Connecting Moonlit Workflow with Google Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Google Ads data in real time.
-
How to Build an ETL App for SAP Business Warehouse Data in Python with CData Connect AI
Extract and transform live SAP Business Warehouse data in Python with petl and the CData Connect AI Python SDK.
-
Access Live Jira Assets Data in AWS Lambda
Connect to live Jira Assets data in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Superchat in MicroStrategy Desktop
Connect to Superchat data in MicroStrategy Desktop using the CData Software JDBC Driver for Superchat.
-
Build Visualizations of ConvertAPI Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ConvertAPI data in Birst.
-
Integrating Kiro with Reckon Accounts Hosted 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.
-
Connecting Pipedream with Wave Financial 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 Wave Financial data in real time.
-
Automated Continuous Twitter Ads Replication to MongoDB
Use CData Sync for automated, continuous, customizable Twitter Ads replication to MongoDB.
-
How to connect to Monday.com Data with Squirrel SQL client
Connect to Monday.com data and execute queries in the Squirrel SQL Client.
-
Create Datasets from SAP Fieldglass in Domo Workbench and Build Visualizations of SAP Fieldglass Data in Domo
Use the CData Software ODBC Driver for SAP Fieldglass to create datasets from SAP Fieldglass data in Domo Workbench and then build visualizations in the Domo service.
-
Create Apps from SAP Fieldglass Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP Fieldglass Data and build apps from live SAP Fieldglass data in Qlik Sense Cloud.
-
Integrating Codex with Pingdom 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.
-
Automate Figshare Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Figshare data from PowerShell? This article demonstrates how to utilize the Figshare Cmdlets for tasks like connecting to Figshare data, automating operations, downloading data, and more.
-
Access Live Amazon Athena Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Amazon Athena data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Snowflake Reporting in OBIEE with the Snowflake JDBC Driver
Deploy the Snowflake JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Import and Visualize Microsoft Entra ID Data in Power View
Create data visualizations based on Microsoft Entra ID data in Excel.
-
Automated Continuous Calendly Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Calendly replication to Amazon S3.
-
Getting Started with the CData ODBC Driver for Spotify
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Spotify.
-
Import Real-Time Oracle HCM Cloud Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Oracle HCM Cloud data in ColdFusion.
-
Integrate Paylocity Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Paylocity data from Informatica Cloud.
-
Automate Active Directory Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Active Directory data from PowerShell? This article demonstrates how to utilize the Active Directory Cmdlets for tasks like connecting to Active Directory data, automating operations, downloading data, and more.
-
How to Connect to Live ZohoDesk Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live ZohoDesk data securely in real time.
-
Migrating data from HCL Domino to Google BigQuery using CData SSIS Components.
Easily push HCL Domino data to Google BigQuery using the CData SSIS Tasks for HCL Domino and Google BigQuery.
-
Automate Apollo Data Replication to Azure Synapse
Use CData Sync to customize and automate Apollo data replication to Azure Synapse.