CData Software - Knowledge Base
Recent Articles
-
Connect to Live Sage Intacct Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Sage Intacct in CData Connect AI and connect to your Sage Intacct data from PostgreSQL.
-
Integrate Theia IDE with Live Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Avalara AvaTax data from within the development environment.
-
Connect to Freshservice Data in DBArtisan
Use wizards in DBArtisan to configure Freshservice data as a data source.
-
How to Create Power BI Visual Reports with Real-Time SAP HANA XS Advanced Data
Use CData Power BI Connectors to visualize SAP HANA XS Advanced data in Power BI.
-
Connect to AgileCRM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for AgileCRM and the SQL Gateway to access AgileCRM data from Google Apps Script.
-
Build a Simple VCL Application for Azure Data Catalog Data
How to build a simple VCL Application to view Azure Data Catalog data in RAD Studio using the CData ODBC Driver for Azure Data Catalog.
-
Import Azure Table Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Azure Table Data and provide access to live Azure Table data for custom reports in the Power BI Service.
-
Integrate with Printify Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Printify data in SnapLogic.
-
Access Eventbrite Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Eventbrite data from your Oracle system.
-
Create Power BI Reports on Real-Time Zoho Creator Data
Use the CData ODBC Driver for Zoho Creator to visualize Zoho Creator data in Power BI Desktop.
-
Migrating data from Jodoo to Databricks using CData SSIS Components.
Easily push Jodoo data to Databricks using the CData SSIS Tasks for Jodoo and Databricks.
-
Automate Redis Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Redis data from PowerShell? This article demonstrates how to utilize the Redis Cmdlets for tasks like connecting to Redis data, automating operations, downloading data, and more.
-
Replicate Dynamics NAV Data from PowerShell
Write a quick PowerShell script to query Dynamics NAV data. Use connectivity to the live data to replicate Dynamics NAV data to SQL Server.
-
Model, Search, and Visualize Live Bannerbear Data in ThoughtSpot
Use CData Connect AI to connect to live Bannerbear data for modeling, searching, and visualizing.
-
How to Build an ETL App for Impala Data in Python with CData
Create ETL applications and real-time data pipelines for Impala data in Python with petl.
-
Connect to Live Sendwithus Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Sendwithus in CData Connect AI and connect to your Sendwithus data from PostgreSQL.
-
Getting Started with the CData JDBC Driver for Cloudflare
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Cloudflare.
-
Connect to SendGrid Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SendGrid data from Filemaker Pro on Mac.
-
Connect to Google Search from Asprova with CData Software ODBC Driver for Google Search
This article shows how to connect faster to Google Search data from Asprova.
-
Establish a Live Connection with Pinterest Data using Tableau Bridge
The CData ODBC Driver for Pinterest enables you to integrate live Pinterest data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Microsoft Dataverse Data from PowerBuilder via JDBC
This article demonstrates how to access Microsoft Dataverse data from PowerBuilder using the Microsoft Dataverse JDBC Driver.
-
Connect to Amazon Marketplace Data in Claris FileMaker Pro
Use the CData ODBC Driver for Amazon Marketplace in FileMaker Pro to connect to Amazon Marketplace and work with Amazon Marketplace data in your FileMaker applications.
-
How to connect to Apify Data from IntelliJ
Integrate connectivity to Apify data with wizards in IntelliJ.
-
Access Live QuickBooks Time Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live QuickBooks Time data through MCP integration.
-
A PostgreSQL Interface for Sendwithus Data (MySQL Remoting via JDBC)
Use the Remoting features of the Sendwithus JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live ShipEngine 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 ShipEngine data for you.
-
DataBind Cloudflare Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Cloudflare data to a chart.
-
Integrate LeadDesk with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate LeadDesk with External Services.
-
Use JayDeBeApi to access Vercel Data in Python
Use standard Python scripting and the development environment of your choice to access live Vercel data.
-
Use Agno to Talk to Your SFTP 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 SFTP data for you.
-
Natively Connect to Discourse Data in PHP
The CData ODBC driver for Discourse enables you to create PHP applications with connectivity to Discourse data. Leverage the native support for ODBC in PHP.
-
Connect to OData Services in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to OData.
-
Perform Batch Operations with ADP Data in Apache NiFi
Connect to ADP data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to load Outreach.io data into Elasticsearch via Logstash
Introducing a simple method to load Outreach.io data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to publish and share Landbot Data dashboards with Tableau Server
The CData ODBC driver for Landbot enables you integrate Landbot data into Tableau dashboards.
-
Create Kintone-Connected Dashboards in Grafana
Connect to Kintone Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Kintone data.
-
Enable the FormSite JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with FormSite data.
-
Build Semantic Layer Views for Workday Data in APOS Live Data Gateway
Use the CData Connector for Workday in APOS Live Data Gateway to build Semantic Layer Views for Workday data.
-
Provide OData Services of JotForm Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for JotForm data by developing a WCF Service Application.
-
How to work with Act-On Data in Apache Spark using SQL
Access and process Act-On Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Live Exa Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Exa data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automate Scrapfly Data Replication to Couchbase
Use CData Sync to Customize and automate Scrapfly data replication to Couchbase.
-
Build MarkLogic-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to MarkLogic data and build web apps with connectivity to live MarkLogic data.
-
Connect to Perigon Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Perigon as an External Source in Dremio.
-
Integrating LangChain with Gong Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Gong data within automated workflows.
-
How to create ADP federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ADP data in MySQL .
-
How to Create Power BI Visual Reports with Real-Time Sage 200 Data
Use CData Power BI Connectors to visualize Sage 200 data in Power BI.
-
Choosing the Best Method to Connect ZohoPeople to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZohoPeople data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Bright Data Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Bright Data Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Raisers Edge NXT Reporting in OBIEE with the Raisers Edge NXT JDBC Driver
Deploy the Raisers Edge NXT JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use ChatGPT to Talk to Your Testmonitor Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Testmonitor data for you.
-
Design BIRT Reports on Drip Data
Provide current Drip data to your embedded analytics.
-
Visualize Live ShipEngine Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ShipEngine data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Publish Reports with Wrike Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Wrike data.
-
Use the CData ODBC Driver for FreshBooks from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for FreshBooks to connect to FreshBooks data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring FreshBooks data in Excel.
-
Trigger SAP Concur IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SAP Concur with standard wizards in Logic Apps.
-
Build Dashboards with Hive Data in DBxtra
Create dynamic dashboards and perform analytics based on Hive data in DBxtra.
-
Analyze Dotmailer Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Dotmailer data with the CData JDBC Driver for Dotmailer.
-
Build FreshBooks-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live FreshBooks data without replication.
-
Build WooCommerce-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to WooCommerce data and build web apps with connectivity to live WooCommerce data.
-
Connect to Live DocuSign Data in MicroStrategy through CData Connect AI
Create a live connection to DocuSign Data in CData Connect AI and connect to your DocuSign data from MicroStrategy.
-
Integrate Google's Vertex AI Agent with Live Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Amazon Athena data within intelligent workflows.
-
Replicate QuickBooks Online Data to Multiple Databases via the CData Sync CLI
Replicate QuickBooks Online data to disparate databases with a single configuration.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Marketo
Provide connectivity to Marketo data through an SAP BusinessObjects universe.
-
Integrating Cursor with Exa 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 Testmonitor-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Testmonitor data without replication.
-
DataBind Controls to Templated Data in Delphi
DataBind to Templated data in Delphi with standard data access components and controls.
-
Use the CData ODBC Driver for Copper from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Copper to connect to Copper data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Copper data in Excel.
-
Connecting Pipedream with Azure Table 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 Azure Table data in real time.
-
Connect to Google Ad Manager Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Ad Manager data in Airbyte.
-
Use Manus AI to Talk to Your Impala 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 Impala data.
-
Analyze Adobe Commerce Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Adobe Commerce data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Feed Reply.io Data into FineReport
How to set Reply.io data as a JDBC data source in FineReport.
-
Getting Started with the CData ODBC Driver for Zoho Books
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Zoho Books.
-
Connecting Agentforce with Certinia 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 Certinia data for you.
-
Automated Continuous Monday.com Replication to SQL Server
Use CData Sync for automated, continuous, customizable Monday.com replication to SQL Server.
-
Connect to Salesforce Pardot Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Salesforce Pardot.
-
Automated Continuous Monday.com Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Monday.com replication to Amazon Redshift.
-
Integrate Facebook Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Facebook data from Informatica Cloud.
-
Access Live FTP Data in AWS Lambda (with IntelliJ IDEA)
Connect to live FTP data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate CSV Data in Pentaho Data Integration
Build ETL pipelines based on CSV data in the Pentaho Data Integration tool.
-
Natively Connect to Salesforce CRM Analytics Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Salesforce CRM Analytics data. Leverage the native support for ODBC in PHP.
-
Integrating Boomi Agentstudio with Zoho Inventory Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Zoho Inventory data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Import Real-Time xBase Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use xBase data in ColdFusion.
-
Create WooCommerce-Connected Business Apps in AppSheet
Connect to WooCommerce Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to WooCommerce data.
-
Visualize Excel Online Data in Tableau
The CData ODBC driver for Excel Online enables you integrate Excel Online data into Tableau dashboards.
-
Access Live Microsoft Teams Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Teams data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData ADO.NET Provider for Timely
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Connect Flowise AI Agents to Live SQL Analysis Services 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 SQL Analysis Services data without replication.
-
Back Up Wave Financial data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Wave Financial. In this article, we will employ an SSIS workflow to populate a database with Wave Financial data data.
-
Automate SharePoint Excel Services Data Replication to Azure Synapse
Use CData Sync to customize and automate SharePoint Excel Services data replication to Azure Synapse.
-
Migrating data from Act CRM to Snowflake using CData SSIS Components.
Easily push Act CRM data to Snowflake using the CData SSIS Tasks for Act CRM and Snowflake.
-
Automated Continuous Keap Replication to SingleStore
Use CData Sync for automated, continuous, customizable Keap replication to SingleStore.
-
Viewing CapsuleCRM Data in RAD Studio Data Explorer
How to view CapsuleCRM data in RAD Studio Data Explorer using the CData ODBC Driver for CapsuleCRM.
-
Access Live Oracle 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 Oracle data through MCP integration.
-
Automated Continuous Hacker News Replication to Databricks
Use CData Sync for automated, continuous, customizable Hacker News replication to Databricks.
-
Deploy the ADO.NET Provider for Reckon on an SSRS Report Server
Connect to Reckon data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Publish Reports with Email Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Email data.
-
Import QuickBooks Online Data Using Azure Data Factory
Use CData Connect AI to connect to QuickBooks Online Data from Azure Data Factory and import live QuickBooks Online data.
-
Connect ActiveCampaign to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ActiveCampaign data using the CData Python MCP Server.