CData Software - Knowledge Base
Recent Articles
-
Connect to Sentry Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Sentry as an External Source in Dremio.
-
Getting Started with the CData ADO.NET Provider for Square
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Square.
-
Connect to Teamwork Data from a Connection Pool in Jetty
The Teamwork JDBC Driver supports connection pooling: This article shows how to connect faster to Teamwork data from Web apps in Jetty.
-
Create Dynamic Exact Online Grids Using the Infragistics XamDataGrid
Learn how you can connect Exact Online to Infragistics XamDataGrid to build dynamic grids.
-
Connect Suadeo to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Suadeo with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Pipeline CRM Data from PowerBuilder via ADO.NET
This article demonstrates how to access Pipeline CRM data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automated Quaderno Data Replication to Teradata
Use CData Sync to Customize and automate Quaderno data replication to Teradata.
-
Build Visualizations of Superchat Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Superchat data in Birst.
-
Integrate Cline with Live OData Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live OData services from within your IDE.
-
Integrating Boomi Agentstudio with Couchbase Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Couchbase data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Import and Visualize Amplitude Data in Power View
Create data visualizations based on Amplitude data in Excel.
-
Create ZohoMarketingHub-Connected Nintex Workflows
Use CData Connect AI to connect to ZohoMarketingHub Data from Nintex Workflow Cloud and build custom workflows using live ZohoMarketingHub data.
-
Connect to Tanda from Asprova with CData Software ODBC Driver for Tanda
This article shows how to connect faster to Tanda data from Asprova.
-
Build Data Flows from Nuclia to SQL Server using SSIS
Easily back up Nuclia data to SQL Server using the SSIS components for Nuclia.
-
Automated Continuous Power BI XMLA Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Apache Kafka.
-
Build Dashboards with Blackbaud FE NXT Data in DBxtra
Create dynamic dashboards and perform analytics based on Blackbaud FE NXT data in DBxtra.
-
Publish Oracle Eloqua-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Oracle Eloqua data.
-
Integrate with SendGrid Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SendGrid data in SnapLogic.
-
How to load Parquet data into Elasticsearch via Logstash
Introducing a simple method to load Parquet data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Zendesk Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zendesk data from your Google Sheets.
-
Build Semantic Layer Views for OneNote Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for OneNote data.
-
Connect Sage Cloud Accounting Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Sage Cloud Accounting data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
SurveyMonkey Reporting in OBIEE with the SurveyMonkey JDBC Driver
Deploy the SurveyMonkey JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Zuora Data in Ruby
Connect to Zuora data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Design BIRT Reports on Pipeliner CRM Data
Provide current Pipeliner CRM data to your embedded analytics.
-
Consume PostgreSQL OData Feeds in PowerBuilder
This article demonstrates how to consume PostgreSQL data as OData feeds from PowerBuilder using the API Server.
-
Extract, Transform, and Load DB2 Data in Informatica PowerCenter
Create a simple Workflow for DB2 data in Informatica PowerCenter.
-
Replicate Multiple Instantly Accounts via the CData Sync CLI
Replicate multiple Instantly accounts to one or many databases.
-
Connect OData to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live OData services using the CData Python MCP Server.
-
Automate Coinbase Data Replication to Azure Data Lake
Use CData Sync to customize and automate Coinbase data replication to Azure Data Lake.
-
Configure the CData JDBC Driver for CloudConvert in a Connection Pool in Tomcat
Connect to CloudConvert data from a connection pool in Tomcat.
-
Query Live Shopify 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 Shopify data directly from the development environment.
-
How to Work with IBM Informix Data in ETL Validator JDBC
Connect to IBM Informix from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Live Google Cloud Storage Data in MicroStrategy through CData Connect AI
Create a live connection to Google Cloud Storage Data in CData Connect AI and connect to your Google Cloud Storage data from MicroStrategy.
-
Connect and Visualize Live Typeform Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Typeform data into the Databricks platform and create visualization dashboards with real-time Typeform data.
-
Manage Salesforce Marketing Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Salesforce Marketing.
-
Connecting GenSpark with Gong Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Gong data without any replication or custom integration required.
-
How to create an RPA flow for Zuora Data in UiPath Studio
Use the Zuora ODBC Driver to create workflows that access real-time Zuora data without any coding.
-
Migrating data from Pipeliner CRM to Databricks using CData SSIS Components.
Easily push Pipeliner CRM data to Databricks using the CData SSIS Tasks for Pipeliner CRM and Databricks.
-
Feed Aweber Data into FineReport
How to set Aweber data as a JDBC data source in FineReport.
-
How to work with Redshift Data in Apache Spark using SQL
Access and process Redshift Data in Apache Spark using the CData Software JDBC Driver.
-
How to connect PolyBase to FHIR
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live FHIR data.
-
Replicate Multiple Yelp Accounts via the CData Sync CLI
Replicate multiple Yelp accounts to one or many databases.
-
Connect to VWO Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time VWO data using standard SQL.
-
Enable the LeadDesk JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with LeadDesk data.
-
Analyze DB2 Data in Looker
Use CData Connect AI to connect to DB2 Data from Looker and build custom apps using live DB2 data.
-
Build OData-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live OData services and build OData-connected web apps with Axios.
-
Integrating Claude Code CLI with MessageBird 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.
-
Integrate Theia IDE with Live Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Pipedrive data from within the development environment.
-
ETL Kafka in Oracle Data Integrator
This article shows how to transfer Kafka data into a data warehouse using Oracle Data Integrator.
-
Provide OData Services of Hacker News Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Hacker News data by developing a WCF Service Application.
-
Use the CData Software ODBC Driver for Rootly in SAS for Real-Time Reporting and Analytics
Connect to real-time Rootly data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Rootly.
-
Query Live FHIR 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 FHIR data directly from the development environment.
-
Publish Instagram-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Instagram data.
-
Bind Live Greenhouse Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Greenhouse data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect to Live Marketo Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Marketo in CData Connect AI and connect to your Marketo data from PostgreSQL.
-
Integrate Live Stripe Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Stripe data to Blue Prism using the CData ODBC Driver for Stripe to create automated workflows for repetitive business tasks.
-
Automated Continuous SuiteCRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable SuiteCRM replication to SingleStore.
-
Build MVC Applications with Connectivity to Float Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Float from an ASP.NET MVC application.
-
Extract, Transform, and Load Pinecone Data in Informatica PowerCenter
Create a simple Workflow for Pinecone data in Informatica PowerCenter.
-
Deploy the ADO.NET Provider for Amazon Athena on an SSRS Report Server
Connect to Amazon Athena 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.
-
Connect to Simplesat Data in DBeaver
Use the CData ODBC Driver to connect to Simplesat data in DBeaver.
-
Build ADP Visualizations in Tableau Desktop
Use CData Connect AI to connect to live ADP data and build visualizations in Tableau.
-
Connect to Front Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Front to connect to Front data and execute queries in PowerBuilder.
-
DataBind Amplitude Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Amplitude data to a chart.
-
Load Adobe Experience Manager Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Adobe Experience Manager data to a database.
-
Migrating data from Cloudflare to Google BigQuery using CData SSIS Components.
Easily push Cloudflare data to Google BigQuery using the CData SSIS Tasks for Cloudflare and Google BigQuery.
-
Explore Geographical Relationships in Salesforce Marketing Data with Power Map
Create data visualizations with Salesforce Marketing data in Power Map.
-
How to connect PolyBase to Airtable
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Airtable data.
-
Connect to LDAP Objects as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live LDAP objects.
-
Automated Continuous Salesforce Replication to Vertica
Use CData Sync for automated, continuous, customizable Salesforce replication to Vertica.
-
Integrate Insightly Data in Pentaho Data Integration
Build ETL pipelines based on Insightly data in the Pentaho Data Integration tool.
-
Deploy the ADO.NET Provider for Google Analytics on an SSRS Report Server
Connect to Google Analytics 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.
-
Use the CData Software JDBC Driver for Excel in MicroStrategy Web
Connect to Excel data in MicroStrategy Web using the CData Software JDBC Driver for Excel.
-
Stream Keap Data into Apache Kafka Topics
Access and stream Keap data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Supabase Data in RazorSQL
Connect to Supabase from wizards and query Supabase data from the GUI in the RazorSQL database management tool.
-
Connect to Azure Analysis Services Data in DBeaver
Use the CData ODBC Driver to connect to Azure Analysis Services data in DBeaver.
-
Query Excel Online Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Excel Online entities in PHP by modeling them as objects.
-
Connecting Agentforce with Vertica Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Vertica data for you.
-
Automate Printful Data Replication to SAP HANA
Use CData Sync to customize and automate Printful data replication to SAP HANA.
-
Integrate MYOB AccountRight Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MYOB AccountRight data from Informatica Cloud.
-
Access Live Landbot Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Landbot data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Access Dropbox Data Using Entity Framework
This article shows how to access Dropbox data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build AI Agents with Zoho Books 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 Zoho Books data through CData Connect AI.
-
Automated Continuous Greenhouse Replication to SQL Server
Use CData Sync for automated, continuous, customizable Greenhouse replication to SQL Server.
-
Query PolarTeamPro Data in ColdFusion
Write standard ColdFusion data access code to connect to PolarTeamPro data.
-
Build Automated DB2-Connected Workflows in Zapier
Use CData Connect AI to connect to live DB2 data and build automated workflows in Zapier.
-
Connect to Acumatica from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Acumatica data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Natively Connect to Bugsnag Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Bugsnag data. Leverage the native support for ODBC in PHP.
-
Object-Relational Mapping (ORM) with Simplesat 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 Simplesat data into a Java-based ORM framework, Hibernate.
-
Migrating data from Gmail to Snowflake using CData SSIS Components.
Easily push Gmail data to Snowflake using the CData SSIS Tasks for Gmail and Snowflake.
-
Build Apps with Live Cloudant data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Cloudant data into the Adalo platform and build custom mobile and web applications with real-time Cloudant data.
-
Visualize Live Tavily Data in the Power BI Service
Use CData Connect AI to connect to live Tavily data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Work with Confluence Data in FoxPro
Load Confluence data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live Flowlu Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Flowlu data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software JDBC Driver for Oracle Financials Cloud in MicroStrategy Desktop
Connect to Oracle Financials Cloud data in MicroStrategy Desktop using the CData Software JDBC Driver for Oracle Financials Cloud.
-
Choosing the Best Method to Connect SAP Business One to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP Business One data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
View Reports on Real-Time Coinbase Data in Power BI Report Server
Use the CData ODBC Driver for Coinbase to visualize Coinbase data in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData ADO.NET Provider for SAP Fieldglass
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAP Fieldglass.
-
Object-Relational Mapping (ORM) with Mixpanel 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 Mixpanel data into a Java-based ORM framework, Hibernate.