CData Software - Knowledge Base
Recent Articles
-
Create Dynamic Impala Grids Using the Infragistics XamDataGrid
Learn how you can connect Impala to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Live Snowflake Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Snowflake in CData Connect AI and connect to your Snowflake data from PostgreSQL.
-
Connect to Workable Data in JRuby
Create a simple JRuby app with access to live Workable data.
-
Analyze Live AgileCRM Data in SAS Viya
Use CData Connect AI to connect to AgileCRM data from SAS Viya and deploy self-service analytics using live AgileCRM data.
-
Use the CData Software ODBC Driver for FTP in MicroStrategy Desktop
Connect to FTP data in MicroStrategy Desktop using the CData Software ODBC Driver for FTP.
-
Work with Greenhouse Data in FoxPro
Load Greenhouse data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData ODBC Driver for SQL Analysis Services in Microsoft Power Query
You can use the CData SQL Analysis Services ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SQL Analysis Services data into Microsoft Power Query.
-
Getting Started with the CData SSIS Components for Printify
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Printify.
-
How to Build an ETL App for Exa Data in Python with CData
Create ETL applications and real-time data pipelines for Exa data in Python with petl.
-
Use the CData Software ODBC Driver for Sage 300 in MicroStrategy Desktop
Connect to Sage 300 data in MicroStrategy Desktop using the CData Software ODBC Driver for Sage 300.
-
Connect to EnterpriseDB Data from a Connection Pool in JBoss
Integrate EnterpriseDB data into Java servlets: Use the Management Console in JBoss to install the EnterpriseDB JDBC Driver.
-
How to Seamlessly Import Shippo Data into IBM SPSS Modeler
Integrate Shippo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Import Real-Time JobNimbus Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use JobNimbus data in ColdFusion.
-
Connect to Adobe Commerce Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Adobe Commerce data in the Denodo Virtual DataPort Administrator.
-
Natively Connect to Zoho Recruit Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Zoho Recruit data. Leverage the native support for ODBC in PHP.
-
Integrating Claude Code with Salesforce Marketing Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Salesforce Marketing data within assisted coding and automated development workflows.
-
Use the CData Software ODBC Driver for ZohoMarketingHub in SAS for Real-Time Reporting and Analytics
Connect to real-time ZohoMarketingHub data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ZohoMarketingHub.
-
Access Live ZohoDesk Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ZohoDesk data from your Excel spreadsheets.
-
ETL Instantly in Oracle Data Integrator
This article shows how to transfer Instantly data into a data warehouse using Oracle Data Integrator.
-
Integrate with Live ShipEngine Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to ShipEngine from the MuleSoft Anypoint Platform to integrate live ShipEngine data into custom reports and dashboards.
-
Access Live Omnisend Data in AWS Lambda
Connect to live Omnisend data in AWS Lambda using the CData JDBC Driver.
-
Create Datasets from Copper in Domo Workbench and Build Visualizations of Copper Data in Domo
Use the CData Software ODBC Driver for Copper to create datasets from Copper data in Domo Workbench and then build visualizations in the Domo service.
-
Build Automated MySQL-Connected Workflows in Zapier
Use CData Connect AI to connect to live MySQL data and build automated workflows in Zapier.
-
How to Connect Paylocity 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 Paylocity data in real time using natural language.
-
Replicate Splunk Data from PowerShell
Write a quick PowerShell script to query Splunk data. Use connectivity to the live data to replicate Splunk data to SQL Server.
-
Build Apps with Live Printful Data Using the Low-Code Development Platform of Mendix
Connect Printful data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Real-Time Quickbase Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Quickbase and Dataflow to import and use Quickbase data in Power Apps.
-
Integrate Real-Time Access to Bitbucket in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Bitbucket data in real time.
-
Use the CData Software ODBC Driver for Snowflake in MicroStrategy
Connect to Snowflake data in MicroStrategy Developer using the CData Software ODBC Driver for Snowflake.
-
Integrating Kiro with Power BI XMLA 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.
-
Connecting Pipedream with Bitly 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 Bitly data in real time.
-
Seamlessly Bring PolarTeamPro Data into Retool Using CData Connect AI
Integrate PolarTeamPro data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous Factorial Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Factorial replication to Amazon Redshift.
-
Object-Relational Mapping (ORM) with Bright Data 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 Bright Data data into a Java-based ORM framework, Hibernate.
-
Feed CockroachDB Data into FineReport
How to set CockroachDB data as a JDBC data source in FineReport.
-
Integrate OpenCode with Live Freshteam Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Freshteam data from within your AI coding agent.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for PDFMonkey
Provide connectivity to PDFMonkey data through an SAP BusinessObjects universe.
-
Prepare, Blend, and Analyze Guru Data in Alteryx Designer (ODBC)
Build workflows to access live Guru data for self-service data analytics.
-
Connect to Active Directory 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 Active Directory data.
-
Access Live Google Translate Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google Translate data into the statistical analysis tools available in SAS JMP. This article shows how to use Google Translate data in the Graph Builder and Query Builder.
-
Create Oracle SCM-Connected Business Apps in AppSheet
Connect to Oracle SCM Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Oracle SCM data.
-
Integrate OpenCode with Live Freshservice Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Freshservice data from within your AI coding agent.
-
Explore Geographical Relationships in Ontraport Data with Power Map
Create data visualizations with Ontraport data in Power Map.
-
Use JayDeBeApi to access CSV Data in Python
Use standard Python scripting and the development environment of your choice to access live CSV data.
-
Write a Simple Go Application to work with Templated Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Templated data.
-
How to connect Amazon QuickSight to Outreach.io Data
Create a connection to Outreach.io data in CData Connect AI and insert Outreach.io data into Amazon QuickSight SPICE to build interactive dashboards.
-
Use the CData ODBC Driver for Printify from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Printify to connect to Printify data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Printify data in Excel.
-
Build Instagram-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Instagram Data and create custom apps in Mendix.
-
How to Query Live Spotify Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Spotify data data in natural language using Python.
-
Work with Google Contacts Data in FoxPro
Load Google Contacts data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Provide OData Services of ZohoInvoice Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ZohoInvoice data by developing a WCF Service Application.
-
Connect to Oracle Sales in SpagoBI
Create reports featuring live Oracle Sales data in SpagoBI Studio. Host Oracle Sales reports on SpagoBI Server.
-
How to Query ConvertAPI Data in MySQL Workbench
Execute MySQL queries against live ConvertAPI data from MySQL Workbench.
-
Connect to Tavily Data in NetBeans
Connect to Tavily data in NetBeans with the data source configuration wizard.
-
Back Up Autopilot 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 Autopilot data data.
-
How to create an RPA flow for ZohoMarketingHub Data in UiPath Studio
Use the ZohoMarketingHub ODBC Driver to create workflows that access real-time ZohoMarketingHub data without any coding.
-
Analyze Phoenix Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Phoenix data and visualize live Phoenix data in Infragistics Reveal.
-
Use JayDeBeApi to access ChartMogul Data in Python
Use standard Python scripting and the development environment of your choice to access live ChartMogul data.
-
Establish a Live Connection with Jumpseller Data using Tableau Bridge
The CData ODBC Driver for Jumpseller enables you to integrate live Jumpseller data into Tableau Cloud dashboards using the Tableau Bridge.
-
Choosing the Best Method to Connect Slack to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Slack data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData Software ODBC Driver for Nuclia in MicroStrategy Web
Connect to Nuclia data in MicroStrategy Web using the CData Software ODBC Driver for Nuclia.
-
Build VWO-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live VWO data and build VWO-connected web apps with Axios.
-
Prepare, Blend, and Analyze Samanage Data in Alteryx Designer (ODBC)
Build workflows to access live Samanage data for self-service data analytics.
-
ETL Harvest in Oracle Data Integrator
This article shows how to transfer Harvest data into a data warehouse using Oracle Data Integrator.
-
Discord Reporting in OBIEE with the Discord JDBC Driver
Deploy the Discord JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Teradata Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Teradata facts in real time.
-
Natively Connect to Productboard Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Productboard data. Leverage the native support for ODBC in PHP.
-
How to import Facebook Data into Apache Solr
Use the CData Software JDBC Driver for Facebook in Data Import Handler and create an automated import of Facebook data to Apache Solr Enterprise Search platform.
-
Use Databricks Agent Bricks to Talk to Your CSV Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your CSV data for you.
-
Integrate with xBase Data in JReport Designer
Create charts and reports based on xBase data in JReport Designer.
-
How to Connect to & Open ZeroBounce Data in Microsoft Excel
This article uses the CData ODBC driver for ZeroBounce to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build ZohoMarketingHub-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live ZohoMarketingHub data and build ZohoMarketingHub-connected web apps with Axios.
-
Automate FormSite Data Replication to Couchbase
Use CData Sync to Customize and automate FormSite data replication to Couchbase.
-
Integrating Claude Code CLI with Close 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.
-
Automated Continuous Splunk Replication to MySQL
Use CData Sync for automated, continuous, customizable Splunk replication to MySQL.
-
Automated Continuous SendGrid Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SendGrid replication to Google Cloud SQL.
-
Import and Visualize Zoho Projects Data in Power View
Create data visualizations based on Zoho Projects data in Excel.
-
Build Bitbucket-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Bitbucket data and build web apps with connectivity to live Bitbucket data.
-
How to import Recurly Data into Apache Solr
Use the CData Software JDBC Driver for Recurly in Data Import Handler and create an automated import of Recurly data to Apache Solr Enterprise Search platform.
-
Connect to Asana Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Asana and the SQL Gateway to access Asana data from Google Apps Script.
-
A PostgreSQL Interface for PostgreSQL Data (MySQL Remoting via JDBC)
Use the Remoting features of the PostgreSQL JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Theia IDE with Live Cloudflare 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 Cloudflare data from within the development environment.
-
Integrate Live Guru Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Guru from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Guru data.
-
Connect to Zoho Creator Data in RapidMiner
Integrate Zoho Creator data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to integrate Metabase with AlloyDB Data
Use CData Connect AI to connect to live AlloyDB data and create an interactive dashboard in Metabase from AlloyDB data.
-
Create Informatica Mappings From/To an ODBC Data Source for JotForm
Create an ODBC connection to JotForm in Informatica and browse and transfer JotForm data.
-
Connect to Browserless Data in Aqua Data Studio
Access Browserless data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Visualize Live Zoho Recruit Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Zoho Recruit data.
-
Integrating Cursor with Dropbox 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.
-
Microsoft Teams Reporting in OBIEE with the Microsoft Teams JDBC Driver
Deploy the Microsoft Teams JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Automated SAP ByDesign-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP ByDesign data and build automated workflows in Zapier.
-
Manage AlloyDB Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for AlloyDB.
-
Integrating Claude Code with Notion Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Notion data within assisted coding and automated development workflows.
-
Create Parallel Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Parallel from PowerBI.com to create Power BI Dataflows with real-time data.
-
Replicate FHIR Data to Multiple Databases
Replicate FHIR data to disparate databases with a point-and-click configuration.
-
Connect to Short.io Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Short.io data using standard SQL.
-
Automate ZohoInvoice Data Replication to Azure Synapse
Use CData Sync to customize and automate ZohoInvoice data replication to Azure Synapse.
-
Easily Integrate Pinterest Data in Lazarus Pascal IDE
Learn how to easily integrate live Pinterest data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automate Testmonitor Data Replication to Azure Data Lake
Use CData Sync to customize and automate Testmonitor data replication to Azure Data Lake.
-
Moving Data from BigCommerce to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live BigCommerce data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.