CData Software - Knowledge Base
Recent Articles
-
Prepare, Blend, and Analyze Mailjet Data in Alteryx Designer (Connect AI)
Build workflows to access live Mailjet data for self-service data analytics.
-
Automated Continuous Brex Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Brex replication to PostgreSQL.
-
Use Microsoft Copilot Studio to talk to your Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Acumatica data for you.
-
Bidirectional Access to SingleStore Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SingleStore data in Filemaker Pro for Mac or Windows.
-
Integrate Teamwork Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Teamwork data from Informatica Cloud.
-
Connect to XML Data in Claris FileMaker Pro
Use the CData ODBC Driver for XML in FileMaker Pro to connect to XML and work with XML data in your FileMaker applications.
-
Consume Kafka OData Feeds in PowerBuilder
This article demonstrates how to consume Kafka data as OData feeds from PowerBuilder using the API Server.
-
Create Reports with Salesforce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Salesforce data.
-
Use Biml to Build SSIS Tasks to Replicate Productboard Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Productboard data to SQL Server.
-
Visualize AdRoll Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to AdRoll data.
-
Create SAP Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP data access from reports, embedded analytics, and more.
-
Automate Egnyte Data Replication to Azure Synapse
Use CData Sync to customize and automate Egnyte data replication to Azure Synapse.
-
Create SSAS Tabular Models from Printful Data
How to build a SQL Server Analysis Service Tabular Model from Printful data using CData drivers.
-
How to publish and share Clockify Data dashboards with Tableau Server
The CData ODBC driver for Clockify enables you integrate Clockify data into Tableau dashboards.
-
Use the CData Software JDBC Driver for ServiceNow in MicroStrategy Web
Connect to ServiceNow data in MicroStrategy Web using the CData Software JDBC Driver for ServiceNow.
-
Automated Continuous Klipfolio Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Klipfolio replication to Amazon Redshift.
-
Use the CData ODBC Driver for Azure Table from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Azure Table to connect to Azure Table data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Azure Table data in Excel.
-
Automated Continuous EnterpriseDB Replication to Oracle
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Oracle.
-
Rapidly Develop SQL Server-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 SQL Server.
-
Integrating Cursor with SAP Business Warehouse 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.
-
Create BigQuery-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to BigQuery Data from Klipfolio and build custom visualizations using live BigQuery data.
-
Automated Continuous CockroachDB Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable CockroachDB replication to Google BigQuery.
-
Connect to JSON Services in NetBeans
Connect to JSON services in NetBeans with the data source configuration wizard.
-
Integrating Dataiku with Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Elasticsearch data.
-
Connect and Visualize Live Amazon S3 Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Amazon S3 data into the Databricks platform and create visualization dashboards with real-time Amazon S3 data.
-
Build ZohoDesk Visualizations in Tableau Cloud
Use CData Connect AI to connect to live ZohoDesk data and build visualizations in Tableau Cloud.
-
Connect to Adobe Analytics Data in Claris FileMaker Pro
Use the CData ODBC Driver for Adobe Analytics in FileMaker Pro to connect to Adobe Analytics and work with Adobe Analytics data in your FileMaker applications.
-
Automated Continuous Greenhouse Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Greenhouse replication to IBM DB2.
-
LINQ to SendInBlue 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 SendInBlue Data Provider.
-
Connect to xBase Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live xBase data from Filemaker Pro on Mac.
-
Build Apps with Live Dropbox data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Dropbox data into the Adalo platform and build custom mobile and web applications with real-time Dropbox data.
-
Connect to and Visualize Live PDFMonkey Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live PDFMonkey data.
-
Build Visualizations of Aha! Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Aha! data in Birst.
-
Build a PostgreSQL Interface for Salesforce CRM Analytics Data using the CData JDBC Driver
Use the Remoting features of the Salesforce CRM Analytics JDBC Driver to create a PostgreSQL entry-point for data access.
-
Bridge LeadDesk Connectivity with Apache NiFi
Access and process LeadDesk data in Apache NiFi using the CData JDBC Driver.
-
Access Oracle HCM Cloud Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Oracle HCM Cloud data from HeidiSQL.
-
How to work with Freshsales Data in Apache Spark using SQL
Access and process Freshsales Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to Live Omnisend Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Omnisend data for you.
-
Access Toggl 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 Toggl data.
-
Replicate Missive Data from PowerShell
Write a quick PowerShell script to query Missive data. Use connectivity to the live data to replicate Missive data to SQL Server.
-
Automate Hive Data Replication to Azure Synapse
Use CData Sync to customize and automate Hive data replication to Azure Synapse.
-
Build a Simple VCL Application for ZohoSubscriptions Data
How to build a simple VCL Application to view ZohoSubscriptions data in RAD Studio using the CData ODBC Driver for ZohoSubscriptions.
-
Connect to Nuclia Data in NetBeans
Connect to Nuclia data in NetBeans with the data source configuration wizard.
-
Import SendPulse Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SendPulse Data and provide access to live SendPulse data for custom reports in the Power BI Service.
-
Deploy the ADO.NET Provider for Zoho Projects on an SSRS Report Server
Connect to Zoho Projects 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 Reply.io Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Reply.io data from HeidiSQL.
-
Connect to Klipfolio Data in DBeaver
Use the CData ODBC Driver to connect to Klipfolio data in DBeaver.
-
How to connect PolyBase to PDFMonkey
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PDFMonkey data.
-
Integrating LangGraph with Workday Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Workday data within automated workflows.
-
Visualize SharePoint 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 SharePoint data into TIBCO Spotfire.
-
Connect to IBM Informix Data as an External Source in Dremio
Use the CData JDBC Driver to connect to IBM Informix as an External Source in Dremio.
-
A PostgreSQL Interface for Sentry Data (MySQL Remoting via JDBC)
Use the Remoting features of the Sentry JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build MySQL-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 MySQL data without replication.
-
Use the CData Software ODBC Driver for Adobe Analytics in MicroStrategy Desktop
Connect to Adobe Analytics data in MicroStrategy Desktop using the CData Software ODBC Driver for Adobe Analytics.
-
Use the CData Software ODBC Driver for PagerDuty in MicroStrategy
Connect to PagerDuty data in MicroStrategy Developer using the CData Software ODBC Driver for PagerDuty.
-
Import Real-Time Ontraport Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Ontraport data in ColdFusion.
-
Connect to Cohere Data in JRuby
Create a simple JRuby app with access to live Cohere data.
-
DataBind Zoho Projects Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Zoho Projects with the DevExpress Windows Forms and Web controls to provide Zoho Projects data to a chart.
-
Build a PostgreSQL Interface for Planio Data using the CData JDBC Driver
Use the Remoting features of the Planio JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Deel Data Replication to Couchbase
Use CData Sync to Customize and automate Deel data replication to Couchbase.
-
DataBind Quaderno Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Quaderno data to a chart.
-
Configure the CData JDBC Driver for SQL Analysis Services in a Connection Pool in Tomcat
Connect to SQL Analysis Services data from a connection pool in Tomcat.
-
How to create GitHub federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for GitHub data in MySQL .
-
Automate JotForm Data Replication to Azure Synapse
Use CData Sync to customize and automate JotForm data replication to Azure Synapse.
-
Integrate with Landbot Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Landbot data to a JSON file on disk.
-
Automate Asana Data Replication to SAP HANA
Use CData Sync to customize and automate Asana data replication to SAP HANA.
-
Visualize Discord Data in TIBCO Spotfire through ADO.NET
Integrate Discord data into dashboards in TIBCO Spotfire.
-
Build Semantic Layer Views for Salesloft Data in APOS Live Data Gateway
Use the CData Connector for Salesloft in APOS Live Data Gateway to build Semantic Layer Views for Salesloft data.
-
Use the CData Software ODBC Driver for Aha! in MicroStrategy Web
Connect to Aha! data in MicroStrategy Web using the CData Software ODBC Driver for Aha!.
-
How to Connect the Power BI Service to Suadeo: Complete Guide
Connect to the CData Software Power BI Connector for Suadeo from PowerBI.com to provide real-time Suadeo data across the organization.
-
How to Connect to Live SAP Fieldglass 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 SAP Fieldglass data for you.
-
Automated Continuous SurveyMonkey Replication to SQL Server
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to SQL Server.
-
Automate SAP Hybris C4C Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP Hybris C4C data from PowerShell? This article demonstrates how to utilize the SAP Hybris C4C Cmdlets for tasks like connecting to SAP Hybris C4C data, automating operations, downloading data, and more.
-
Build an OLAP Cube in SSAS from ScrapingBee Data
Establish a connection to ScrapingBee data data from SQL Server Analysis Services, and use the ScrapingBee Data Provider to build OLAP cubes for use in analytics and reporting.
-
Analyze Bright Data Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Bright Data from Power Pivot. You will use the Table Import Wizard to load Bright Data data. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Salesforce Marketing Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to PostgreSQL.
-
Create SAP Netweaver Gateway-Connected Business Apps in AppSheet
Connect to SAP Netweaver Gateway Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP Netweaver Gateway data.
-
Publish Access-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Access data.
-
Connect to Salesforce Marketing Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Salesforce Marketing to connect to Salesforce Marketing data and execute queries in PowerBuilder.
-
How to connect to Shortcut Data with Squirrel SQL client
Connect to Shortcut data and execute queries in the Squirrel SQL Client.
-
Integrate Dify with Live SAS Data Sets Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live SAS Data Sets data.
-
Process & Analyze ShipEngine Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ShipEngine Data.
-
Access SFTP Data from MySQL in Amazon QuickSight
Connect to SFTP and build visualizations of SFTP data using a MySQL Connection in Amazon QuickSight.
-
Integrating Testmonitor Data in Talend Cloud Data Management Platform
Connect Testmonitor Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build AI Agents with Shortcut Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Shortcut data through CData Connect AI.
-
Natively Connect to QuickBooks Online Data in PHP
The CData ODBC driver for QuickBooks Online enables you to create PHP applications with connectivity to QuickBooks Online data. Leverage the native support for ODBC in PHP.
-
Create Data Visualizations in Cognos BI with Amazon S3 Data
Access Amazon S3 data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Data Visualizations in Cognos BI with Humanity Data
Access Humanity data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous ServiceDesk Plus Replication to Snowflake
Use CData Sync for automated, continuous, customizable ServiceDesk Plus replication to Snowflake.
-
Load Oracle Eloqua Reporting Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Oracle Eloqua Reporting data to a database.
-
Getting Started with the CData Power BI Connector for ActiveCampaign
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for ActiveCampaign.
-
Build a Singer.io Tap for Airtable With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Airtable data using the CData Python Connector.
-
Connect to and Query Cloudant Data in QlikView over ODBC
Create data visualizations with Cloudant data in QlikView.
-
Getting Started with the CData Power BI Connector for Spotify
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Replicate SAP HANA Data in Heroku for Use in Salesforce Connect
Replicate SAP HANA data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Live Notion Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Notion data into the statistical analysis tools available in SAS JMP. This article shows how to use Notion data in the Graph Builder and Query Builder.
-
Automated Continuous Omnisend Replication to MySQL
Use CData Sync for automated, continuous, customizable Omnisend replication to MySQL.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Epicor Kinetic
Provide connectivity to Epicor Kinetic data through an SAP BusinessObjects universe.
-
Integrate with Google Campaign Manager 360 Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Campaign Manager 360 data to a JSON file on disk.
-
Create Apps from Kintone Data in Qlik Sense Cloud
Use CData Connect AI to connect to Kintone Data and build apps from live Kintone data in Qlik Sense Cloud.