CData Software - Knowledge Base
Recent Articles
-
Integrate with SAP SuccessFactors LMS Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP SuccessFactors LMS data to a JSON file on disk.
-
Connect to Basecamp Data in NetBeans
Connect to Basecamp data in NetBeans with the data source configuration wizard.
-
Natively Connect to LinkedIn Data in PHP
The CData ODBC driver for LinkedIn enables you to create PHP applications with connectivity to LinkedIn data. Leverage the native support for ODBC in PHP.
-
Working with MailerLite Data in LINQPad
Execute LINQ queries to MailerLite data in LINQPad.
-
ETL Hacker News in Oracle Data Integrator
This article shows how to transfer Hacker News data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous SAP HANA Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP HANA replication to Apache Kafka.
-
Microsoft Dataverse Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Microsoft Dataverse facts in real time.
-
Build Avaza-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Avaza data.
-
Integrate with Azure Analysis Services Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Azure Analysis Services data in SnapLogic.
-
Connect to Paylocity Data in CloverDX (formerly CloverETL)
Transfer Paylocity data using the visual workflow in the CloverDX data integration tool.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ZohoPeople
Provide connectivity to ZohoPeople data through an SAP BusinessObjects universe.
-
Connect to Adobe Analytics Data in RapidMiner
Integrate Adobe Analytics data with standard components and data source configuration wizards in RapidMiner Studio.
-
Prepare, Blend, and Analyze MailerSend Data in Alteryx Designer (ODBC)
Build workflows to access live MailerSend data for self-service data analytics.
-
Query Live Presto Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Presto data through a conversational interface.
-
Build Dashboards with Outlook Data in Dundas BI
Create dynamic dashboards and perform analytics based on Outlook data in Dundas BI.
-
Load Float Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Float data to a database.
-
Connecting Moonlit Workflow with Google Contacts Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Google Contacts data in real time.
-
Build an OLAP Cube in SSAS from Oracle Sales Data
Establish a connection to Oracle Sales data data from SQL Server Analysis Services, and use the Oracle Sales Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Easily Query VWO Data in OpenOffice Base
Connect to VWO data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate Live Blackbaud FE NXT Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Blackbaud FE NXT data and integrate live Blackbaud FE NXT data into apps built in Microsoft Power Apps.
-
Link Optimizely with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Optimizely data in Filemaker Pro for Mac or Windows.
-
DataBind CapsuleCRM Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide CapsuleCRM data to a chart.
-
Query, Visualize, and Share live Azure Data Lake Storage Data in Redash
Use CData Connect AI to connect to live Azure Data Lake Storage data in Redash for querying, visualizing, and sharing.
-
Connect to Moosend Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Moosend data using standard SQL.
-
Create Power BI Reports on Real-Time Google Ads Data
Use the CData ODBC Driver for Google Ads to visualize Google Ads data in Power BI Desktop.
-
Automated Continuous Scrapfly Replication to MySQL
Use CData Sync for automated, continuous, customizable Scrapfly replication to MySQL.
-
Integrating GitHub Copilot with CockroachDB 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.
-
Connect to Amazon S3 Data in Claris FileMaker Pro
Use the CData ODBC Driver for Amazon S3 in FileMaker Pro to connect to Amazon S3 and work with Amazon S3 data in your FileMaker applications.
-
Connect to Scrapfly Data in RapidMiner
Integrate Scrapfly data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Gumroad Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Gumroad replication to Apache Kafka.
-
Getting Started with the CData Python Connector for ServiceNow
Learn to install and license the CData Python Connector and configure a connection to live ServiceNow data.
-
Build Voice Agents in ElevenLabs with access to Live Presto Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Presto data.
-
Integrate with Google Ad Manager Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Ad Manager data to a JSON file on disk.
-
Create Informatica Mappings From/To a JDBC Data Source for Coinbase
Create Coinbase data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating Twitter Ads Data in Talend Cloud Data Management Platform
Connect Twitter Ads Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Twitter Ads.
-
Use Dash to Build Web Apps on Active Directory Data via CData Connect AI
Build interactive Dash web apps on live Active Directory data using pandas and the CData Connect AI Python SDK.
-
How to Connect the Power BI Service to Google Tasks: Complete Guide
Connect to the CData Software Power BI Connector for Google Tasks from PowerBI.com to provide real-time Google Tasks data across the organization.
-
Access Live Shortcut Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Shortcut data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Live Impala Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Impala data into the statistical analysis tools available in SAS JMP. This article shows how to use Impala data in the Graph Builder and Query Builder.
-
Use Databricks Agent Bricks to Talk to Your Quickbase Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Quickbase data for you.
-
Write a Simple Go Application to work with SuiteCRM Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SuiteCRM data.
-
Analyze Stripe Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Stripe data and visualize Stripe data in SAP Analytics Cloud.
-
Build Acumatica-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Acumatica Data from Zoho Analytics and import live Acumatica data.
-
Access Live Salesforce Pardot 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 Salesforce Pardot data through MCP integration.
-
Acumatica Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Acumatica data through CData Connect AI using different applications and tools.
-
A PostgreSQL Interface for Unbounce Data using the CData ODBC Driver
Use the SQL Gateway and Unbounce ODBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData ODBC Driver for Splunk
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Splunk.
-
Integrating Cursor with Aweber 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 FTP Data in Tableau
The CData ODBC driver for FTP enables you integrate FTP data into Tableau dashboards.
-
Integrate with CockroachDB Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy CockroachDB data to a JSON file on disk.
-
Visualize Paylocity Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Paylocity data.
-
Automate Reply.io Data Replication to Couchbase
Use CData Sync to Customize and automate Reply.io data replication to Couchbase.
-
Integrate OpenCode with Live FHIR Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live FHIR data from within your AI coding agent.
-
Connect to Snowflake Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Snowflake to connect to Snowflake data and execute queries in PowerBuilder.
-
How to connect to PabblySubscriptions Data from Spring Boot
Connect to PabblySubscriptions in a Spring Boot Application using the CData API Driver for JDBC
-
Query BambooHR Data in DataGrip
Create a Data Source for BambooHR in DataGrip and use SQL to query live BambooHR data.
-
Replicate Pinterest Data from PowerShell
Write a quick PowerShell script to query Pinterest data. Use connectivity to the live data to replicate Pinterest data to SQL Server.
-
Getting Started with the CData Excel Add-In for IBM Informix
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for IBM Informix.
-
Automate Amazon S3 Data Replication to Azure Data Lake
Use CData Sync to customize and automate Amazon S3 data replication to Azure Data Lake.
-
Automated Continuous Gong Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Gong replication to Amazon Redshift.
-
Create Reports from Exact Online Data in Looker Studio
Use CData Connect AI to gain access to live Exact Online data and create custom reports in Looker Studio.
-
How to publish and share Oracle Service Cloud Data dashboards with Tableau Server
The CData ODBC driver for Oracle Service Cloud enables you integrate Oracle Service Cloud data into Tableau dashboards.
-
Access Live Google Search Results in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Search results from your Excel spreadsheets.
-
Integrating Claude Code CLI with PingOne 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.
-
Connect and Visualize Live MongoDB Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live MongoDB data into the Databricks platform and create visualization dashboards with real-time MongoDB data.
-
How to Seamlessly Import Procore Data into IBM SPSS Modeler
Integrate Procore data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Devin with Live Shippo 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 Shippo data.
-
Integrating Boomi Agentstudio with eBay Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to eBay data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Model LDAP Objects Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and LDAP, enabling the direct import of real-time LDAP objects.
-
Replicate CSV Data from PowerShell
Write a quick PowerShell script to query CSV data. Use connectivity to the live data to replicate CSV data to SQL Server.
-
Automated Continuous Redis Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Redis replication to Apache Cassandra.
-
Integrating LangGraph with Salesforce Data 360 Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Salesforce Data 360 data within automated workflows.
-
Connect to ChartMogul Data in Aqua Data Studio
Access ChartMogul data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Build an ETL App for DocuSign Data in Python with CData Connect AI
Extract and transform live DocuSign data in Python with petl and the CData Connect AI Python SDK.
-
Integrate Live Google Cloud Storage Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Cloud Storage data to Blue Prism using the CData ODBC Driver for Google Cloud Storage to create automated workflows for repetitive business tasks.
-
Build Visualizations of Bannerbear Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Bannerbear data in Birst.
-
Access Live Klipfolio Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Klipfolio data through MCP integration.
-
How to Work with Mode Data in ETL Validator JDBC
Connect to Mode from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software JDBC Driver for Strava in MicroStrategy
Connect to Strava data in MicroStrategy Developer using the CData Software JDBC Driver for Strava.
-
Getting Started with the CData Tableau Connector for Azure DevOps
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Azure DevOps.
-
How to Access Tickspot Data Using Entity Framework
This article shows how to access Tickspot data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect the Power BI Service to Beeminder: Complete Guide
Connect to the CData Software Power BI Connector for Beeminder from PowerBI.com to provide real-time Beeminder data across the organization.
-
Enable the FreshBooks JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with FreshBooks data.
-
ETL Asana in Oracle Data Integrator
This article shows how to transfer Asana data into a data warehouse using Oracle Data Integrator.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Shippo
Provide connectivity to Shippo data through an SAP BusinessObjects universe.
-
Integrate Google's Vertex AI Agent with Live Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Azure Synapse data within intelligent workflows.
-
Build ConstantContact-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ConstantContact data and build web apps with connectivity to live ConstantContact data.
-
Integrate with Live WordPress Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to WordPress from the MuleSoft Anypoint Platform to integrate live WordPress data into custom reports and dashboards.
-
Replicate Google Ad Manager Data in Heroku for Use in Salesforce Connect
Replicate Google Ad Manager data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Replicate Multiple ZarMoney Accounts
Replicate multiple ZarMoney accounts to one or many databases.
-
Import Real-Time Zoho Creator Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Zoho Creator data in ColdFusion.
-
How to create Sage 300 federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Sage 300 data in MySQL .
-
Connecting Mastra with Optimizely Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Optimizely data, no replication required.
-
Integrate with Salesforce Data in JReport Designer
Create charts and reports based on Salesforce data in JReport Designer.
-
DataBind Splunk Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Splunk with the DevExpress Windows Forms and Web controls to provide Splunk data to a chart.
-
Replicate Databricks Data to Multiple Databases via the CData Sync CLI
Replicate Databricks data to disparate databases with a single configuration.
-
Connect to Opsgenie Data in JRuby
Create a simple JRuby app with access to live Opsgenie data.
-
Integrate with live QuickBooks Online Data in Jitterbit
Use CData Connect AI to connect to and integrate live QuickBooks Online data in Jitterbit.
-
Connect to SAP Hybris C4C Data in JRuby
Create a simple JRuby app with access to live SAP Hybris C4C data.
-
Access Live Jodoo Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Jodoo data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.