CData Software - Knowledge Base
Recent Articles
-
Integrate Devin with Live Tavily 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 Tavily data.
-
Connect to Real-Time Zoho Books Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Zoho Books and Dataflow to import and use Zoho Books data in Power Apps.
-
Connect to Coinbase Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Coinbase and work with Coinbase data in your FileMaker application.
-
A PostgreSQL Interface for Teradata Data using the CData ODBC Driver
Use the SQL Gateway and Teradata ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Jira Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Jira data using standard SQL.
-
Build Data Flows from MySQL to SQL Server using SSIS
Easily back up MySQL data to SQL Server using the SSIS components for MySQL.
-
Use CData Connect AI to Access Sage 200 Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Sage 200 data in the Power Pivot business intelligence tool.
-
How to create an RPA flow for Wrike Data in UiPath Studio
Use the Wrike ODBC Driver to create workflows that access real-time Wrike data without any coding.
-
Back Up Acumatica data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Acumatica. In this article, we will employ an SSIS workflow to populate a database with Acumatica data data.
-
Replicate Mouseflow Data to Multiple Databases via the CData Sync CLI
Replicate Mouseflow data to disparate databases with a single configuration.
-
How to Connect to Live Oracle 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 Oracle data for you.
-
Connect to SAP Ariba Source Data in HULFT Integrate
Connect to SAP Ariba Source as a JDBC data source in HULFT Integrate
-
Access Live SharePoint Excel Services Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SharePoint Excel Services data into the statistical analysis tools available in SAS JMP. This article shows how to use SharePoint Excel Services data in the Graph Builder and Query Builder.
-
Connect to Real-Time Google Sheets Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Google Sheets and Dataflow to import and use Google Sheets data in Power Apps.
-
Connect to ZohoDesk Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live ZohoDesk data from Filemaker Pro on Mac.
-
Connect to Google Campaign Manager 360 from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Campaign Manager 360 to connect to Google Campaign Manager 360 data from Web applications running on WebLogic.
-
Use the CData Software ODBC Driver for Webflow in MicroStrategy Web
Connect to Webflow data in MicroStrategy Web using the CData Software ODBC Driver for Webflow.
-
Natively Connect to Pinecone Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Pinecone data. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for Everhour in MicroStrategy Web
Connect to Everhour data in MicroStrategy Web using the CData Software JDBC Driver for Everhour.
-
How to Build an ETL App for Todoist Data in Python with CData
Create ETL applications and real-time data pipelines for Todoist data in Python with petl.
-
Use the CData Software ODBC Driver for Redshift in MicroStrategy Desktop
Connect to Redshift data in MicroStrategy Desktop using the CData Software ODBC Driver for Redshift.
-
Natively Connect to Hacker News Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Hacker News data. Leverage the native support for ODBC in PHP.
-
Visualize Live SAP HANA XS Advanced Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP HANA XS Advanced data into custom reports in Power BI.
-
Connect to EnterpriseDB from Asprova with CData Software ODBC Driver for EnterpriseDB
This article shows how to connect faster to EnterpriseDB data from Asprova.
-
Connect to Microsoft Teams Data in DBArtisan
Use wizards in DBArtisan to configure Microsoft Teams data as a data source.
-
Integrating LlamaIndex with Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Confluence data in real time.
-
Automated Continuous Cloudflare Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Cloudflare replication to Google BigQuery.
-
How to Easily Set Up OAuth Authentication in Salesforce
A quick guide to setting up a Salesforce API app with OAuth 2.0 enabled.
-
How to Connect to & Open Vercel Data in Microsoft Excel
This article uses the CData ODBC driver for Vercel to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Humanity Replication to SQL Server
Use CData Sync for automated, continuous, customizable Humanity replication to SQL Server.
-
Build Charts with ZarMoney Data in Clear Analytics
Create dynamic charts and perform analytics based on ZarMoney data in Clear Analytics.
-
Automate Gumroad Data Replication to Couchbase
Use CData Sync to Customize and automate Gumroad data replication to Couchbase.
-
Build Salesforce Marketing Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Salesforce Marketing data and build visualizations in Tableau.
-
Access Live Access Data in Coginiti Pro
Connect to and query live Access data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create SSAS Tabular Models from Vercel Data
How to build a SQL Server Analysis Service Tabular Model from Vercel data using CData drivers.
-
Integrate Google's Antigravity Agent with Live ZohoInvoice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live ZohoInvoice data using the Model Context Protocol.
-
Add Cloudflare Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Cloudflare with the Informatica Enterprise Data Catalog to classify and organize data.
-
Link Twitter Ads with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Twitter Ads data in Filemaker Pro for Mac or Windows.
-
Build a Simple VCL Application for Google Translate Data
How to build a simple VCL Application to view Google Translate data in RAD Studio using the CData ODBC Driver for Google Translate.
-
Connect to Zoom Data in JRuby
Create a simple JRuby app with access to live Zoom data.
-
Connect to HDFS in SpagoBI
Create reports featuring live HDFS data in SpagoBI Studio. Host HDFS reports on SpagoBI Server.
-
Import MailChimp Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to MailChimp Data and provide access to live MailChimp data for custom reports in the Power BI Service.
-
How to Work with Power BI XMLA Data in AWS Glue Jobs Using JDBC
Connect to Power BI XMLA from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Query Calendly Data in ColdFusion
Write standard ColdFusion data access code to connect to Calendly data.
-
Use Azure AI Foundry to Talk to Your Odoo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Odoo data for you.
-
Getting Started with the CData SSIS Components for Mistral AI
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Mistral AI.
-
Integrate Google Drive with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Drive with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Drive data.
-
Use the CData Software JDBC Driver for Brex in MicroStrategy Web
Connect to Brex data in MicroStrategy Web using the CData Software JDBC Driver for Brex.
-
Bind Live Azure DevOps Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Azure DevOps data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect to Live Authorize.Net Data in MicroStrategy through CData Connect AI
Create a live connection to Authorize.Net Data in CData Connect AI and connect to your Authorize.Net data from MicroStrategy.
-
Connect to Outreach.io Data in Jaspersoft Studio
Execute SQL to remote Outreach.io data in Jaspersoft Studio.
-
Automated Continuous Opsgenie Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Opsgenie replication to IBM DB2.
-
Automated Continuous AfterShip Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable AfterShip data replication to OneLake in Microsoft Fabric.
-
Provide OData Services of Vimeo Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Vimeo data by developing a WCF Service Application.
-
How to integrate Google Campaign Manager 360 with Apache Airflow
Access and process Google Campaign Manager 360 data in Apache Airflow using the CData JDBC Driver.
-
Integrating GitHub Copilot with Redshift 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.
-
Import PayPal Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to PayPal Data and provide access to live PayPal data for custom reports in the Power BI Service.
-
Integrate Vault CRM Data in the Pentaho Report Designer
Publish reports based on Vault CRM data in the Pentaho BI tool.
-
Connect to Dynamics 365 Business Central Data from a Connection Pool in Jetty
The Dynamics 365 Business Central JDBC Driver supports connection pooling: This article shows how to connect faster to Dynamics 365 Business Central data from Web apps in Jetty.
-
Create Reports with Pushbullet Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pushbullet data.
-
Seamlessly Bring QuickBooks Time Data into Retool Using CData Connect AI
Integrate QuickBooks Time data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrating Dataiku with Typeform Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Typeform data.
-
Integrate with Presto Data in JReport Designer
Create charts and reports based on Presto data in JReport Designer.
-
Connect to Azure Table from a Connection Pool in WebLogic
Use the CData JDBC Driver for Azure Table to connect to Azure Table data from Web applications running on WebLogic.
-
Integrate MailerLite Data into Power Automate Desktop using CData Connect
CData Connect for MailerLite Data enables you to integrate MailerLite data into workflows built using Microsoft Power Automate Desktop.
-
Replicate Multiple Invoiced Accounts
Replicate multiple Invoiced accounts to one or many databases.
-
Access Live Twilio 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 Twilio data through MCP integration.
-
Deploy the ADO.NET Provider for LeadDesk on an SSRS Report Server
Connect to LeadDesk 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.
-
Access Live Dynamics 365 Business Central Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Dynamics 365 Business Central data into the statistical analysis tools available in SAS JMP. This article shows how to use Dynamics 365 Business Central data in the Graph Builder and Query Builder.
-
Use JayDeBeApi to access Sage Intacct Data in Python
Use standard Python scripting and the development environment of your choice to access live Sage Intacct data.
-
Automated Continuous SAP Concur Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP Concur replication to Snowflake.
-
Use ChatGPT to Talk to Your Power BI XMLA 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 Power BI XMLA data for you.
-
Integrating Kiro with AgileCRM 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.
-
A PostgreSQL Interface for Impala Data (MySQL Remoting via JDBC)
Use the Remoting features of the Impala JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Presto-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Presto data and build web apps with connectivity to live Presto data.
-
Automated Continuous CouchDB Replication to SQL Server
Use CData Sync for automated, continuous, customizable CouchDB replication to SQL Server.
-
Build Oracle Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Oracle data and build visualizations in Tableau Cloud.
-
Build Data Flows from Jira to SQL Server using SSIS
Easily back up Jira data to SQL Server using the SSIS components for Jira.
-
Access Live SAP BusinessObjects BI Data in Coginiti Pro
Connect to and query live SAP BusinessObjects BI data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Excel Spreadsheet Automation on Parallel Data with the QUERY Formula
Pull data from Parallel, automate spreadsheets, and more with the QUERY formula.
-
Connect to BambooHR Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for BambooHR Data and connect to BambooHR data in Akorbi Digital RunMyProcess.
-
Replicate Multiple Oracle Sales Accounts
Replicate multiple Oracle Sales accounts to one or many databases.
-
How to connect to Gumroad Data in DBVisualizer
Integrate Gumroad data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Semantic Layer Views for Nuclia Data in APOS Live Data Gateway
Use the CData Connector for Nuclia in APOS Live Data Gateway to build Semantic Layer Views for Nuclia data.
-
How to Connect to Live EnterpriseDB 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 EnterpriseDB data through natural language.
-
Integrate LibreChat with Live Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Slack data from within the chat interface.
-
Getting Started with the CData Connect AI Python SDK for Zoho Books
Install the CData Connect AI Python SDK to read live Zoho Books data with standard DB-API 2.0 Python code.
-
Integrate Goose with Live SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP Business One data from within the local AI agent.
-
How to connect to Google Tasks Data from Spring Boot
Connect to Google Tasks in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate with SFTP Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SFTP data in SnapLogic.
-
How to work with Close Data in Apache Spark using SQL
Access and process Close Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData SSIS Components for Sage 300
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Sage 300.
-
How to create Visio diagrams from ActiveCampaign Data
Automatically update ActiveCampaign data with the changes you make to Visio master shapes.
-
Visualize Suadeo Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Suadeo data into TIBCO Spotfire.
-
Build Voice Agents in ElevenLabs with access to Live Sybase IQ Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Sybase IQ data.
-
Integrate with ServiceNow Data in SnapLogic
Use CData Connect AI to connect to and integrate with live ServiceNow data in SnapLogic.
-
Automated Continuous Parallel Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Parallel replication to Azure SQL Database.
-
How to create an RPA flow for Xero Data in UiPath Studio
Use the Xero ODBC Driver to create workflows that access real-time Xero data without any coding.
-
Process & Analyze Close Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Close Data.
-
Use the CData ODBC Driver for Phoenix from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Phoenix to connect to Phoenix data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Phoenix data in Excel.