CData Software - Knowledge Base
Recent Articles
-
Replicate Microsoft OneDrive Data from PowerShell
Write a quick PowerShell script to query Microsoft OneDrive data. Use connectivity to the live data to replicate Microsoft OneDrive data to SQL Server.
-
A Comparison of Drivers for Azure Cosmos DB
An article comparing the read performance and resources usage of the CData Software ODBC Driver for CosmosDB with the native ODBC Driver.
-
Use the CData Software ODBC Driver for Pipeliner CRM in SAS for Real-Time Reporting and Analytics
Connect to real-time Pipeliner CRM data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Pipeliner CRM.
-
Edit and Search External Google Calendar Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Calendar data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Calendar Data objects that you can access from apps and the dashboard.
-
Building Dynamic Web Pages with Greenplum Data Using AngularJS
Create single-page applications with live connectivity to Greenplum using the CData API Server.
-
Automated Continuous Copper Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Copper replication to Azure SQL Database.
-
Enable the Google Translate JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Translate data.
-
Integrate with Power BI XMLA Data in JReport Designer
Create charts and reports based on Power BI XMLA data in JReport Designer.
-
How to Easily Query HubSpot Data in OpenOffice Base
Connect to HubSpot data in OpenOffice Base using the CData ODBC Driver for HubSpot and generate reports with live data insights.
-
How to connect to Onfleet Data from Spring Boot
Connect to Onfleet in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate Theia IDE with Live Google Ad Manager 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 Google Ad Manager data from within the development environment.
-
Build a Simple VCL Application for ScrapingBee Data
How to build a simple VCL Application to view ScrapingBee data in RAD Studio using the CData ODBC Driver for ScrapingBee.
-
Integrate Live Paylocity Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Paylocity data and integrate live Paylocity data into apps built in Microsoft Power Apps.
-
How to integrate Lakebase with Apache Airflow
Access and process Lakebase data in Apache Airflow using the CData JDBC Driver.
-
Query Discord Data as a MySQL Database in Node.js
Execute MySQL queries against Discord data from Node.js.
-
Access Vimeo Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Vimeo data from HeidiSQL.
-
Integrating Dataiku with Tally Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Tally data.
-
LINQ to Mixpanel Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Mixpanel Data Provider.
-
Create Power BI Reports on Real-Time Telegram Data
Use the CData ODBC Driver for Telegram to visualize Telegram data in Power BI Desktop.
-
Migrating data from ClickTime to Snowflake using CData SSIS Components.
Easily push ClickTime data to Snowflake using the CData SSIS Tasks for ClickTime and Snowflake.
-
Connect to Perplexity Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Perplexity data from Filemaker Pro on Mac.
-
Automated Continuous Parquet Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Parquet replication to PostgreSQL.
-
Import and Visualize SAP Ariba Source Data in Power View
Create data visualizations based on SAP Ariba Source data in Excel.
-
How to connect to MySQL Data with Squirrel SQL client
Connect to MySQL data and execute queries in the Squirrel SQL Client.
-
How to load Airtable data into Elasticsearch via Logstash
Introducing a simple method to load Airtable data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Replicate Multiple CockroachDB Accounts
Replicate multiple CockroachDB accounts to one or many databases.
-
Create a Data Access Object for LinkedIn Ads Data using JDBI
A brief overview of creating a SQL Object API for LinkedIn Ads data in JDBI.
-
Prepare, Blend, and Analyze Egnyte Data in Alteryx Designer (Connect AI)
Build workflows to access live Egnyte data for self-service data analytics.
-
How to integrate Missive with Apache Airflow
Access and process Missive data in Apache Airflow using the CData JDBC Driver.
-
Import Real-Time Snapchat Ads Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Snapchat Ads data in ColdFusion.
-
How to Build an ETL App for Zoho Recruit Data in Python with CData
Create ETL applications and real-time data pipelines for Zoho Recruit data in Python with petl.
-
How to connect and process Facebook Ads data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Facebook Ads data.
-
Integrating EmailOctopus Data in Talend Cloud Data Management Platform
Connect EmailOctopus Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create SSAS Tabular Models from LeadDesk Data
How to build a SQL Server Analysis Service Tabular Model from LeadDesk data using CData drivers.
-
Integrate LinkedIn Ads Data in Pentaho Data Integration
Build ETL pipelines based on LinkedIn Ads data in the Pentaho Data Integration tool.
-
Query Adobe Experience Manager Data as a SQL Server Database in Node.js
Execute SQL Server queries against Adobe Experience Manager data from Node.js.
-
How to connect and process Oracle Financials Cloud data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle Financials Cloud data.
-
Visualize Live Guru Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Guru data.
-
Import and Visualize MessageBird Data in Power View
Create data visualizations based on MessageBird data in Excel.
-
Replicate Supabase Data to Multiple Databases
Replicate Supabase data to disparate databases with a point-and-click configuration.
-
Analyze ConstantContact Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ConstantContact data with the CData JDBC Driver for ConstantContact.
-
Automate MailerSend Data Replication to SAP HANA
Use CData Sync to customize and automate MailerSend data replication to SAP HANA.
-
Explore Geographical Relationships in Azure DevOps Data with Power Map
Create data visualizations with Azure DevOps data in Power Map.
-
Create Google Directory-Connected Nintex Workflows
Use CData Connect AI to connect to Google Directory Data from Nintex Workflow Cloud and build custom workflows using live Google Directory data.
-
Integrate Trae with Live SAS xpt Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live SAS xpt data from within the AI-powered IDE.
-
Prepare, Blend, and Analyze Twitter Ads Data in Alteryx Designer (ODBC)
Build workflows to access live Twitter Ads data for self-service data analytics.
-
View Reports on Real-Time Airtable Data in Power BI Report Server
Use the CData ODBC Driver for Airtable to visualize Airtable data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData Software JDBC Driver for PostgreSQL in MicroStrategy Web
Connect to PostgreSQL data in MicroStrategy Web using the CData Software JDBC Driver for PostgreSQL.
-
How to Connect the Power BI Service to Billsby: Complete Guide
Connect to the CData Software Power BI Connector for Billsby from PowerBI.com to provide real-time Billsby data across the organization.
-
How to Work with Procore Data in AWS Glue Jobs Using JDBC
Connect to Procore from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Workday Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Workday data replication to OneLake in Microsoft Fabric.
-
Enable the Vimeo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Vimeo data.
-
Configure the CData JDBC Driver for Beeminder in a Connection Pool in Tomcat
Connect to Beeminder data from a connection pool in Tomcat.
-
Replicate PDFMonkey Data to Multiple Databases
Replicate PDFMonkey data to disparate databases with a point-and-click configuration.
-
Create Informatica Mappings From/To a JDBC Data Source for AdRoll
Create AdRoll data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Apps from Greenplum Data in Qlik Sense Cloud
Use CData Connect AI to connect to Greenplum Data and build apps from live Greenplum data in Qlik Sense Cloud.
-
Getting Started with the CData Excel Add-In for Tavily
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Tavily.
-
Import and Visualize ChartMogul Data in Power View
Create data visualizations based on ChartMogul data in Excel.
-
How to connect to Teamwork Data from Spring Boot
Connect to Teamwork in a Spring Boot Application using the CData API Driver for JDBC
-
Getting Started with the CData Python Connector for Bitbucket
Learn to install and license the CData Python Connector and configure a connection to live Bitbucket data.
-
Connect to Real-Time Gmail Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Gmail and Dataflow to import and use Gmail data in Power Apps.
-
Visualize Klipfolio 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 Klipfolio data into TIBCO Spotfire.
-
Connect to Dynamics CRM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Dynamics CRM and the SQL Gateway to access Dynamics CRM data from Google Apps Script.
-
How to Access Live Google Search Results in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Search enables you to integrate Google Search results into workflows built using Microsoft Power Automate Desktop.
-
Visualize FHIR 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 FHIR data into TIBCO Spotfire.
-
Establish a Live Connection with Odoo Data using Tableau Bridge
The CData ODBC Driver for Odoo enables you to integrate live Odoo data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate with Google Drive Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Drive data in SnapLogic.
-
Connect to Sage 200 Data from Crystal Reports
Use CData Connect AI to connect to and report on live Sage 200 data from Crystal Reports.
-
Create Apps from Power BI XMLA Data in Qlik Sense Cloud
Use CData Connect AI to connect to Power BI XMLA Data and build apps from live Power BI XMLA data in Qlik Sense Cloud.
-
Build Visualizations of Jumpseller Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Jumpseller data in Birst.
-
Connect to Email from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Email data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Work with Zoho CRM Data in FoxPro
Load Zoho CRM data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automate PabblySubscriptions Integration Tasks from PowerShell
Are you in search of a quick and easy way to access PabblySubscriptions data from PowerShell? This article demonstrates how to utilize the PabblySubscriptions Cmdlets for tasks like connecting to PabblySubscriptions data, automating operations, downloading data, and more.
-
Integrate Live SAS xpt Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAS xpt from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAS xpt data.
-
Integrating Cursor with Spotify 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.
-
Analyze Printify Data in Cognos Analytics
Use CData Connect AI to connect to Printify Data from Cognos Analytics and analyze live Printify data.
-
Access Microsoft Dataverse Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Dataverse data from HeidiSQL.
-
Query Live Acumatica 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 Acumatica data directly from the development environment.
-
Bidirectional Access to Redis Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Redis data in Filemaker Pro for Mac or Windows.
-
Integrating Dataiku with QuickBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live QuickBooks data.
-
Migrating data from Oracle Sales to Google BigQuery using CData SSIS Components.
Easily push Oracle Sales data to Google BigQuery using the CData SSIS Tasks for Oracle Sales and Google BigQuery.
-
Connect to Everhour Data in RapidMiner
Integrate Everhour data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Close with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Close with External Services.
-
Build Semantic Layer Views for Xero Data in APOS Live Data Gateway
Use the CData Connector for Xero in APOS Live Data Gateway to build Semantic Layer Views for Xero data.
-
ETL SQL Server in Oracle Data Integrator
This article shows how to transfer SQL Server data into a data warehouse using Oracle Data Integrator.
-
Integrate Google's Vertex AI Agent with Live xBase 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 xBase data within intelligent workflows.
-
Replicate PDFMonkey Data to Multiple Databases via the CData Sync CLI
Replicate PDFMonkey data to disparate databases with a single configuration.
-
Automate Neo4J Data Replication to SAP HANA
Use CData Sync to customize and automate Neo4J data replication to SAP HANA.
-
Getting Started with the CData ADO.NET Provider for Suadeo
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Suadeo.
-
How to connect to NASA Data in DBVisualizer
Integrate NASA data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect to LightSpeedRetail Data from Spring Boot
Connect to LightSpeedRetail in a Spring Boot Application using the CData API Driver for JDBC
-
Use ChatGPT to Talk to Your Sugar CRM 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 Sugar CRM data for you.
-
Getting Started with the CData JDBC Driver for Miro
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Miro.
-
Analyze GraphQL Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of GraphQL data and visualize live GraphQL data in Infragistics Reveal.
-
A PostgreSQL Interface for NASA Data (MySQL Remoting via JDBC)
Use the Remoting features of the NASA JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect Databricks to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Databricks with IBM WebSphere for seamless data integration and connectivity.
-
Use Azure AI Foundry to Talk to Your Testmonitor 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 Testmonitor data for you.
-
How to Build an ETL App for IBM Informix Data in Python with CData Connect AI
Build ETL pipelines that read and write live IBM Informix data in Python with petl and the CData Connect AI Python SDK.
-
Connecting Mastra with HCL Domino Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time HCL Domino data, no replication required.
-
Create LinkedIn-Connected Applications in Appsmith
Connect to LinkedIn Data via CData Connect AI in Appsmith and create custom business applications with real-time access to LinkedIn data.