CData Software - Knowledge Base
Recent Articles
-
Publish Facebook-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Facebook.
-
Connect to Live Slack Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Slack in CData Connect AI and connect to your Slack from PostgreSQL.
-
Create Box Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Box from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Zendesk Data in NetBeans
Connect to Zendesk in NetBeans with the data source configuration wizard.
-
Connect to Square Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Square to connect to Square and execute queries in PowerBuilder.
-
How to Work with Spotify Data in ETL Validator JDBC
Connect to Spotify from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for SendPulse in MicroStrategy
Connect to SendPulse in MicroStrategy Developer using the CData Software ODBC Driver for SendPulse.
-
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 in Dundas BI.
-
Connect AlloyDB Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google AlloyDB 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 Pivotal GreenPlum 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.
-
Access Aircall Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Aircall 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 Azure Cosmos DB 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.
-
Build Sage 200-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Sage 200 to explore live Sage 200 Data in GitHub Copilot to assist with building Sage 200-powered applications.
-
Integrating Cursor CLI 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 directly from the development environment.
-
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.
-
Use the CData Software ODBC Driver for Sybase in MicroStrategy
Connect to Sybase 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. Leverage the native support for ODBC in PHP.
-
How to connect Amazon QuickSight to CSV Data
Create a connection to CSV/TSV Files in CData Connect AI and insert CSV/TSV Files into Amazon QuickSight SPICE to build interactive dashboards.
-
Use the CData Software ODBC Driver for PagerDuty in MicroStrategy Desktop
Connect to PagerDuty 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 in Filemaker Pro for Mac or Windows.
-
Integrating LangGraph with FHIR Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on FHIR within automated workflows.
-
Connect to SAP Concur Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Concur 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 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 and build web apps with connectivity to live Blackbaud FE NXT.
-
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 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 ERP, 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 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 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 in Power Apps.
-
Build Charts with Adobe Analytics Data in Clear Analytics
Create dynamic charts and perform analytics based on Adobe Analytics in Clear Analytics.
-
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 for you.
-
Visualize Nuclia Data in Sisense
Create an ElastiCube in Sisense app with access to Nuclia.
-
Build Automated Workflows with Live Oracle HCM Cloud Data in Workato
Use CData Connect AI to connect to live Oracle HCM Cloud and build automated workflows in Workato.
-
Connect to Quickbase Data from AWS Glue
Use CData Connect AI to gain access to live Quickbase 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 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.
-
DataBind Controls to Outreach.io Data in Delphi
DataBind to Outreach.io 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 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 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 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 through an SAP BusinessObjects universe.
-
Access Live Pipeline CRM Data in AWS Lambda
Connect to live Pipeline CRM in AWS Lambda using the CData JDBC Driver.
-
Analyze Dynamics NAV Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft Dynamics NAV in Microsoft R Open.
-
Query Splunk Data as a MySQL Database in Node.js
Execute MySQL queries against Splunk 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 by developing a WCF Service Application.
-
Connect to PagerDuty Data in DBArtisan
Use wizards in DBArtisan to configure PagerDuty 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 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 in your FileMaker applications.
-
Connect to Omnisend Data in DBArtisan
Use wizards in DBArtisan to configure Omnisend 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 from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Extend Google Sheets with Stripe Data
Make calls to Stripe from Google Apps Script via the API Server.
-
How to integrate Metabase with Acumatica Data
Use CData Connect AI to connect to live Acumatica ERP and create an interactive dashboard in Metabase from Acumatica ERP.
-
Operational Reporting on Bugsnag Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Bugsnag.
-
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 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 from MySQL Workbench.
-
Connect to Auth0 Data from PowerBuilder via ADO.NET
This article demonstrates how to access Auth0 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 Cloud 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 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.
-
Automated Continuous Attio Replication to Snowflake
Use CData Sync for automated, continuous, customizable Attio replication to Snowflake.
-
Analyze Drift Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Drift with the CData JDBC Driver for Drift.
-
Build Automated Workflows with Live Microsoft Teams Data in Workato
Use CData Connect AI to connect to live Microsoft Teams 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 in your FileMaker application.
-
Integrate Cvent Data into Power Automate Desktop using CData Connect
CData Connect for Cvent Data enables you to integrate Cvent into workflows built using Microsoft Power Automate Desktop.
-
Analyze Reckon Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Reckon and visualize live Reckon in Infragistics Reveal.
-
Connect GitHub Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your GitHub 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.
-
Build a Simple VCL Application for Microsoft Ads Data
How to build a simple VCL Application to view Microsoft Ads 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 Servers.
-
Access Exact Online Data from MySQL in Amazon QuickSight
Connect to Exact Online and build visualizations of Exact Online using a MySQL Connection in Amazon QuickSight.
-
Connect to Apollo Data from Crystal Reports
Use CData Connect AI to connect to and report on live Apollo 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 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 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 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 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 in Microsoft R Open.