CData Software - Knowledge Base
Recent Articles
-
Build Pipelines with Live Campaigner Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Campaigner from Google Cloud Data Fusion, enabling the integration of live Campaigner data into the building and management of effective data pipelines.
-
Automated Continuous NASA Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable NASA replication to Azure SQL Database.
-
How to connect to ServiceDesk Plus Data in DBVisualizer
Integrate ServiceDesk Plus data with visual data analysis tools and data connection wizards in DBVisualizer
-
Sync Google Contacts with QuickBooks
The CData ADO.NET Providers offer an easy way to integrate with different data sources. This article walks through the downloadable, fully functional application that can be used to synchronize contacts between Google and QuickBooks.
-
Visualize Live DB2 Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live DB2 data into custom reports in Power BI.
-
Connect to PolarTeamPro 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 PolarTeamPro data.
-
A PostgreSQL Interface for Excel Data using the CData ODBC Driver
Use the SQL Gateway and Excel ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Blackbaud FE NXT Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Blackbaud FE NXT to connect to Blackbaud FE NXT data and execute queries in PowerBuilder.
-
Connect to Salesforce Marketing Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Salesforce Marketing data.
-
Bridge Clockify Connectivity with Apache NiFi
Access and process Clockify data in Apache NiFi using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Azure Table in MicroStrategy
Connect to Azure Table data in MicroStrategy Developer using the CData Software JDBC Driver for Azure Table.
-
How to Create Power BI Visual Reports with Real-Time Azure Table Data
Use CData Power BI Connectors to visualize Azure Table data in Power BI.
-
Analyze Live Wistia Data in SAS Viya
Use CData Connect AI to connect to Wistia data from SAS Viya and deploy self-service analytics using live Wistia data.
-
Integrate with Azure DevOps Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Azure DevOps data in SnapLogic.
-
Connect to Zoho Creator Data in DBArtisan
Use wizards in DBArtisan to configure Zoho Creator data as a data source.
-
Integrating GitHub Copilot with Email 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.
-
Build Azure Data Catalog-Connected Apps in Choreo
Use CData Connect AI to connect to Azure Data Catalog Data from Choreo and build custom apps using live Azure Data Catalog data.
-
Getting Started with the CData Excel Add-In for OpenWeatherMap
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for OpenWeatherMap.
-
Use Dash to Build Web Apps on Sage Cloud Accounting Data via CData Connect AI
Build interactive Dash web apps on live Sage Cloud Accounting data using pandas and the CData Connect AI Python SDK.
-
Use the CData Software JDBC Driver for Azure Synapse in MicroStrategy
Connect to Azure Synapse data in MicroStrategy Developer using the CData Software JDBC Driver for Azure Synapse.
-
Use the CData Software ODBC Driver for FTP in MicroStrategy Web
Connect to FTP data in MicroStrategy Web using the CData Software ODBC Driver for FTP.
-
DataBind Controls to Toggl Data in Delphi
DataBind to Toggl data in Delphi with standard data access components and controls.
-
Object-Relational Mapping (ORM) with QuickBooks Online 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 QuickBooks Online data into a Java-based ORM framework, Hibernate.
-
Connect to Gong Data in HULFT Integrate
Connect to Gong as a JDBC data source in HULFT Integrate
-
Operational Reporting on CockroachDB Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote CockroachDB data.
-
How to Connect to & Open Bullhorn CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Bullhorn CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Real-Time Aha! Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Aha! data in Power Apps.
-
Automated Continuous DB2 Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable DB2 replication to Azure SQL Database.
-
How to Build an ETL App for Okta Data in Python with CData
Create ETL applications and real-time data pipelines for Okta data in Python with petl.
-
Integrating OpenCode with Tanda 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.
-
How to Build an ETL App for Phoenix Data in Python with CData Connect AI
Extract and transform live Phoenix data in Python with petl and the CData Connect AI Python SDK.
-
How to connect and process Customer.io data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Customer.io data.
-
Connect to CircleCI Data in Jaspersoft Studio
Execute SQL to remote CircleCI data in Jaspersoft Studio.
-
Natively Connect to Cohere Data in PHP
The CData ODBC driver for Cohere enables you to create PHP applications with connectivity to Cohere data. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData JDBC Driver for Azure Table
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Azure Table.
-
A PostgreSQL Interface for ChartMogul Data using the CData ODBC Driver
Use the SQL Gateway and ChartMogul ODBC Driver to create a PostgreSQL entry-point for data access.
-
Process & Analyze Google Translate Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Translate Data.
-
How to create ConvertAPI federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ConvertAPI data in MySQL .
-
Integrate OpenCode with Live Greenhouse Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Greenhouse data from within your AI coding agent.
-
Enable the Brex JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Brex data.
-
Getting Started with the CData Power BI Connector for ChartMogul
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Getting Started with the CData SSIS Components for MailerSend
Complete guide to installing, licensing, and connecting with the CData SSIS Components for MailerSend.
-
Visualize Live iContact Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live iContact data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access BambooHR Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live BambooHR data from HeidiSQL.
-
Visualize Apify Data in TIBCO Spotfire through ADO.NET
Integrate Apify data into dashboards in TIBCO Spotfire.
-
How to Connect to Live Raisers Edge NXT Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Raisers Edge NXT data for you.
-
Stream Instantly Data into Apache Kafka Topics
Access and stream Instantly data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Build an ETL App for GraphQL Data in Python with CData Connect AI
Extract and transform live GraphQL data in Python with petl and the CData Connect AI Python SDK.
-
Connect to Live Figshare Data in MicroStrategy through CData Connect AI
Create a live connection to Figshare Data in CData Connect AI and connect to your Figshare data from MicroStrategy.
-
Integrating Cursor with Opsgenie 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.
-
Import and Visualize Auth0 Data in Power View
Create data visualizations based on Auth0 data in Excel.
-
Automated FreeAgent Data Replication to Teradata
Use CData Sync to Customize and automate FreeAgent data replication to Teradata.
-
Automated Continuous Workday Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Workday replication to IBM DB2.
-
SAP SuccessFactors Reporting in OBIEE with the SAP SuccessFactors JDBC Driver
Deploy the SAP SuccessFactors JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Pipeliner CRM Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Pipeliner CRM and work with Pipeliner CRM data in your FileMaker application.
-
Bridge CSV Connectivity with Apache NiFi
Access and process CSV data in Apache NiFi using the CData JDBC Driver.
-
How to Query Deel Data in MySQL Workbench
Execute MySQL queries against live Deel data from MySQL Workbench.
-
How to Connect to Live EnterpriseDB Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your EnterpriseDB data for you.
-
Connecting Pipedream with Moosend Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Moosend data in real time.
-
Use Azure AI Foundry to Talk to Your SendGrid 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 SendGrid data for you.
-
Visualize Live CouchDB Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live CouchDB data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Egnyte Data in DataGrip
Create a Data Source for Egnyte in DataGrip and use SQL to query live Egnyte data.
-
Model Teradata Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Teradata, enabling the direct import of real-time Teradata data.
-
Using CData JDBC Drivers from NetBeans
CData JDBC Drivers make it easy for Java developers to work with a variety of data sources. In this article we show how to develop with CData JDBC Drivers using the NetBeans Java IDE.
-
Build Pipelines with Live Freshdesk Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Freshdesk from Google Cloud Data Fusion, enabling the integration of live Freshdesk data into the building and management of effective data pipelines.
-
Interact with Live SharePoint Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SharePoint data.
-
Operational Reporting on SAP ByDesign Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP ByDesign data.
-
Integrate Google's Vertex AI Agent with Live Yelp 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 Yelp data within intelligent workflows.
-
Build Exa-Connected Apps in Choreo
Use CData Connect AI to connect to Exa Data from Choreo and build custom apps using live Exa data.
-
Publish Gong-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Gong data.
-
Connect to Google Analytics Data in Jaspersoft Studio
Execute SQL to remote Google Analytics data in Jaspersoft Studio.
-
How to Connect Amazon Athena 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 Amazon Athena data in real time using natural language.
-
Connecting Pipedream with GraphQL Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on GraphQL data in real time.
-
Automated Continuous Bitly Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Bitly replication to Google BigQuery.
-
How to connect Amazon QuickSight to SAS xpt Data
Create a connection to SAS xpt data in CData Connect AI and insert SAS xpt data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to connect PolyBase to Dynamics CRM
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Dynamics CRM data.
-
Build AI/ML Models with Live Rebilly Data using Dataiku
Connect Rebilly Data with Dataiku using the CData API Driver for JDBC.
-
How to Seamlessly Import Bullhorn CRM Data into IBM SPSS Modeler
Integrate Bullhorn CRM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Easily Integrate BenchmarkEmail Data in Lazarus Pascal IDE
Learn how to easily integrate live BenchmarkEmail data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect to Live Mode Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Mode data securely in real time.
-
DataBind Controls to Scrapfly Data in Delphi
DataBind to Scrapfly data in Delphi with standard data access components and controls.
-
Access Live Epicor Kinetic Data in TIBCO Data Virtualization
Use the Epicor Kinetic Tibco DV Adapter to create a Epicor Kinetic data data source in TIBCO Data Virtualization Studio and gain access to live Epicor Kinetic data from your TDV Server.
-
Visualize Live MySQL Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live MySQL data.
-
Getting Started with the CData JDBC Driver for Confluence
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Confluence.
-
Integrate Timely Data in Pentaho Data Integration
Build ETL pipelines based on Timely data in the Pentaho Data Integration tool.
-
Bridge ZohoMarketingHub Connectivity with Apache NiFi
Access and process ZohoMarketingHub data in Apache NiFi using the CData JDBC Driver.
-
Deploy the ADO.NET Provider for SpaceX on an SSRS Report Server
Connect to SpaceX 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.
-
Build a PostgreSQL Interface for Typeform Data using the CData JDBC Driver
Use the Remoting features of the Typeform JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SAP HANA XS Advanced Data in HULFT Integrate
Connect to SAP HANA XS Advanced as a JDBC data source in HULFT Integrate
-
How to Connect to Live Cloudant Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Cloudant data for you.
-
Integrate Live Freshservice Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Freshservice data and integrate live Freshservice data into apps built in Microsoft Power Apps.
-
Use the CData Software JDBC Driver for Samanage in MicroStrategy Web
Connect to Samanage data in MicroStrategy Web using the CData Software JDBC Driver for Samanage.
-
Shippo Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Shippo data through CData Connect AI using different applications and tools.
-
Use the CData Software ODBC Driver for Salesforce Data 360 in MicroStrategy
Connect to Salesforce Data 360 data in MicroStrategy Developer using the CData Software ODBC Driver for Salesforce Data 360.
-
Build a Simple VCL Application for GitHub Data
How to build a simple VCL Application to view GitHub data in RAD Studio using the CData ODBC Driver for GitHub.
-
Query PingOne Data as a MySQL Database in Node.js
Execute MySQL queries against PingOne data from Node.js.
-
Back Up CircleCI data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with CircleCI data data.
-
How to connect to LinkedIn Ads Data with Squirrel SQL client
Connect to LinkedIn Ads data and execute queries in the Squirrel SQL Client.
-
Model, Search, and Visualize Live Mailgun Data in ThoughtSpot
Use CData Connect AI to connect to live Mailgun data for modeling, searching, and visualizing.
-
Use the CData ODBC Driver for SharePoint from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SharePoint to connect to SharePoint data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SharePoint data in Excel.