CData Software - Knowledge Base
Recent Articles
-
Connect to Amazon Marketplace Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Amazon Marketplace data.
-
Access Live Google Ad Manager Data in AWS Lambda
Connect to live Google Ad Manager data in AWS Lambda using the CData JDBC Driver.
-
How to Build an ETL App for SFTP Data in Python with CData Connect AI
Build ETL pipelines that read and write live SFTP data in Python with petl and the CData Connect AI Python SDK.
-
How to Build an ETL App for Vercel Data in Python with CData
Create ETL applications and real-time data pipelines for Vercel data in Python with petl.
-
Automate Brex Data Replication to Azure Synapse
Use CData Sync to customize and automate Brex data replication to Azure Synapse.
-
Access Live SAP HANA Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP HANA data into the statistical analysis tools available in SAS JMP. This article shows how to use SAP HANA data in the Graph Builder and Query Builder.
-
DataBind Campaigner Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Campaigner data to a chart.
-
Connect to Azure Data Lake Storage Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Azure Data Lake Storage Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Access Trello Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Trello data from HeidiSQL.
-
Object-Relational Mapping (ORM) with Avaza 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 Avaza data into a Java-based ORM framework, Hibernate.
-
Access Live Intercom Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Intercom data into the statistical analysis tools available in SAS JMP. This article shows how to use Intercom data in the Graph Builder and Query Builder.
-
Integrate Live Databricks Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Databricks from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Databricks data.
-
Access Live Miro Data in AWS Lambda
Connect to live Miro data in AWS Lambda using the CData JDBC Driver.
-
Publish IBM Cloud Object Storage-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live IBM Cloud Object Storage data.
-
Getting Started with the CData Excel Add-In for Zuora
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Zuora.
-
Connect to Wave Financial Data from PowerBuilder via JDBC
This article demonstrates how to access Wave Financial data from PowerBuilder using the Wave Financial JDBC Driver.
-
Connect to eBay Data from a Connection Pool in JBoss
Integrate eBay data into Java servlets: Use the Management Console in JBoss to install the eBay JDBC Driver.
-
Create Freshservice-Connected Applications in Appsmith
Connect to Freshservice Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Freshservice data.
-
Getting Started with the CData ADO.NET Provider for CapsuleCRM
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Analyze Azure Data Catalog Data in Looker
Use CData Connect AI to connect to Azure Data Catalog Data from Looker and build custom apps using live Azure Data Catalog data.
-
Connect to Pingdom Data in DBArtisan
Use wizards in DBArtisan to configure Pingdom data as a data source.
-
Use Grok to Talk to Your Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Amazon Athena data for you.
-
Create Figshare Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Figshare data access from reports, embedded analytics, and more.
-
Interact with Live Testmonitor Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Testmonitor data.
-
Build an OLAP Cube in SSAS from Workable Data
Establish a connection to Workable data data from SQL Server Analysis Services, and use the Workable Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData ODBC Driver for Shortcut in Microsoft Power Query
You can use the CData Shortcut ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Shortcut data into Microsoft Power Query.
-
Build SAS Data Sets-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 SAS Data Sets data without replication.
-
Create Quickbase Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Quickbase from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Freshservice Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Freshservice data using standard SQL.
-
Automate Klaviyo Data Replication to Azure Data Lake
Use CData Sync to customize and automate Klaviyo data replication to Azure Data Lake.
-
Connect to Bitly Data from a Connection Pool in JBoss
Integrate Bitly data into Java servlets: Use the Management Console in JBoss to install the Bitly JDBC Driver.
-
Access Live Apify 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 Apify data through MCP integration.
-
How to Connect to Live Guru Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Guru data for you.
-
Import Real-Time Facebook Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Facebook data in ColdFusion.
-
Automated Pinterest Data Replication to Teradata
Use CData Sync to Customize and automate Pinterest data replication to Teradata.
-
Connect to Blackbaud FE NXT Data in Jaspersoft Studio
Execute SQL to remote Blackbaud FE NXT data in Jaspersoft Studio.
-
Back Up GraphQL data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for GraphQL. In this article, we will employ an SSIS workflow to populate a database with GraphQL data data.
-
Feed Telegram Data into FineReport
How to set Telegram data as a JDBC data source in FineReport.
-
Connect to Databricks Data from AWS Glue
Use CData Connect AI to gain access to live Databricks data from your AWS Glue jobs.
-
Publish LDAP-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live LDAP objects.
-
Import and Visualize Coinbase Data in Power View
Create data visualizations based on Coinbase data in Excel.
-
Access ADP Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ADP data from HeidiSQL.
-
Integrate Goose with Live Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Zoho CRM data from within the local AI agent.
-
Connect to OnePageCrm Data as an External Source in Dremio
Use the CData JDBC Driver to connect to OnePageCrm as an External Source in Dremio.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for IBM Informix
Provide connectivity to IBM Informix data through an SAP BusinessObjects universe.
-
Create Power BI Reports on Real-Time Coda Data
Use the CData ODBC Driver for Coda to visualize Coda data in Power BI Desktop.
-
ETL Google Analytics in Oracle Data Integrator
This article shows how to transfer Google Analytics data into a data warehouse using Oracle Data Integrator.
-
Integrating Dataiku with Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Cosmos DB data.
-
Getting Started with the CData ADO.NET Provider for LinkedIn
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for LinkedIn.
-
Work with Live Suadeo Data in Power Query
Use CData Connect AI to connect to Suadeo data and work with live Suadeo data in Microsoft Power Query.
-
Publish xBase-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live xBase data.
-
Automated Continuous Presto Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Presto replication to Amazon Redshift.
-
How to Connect Flowise AI Agents to Live NetSuite 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 NetSuite data without replication.
-
Integrating Antigravity CLI with Klaviyo data via CData CLI
Connect Klaviyo data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData ADO.NET Provider for Perigon
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to and Visualize Live Amazon DynamoDB Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Amazon DynamoDB data.
-
Deploy the ADO.NET Provider for Kafka on an SSRS Report Server
Connect to Kafka 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.
-
Automated Continuous GetResponse Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable GetResponse replication to PostgreSQL.
-
Access Live Bright Data Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Bright Data data from your Excel spreadsheets.
-
Getting Started with the CData Tableau Connector for Oracle Eloqua
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Oracle Eloqua.
-
Connect and Query Live Zendesk Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Zendesk data into Databricks and enable direct, live querying and analysis without replication.
-
Integrate Dify with Live Google Sheets 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 Google Sheets data.
-
Connect to Microsoft OneDrive Data in CloverDX (formerly CloverETL)
Transfer Microsoft OneDrive data using the visual workflow in the CloverDX data integration tool.
-
Connect to Quickbase Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Quickbase Data and connect to Quickbase data in Akorbi Digital RunMyProcess.
-
Integrating LlamaIndex with Anaplan Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Anaplan data in real time.
-
Import HBase Data Using Azure Data Factory
Use CData Connect AI to connect to HBase Data from Azure Data Factory and import live HBase data.
-
Create Informatica Mappings From/To a JDBC Data Source for ConstantContact
Create ConstantContact data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Viewing LDAP Objects in RAD Studio Data Explorer
How to view LDAP objects in RAD Studio Data Explorer using the CData ODBC Driver for LDAP.
-
How to Query Attio Data in MySQL Workbench
Execute MySQL queries against live Attio data from MySQL Workbench.
-
Connect Oracle Eloqua to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Oracle Eloqua with IBM WebSphere for seamless data integration and connectivity.
-
Connect to ConstantContact Data in NetBeans
Connect to ConstantContact data in NetBeans with the data source configuration wizard.
-
Configure the CData JDBC Driver for Zoho Projects in a Connection Pool in Tomcat
Connect to Zoho Projects data from a connection pool in Tomcat.
-
Import Real-Time iContact Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use iContact data in ColdFusion.
-
Connect to Airtable Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Airtable data in the Denodo Virtual DataPort Administrator.
-
Analyze xBase Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze xBase data with the CData JDBC Driver for xBase.
-
Integrate FHIR Data into Power Automate Desktop using CData Connect
CData Connect for FHIR Data enables you to integrate FHIR data into workflows built using Microsoft Power Automate Desktop.
-
Integrating Antigravity CLI with Billsby data via CData CLI
Connect Billsby data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Auth0-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Auth0 data and build web apps with connectivity to live Auth0 data.
-
Integrate Google's Vertex AI Agent with Live Presto 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 Presto data within intelligent workflows.
-
Create Campaigner-Connected Business Apps in AppSheet
Connect to Campaigner Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Campaigner data.
-
Create Reports from Kafka Data in Looker Studio
Use CData Connect AI to gain access to live Kafka data and create custom reports in Looker Studio.
-
How to Access Parquet Data Using Entity Framework
This article shows how to access Parquet data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate with live Bitly Data in Jitterbit
Use CData Connect AI to connect to and integrate live Bitly data in Jitterbit.
-
Create Data Visualizations in Cognos BI with Google Drive Data
Access Google Drive data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Model, Search, and Visualize Live Oracle Service Cloud Data in ThoughtSpot
Use CData Connect AI to connect to live Oracle Service Cloud data for modeling, searching, and visualizing.
-
Build Apps with Live SAS xpt Data Using the Low-Code Development Platform of Mendix
Connect SAS xpt data with Mendix to build apps using the CData JDBC Driver for SAS xpt.
-
Integrating Antigravity CLI with Grafana data via CData CLI
Connect Grafana data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize Adobe Target Data in Sisense
Create an ElastiCube in Sisense app with access to Adobe Target data.
-
Connect to Adobe Analytics Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Adobe Analytics and the Script function in FileMaker Pro to connect to Adobe Analytics and work with Adobe Analytics data in your FileMaker application.
-
Replicate Oracle SCM Data to Multiple Databases
Replicate Oracle SCM data to disparate databases with a point-and-click configuration.
-
Use the CData ODBC Driver for Mocean from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Mocean to connect to Mocean data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Mocean data in Excel.
-
How to integrate Stripe with Apache Airflow
Access and process Stripe data in Apache Airflow using the CData JDBC Driver.
-
Connect to ClickTime Data in Ruby
Connect to ClickTime data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Import CSV Data Using Azure Data Factory
Use CData Connect AI to connect to CSV Data from Azure Data Factory and import live CSV data.
-
Access Live Kafka Data in Coginiti Pro
Connect to and query live Kafka data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze Anaplan Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Anaplan data with the CData JDBC Driver for Anaplan.
-
Automated Continuous QuickBooks Time Replication to Databricks
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Databricks.
-
Connecting Agentforce with Facebook Ads 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 Facebook Ads data for you.
-
Visualize Adobe Analytics 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 Adobe Analytics data into TIBCO Spotfire.
-
Connect to FreshBooks Data in HULFT Integrate
Connect to FreshBooks as a JDBC data source in HULFT Integrate