CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Teamwork Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Teamwork replication to Google Cloud SQL.
-
Working with Salesforce Data in LINQPad
Execute LINQ queries to Salesforce data in LINQPad.
-
Automate Zoho Inventory Data Replication to SAP HANA
Use CData Sync to customize and automate Zoho Inventory data replication to SAP HANA.
-
Access Live Mixpanel Data in AWS Lambda
Connect to live Mixpanel data in AWS Lambda using the CData JDBC Driver.
-
A PostgreSQL Interface for Jumpseller Data (MySQL Remoting via JDBC)
Use the Remoting features of the Jumpseller JDBC Driver to create a PostgreSQL entry-point for data access.
-
Enable the ZohoDesk JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ZohoDesk data.
-
Automated Continuous Onfleet Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Onfleet replication to Google BigQuery.
-
Connect Foursquare to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Foursquare with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software ODBC Driver for IBM Cloud Object Storage in MicroStrategy
Connect to IBM Cloud Object Storage data in MicroStrategy Developer using the CData Software ODBC Driver for IBM Cloud Object Storage.
-
Replicate Oracle Data to Multiple Databases
Replicate Oracle data to disparate databases with a point-and-click configuration.
-
Connect PostgreSQL Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your PostgreSQL data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Live Pinterest Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Pinterest data and integrate live Pinterest data into apps built in Microsoft Power Apps.
-
Access Avalara AvaTax Data from MySQL in PHP
Connect to Avalara AvaTax through the standard MySQL libraries in PHP.
-
Operational Reporting on Active Directory Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Active Directory data.
-
How to connect to Zendesk Data from Spring Boot
Connect to Zendesk in a Spring Boot Application using the CData JDBC Driver for Zendesk
-
Use CData Connect AI to Access API Data in Microsoft Power Pivot
Use CData Connect AI to connect to live API data in the Power Pivot business intelligence tool.
-
Working with SpaceX Data in LINQPad
Execute LINQ queries to SpaceX data in LINQPad.
-
Visualize Campaigner Data in TIBCO Spotfire through ADO.NET
Integrate Campaigner data into dashboards in TIBCO Spotfire.
-
Load Dynamics 365 Business Central Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Dynamics 365 Business Central data to a database.
-
Build Apps with Live Figshare Data Using the Low-Code Development Platform of Mendix
Connect Figshare data with Mendix to build apps using the CData API Driver for JDBC.
-
Provide OData Services of Sybase IQ Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sybase IQ data by developing a WCF Service Application.
-
Replicate Reply.io Data to Multiple Databases
Replicate Reply.io data to disparate databases with a point-and-click configuration.
-
Automated Continuous Productboard Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Productboard replication to Azure SQL Database.
-
Automate Couchbase Data Replication to Azure Data Lake
Use CData Sync to customize and automate Couchbase data replication to Azure Data Lake.
-
Use the CData ODBC Driver for Anaplan in Microsoft Power Query
You can use the CData Anaplan ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Anaplan data into Microsoft Power Query.
-
Build a Simple VCL Application for ConvertAPI Data
How to build a simple VCL Application to view ConvertAPI data in RAD Studio using the CData ODBC Driver for ConvertAPI.
-
Migrating data from Google Ads to Snowflake using CData SSIS Components.
Easily push Google Ads data to Snowflake using the CData SSIS Tasks for Google Ads and Snowflake.
-
Build an OLAP Cube in SSAS from SparkPost Data
Establish a connection to SparkPost data data from SQL Server Analysis Services, and use the SparkPost Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connecting Agentforce with QuickBooks 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 QuickBooks data for you.
-
Search External ZohoSubscriptions Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of ZohoSubscriptions data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ZohoSubscriptions Data objects that you can access from apps and the dashboard.
-
Integrate with Zoho CRM Data in JReport Designer
Create charts and reports based on Zoho CRM data in JReport Designer.
-
Integrate with Keap Data in JReport Designer
Create charts and reports based on Keap data in JReport Designer.
-
How to connect and process AlloyDB data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live AlloyDB data.
-
Connect Smartsheet to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Smartsheet data using the CData Python MCP Server.
-
Integrate Printful Data in Pentaho Data Integration
Build ETL pipelines based on Printful data in the Pentaho Data Integration tool.
-
Add Microsoft Exchange Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Microsoft Exchange with the Informatica Enterprise Data Catalog to classify and organize data.
-
Validate Stripe Data with QuerySurge
Access and validate Stripe data in QuerySurge using the CData JDBC Driver.
-
How to Connect to Live Klaviyo Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Klaviyo data through natural language.
-
Use Claude to Talk to Your Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Dynamics 365 data for you.
-
Build MVC Applications with Connectivity to Moosend Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Moosend from an ASP.NET MVC application.
-
How to Work with Clio Data in AWS Glue Jobs Using JDBC
Connect to Clio from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build AI Agents with CSV 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 CSV data through CData Connect AI.
-
DataBind Charts to Google Ads Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Ads data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Migrating data from Quickbase to Databricks using CData SSIS Components.
Easily push Quickbase data to Databricks using the CData SSIS Tasks for Quickbase and Databricks.
-
DataBind Controls to Gong Data in C++Builder
DataBind to Gong data in C++Builder with standard components and controls.
-
Create SSAS Tabular Models from Ontraport Data
How to build a SQL Server Analysis Service Tabular Model from Ontraport data using CData drivers.
-
Import ZohoMarketingHub Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to ZohoMarketingHub Data and provide access to live ZohoMarketingHub data for custom reports in the Power BI Service.
-
Connect to eBay Analytics from a Connection Pool in WebLogic
Use the CData JDBC Driver for eBay Analytics to connect to eBay Analytics data from Web applications running on WebLogic.
-
How to Build an ETL App for Cassandra Data in Python with CData
Create ETL applications and real-time data pipelines for Cassandra data in Python with petl.
-
Use Microsoft Copilot Studio to talk to your ShipStation 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 ShipStation data for you.
-
How to Connect CockroachDB Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live CockroachDB data in real time using natural language.
-
Object-Relational Mapping (ORM) with ZohoSubscriptions 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 ZohoSubscriptions data into a Java-based ORM framework, Hibernate.
-
Query Live BenchmarkEmail 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 BenchmarkEmail data directly from the development environment.
-
Connect to Insightly Data in RapidMiner
Integrate Insightly data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to connect Amazon QuickSight to Raisers Edge NXT Data
Create a connection to Raisers Edge NXT data in CData Connect AI and insert Raisers Edge NXT data into Amazon QuickSight SPICE to build interactive dashboards.
-
Visualize Kintone Data in TIBCO Spotfire through ADO.NET
Integrate Kintone data into dashboards in TIBCO Spotfire.
-
Use ChatGPT to Talk to Your Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Google Ad Manager data for you.
-
Access Live Freshteam Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Freshteam data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Gmail Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Gmail and the SQL Gateway to access Gmail data from Google Apps Script.
-
Use Claude to Talk to Your Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Cassandra data for you.
-
Integrate Live Microsoft Dataverse Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Microsoft Dataverse data and integrate live Microsoft Dataverse data into apps built in Microsoft Power Apps.
-
Use CData Connect AI to Access Zendesk Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Zendesk data in the Power Pivot business intelligence tool.
-
Visualize Live Shippo Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Shippo data.
-
Integrating Cursor with Aircall 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.
-
Use the CData Software ODBC Driver for Smartsheet in MicroStrategy Desktop
Connect to Smartsheet data in MicroStrategy Desktop using the CData Software ODBC Driver for Smartsheet.
-
Connect to Cvent Data in Ruby
Connect to Cvent data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Write a Simple Go Application to work with Salesforce Pardot Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Salesforce Pardot data.
-
Establish a Live Connection with Planio Data using Tableau Bridge
The CData ODBC Driver for Planio enables you to integrate live Planio data into Tableau Cloud dashboards using the Tableau Bridge.
-
Add GitLab Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for GitLab with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect Flowise AI Agents to Live Sage 200 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 Sage 200 data without replication.
-
Extract, Transform, and Load Snowflake Data in Informatica PowerCenter
Create a simple Workflow for Snowflake data in Informatica PowerCenter.
-
Excel Spreadsheet Automation on SurveyMonkey Data with the QUERY Formula
Pull data from SurveyMonkey, automate spreadsheets, and more with the QUERY formula.
-
Connect to SAP SuccessFactors Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP SuccessFactors data in Google Apps Script.
-
Connect to Exa Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Exa Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use JayDeBeApi to access GitHub Data in Python
Use standard Python scripting and the development environment of your choice to access live GitHub data.
-
Connect to Jira Data in DBeaver
Use the CData ODBC Driver to connect to Jira data in DBeaver.
-
Extract, Transform, and Load Greenhouse Data in Informatica PowerCenter
Create a simple Workflow for Greenhouse data in Informatica PowerCenter.
-
Connect to Mouseflow Data in DBeaver
Use the CData ODBC Driver to connect to Mouseflow data in DBeaver.
-
Connect to Act CRM Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Act CRM data from Filemaker Pro on Mac.
-
Connect to AlloyDB Data in DBArtisan
Use wizards in DBArtisan to configure AlloyDB data as a data source.
-
Choosing the Best Method to Connect Azure Data Lake Storage to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Azure Data Lake Storage data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Prepare, Blend, and Analyze JSON Services in Alteryx Designer (ODBC)
Build workflows to access live JSON services for self-service data analytics.
-
Stream Copper Data into Apache Kafka Topics
Access and stream Copper data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Semantic Layer Views for Miro Data in APOS Live Data Gateway
Use the CData Connector for Miro in APOS Live Data Gateway to build Semantic Layer Views for Miro data.
-
How to Work with Moosend Data in AWS Glue Jobs Using JDBC
Connect to Moosend from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automate Anaplan Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Anaplan data from PowerShell? This article demonstrates how to utilize the Anaplan Cmdlets for tasks like connecting to Anaplan data, automating operations, downloading data, and more.
-
Creating HubSpot-Connected Applications in Unqork
You can use CData Connect AI to feed HubSpot data to Unqork and build custom business apps.
-
Connect to EnterpriseDB Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live EnterpriseDB data from Filemaker Pro on Mac.
-
Validate Quaderno Data with QuerySurge
Access and validate Quaderno data in QuerySurge using the CData JDBC Driver.
-
Model, Search, and Visualize Live QuickBooks Data in ThoughtSpot
Use CData Connect AI to connect to live QuickBooks data for modeling, searching, and visualizing.
-
How to Build an ETL App for Workday Data in Python with CData Connect AI
Build ETL pipelines that read and write live Workday data in Python with petl and the CData Connect AI Python SDK.
-
Create Dynamic Dropbox Grids Using the Infragistics XamDataGrid
Learn how you can connect Dropbox to Infragistics XamDataGrid to build dynamic grids.
-
Analyze Avalara AvaTax Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Avalara AvaTax data with the CData JDBC Driver for Avalara AvaTax.
-
Use Biml to Build SSIS Tasks to Replicate LinkedIn Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate LinkedIn data to SQL Server.
-
Integrate Real-Time Access to Amazon Athena in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Amazon Athena data in real time.
-
Integrate LibreChat with Live Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Bullhorn CRM data from within the chat interface.
-
Integrate with BigQuery Data in JReport Designer
Create charts and reports based on BigQuery data in JReport Designer.
-
Manage Microsoft Ads Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Microsoft Ads.
-
Integrating Cursor with Freshteam 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.
-
Object-Relational Mapping (ORM) with Landbot 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 Landbot data into a Java-based ORM framework, Hibernate.