CData Software - Knowledge Base
Recent Articles
-
Vault CRM Reporting in OBIEE with the Vault CRM JDBC Driver
Deploy the Vault CRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Dashboards with Google Spanner Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Spanner data in Dundas BI.
-
Connect AlloyDB Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your AlloyDB data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automate Greenplum Data Replication to Azure Synapse
Use CData Sync to customize and automate Greenplum data replication to Azure Synapse.
-
Access Oracle HCM Cloud 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 Oracle HCM Cloud data.
-
Access Aircall Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Aircall data from HeidiSQL.
-
Automated Continuous BenchmarkEmail Replication to Vertica
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to Vertica.
-
Build Cosmos DB Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Cosmos DB data and build visualizations in Tableau.
-
Using the CData Software ODBC Driver for Calendly in PyCharm
Connect to Calendly as an ODBC data source in PyCharm using the CData Software ODBC Driver for Calendly.
-
Building Dynamic Web Pages with Odoo Data Using AngularJS
Create single-page applications with live connectivity to Odoo using the CData API Server.
-
Getting Started with the CData Excel Add-In for Demio
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Demio.
-
Create ConstantContact Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ConstantContact from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData SSIS Components for Reckon
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Reckon.
-
Integrating Cursor with Azure Data Lake Storage 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.
-
Query Live Exact Online 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 Exact Online data directly from the development environment.
-
Connect to MailerLite Data in ACL Analytics
Connect to MailerLite data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to MailerLite data.
-
Getting Started with the CData Excel Add-In for PingOne
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for PingOne.
-
Visualize AdRoll Data in Sisense
Create an ElastiCube in Sisense app with access to AdRoll data.
-
Use the CData Software ODBC Driver for Sybase in MicroStrategy
Connect to Sybase data in MicroStrategy Developer using the CData Software ODBC Driver for Sybase.
-
Integrate Bitly with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Bitly with External Services.
-
Natively Connect to Reply.io Data in PHP
The CData ODBC driver for Reply.io enables you to create PHP applications with connectivity to Reply.io data. Leverage the native support for ODBC in PHP.
-
How to connect Amazon QuickSight to CSV Data
Create a connection to CSV data in CData Connect AI and insert CSV data into Amazon QuickSight SPICE to build interactive dashboards.
-
Use the CData Software ODBC Driver for PagerDuty in MicroStrategy Desktop
Connect to PagerDuty data in MicroStrategy Desktop using the CData Software ODBC Driver for PagerDuty.
-
Bidirectional Access to MailChimp Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate MailChimp data in Filemaker Pro for Mac or Windows.
-
Connect to Exa from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Exa data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrating LangGraph with FHIR Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on FHIR data within automated workflows.
-
Connect to SAP Concur Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Concur data from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Concur.
-
Analyze Lakebase Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Lakebase data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Blackbaud FE NXT-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Blackbaud FE NXT data and build web apps with connectivity to live Blackbaud FE NXT data.
-
Connect to Marketo Data in Claris FileMaker Pro
Use the CData ODBC Driver for Marketo in FileMaker Pro to connect to Marketo and work with Marketo data in your FileMaker applications.
-
Integrating Boomi Agentstudio with Acumatica Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Acumatica data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Asana Data from a Connection Pool in Jetty
The Asana JDBC Driver supports connection pooling: This article shows how to connect faster to Asana data from Web apps in Jetty.
-
LINQ to Sentry Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Sentry Data Provider.
-
How to connect to PayPal Data from IntelliJ
Integrate connectivity to PayPal data with wizards in IntelliJ.
-
Connect to Real-Time Drip Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Drip data in Power Apps.
-
Build Charts with Adobe Analytics Data in Clear Analytics
Create dynamic charts and perform analytics based on Adobe Analytics data in Clear Analytics.
-
Getting Started with the CData Connect AI Python SDK for Notion
Install the CData Connect AI Python SDK to read live Notion data with standard DB-API 2.0 Python code.
-
Import Notion Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Notion Data and provide access to live Notion data for custom reports in the Power BI Service.
-
Use Agno to Talk to Your Square 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 Square data for you.
-
Visualize Nuclia Data in Sisense
Create an ElastiCube in Sisense app with access to Nuclia data.
-
Build Automated Workflows with Live Oracle HCM Cloud Data in Workato
Use CData Connect AI to connect to live Oracle HCM Cloud data and build automated workflows in Workato.
-
Connect to Quickbase Data from AWS Glue
Use CData Connect AI to gain access to live Quickbase data from your AWS Glue jobs.
-
Query Live Asana 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 Asana data directly from the development environment.
-
Publish Reports with Clockify Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Clockify data.
-
DataBind Controls to Outreach.io Data in Delphi
DataBind to Outreach.io data in Delphi with standard data access components and controls.
-
How to Create Power BI Visual Reports with Real-Time ConvertAPI Data
Use CData Power BI Connectors to visualize ConvertAPI data in Power BI.
-
Connect to Zoho CRM Data from a Connection Pool in Jetty
The Zoho CRM JDBC Driver supports connection pooling: This article shows how to connect faster to Zoho CRM data from Web apps in Jetty.
-
Build AI/ML Models with Live Chargebee Data using Dataiku
Connect Chargebee Data with Dataiku using the CData API Driver for JDBC.
-
Use Claude to Talk to Your Zuora 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 Zuora data for you.
-
Automated Continuous Snapchat Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Amazon S3.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Productboard
Provide connectivity to Productboard data through an SAP BusinessObjects universe.
-
Create Reports from Teradata Data in Looker Studio
Use CData Connect AI to gain access to live Teradata data and create custom reports in Looker Studio.
-
Access Live Pipeline CRM Data in AWS Lambda
Connect to live Pipeline CRM data in AWS Lambda using the CData JDBC Driver.
-
Automate ZeroBounce Data Replication to Couchbase
Use CData Sync to Customize and automate ZeroBounce data replication to Couchbase.
-
Analyze Dynamics NAV Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Dynamics NAV data in Microsoft R Open.
-
Query Splunk Data as a MySQL Database in Node.js
Execute MySQL queries against Splunk data from Node.js.
-
Add ChargeOver Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ChargeOver with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build a PostgreSQL Interface for Pushbullet Data using the CData JDBC Driver
Use the Remoting features of the Pushbullet JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create TaxJar Dataflows on PowerBI.com
Connect to the CData Power BI Connector for TaxJar from PowerBI.com to create Power BI Dataflows with real-time data.
-
Provide OData Services of Autopilot Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Autopilot data by developing a WCF Service Application.
-
Connect to PagerDuty Data in DBArtisan
Use wizards in DBArtisan to configure PagerDuty data as a data source.
-
Access Active Directory Data from MySQL in PHP
Connect to Active Directory through the standard MySQL libraries in PHP.
-
Build Apps with Live Unbounce Data Using the Low-Code Development Platform of Mendix
Connect Unbounce data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Google Ads Data in Claris FileMaker Pro
Use the CData ODBC Driver for Google Ads in FileMaker Pro to connect to Google Ads and work with Google Ads data in your FileMaker applications.
-
Connect to Omnisend Data in DBArtisan
Use wizards in DBArtisan to configure Omnisend data as a data source.
-
Access CapsuleCRM Data from MySQL in PHP
Connect to CapsuleCRM through the standard MySQL libraries in PHP.
-
Access Live QuickBooks Time Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to QuickBooks Time data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to integrate Metabase with Acumatica Data
Use CData Connect AI to connect to live Acumatica data and create an interactive dashboard in Metabase from Acumatica data.
-
Operational Reporting on Bugsnag Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Bugsnag data.
-
Automated Continuous Couchbase Replication to SQL Server
Use CData Sync for automated, continuous, customizable Couchbase replication to SQL Server.
-
Import Real-Time Factorial Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Factorial data in ColdFusion.
-
Automated Continuous Recurly Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Recurly replication to Amazon S3.
-
How to Query SAP SuccessFactors LMS Data in MySQL Workbench
Execute MySQL queries against live SAP SuccessFactors LMS data from MySQL Workbench.
-
Connect to Auth0 Data from PowerBuilder via ADO.NET
This article demonstrates how to access Auth0 data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Real-Time Salesforce Marketing Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Salesforce Marketing and Dataflow to import and use Salesforce Marketing data in Power Apps.
-
Automated Continuous AfterShip Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable AfterShip replication to PostgreSQL.
-
Build MVC Applications with Connectivity to ZohoPeople Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ZohoPeople from an ASP.NET MVC application.
-
Replicate Facebook Ads Data to Multiple Databases via the CData Sync CLI
Replicate Facebook Ads data to disparate databases with a single configuration.
-
Query BigCommerce Data in DataGrip
Create a Data Source for BigCommerce in DataGrip and use SQL to query live BigCommerce data.
-
Automated Continuous Attio Replication to Snowflake
Use CData Sync for automated, continuous, customizable Attio replication to Snowflake.
-
Build Automated Workflows with Live Microsoft Teams Data in Workato
Use CData Connect AI to connect to live Microsoft Teams data and build automated workflows in Workato.
-
Connect to Tanda 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 Tanda and work with Tanda data in your FileMaker application.
-
Integrate Cvent Data into Power Automate Desktop using CData Connect
CData Connect for Cvent Data enables you to integrate Cvent data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Google's Antigravity Agent with Live PolarTeamPro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live PolarTeamPro data using the Model Context Protocol.
-
Import ConstantContact Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to ConstantContact Data and provide access to live ConstantContact data for custom reports in the Power BI Service.
-
Connect GitHub Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your GitHub data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access SendPulse 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 SendPulse data.
-
Build a Simple VCL Application for Microsoft Ads Data
How to build a simple VCL Application to view Microsoft Ads data in RAD Studio using the CData ODBC Driver for Microsoft Ads.
-
Publish Crystal Reports on FTP Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date FTP data.
-
Access Exact Online Data from MySQL in Amazon QuickSight
Connect to Exact Online and build visualizations of Exact Online data using a MySQL Connection in Amazon QuickSight.
-
Build PostgreSQL-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 PostgreSQL data without replication.
-
Connect to Apollo Data from Crystal Reports
Use CData Connect AI to connect to and report on live Apollo data from Crystal Reports.
-
Use Azure AI Foundry to Talk to Your Azure Data Lake Storage 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 Azure Data Lake Storage data for you.
-
Build Agents in Relevance AI with Access to Live GraphQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on GraphQL data within intelligent agent workflows.
-
Automate RSS Integration Tasks from PowerShell
Are you in search of a quick and easy way to access RSS feeds from PowerShell? This article demonstrates how to utilize the RSS Cmdlets for tasks like connecting to RSS feeds, automating operations, downloading data, and more.
-
Use the CData Software JDBC Driver for Smartsheet in MicroStrategy
Connect to Smartsheet data in MicroStrategy Developer using the CData Software JDBC Driver for Smartsheet.
-
Create Datasets from Beeminder in Domo Workbench and Build Visualizations of Beeminder Data in Domo
Use the CData Software ODBC Driver for Beeminder to create datasets from Beeminder data in Domo Workbench and then build visualizations in the Domo service.
-
Analyze Reckon Accounts Hosted Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Reckon Accounts Hosted data in Microsoft R Open.
-
Back Up Sybase IQ data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sybase IQ. In this article, we will employ an SSIS workflow to populate a database with Sybase IQ data data.
-
Build Semantic Layer Views for Teamwork Data in APOS Live Data Gateway
Use the CData Connector for Teamwork in APOS Live Data Gateway to build Semantic Layer Views for Teamwork data.