CData Software - Knowledge Base
Recent Articles
-
Easily Integrate Insightly Data in Lazarus Pascal IDE
Learn how to easily integrate live Insightly data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to OData Services in Google Apps Script via SQL Gateway
Use the ODBC Driver for OData and the SQL Gateway to access OData services from Google Apps Script.
-
Publish Adobe Analytics-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Adobe Analytics data.
-
Automated Continuous Teradata Replication to SingleStore
Use CData Sync for automated, continuous, customizable Teradata replication to SingleStore.
-
Integrate Live Azure Data Catalog Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Azure Data Catalog data to Blue Prism using the CData ODBC Driver for Azure Data Catalog to create automated workflows for repetitive business tasks.
-
Automated MailerLite Data Replication to Teradata
Use CData Sync to Customize and automate MailerLite data replication to Teradata.
-
Automate ConvertKit Data Replication to Azure Data Lake
Use CData Sync to customize and automate ConvertKit data replication to Azure Data Lake.
-
Getting Started with the CData ODBC Driver for Zoho Recruit
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Zoho Recruit.
-
Using the CData Software ODBC Driver for Impala in PyCharm
Connect to Impala as an ODBC data source in PyCharm using the CData Software ODBC Driver for Impala.
-
Use the CData ODBC Driver for Presto in Microsoft Power Query
You can use the CData Presto ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Presto data into Microsoft Power Query.
-
Rapidly Develop SAP SuccessFactors-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 SAP SuccessFactors.
-
How to Build an ETL App for Redshift Data in Python with CData
Create ETL applications and real-time data pipelines for Redshift data in Python with petl.
-
Build Automated Workflows with Live Samanage Data in Workato
Use CData Connect AI to connect to live Samanage data and build automated workflows in Workato.
-
Query Suadeo Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Suadeo data from Node.js.
-
Build Semantic Layer Views for Klaviyo Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Klaviyo data.
-
Create a Data Access Object for WooCommerce Data using JDBI
A brief overview of creating a SQL Object API for WooCommerce data in JDBI.
-
Connect to Helpscout Data from a Connection Pool in Jetty
The Helpscout JDBC Driver supports connection pooling: This article shows how to connect faster to Helpscout data from Web apps in Jetty.
-
Replicate Microsoft Entra ID Data from PowerShell
Write a quick PowerShell script to query Microsoft Entra ID data. Use connectivity to the live data to replicate Microsoft Entra ID data to SQL Server.
-
Getting Started with the CData Excel Add-In for SQL Server
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SQL Server.
-
Automated Oracle Service Cloud Data Replication to Teradata
Use CData Sync to Customize and automate Oracle Service Cloud data replication to Teradata.
-
Automated Continuous WooCommerce Replication to SQLite
Use CData Sync for automated, continuous, customizable WooCommerce replication to SQLite.
-
Use Azure AI Foundry to Talk to Your Cosmos DB 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 Cosmos DB data for you.
-
Use the CData Software JDBC Driver for Pinecone in MicroStrategy Desktop
Connect to Pinecone data in MicroStrategy Desktop using the CData Software JDBC Driver for Pinecone.
-
Use Manus AI to Talk to Your SAP HANA XS Advanced Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on SAP HANA XS Advanced data.
-
Connect to Recurly Data in JRuby
Create a simple JRuby app with access to live Recurly data.
-
Model, Search, and Visualize Live Jira Assets Data in ThoughtSpot
Use CData Connect AI to connect to live Jira Assets data for modeling, searching, and visualizing.
-
Connect to and Query Sendwithus Data in QlikView over ODBC
Create data visualizations with Sendwithus data in QlikView.
-
Getting Started with the CData Excel Add-In for Short.io
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Short.io.
-
Replicate Customer.io Data to Multiple Databases
Replicate Customer.io data to disparate databases with a point-and-click configuration.
-
Publish NetSuite-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live NetSuite data.
-
Automated Continuous Tanda Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Tanda replication to PostgreSQL.
-
Integrating Claude Code with Salesforce CRM Analytics Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Salesforce CRM Analytics data within assisted coding and automated development workflows.
-
How to Build an ETL App for Paymo Data in Python with CData
Create ETL applications and real-time data pipelines for Paymo data in Python with petl.
-
Automated Continuous Phoenix Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Phoenix data replication to OneLake in Microsoft Fabric.
-
Write a Simple Go Application to work with Bullhorn CRM Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Bullhorn CRM data.
-
How to Connect Optimizely 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 Optimizely data in real time using natural language.
-
Query Microsoft OneDrive Data in ColdFusion
Write standard ColdFusion data access code to connect to Microsoft OneDrive data.
-
Automated Continuous Raisers Edge NXT Replication to SQLite
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to SQLite.
-
Deploy the ADO.NET Provider for Teamwork on an SSRS Report Server
Connect to Teamwork 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 AI/ML Models with Live QuickBooks Online Data using Dataiku
Connect QuickBooks Online Data with Dataiku using the CData JDBC Driver for QuickBooks Online.
-
Replicate Basecamp Data to Multiple Databases
Replicate Basecamp data to disparate databases with a point-and-click configuration.
-
Explore Geographical Relationships in Elasticsearch Data with Power Map
Create data visualizations with Elasticsearch data in Power Map.
-
Building Dynamic Web Pages with Greenhouse Data Using AngularJS
Create single-page applications with live connectivity to Greenhouse using the CData API Server.
-
Process & Analyze Tickspot Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Tickspot Data.
-
Rapidly Develop Zoho CRM-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 Zoho CRM.
-
How to Visualize Bright Data Data in Python with pandas
Use pandas and other modules to analyze and visualize live Bright Data data in Python.
-
Spring4Shell Overview
CData is aware of the recently disclosed CVE-2022-22963, a remote code execution in Spring Cloud Function by malicious Spring Expression Spring4Shell (CVE-2022-22965).
-
Access Live Zoho CRM Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Zoho CRM data into the statistical analysis tools available in SAS JMP. This article shows how to use Zoho CRM data in the Graph Builder and Query Builder.
-
DataBind Controls to CockroachDB Data in Delphi
DataBind to CockroachDB data in Delphi with standard data access components and controls.
-
Publish Spotify-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Spotify data.
-
Operational Reporting on PDFMonkey Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote PDFMonkey data.
-
Analyze ConvertAPI Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ConvertAPI from Power Pivot. You will use the Table Import Wizard to load ConvertAPI data. You can visually build the import query or use any SQL supported by the driver.
-
Automate Facebook Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Facebook data from PowerShell? This article demonstrates how to utilize the Facebook Cmdlets for tasks like connecting to Facebook data, automating operations, downloading data, and more.
-
Connecting GenSpark with Presto Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Presto data without any replication or custom integration required.
-
Automated Continuous Elasticsearch Replication to Snowflake
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Snowflake.
-
Create Cvent-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Cvent Data from OutSystems and build custom enterprise apps using live Cvent data.
-
Use ChatGPT to Talk to Your Amazon Athena 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 Amazon Athena data for you.
-
Access Live Quickbase Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Quickbase data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Building Dynamic Web Pages with Pipedrive Data Using AngularJS
Create single-page applications with live connectivity to Pipedrive using the CData API Server.
-
Work with Live BambooHR Data in Power Query
Use CData Connect AI to connect to BambooHR data and work with live BambooHR data in Microsoft Power Query.
-
How to integrate Metabase with Presto Data
Use CData Connect AI to connect to live Presto data and create an interactive dashboard in Metabase from Presto data.
-
Build Automated Workflows with Live LDAP Objects in Workato
Use CData Connect AI to connect to live LDAP objects and build automated workflows in Workato.
-
How to Connect to Live Amazon DynamoDB 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 Amazon DynamoDB data through natural language.
-
Connect to Microsoft Entra ID Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Microsoft Entra ID data from Filemaker Pro on Mac.
-
Connect and Query Live Gmail Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Gmail data into Databricks and enable direct, live querying and analysis without replication.
-
How to Use a Microsoft Access Database to Update Facebook Data in Real Time
Update Facebook data by creating a linked table in Microsoft Access with the CData Facebook ODBC Driver.
-
Connect to JSON Services in Jaspersoft Studio
Execute SQL to remote JSON services in Jaspersoft Studio.
-
How to Work with Mailjet Data in AWS Glue Jobs Using JDBC
Connect to Mailjet from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect to & Open MongoDB Data in Microsoft Excel
This article uses the CData ODBC driver for MongoDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automate Office 365 Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Office 365 data from PowerShell? This article demonstrates how to utilize the Office 365 Cmdlets for tasks like connecting to Office 365 data, automating operations, downloading data, and more.
-
Automated Continuous Microsoft Teams Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to AlloyDB.
-
Migrating data from Authorize.Net to Google BigQuery using CData SSIS Components.
Easily push Authorize.Net data to Google BigQuery using the CData SSIS Tasks for Authorize.Net and Google BigQuery.
-
Query Planio Data in ColdFusion
Write standard ColdFusion data access code to connect to Planio data.
-
Access Live Google Forms Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Forms data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Live Snapchat Ads Data in AWS Lambda
Connect to live Snapchat Ads data in AWS Lambda using the CData JDBC Driver.
-
Explore Geographical Relationships in MySQL Data with Power Map
Create data visualizations with MySQL data in Power Map.
-
Connect Discourse to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Discourse with IBM WebSphere for seamless data integration and connectivity.
-
Natively Connect to Eventbrite Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Eventbrite data. Leverage the native support for ODBC in PHP.
-
Migrating data from Discord to Databricks using CData SSIS Components.
Easily push Discord data to Databricks using the CData SSIS Tasks for Discord and Databricks.
-
Replicate Multiple Vimeo Accounts
Replicate multiple Vimeo accounts to one or many databases.
-
How to Connect API 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 API data in real time using natural language.
-
Analyze Eventbrite Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Eventbrite data in Microsoft R Open.
-
Prepare, Blend, and Analyze Rootly Data in Alteryx Designer (ODBC)
Build workflows to access live Rootly data for self-service data analytics.
-
Visualize Front Data in Tableau
The CData ODBC driver for Front enables you integrate Front data into Tableau dashboards.
-
Analyze Adobe Target Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Adobe Target data and visualize Adobe Target data in SAP Analytics Cloud.
-
Integrate Dify with Live SAP HANA Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live SAP HANA data.
-
How to Connect Flowise AI Agents to Live Klipfolio 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 Klipfolio data without replication.
-
Build a PostgreSQL Interface for Templated Data using the CData JDBC Driver
Use the Remoting features of the Templated JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Sybase Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Sybase entities in PHP by modeling them as objects.
-
How to connect to Slack Data in DBVisualizer
Integrate Slack data with visual data analysis tools and data connection wizards in DBVisualizer
-
A PostgreSQL Interface for LDAP Objects using the CData ODBC Driver
Use the SQL Gateway and LDAP ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build eBay Analytics-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to eBay Analytics Data from Zoho Analytics and import live eBay Analytics data.
-
Create SAP Business Warehouse-Connected Nintex Workflows
Use CData Connect AI to connect to SAP Business Warehouse Data from Nintex Workflow Cloud and build custom workflows using live SAP Business Warehouse data.
-
Build OneNote-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for OneNote Data and create custom apps in Mendix.
-
Connect and Query Live Tally Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Tally data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to Foursquare in SpagoBI
Create reports featuring live Foursquare data in SpagoBI Studio. Host Foursquare reports on SpagoBI Server.
-
Use the CData Software ODBC Driver for QuickBooks Online in MicroStrategy Desktop
Connect to QuickBooks Online data in MicroStrategy Desktop using the CData Software ODBC Driver for QuickBooks Online.
-
Integrate Live Pushbullet Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Pushbullet data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Connect to Live GraphQL Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your GraphQL data for you.
-
Integrating Gumloop with Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Avalara AvaTax data within automated workflows.