CData Software - Knowledge Base
Recent Articles
-
How to Connect to & Open Trello Data in Microsoft Excel
This article uses the CData ODBC driver for Trello to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Zoho Recruit Data from PowerBuilder via ADO.NET
This article demonstrates how to access Zoho Recruit data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Analyze PagerDuty Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for PagerDuty from Power Pivot. You will use the Table Import Wizard to load PagerDuty data. You can visually build the import query or use any SQL supported by the driver.
-
Automate ZarMoney Data Replication to Couchbase
Use CData Sync to Customize and automate ZarMoney data replication to Couchbase.
-
Integrate with Dynamics CRM Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Dynamics CRM data to a JSON file on disk.
-
Rapidly Develop Browserless-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 Browserless.
-
Migrating data from LaunchDarkly to Google BigQuery using CData SSIS Components.
Easily push LaunchDarkly data to Google BigQuery using the CData SSIS Tasks for LaunchDarkly and Google BigQuery.
-
How to Connect to Live Cloudant Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Cloudant data for you.
-
How to Seamlessly Import Contentful Data into IBM SPSS Modeler
Integrate Contentful data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create Dynamic Cloudflare Grids Using the Infragistics XamDataGrid
Learn how you can connect Cloudflare to Infragistics XamDataGrid to build dynamic grids.
-
Use Biml to Build SSIS Tasks to Replicate CampaignMonitor Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate CampaignMonitor data to SQL Server.
-
Build Pipelines with Live BambooHR Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to BambooHR from Google Cloud Data Fusion, enabling the integration of live BambooHR data into the building and management of effective data pipelines.
-
Create Informatica Mappings From/To an ODBC Data Source for Nethunt
Create an ODBC connection to Nethunt in Informatica and browse and transfer Nethunt data.
-
Query Blackbaud FE NXT Data as a SQL Server Database in Node.js
Execute SQL Server queries against Blackbaud FE NXT data from Node.js.
-
How to Connect to Live Bitbucket Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Bitbucket data for you.
-
Bridge Microsoft Teams Connectivity with Apache NiFi
Access and process Microsoft Teams data in Apache NiFi using the CData JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for XML
Create an ODBC connection to XML in Informatica and browse and transfer XML data.
-
How to Build an ETL App for PostgreSQL Data in Python with CData Connect AI
Build ETL pipelines that read and write live PostgreSQL data in Python with petl and the CData Connect AI Python SDK.
-
Integrate Live Impala Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Impala from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Impala data.
-
Access Oracle Sales Data from MySQL in PHP
Connect to Oracle Sales through the standard MySQL libraries in PHP.
-
ZohoDesk Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ZohoDesk facts in real time.
-
How to Connect to Live YouTube Analytics 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 YouTube Analytics data without replication.
-
Visualize Dynamics 365 Business Central Data in TIBCO Spotfire through ADO.NET
Integrate Dynamics 365 Business Central data into dashboards in TIBCO Spotfire.
-
Getting Started with the CData SSIS Components for Microsoft Teams
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Microsoft Teams.
-
How to Query Insightly Data in MySQL Workbench
Execute MySQL queries against live Insightly data from MySQL Workbench.
-
How to Access TaxJar Data Using Entity Framework
This article shows how to access TaxJar data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Informatica Mappings From/To an ODBC Data Source for Chargebee
Create an ODBC connection to Chargebee in Informatica and browse and transfer Chargebee data.
-
Use Agno to Talk to Your MailerLite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your MailerLite data for you.
-
A PostgreSQL Interface for Outlook Data (MySQL Remoting via JDBC)
Use the Remoting features of the Outlook JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Figshare Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Figshare data replication to OneLake in Microsoft Fabric.
-
Back Up Pinecone data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Pinecone data data.
-
Create a Data Access Object for SAP SuccessFactors Data using JDBI
A brief overview of creating a SQL Object API for SAP SuccessFactors data in JDBI.
-
Integrate Live Sendwithus Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Sendwithus data and integrate live Sendwithus data into apps built in Microsoft Power Apps.
-
Bidirectional Access to NetSuite Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate NetSuite data in Filemaker Pro for Mac or Windows.
-
Publish Crystal Reports on AgileCRM Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date AgileCRM data.
-
Use Agno to Talk to Your MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your MYOB AccountRight data for you.
-
Connect to Close Data in Aqua Data Studio
Access Close data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build AI/ML Models with Live Hugging Face Data using Dataiku
Connect Hugging Face Data with Dataiku using the CData API Driver for JDBC.
-
Access Live Zoho Projects Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoho Projects data from your Google Sheets.
-
Provide OData Services of Supabase Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Supabase data by developing a WCF Service Application.
-
Connecting Mastra with SparkPost 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 SparkPost data, no replication required.
-
Connect Adobe Experience Manager Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Adobe Experience Manager data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Analyze Datadog Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Datadog data with the CData JDBC Driver for Datadog.
-
How to Access Reply.io Data Using Entity Framework
This article shows how to access Reply.io data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to LightSpeedRetail Data in Ruby
Connect to LightSpeedRetail data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Sybase Replication to SQLite
Use CData Sync for automated, continuous, customizable Sybase replication to SQLite.
-
Link Suadeo with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Suadeo data in Filemaker Pro for Mac or Windows.
-
ETL Copper in Oracle Data Integrator
This article shows how to transfer Copper data into a data warehouse using Oracle Data Integrator.
-
Use the CData Software JDBC Driver for ClickUp in MicroStrategy
Connect to ClickUp data in MicroStrategy Developer using the CData Software JDBC Driver for ClickUp.
-
Query Postmark Data as a MySQL Database in Node.js
Execute MySQL queries against Postmark data from Node.js.
-
Establish a Live Connection with Phoenix Data using Tableau Bridge
The CData ODBC Driver for Phoenix enables you to integrate live Phoenix data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect to Live Instagram Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Instagram data for you.
-
Connect to Jumpseller Data in CloverDX (formerly CloverETL)
Transfer Jumpseller data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous ServiceNow Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ServiceNow replication to Amazon S3.
-
Consume EnterpriseDB OData Feeds in SAP Lumira
Use the API Server to create data visualizations on EnterpriseDB feeds that reflect any changes in SAP Lumira.
-
Access Live Jumpseller Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Jumpseller data through MCP integration.
-
Getting Started with the CData Power BI Connector for Office 365
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Office 365.
-
Analyze Mode Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Mode from Power Pivot. You will use the Table Import Wizard to load Mode data. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Live Adobe Experience Manager Data in the Power BI Service
Use CData Connect AI to connect to live Adobe Experience Manager data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Building Dynamic Web Pages with CSV Data Using AngularJS
Create single-page applications with live connectivity to CSV using the CData API Server.
-
Build a Simple VCL Application for Avro Data
How to build a simple VCL Application to view Avro data in RAD Studio using the CData ODBC Driver for Avro.
-
How to Access Live Sendwithus Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Sendwithus enables you to integrate Sendwithus data into workflows built using Microsoft Power Automate Desktop.
-
Build Semantic Layer Views for Act CRM Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Act CRM data.
-
Analyze HubSpot Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze HubSpot data with the CData JDBC Driver for HubSpot.
-
Connect to Postmark Data from PowerBuilder via JDBC
This article demonstrates how to access Postmark data from PowerBuilder using the Postmark JDBC Driver.
-
Connecting Pipedream with BigCommerce 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 BigCommerce data in real time.
-
Connect to ConvertKit Data from a Connection Pool in JBoss
Integrate ConvertKit data into Java servlets: Use the Management Console in JBoss to install the ConvertKit JDBC Driver.
-
Integrate Cline with Live SAP Fieldglass Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP Fieldglass data from within your IDE.
-
Connect to GraphQL from a Connection Pool in WebLogic
Use the CData JDBC Driver for GraphQL to connect to GraphQL data from Web applications running on WebLogic.
-
Automated Zoho Recruit Data Replication to Teradata
Use CData Sync to Customize and automate Zoho Recruit data replication to Teradata.
-
Connect to Twitter Ads Data from PowerBuilder via JDBC
This article demonstrates how to access Twitter Ads data from PowerBuilder using the Twitter Ads JDBC Driver.
-
Connecting Pipedream with Google Drive 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 Google Drive data in real time.
-
Integrating Gumloop with Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Splunk data within automated workflows.
-
Integrating Antigravity CLI with SageHR data via CData CLI
Connect SageHR data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Trello-Connected Business Apps in AppSheet
Connect to Trello Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Trello data.
-
Getting Started with the CData ADO.NET Provider for Greenplum
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Greenplum.
-
Use Databricks Agent Bricks to Talk to Your Shippo Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Shippo data for you.
-
Access Live Salesforce Data 360 Data in AWS Lambda
Connect to live Salesforce Data 360 data in AWS Lambda using the CData JDBC Driver.
-
DataBind Charts to CloudConvert Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to CloudConvert 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.
-
Automated Continuous NetSuite Replication to Snowflake
Use CData Sync for automated, continuous, customizable NetSuite replication to Snowflake.
-
Create Data Visualizations in Cognos BI with Vault CRM Data
Access Vault CRM data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automate Unbounce Data Replication to Couchbase
Use CData Sync to Customize and automate Unbounce data replication to Couchbase.
-
How to Use an External ID to Perform an UPSERT Operation against Salesforce
A basic overview of using External IDs to perform efficient UPSERT operations in Salesforce with the CData Salesforce Driver.
-
Build Asana-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Asana Data from Zoho Analytics and import live Asana data.
-
Seamlessly Bring Monday.com Data into Retool Using CData Connect AI
Integrate Monday.com data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrating Antigravity CLI with Okta data via CData CLI
Connect Okta data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Oracle Sales Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Oracle Sales data in Airbyte.
-
SAS xpt Reporting in OBIEE with the SAS xpt JDBC Driver
Deploy the SAS xpt JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
DataBind Controls to Strava Data in C++Builder
DataBind to Strava data in C++Builder with standard components and controls.
-
How to connect Amazon QuickSight to Google Sheets Data
Create a connection to Google Sheets data in CData Connect AI and insert Google Sheets data into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous ZohoExpense Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ZohoExpense replication to PostgreSQL.
-
Connect to Sage Intacct Data in JRuby
Create a simple JRuby app with access to live Sage Intacct data.
-
How to Query Live BambooHR Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live BambooHR data data in natural language using Python.
-
Automated Tickspot Data Replication to Teradata
Use CData Sync to Customize and automate Tickspot data replication to Teradata.
-
Create Dynamic Google Campaign Manager 360 Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Campaign Manager 360 to Infragistics XamDataGrid to build dynamic grids.
-
Connect to TigerGraph Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for TigerGraph data in the Denodo Virtual DataPort Administrator.
-
Connect to Oracle Eloqua Reporting Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Oracle Eloqua Reporting data using standard SQL.
-
Connect to Procore Data from Crystal Reports
Use CData Connect AI to connect to and report on live Procore data from Crystal Reports.
-
How to Connect to Perigon Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Perigon data. Leverage the pyodbc module for ODBC in Python.
-
Create Bitbucket-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Bitbucket Data from Klipfolio and build custom visualizations using live Bitbucket data.