CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Oracle Sales Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Oracle Sales replication to IBM DB2.
-
Build Invoiced-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Invoiced.
-
Connect to Google Search Results from PowerBuilder via ADO.NET
This article demonstrates how to access Google Search from Appeon PowerBuilder using the CData ADO.NET Provider for Google Search.
-
Integrate with Live Azure Analysis Services Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Azure Analysis Services from the MuleSoft Anypoint Platform to integrate live Azure Analysis Services into custom reports and dashboards.
-
Deploy the ADO.NET Provider for Snapchat Ads on an SSRS Report Server
Connect to Snapchat Ads 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.
-
How to Query Google Analytics Data in MySQL Workbench
Execute MySQL queries against live Google Analytics from MySQL Workbench.
-
Create Amazon Athena-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Amazon Athena Data from Klipfolio and build custom visualizations using live Amazon Athena.
-
Use Azure AI Foundry to Talk to Your SAP Netweaver Gateway 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 SAP Netweaver Gateway for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Bullhorn CRM
Provide connectivity to Bullhorn CRM through an SAP BusinessObjects universe.
-
Build Blackbaud FE NXT-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Blackbaud FE NXT to explore live Blackbaud FE NXT Data in Claude Code to assist with building Blackbaud FE NXT-powered applications.
-
Analyze DocuSign Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of DocuSign and visualize live DocuSign in Infragistics Reveal.
-
Connect to Vimeo Data in DBArtisan
Use wizards in DBArtisan to configure Vimeo as a data source.
-
Build a PostgreSQL Interface for Google Tasks Data using the CData JDBC Driver
Use the Remoting features of the Google Tasks JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Biml to Build SSIS Tasks to Replicate PingOne Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate PingOne to SQL Server.
-
Connect to Oracle Eloqua Reporting Data in NetBeans
Connect to Oracle Eloqua Reporting in NetBeans with the data source configuration wizard.
-
Establish a Live Connection with REST Data using Tableau Bridge
The CData ODBC Driver for REST enables you to integrate live REST into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Typeform Data from a Connection Pool in Jetty
The Typeform JDBC Driver supports connection pooling: This article shows how to connect faster to Typeform from Web apps in Jetty.
-
Use the CData Software JDBC Driver for Facebook in MicroStrategy Desktop
Connect to Facebook in MicroStrategy Desktop using the CData Software JDBC Driver for Facebook.
-
ETL PingOne in Oracle Data Integrator
This article shows how to transfer PingOne into a data warehouse using Oracle Data Integrator.
-
How to Access MYOB AccountRight Data Using Entity Framework
This article shows how to access MYOB AccountRight using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to and Visualize Live Customer.io Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Customer.io.
-
Connect to Mailgun Data in Jaspersoft Studio
Execute SQL to remote Mailgun in Jaspersoft Studio.
-
Automated Continuous MYOB AccountRight Replication to Databricks
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Databricks.
-
Visualize Discourse Data in TIBCO Spotfire through ADO.NET
Integrate Discourse into dashboards in TIBCO Spotfire.
-
Getting Started with the CData JDBC Driver for CockroachDB
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for CockroachDB.
-
Integrating LangChain with Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Outreach.io within automated workflows.
-
Query Supabase Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Supabase from Node.js.
-
Query Freshdesk Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Freshdesk from Node.js.
-
Natively Connect to Outlook Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Outlook. Leverage the native support for ODBC in PHP.
-
Create Data Visualizations in Cognos BI with Asana Data
Access Asana as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to work with ServiceDesk Plus Data in Apache Spark using SQL
Access and process ServiceDesk Plus Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Access Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Access replication to Google Cloud SQL.
-
How to connect to BambooHR Data in DBVisualizer
Integrate BambooHR with visual data analysis tools and data connection wizards in DBVisualizer
-
Provide OData Services of Authorize.Net Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Authorize.Net by developing a WCF Service Application.
-
Automated Continuous ServiceNow Replication to SQLite
Use CData Sync for automated, continuous, customizable ServiceNow replication to SQLite.
-
Connect AfterShip to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect AfterShip with IBM WebSphere for seamless data integration and connectivity.
-
How to connect and process Quaderno from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Quaderno.
-
How to Connect the Power BI Service to Tavily: Complete Guide
Connect to the CData Software Power BI Connector for Tavily from PowerBI.com to provide real-time Tavily across the organization.
-
Connect to PagerDuty Data from PowerBuilder via JDBC
This article demonstrates how to access PagerDuty from PowerBuilder using the PagerDuty JDBC Driver.
-
How to Visualize IBM Informix Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live IBM Informix in Python.
-
Publish Oracle Eloqua Reporting-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Oracle Eloqua Reporting.
-
Viewing Adobe Analytics Data in RAD Studio Data Explorer
How to view Adobe Analytics in RAD Studio Data Explorer using the CData ODBC Driver for Adobe Analytics.
-
How to Query Live Klaviyo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Klaviyo data in natural language using Python.
-
Getting Started with the CData Power BI Connector for PolarTeamPro
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build a Simple VCL Application for Google Analytics Data
How to build a simple VCL Application to view Google Analytics in RAD Studio using the CData ODBC Driver for Google Analytics.
-
Replicate Gorgias Data from PowerShell
Write a quick PowerShell script to query Gorgias. Use connectivity to the live data to replicate Gorgias to SQL Server.
-
Automated Continuous Perplexity Replication to SQL Server
Use CData Sync for automated, continuous, customizable Perplexity replication to SQL Server.
-
How to load OpenWeatherMap data into Elasticsearch via Logstash
Introducing a simple method to load OpenWeatherMap data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automate RSS Feeds Replication to Azure Data Lake
Use CData Sync to customize and automate RSS Feeds replication to Azure Data Lake.
-
Create a Data Access Object for ADP Data using JDBI
A brief overview of creating a SQL Object API for ADP in JDBI.
-
Automated Continuous SAP Hybris C4C Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Apache Cassandra.
-
How to import Google Search Results into Apache Solr
Use the CData Software JDBC Driver for Google Search in Data Import Handler and create an automated import of Google Search to Apache Solr Enterprise Search platform.
-
How to load Greenplum data into Elasticsearch via Logstash
Introducing a simple method to load Greenplum data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Access Live PabblySubscriptions Data in Power Automate Desktop via ODBC
The CData ODBC Driver for PabblySubscriptions enables you to integrate PabblySubscriptions into workflows built using Microsoft Power Automate Desktop.
-
Build Odoo-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Odoo ERP.
-
Build ShipStation-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for ShipStation to explore live ShipStation Data in GitHub Copilot to assist with building ShipStation-powered applications.
-
Automated Continuous SingleStore Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SingleStore replication to Google BigQuery.
-
How to connect to SparkPost Data with Squirrel SQL client
Connect to SparkPost and execute queries in the Squirrel SQL Client.
-
Trigger EnterpriseDB IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for EnterpriseDB with standard wizards in Logic Apps.
-
Create Informatica Mappings From/To an ODBC Data Source for Beeminder
Create an ODBC connection to Beeminder in Informatica and browse and transfer Beeminder.
-
Extend Google Sheets with Google Directory Data
Make calls to Google Directory from Google Apps Script via the API Server.
-
Use Biml to Build SSIS Tasks to Replicate Neo4J Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Neo4J to SQL Server.
-
Visualize Live Amplitude Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Amplitude using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating GitHub Copilot CLI with Freshteam 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 Reports with Okta Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Okta.
-
Visualize Sage 200 Data in TIBCO Spotfire through ADO.NET
Integrate Sage 200 into dashboards in TIBCO Spotfire.
-
Create Act-On-Connected Business Apps in AppSheet
Connect to Act-On Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Act-On.
-
Use the CData Software ODBC Driver for Rebilly in MicroStrategy Desktop
Connect to Rebilly in MicroStrategy Desktop using the CData Software ODBC Driver for Rebilly.
-
Getting Started with the CData SSIS Components for Factorial
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Factorial.
-
Process & Analyze Stripe Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Stripe Data.
-
Build Charts with Coinbase Data in Clear Analytics
Create dynamic charts and perform analytics based on Coinbase in Clear Analytics.
-
Connect to and Visualize Live Outreach.io Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Outreach.io.
-
Integrating OpenCode Terminal with OneNote 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.
-
Visualize HCL Domino Data in TIBCO Spotfire through OData
Integrate HCL Domino into dashboards in TIBCO Spotfire.
-
Import Real-Time Zoho Inventory Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Zoho Inventory in ColdFusion.
-
Bidirectional Access to Everhour Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Everhour in Filemaker Pro for Mac or Windows.
-
Analyze Figshare Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Figshare from Power Pivot. You will use the Table Import Wizard to load Figshare. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Marketo Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Marketo replication to OneLake in Microsoft Fabric.
-
Process & Analyze Microsoft OneDrive Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Microsoft OneDrive Data.
-
Access Live Google Ads Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Ads from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Add Azure Synapse Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Azure Synapse with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous CSV Replication to IBM DB2
Use CData Sync for automated, continuous, customizable CSV replication to IBM DB2.
-
Visualize REST Data in Tableau
The CData ODBC driver for REST enables you integrate REST into Tableau dashboards.
-
How to Connect Flowise AI Agents to Live SAP SuccessFactors 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 SAP SuccessFactors without replication.
-
Automate Hubstaff Data Replication to Azure Data Lake
Use CData Sync to customize and automate Hubstaff replication to Azure Data Lake.
-
FHIR Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to FHIR through CData Connect AI using different applications and tools.
-
How to Design Salesforce Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Salesforce from mobile and tablet Power Apps.
-
Getting Started with the CData Tableau Connector for PivotalTracker
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Object-Relational Mapping (ORM) with Airtable Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Airtable into a Java-based ORM framework, Hibernate.
-
Build Data Flows from Figshare to SQL Server using SSIS
Easily back up Figshare to SQL Server using the SSIS components for Figshare.
-
How to create Visio diagrams from Zoho CRM Data
Automatically update Zoho CRM with the changes you make to Visio master shapes.
-
How to Work with Hugging Face Data in ETL Validator JDBC
Connect to Hugging Face from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData JDBC Driver for Parallel
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Parallel.
-
Integrating OpenCode Terminal with Epicor Kinetic 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.
-
Validate Square Data with QuerySurge
Access and validate Square in QuerySurge using the CData JDBC Driver.
-
Easily Integrate Jira Assets Data in Lazarus Pascal IDE
Learn how to easily integrate live Jira Assets in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Model, Search, and Visualize Live Adobe Commerce Data in ThoughtSpot
Use CData Connect AI to connect to live Adobe Commerce for modeling, searching, and visualizing.
-
Access Microsoft OneDrive Data from MySQL in PHP
Connect to Microsoft OneDrive through the standard MySQL libraries in PHP.
-
Integrate with SAP Business One Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP Business One in SnapLogic.
-
Create Datasets from Sugar CRM in Domo Workbench and Build Visualizations of Sugar CRM Data in Domo
Use the CData Software ODBC Driver for Sugar CRM to create datasets from Sugar CRM in Domo Workbench and then build visualizations in the Domo service.