CData Software - Knowledge Base
Recent Articles
-
Connecting Pipedream with Gmail 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 Gmail data in real time.
-
Build Automated Cvent-Connected Workflows in Zapier
Use CData Connect AI to connect to live Cvent data and build automated workflows in Zapier.
-
Build Elasticsearch-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Elasticsearch Data and create custom apps in Bubble.
-
How to Connect to & Open Perplexity Data in Microsoft Excel
This article uses the CData ODBC driver for Perplexity to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use Dash to Build to Web Apps on HelloSign Data
Create Python applications that use pandas and Dash to build HelloSign-connected web apps.
-
Connecting Moonlit Workflow with SendGrid Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SendGrid data in real time.
-
Connect to Perigon 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 Perigon and work with Perigon data in your FileMaker application.
-
Use Dash to Build to Web Apps on AlloyDB Data
Create Python applications that use pandas and Dash to build AlloyDB-connected web apps.
-
Query, Visualize, and Share live Sugar CRM Data in Redash
Use CData Connect AI to connect to live Sugar CRM data in Redash for querying, visualizing, and sharing.
-
Create SQL Analysis Services-Connected Applications in Appsmith
Connect to SQL Analysis Services Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SQL Analysis Services data.
-
How to Connect the Power BI Service to Freshteam: Complete Guide
Connect to the CData Software Power BI Connector for Freshteam from PowerBI.com to provide real-time Freshteam data across the organization.
-
Integrate Theia IDE with Live Sage Cloud Accounting 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 Sage Cloud Accounting data from within the development environment.
-
How to Work with Chargebee Data in AWS Glue Jobs Using JDBC
Connect to Chargebee from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Replicate Kafka Data to Multiple Databases
Replicate Kafka data to disparate databases with a point-and-click configuration.
-
How to Create Power BI Visual Reports with Real-Time Mocean Data
Use CData Power BI Connectors to visualize Mocean data in Power BI.
-
Access Live SAP HANA Data in AWS Lambda
Connect to live SAP HANA data in AWS Lambda using the CData JDBC Driver.
-
Import Anaplan Data Using Azure Data Factory
Use CData Connect AI to connect to Anaplan Data from Azure Data Factory and import live Anaplan data.
-
Visualize SAP HANA 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 SAP HANA data into TIBCO Spotfire.
-
Integrate SAP Fieldglass Data in the Pentaho Report Designer
Publish reports based on SAP Fieldglass data in the Pentaho BI tool.
-
Connect Okta to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Okta data using the CData Python MCP Server.
-
Work with Beeminder Data in FoxPro
Load Beeminder data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use Claude to Talk to Your Paymo 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 Paymo data for you.
-
Use the CData Software ODBC Driver for Amazon Marketplace in MicroStrategy Desktop
Connect to Amazon Marketplace data in MicroStrategy Desktop using the CData Software ODBC Driver for Amazon Marketplace.
-
Integrating Codex with Clari 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 Live Xero Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Xero data to Blue Prism using the CData ODBC Driver for Xero to create automated workflows for repetitive business tasks.
-
Integrate Customer.io Data in the Pentaho Report Designer
Publish reports based on Customer.io data in the Pentaho BI tool.
-
Automated ClickUp Data Replication to Teradata
Use CData Sync to Customize and automate ClickUp data replication to Teradata.
-
Automated Continuous ServiceDesk Plus Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ServiceDesk Plus replication to Google BigQuery.
-
Manage LDAP Objects in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for LDAP.
-
Query, Visualize, and Share live Dynamics 365 Data in Redash
Use CData Connect AI to connect to live Dynamics 365 data in Redash for querying, visualizing, and sharing.
-
Connect to SAP SuccessFactors Data in ACL Analytics
Connect to SAP SuccessFactors data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP SuccessFactors data.
-
Use the CData Software JDBC Driver for Outreach.io in MicroStrategy
Connect to Outreach.io data in MicroStrategy Developer using the CData Software JDBC Driver for Outreach.io.
-
Use the CData Software ODBC Driver for Planio in MicroStrategy
Connect to Planio data in MicroStrategy Developer using the CData Software ODBC Driver for Planio.
-
Automated Continuous Azure Blob Storage Replication to Oracle
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Oracle.
-
Use the CData ODBC Driver for Discourse in Microsoft Power Query
You can use the CData Discourse ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Discourse data into Microsoft Power Query.
-
Connect to Microsoft Ads Data from a Connection Pool in JBoss
Integrate Microsoft Ads data into Java servlets: Use the Management Console in JBoss to install the Microsoft Ads JDBC Driver.
-
Build Apps with Live ZohoExpense data in Adalo using CData Connect AI
Use CData Connect AI to integrate live ZohoExpense data into the Adalo platform and build custom mobile and web applications with real-time ZohoExpense data.
-
DataBind Timely Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Timely data to a chart.
-
Analyze Google Ads Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Ads from Power Pivot. You will use the Table Import Wizard to load Google Ads data. You can visually build the import query or use any SQL supported by the driver.
-
How to load Smartsheet data into Elasticsearch via Logstash
Introducing a simple method to load Smartsheet data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Basecamp-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Basecamp data and build web apps with connectivity to live Basecamp data.
-
Build YouTube Analytics-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for YouTube Analytics Data and create custom apps in Bubble.
-
Create iContact Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time iContact data access from reports, embedded analytics, and more.
-
Bridge VWO Connectivity with Apache NiFi
Access and process VWO data in Apache NiFi using the CData JDBC Driver.
-
Publish Crystal Reports on Figshare Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Figshare data.
-
Automate SAP BusinessObjects BI Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP BusinessObjects BI data from PowerShell? This article demonstrates how to utilize the SAP BusinessObjects BI Cmdlets for tasks like connecting to SAP BusinessObjects BI data, automating operations, downloading data, and more.
-
Automated Continuous eBay Analytics Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Azure SQL Database.
-
Automated Continuous Zoho Books Replication to MongoDB
Use CData Sync for automated, continuous, customizable Zoho Books replication to MongoDB.
-
Integrate Goose with Live Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Avro data from within the local AI agent.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Vimeo
Provide connectivity to Vimeo data through an SAP BusinessObjects universe.
-
Connect to Instagram Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Instagram to connect to Instagram data and execute queries in PowerBuilder.
-
Build Dashboards with Sage 200 Data in Dundas BI
Create dynamic dashboards and perform analytics based on Sage 200 data in Dundas BI.
-
Create Informatica Mappings From/To an ODBC Data Source for Zoho CRM
Create an ODBC connection to Zoho CRM in Informatica and browse and transfer Zoho CRM data.
-
Create Informatica Mappings From/To an ODBC Data Source for Webflow
Create an ODBC connection to Webflow in Informatica and browse and transfer Webflow data.
-
Automated Continuous Ontraport Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Ontraport replication to Apache Cassandra.
-
Connect to HBase Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for HBase data in the Denodo Virtual DataPort Administrator.
-
Using the CData Software ODBC Driver for Auth0 in PyCharm
Connect to Auth0 as an ODBC data source in PyCharm using the CData Software ODBC Driver for Auth0.
-
View Reports on Real-Time Smartsheet Data in Power BI Report Server
Use the CData ODBC Driver for Smartsheet to visualize Smartsheet data in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData Power BI Connector for eBay
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for eBay.
-
How to use SQLAlchemy ORM to access PostgreSQL Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of PostgreSQL data.
-
How to Work with Tickspot Data in ETL Validator JDBC
Connect to Tickspot from ETL Validator jobs using the CData Software JDBC Driver.
-
Build a Simple VCL Application for Miro Data
How to build a simple VCL Application to view Miro data in RAD Studio using the CData ODBC Driver for Miro.
-
Access Salesforce Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Salesforce data from your Oracle system.
-
A PostgreSQL Interface for Nuclia Data using the CData ODBC Driver
Use the SQL Gateway and Nuclia ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Adobe Analytics Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Adobe Analytics from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build a Simple VCL Application for OData Services
How to build a simple VCL Application to view OData services in RAD Studio using the CData ODBC Driver for OData.
-
How to connect PolyBase to Sage 300
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Sage 300 data.
-
Connect to Lakebase Data from HeidiSQL
Use CData Connect AI to connect to and query live Lakebase data from HeidiSQL.
-
Replicate Amplitude Data to Multiple Databases via the CData Sync CLI
Replicate Amplitude data to disparate databases with a single configuration.
-
Integrate Google's Antigravity Agent with Live Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Twilio data using the Model Context Protocol.
-
Back Up Google Search results to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Search. In this article, we will employ an SSIS workflow to populate a database with Google Search results data.
-
Back Up Google Ad Manager data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Ad Manager. In this article, we will employ an SSIS workflow to populate a database with Google Ad Manager data data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for HubSpot
Provide connectivity to HubSpot data through an SAP BusinessObjects universe.
-
Connect to Printify Data in HULFT Integrate
Connect to Printify as a JDBC data source in HULFT Integrate
-
DataBind Controls to PhantomBuster Data in Delphi
DataBind to PhantomBuster data in Delphi with standard data access components and controls.
-
How to import Paylocity Data into Apache Solr
Use the CData Software JDBC Driver for Paylocity in Data Import Handler and create an automated import of Paylocity data to Apache Solr Enterprise Search platform.
-
How to Access Live REST Data in Power Automate Desktop via ODBC
The CData ODBC Driver for REST enables you to integrate REST data into workflows built using Microsoft Power Automate Desktop.
-
Replicate Act CRM Data in Heroku for Use in Salesforce Connect
Replicate Act CRM data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Live eBay Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate eBay data into the statistical analysis tools available in SAS JMP. This article shows how to use eBay data in the Graph Builder and Query Builder.
-
Integrate Avalara AvaTax with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Avalara AvaTax with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Avalara AvaTax data.
-
Query Live Dynamics CRM 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 Dynamics CRM data directly from the development environment.
-
Use the CData Software ODBC Driver for QuickBooks in SAS for Real-Time Reporting and Analytics
Connect to real-time QuickBooks data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for QuickBooks.
-
How to connect to Printify Data from Spring Boot
Connect to Printify in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Attio Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Attio as an External Source in Dremio.
-
Consume Hive OData Feeds in PowerBuilder
This article demonstrates how to consume Hive data as OData feeds from PowerBuilder using the API Server.
-
How to Visualize Shopify Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Shopify data in Python.
-
Integrate with live Avro Data in Jitterbit
Use CData Connect AI to connect to and integrate live Avro data in Jitterbit.
-
Automate Zoho Projects Data Replication to Azure Synapse
Use CData Sync to customize and automate Zoho Projects data replication to Azure Synapse.
-
DataBind Controls to BenchmarkEmail Data in Delphi
DataBind to BenchmarkEmail data in Delphi with standard data access components and controls.
-
Connect and Query Live Twilio Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Twilio data into Databricks and enable direct, live querying and analysis without replication.
-
Working with Sage 200 Data in LINQPad
Execute LINQ queries to Sage 200 data in LINQPad.
-
Connect to Salesforce Data 360 Data from a Connection Pool in JBoss
Integrate Salesforce Data 360 data into Java servlets: Use the Management Console in JBoss to install the Salesforce Data 360 JDBC Driver.
-
Access Live Mode Data in Coginiti Pro
Connect to and query live Mode data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Visualize WordPress Data in Python with pandas
Use pandas and other modules to analyze and visualize live WordPress data in Python.
-
Use the CData Software JDBC Driver for Microsoft Entra ID in MicroStrategy Web
Connect to Microsoft Entra ID data in MicroStrategy Web using the CData Software JDBC Driver for Microsoft Entra ID.
-
Publish Crystal Reports on Apify Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Apify data.
-
Integrating GitHub Copilot with SQL Analysis Services 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 Visualize Shortcut Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Shortcut data in Python.
-
Connect to Microsoft Teams Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft Teams data in Airbyte.
-
Connect to Mailjet Data in RazorSQL
Connect to Mailjet from wizards and query Mailjet data from the GUI in the RazorSQL database management tool.