CData Software - Knowledge Base
Recent Articles
-
Integrate Square Data in Pentaho Data Integration
Build ETL pipelines based on Square data in the Pentaho Data Integration tool.
-
Build Pipelines with Live Google Search Results in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Search from Google Cloud Data Fusion, enabling the integration of live Google Search results into the building and management of effective data pipelines.
-
Work with OnePageCrm Data in FoxPro
Load OnePageCrm data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access eBay Data from MySQL in Amazon QuickSight
Connect to eBay and build visualizations of eBay data using a MySQL Connection in Amazon QuickSight.
-
Query, Visualize, and Share live VWO Data in Redash
Use CData Connect AI to connect to live VWO data in Redash for querying, visualizing, and sharing.
-
Connect to Pipeliner CRM Data in RazorSQL
Connect to Pipeliner CRM from wizards and query Pipeliner CRM data from the GUI in the RazorSQL database management tool.
-
Query Sugar CRM Data in ColdFusion
Write standard ColdFusion data access code to connect to Sugar CRM data.
-
Integrating OpenCode with TigerGraph 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.
-
Integrating Teradata Data in Talend Cloud Data Management Platform
Connect Teradata Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Teradata.
-
Use the CData Software JDBC Driver for NetSuite in MicroStrategy Desktop
Connect to NetSuite data in MicroStrategy Desktop using the CData Software JDBC Driver for NetSuite.
-
Build a Simple VCL Application for SAP SuccessFactors Data
How to build a simple VCL Application to view SAP SuccessFactors data in RAD Studio using the CData ODBC Driver for SAP SuccessFactors.
-
Rapidly Develop Salesloft-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Salesloft.
-
Connect to and Query Salesforce Marketing Data in QlikView over ODBC
Create data visualizations with Salesforce Marketing data in QlikView.
-
How to connect to AgileCRM Data from Spring Boot
Connect to AgileCRM in a Spring Boot Application using the CData API Driver for JDBC
-
Write a Simple Go Application to work with Recurly Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Recurly data.
-
Build Dashboards with Gumroad Data in DBxtra
Create dynamic dashboards and perform analytics based on Gumroad data in DBxtra.
-
Connect to Kintone Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Kintone data in Airbyte.
-
How to connect to Nethunt Data in DBVisualizer
Integrate Nethunt data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect Calendly to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Calendly data using the CData Python MCP Server.
-
Integrating OpenCode with Yelp 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.
-
Connect to Kintone from a Connection Pool in WebLogic
Use the CData JDBC Driver for Kintone to connect to Kintone data from Web applications running on WebLogic.
-
How to connect to ZohoMarketingHub Data with Squirrel SQL client
Connect to ZohoMarketingHub data and execute queries in the Squirrel SQL Client.
-
Use the CData Software JDBC Driver for Twitter Ads in MicroStrategy Web
Connect to Twitter Ads data in MicroStrategy Web using the CData Software JDBC Driver for Twitter Ads.
-
Query QuickBooks Time Data as a MySQL Database in Node.js
Execute MySQL queries against QuickBooks Time data from Node.js.
-
Work with Live Google Ad Manager Data in Power Query
Use CData Connect AI to connect to Google Ad Manager data and work with live Google Ad Manager data in Microsoft Power Query.
-
Automated Continuous Clio Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Clio replication to AlloyDB.
-
Add Quickbase Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Quickbase with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Work with Vimeo Data in AWS Glue Jobs Using JDBC
Connect to Vimeo from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous FreeAgent Replication to Amazon S3
Use CData Sync for automated, continuous, customizable FreeAgent replication to Amazon S3.
-
How to create Ontraport federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Ontraport data in MySQL .
-
Access Live Sybase Data in TIBCO Data Virtualization
Use the Sybase Tibco DV Adapter to create a Sybase data data source in TIBCO Data Virtualization Studio and gain access to live Sybase data from your TDV Server.
-
Build Anaplan Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Anaplan data and build visualizations in Tableau.
-
How to connect and process Everhour data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Everhour data.
-
Access Redshift Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Redshift data from your Oracle system.
-
Build Microsoft Teams-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft Teams data and build web apps with connectivity to live Microsoft Teams data.
-
How to create an RPA flow for Tally Data in UiPath Studio
Use the Tally ODBC Driver to create workflows that access real-time Tally data without any coding.
-
How to Build an ETL App for Superchat Data in Python with CData
Create ETL applications and real-time data pipelines for Superchat data in Python with petl.
-
Integrate Cline with Live Teradata Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Teradata data from within your IDE.
-
How to Build an ETL App for Humanity Data in Python with CData
Create ETL applications and real-time data pipelines for Humanity data in Python with petl.
-
Bind Live OneNote Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live OneNote data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Use Databricks Agent Bricks to Talk to Your BigCommerce Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your BigCommerce data for you.
-
Connect to Demio Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Demio and the SQL Gateway to access Demio data from Google Apps Script.
-
Use the CData ODBC Driver for Google Tasks from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Tasks to connect to Google Tasks data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Tasks data in Excel.
-
Integrate Google Tasks with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Tasks with External Services.
-
How to connect PolyBase to Shopify
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Shopify data.
-
Use Claude to Talk to Your MariaDB 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 MariaDB data for you.
-
Connect to Salesforce CRM Analytics Data from PowerBuilder via JDBC
This article demonstrates how to access Salesforce CRM Analytics data from PowerBuilder using the Salesforce CRM Analytics JDBC Driver.
-
Automate Pushbullet Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Pushbullet data from PowerShell? This article demonstrates how to utilize the Pushbullet Cmdlets for tasks like connecting to Pushbullet data, automating operations, downloading data, and more.
-
Integrating OpenCode with SQL Server 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 Real-Time Access to Amazon DynamoDB in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Amazon DynamoDB data in real time.
-
Visualize Live PingOne Data in the Power BI Service
Use CData Connect AI to connect to live PingOne data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to integrate Metabase with Shopify Data
Use CData Connect AI to connect to live Shopify data and create an interactive dashboard in Metabase from Shopify data.
-
Prepare, Blend, and Analyze Pipedrive Data in Alteryx Designer (Connect AI)
Build workflows to access live Pipedrive data for self-service data analytics.
-
Connect Omnisend to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Omnisend with IBM WebSphere for seamless data integration and connectivity.
-
Build a PostgreSQL Interface for EnterpriseDB Data using the CData JDBC Driver
Use the Remoting features of the EnterpriseDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Antigravity CLI with RSS feeds via CData CLI
Connect RSS feeds to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to connect to Zoho Inventory Data from Spring Boot
Connect to Zoho Inventory in a Spring Boot Application using the CData JDBC Driver for Zoho Inventory
-
Build BambooHR-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to BambooHR data and build web apps with connectivity to live BambooHR data.
-
Connect to MarkLogic Data from AWS Glue
Use CData Connect AI to gain access to live MarkLogic data from your AWS Glue jobs.
-
How to create WordPress federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for WordPress data in MySQL .
-
Connect to Real-Time Mixpanel Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Mixpanel data in Power Apps.
-
Use Azure AI Foundry to Talk to Your CouchDB 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 CouchDB data for you.
-
Build MVC Applications with Connectivity to Bitly Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Bitly from an ASP.NET MVC application.
-
Connecting Pipedream with Mode 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 Mode data in real time.
-
Visualize Zoom Data in Sisense
Create an ElastiCube in Sisense app with access to Zoom data.
-
Integrating Antigravity CLI with Simplesat data via CData CLI
Connect Simplesat data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Connect the Power BI Service to GitLab: Complete Guide
Connect to the CData Software Power BI Connector for GitLab from PowerBI.com to provide real-time GitLab data across the organization.
-
Connect to and Query Microsoft Teams Data in QlikView over ODBC
Create data visualizations with Microsoft Teams data in QlikView.
-
Connect to SAP BusinessObjects BI Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP BusinessObjects BI data in Google Apps Script.
-
Query Reckon Data as a MySQL Database in Node.js
Execute MySQL queries against Reckon data from Node.js.
-
Use ChatGPT to Talk to Your Google Forms 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 Forms data for you.
-
Getting Started with the CData ODBC Driver for HCL Domino
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for HCL Domino.
-
Automated Vercel Data Replication to Teradata
Use CData Sync to Customize and automate Vercel data replication to Teradata.
-
A PostgreSQL Interface for LaunchDarkly Data (MySQL Remoting via JDBC)
Use the Remoting features of the LaunchDarkly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous CloudConvert Replication to Oracle
Use CData Sync for automated, continuous, customizable CloudConvert replication to Oracle.
-
Create Power BI Reports on Real-Time Office 365 Data
Use the CData ODBC Driver for Office 365 to visualize Office 365 data in Power BI Desktop.
-
How to connect PolyBase to Google Drive
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Drive data.
-
Getting Started with the CData Excel Add-In for Oracle
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Oracle.
-
Connect to Google Sheets Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Sheets data.
-
Moving Data from CSV to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live CSV data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Establish a Live Connection with SQL Analysis Services Data using Tableau Bridge
The CData ODBC Driver for SQL Analysis Services enables you to integrate live SQL Analysis Services data into Tableau Cloud dashboards using the Tableau Bridge.
-
Load Oracle Eloqua Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Oracle Eloqua data to a database.
-
Bridge Trello Connectivity with Apache NiFi
Access and process Trello data in Apache NiFi using the CData JDBC Driver.
-
Getting Started with the CData ODBC Driver for Pipedrive
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Pipedrive.
-
Automated Continuous SQL Server Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SQL Server data replication to OneLake in Microsoft Fabric.
-
Query Marketo Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Marketo entities in PHP by modeling them as objects.
-
Build Discord-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Discord data.
-
Getting Started with the CData SSIS Components for NASA
Complete guide to installing, licensing, and connecting with the CData SSIS Components for NASA.
-
Use Dash to Build to Web Apps on Customer.io Data
Create Python applications that use pandas and Dash to build Customer.io-connected web apps.
-
Integrate Asana with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Asana with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Asana data.
-
Automated Continuous Sage 200 Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sage 200 replication to Amazon Redshift.
-
Automated Continuous Wistia Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Wistia data replication to OneLake in Microsoft Fabric.
-
Visualize ZohoInvoice Data in Tableau
The CData ODBC driver for ZohoInvoice enables you integrate ZohoInvoice data into Tableau dashboards.
-
Process & Analyze Act-On Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Act-On Data.
-
Import Real-Time EmailOctopus Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use EmailOctopus data in ColdFusion.
-
Create Data Visualizations in Cognos BI with Power BI XMLA Data
Access Power BI XMLA data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Connect Cosmos DB 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 Cosmos DB data in real time using natural language.
-
Integrating Authorize.Net Data in Talend Cloud Data Management Platform
Connect Authorize.Net Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Authorize.Net.
-
Integrating Codex with HubSpot 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.
-
Connect to Shippo Data in CloverDX (formerly CloverETL)
Transfer Shippo data using the visual workflow in the CloverDX data integration tool.