CData Software - Knowledge Base
Recent Articles
-
Stream BenchmarkEmail Data into Apache Kafka Topics
Access and stream BenchmarkEmail data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous SQL Server Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SQL Server replication to Google Cloud SQL.
-
Create Power BI Reports on Real-Time ConvertKit Data
Use the CData ODBC Driver for ConvertKit to visualize ConvertKit data in Power BI Desktop.
-
Automated Continuous Onfleet Replication to Databricks
Use CData Sync for automated, continuous, customizable Onfleet replication to Databricks.
-
Integrate Goose with Live Kafka Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Kafka data from within the local AI agent.
-
Automated Continuous Copper Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Copper replication to Amazon S3.
-
Automated Continuous HelloSign Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable HelloSign replication to delimited files (CSV/TSV).
-
Automated Continuous Azure Blob Storage Replication to MongoDB
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to MongoDB.
-
Build Dashboards with Mailgun Data in Dundas BI
Create dynamic dashboards and perform analytics based on Mailgun data in Dundas BI.
-
How to Build an ETL App for Smartsheet Data in Python with CData
Create ETL applications and real-time data pipelines for Smartsheet data in Python with petl.
-
Build an OLAP Cube in SSAS from Google Calendar Data
Establish a connection to Google Calendar data data from SQL Server Analysis Services, and use the Google Calendar Data Provider to build OLAP cubes for use in analytics and reporting.
-
Getting Started with the CData ADO.NET Provider for SharePoint Excel Services
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SharePoint Excel Services.
-
Access Live Asana Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Asana data from your Google Sheets.
-
Migrating data from MongoDB to Databricks using CData SSIS Components.
Easily push MongoDB data to Databricks using the CData SSIS Tasks for MongoDB and Databricks.
-
Using the CData Software ODBC Driver for OData in PyCharm
Connect to OData as an ODBC data source in PyCharm using the CData Software ODBC Driver for OData.
-
Connect to Snowflake Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Snowflake and the Script function in FileMaker Pro to connect to Snowflake and work with Snowflake data in your FileMaker application.
-
Integrate Perplexity with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Perplexity with External Services.
-
How to import Blackbaud FE NXT Data into Apache Solr
Use the CData Software JDBC Driver for Blackbaud FE NXT in Data Import Handler and create an automated import of Blackbaud FE NXT data to Apache Solr Enterprise Search platform.
-
How to Visualize Dropbox 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 Dropbox data in Python.
-
Replicate Multiple Front Accounts
Replicate multiple Front accounts to one or many databases.
-
Integrate Open WebUI with Live Jumpseller Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Jumpseller data from within the chat interface.
-
Integrate Live Active Directory Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Active Directory data and integrate live Active Directory data into apps built in Microsoft Power Apps.
-
Rapidly Develop Exa-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 Exa.
-
Automated Continuous QuickBooks Replication to AlloyDB
Use CData Sync for automated, continuous, customizable QuickBooks replication to AlloyDB.
-
Build Freshservice Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Freshservice data and build visualizations in Tableau Cloud.
-
Publish Crystal Reports on Coinbase Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Coinbase data.
-
How to publish and share ShipEngine Data dashboards with Tableau Server
The CData ODBC driver for ShipEngine enables you integrate ShipEngine data into Tableau dashboards.
-
Publish Parallel-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Parallel data.
-
Use JayDeBeApi to access Jira Assets Data in Python
Use standard Python scripting and the development environment of your choice to access live Jira Assets data.
-
Connect to ConvertAPI Data in NetBeans
Connect to ConvertAPI data in NetBeans with the data source configuration wizard.
-
Visualize Live Adobe Commerce Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Adobe Commerce data into custom reports in Power BI.
-
Query Adobe Experience Manager Data in ColdFusion
Write standard ColdFusion data access code to connect to Adobe Experience Manager data.
-
Integrate Freshservice with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Freshservice with External Services.
-
Integrating OpenCode with Apollo 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.
-
Import Real-Time JobNimbus Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use JobNimbus data in ColdFusion.
-
Integrating LangChain with CapsuleCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on CapsuleCRM data within automated workflows.
-
Integrating LangGraph with Lakebase Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Lakebase data within automated workflows.
-
Create Reports from Pipedrive Data in Looker Studio
Use CData Connect AI to gain access to live Pipedrive data and create custom reports in Looker Studio.
-
Automated Continuous CloudConvert Replication to SingleStore
Use CData Sync for automated, continuous, customizable CloudConvert replication to SingleStore.
-
Automate Vault CRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Vault CRM data from PowerShell? This article demonstrates how to utilize the Vault CRM Cmdlets for tasks like connecting to Vault CRM data, automating operations, downloading data, and more.
-
Query, Visualize, and Share live Dropbox Data in Redash
Use CData Connect AI to connect to live Dropbox data in Redash for querying, visualizing, and sharing.
-
Integrate OpenCode with Live SAP Business One Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live SAP Business One data from within your AI coding agent.
-
Model Sage 200 Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Sage 200, enabling the direct import of real-time Sage 200 data.
-
Build AI/ML Models with Live SendGrid Data using Dataiku
Connect SendGrid Data with Dataiku using the CData JDBC Driver for SendGrid.
-
Access Authorize.Net Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Authorize.Net data.
-
Connect to Odoo from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Odoo data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build an OLAP Cube in SSAS from XML Data
Establish a connection to XML data data from SQL Server Analysis Services, and use the XML Data Provider to build OLAP cubes for use in analytics and reporting.
-
Replicate Amazon Athena Data to Multiple Databases
Replicate Amazon Athena data to disparate databases with a point-and-click configuration.
-
Integrate Live ActiveCampaign Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live ActiveCampaign data from within the IDE.
-
Automated Continuous Email Replication to Snowflake
Use CData Sync for automated, continuous, customizable Email replication to Snowflake.
-
Import and Visualize Landbot Data in Power View
Create data visualizations based on Landbot data in Excel.
-
Load Workday Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Workday data to a database.
-
Connect to Real-Time Freshservice Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Freshservice data in Power Apps.
-
How to connect PolyBase to Google Search
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Search results.
-
Automated Continuous Google Ad Manager Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to AlloyDB.
-
Add AgileCRM Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for AgileCRM with the Informatica Enterprise Data Catalog to classify and organize data.
-
Deploy the ADO.NET Provider for Yelp on an SSRS Report Server
Connect to Yelp 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.
-
Access FreeAgent Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for FreeAgent data.
-
Publish PDFMonkey-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live PDFMonkey data.
-
Connect to Live Tavily Data in MicroStrategy through CData Connect AI
Create a live connection to Tavily Data in CData Connect AI and connect to your Tavily data from MicroStrategy.
-
Build AI/ML Models with Live Reply.io Data using Dataiku
Connect Reply.io Data with Dataiku using the CData API Driver for JDBC.
-
Analyze TaxJar Data in Looker
Use CData Connect AI to connect to TaxJar Data from Looker and build custom apps using live TaxJar data.
-
Use Dash to Build to Web Apps on Freshservice Data
Create Python applications that use pandas and Dash to build Freshservice-connected web apps.
-
Stream Nuclia Data into Apache Kafka Topics
Access and stream Nuclia data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to FHIR Data in ACL Analytics
Connect to FHIR data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to FHIR data.
-
Import and Visualize Deel Data in Power View
Create data visualizations based on Deel data in Excel.
-
Use Grok to Talk to Your Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Instagram data for you.
-
Migrating data from CampaignMonitor to Google BigQuery using CData SSIS Components.
Easily push CampaignMonitor data to Google BigQuery using the CData SSIS Tasks for CampaignMonitor and Google BigQuery.
-
Use JayDeBeApi to access Splunk Data in Python
Use standard Python scripting and the development environment of your choice to access live Splunk data.
-
3 Ways to Integrate External Data Sources with FileMaker via CData ODBC Drivers
Three ways to connect Claris FileMaker to external data via CData ODBC Drivers: ODBC import, FileMaker scripting, and live ESS through the SQL Gateway.
-
How to connect to AdRoll Data with Squirrel SQL client
Connect to AdRoll data and execute queries in the Squirrel SQL Client.
-
Connecting Moonlit Workflow with Excel Online 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 Excel Online data in real time.
-
How to connect to Freshteam Data in DBVisualizer
Integrate Freshteam data with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData Software ODBC Driver for ConstantContact in SAS for Real-Time Reporting and Analytics
Connect to real-time ConstantContact data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ConstantContact.
-
How to connect to Scrapfly Data from Spring Boot
Connect to Scrapfly in a Spring Boot Application using the CData API Driver for JDBC
-
Connecting GenSpark with Supabase Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Supabase data without any replication or custom integration required.
-
Query, Visualize, and Share live IBM Informix Data in Redash
Use CData Connect AI to connect to live IBM Informix data in Redash for querying, visualizing, and sharing.
-
How to publish and share OpenWeatherMap Data dashboards with Tableau Server
The CData ODBC driver for OpenWeatherMap enables you integrate OpenWeatherMap data into Tableau dashboards.
-
Access Live PostgreSQL Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate PostgreSQL data into the statistical analysis tools available in SAS JMP. This article shows how to use PostgreSQL data in the Graph Builder and Query Builder.
-
Access Live GitLab Data in AWS Lambda (with IntelliJ IDEA)
Connect to live GitLab data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build an OLAP Cube in SSAS from Azure Data Lake Storage Data
Establish a connection to Azure Data Lake Storage data data from SQL Server Analysis Services, and use the Azure Data Lake Storage Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Notion in SpagoBI
Create reports featuring live Notion data in SpagoBI Studio. Host Notion reports on SpagoBI Server.
-
Access Greenhouse Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Greenhouse data.
-
How to Work with Okta Data in ETL Validator JDBC
Connect to Okta from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect to Figshare Data with Squirrel SQL client
Connect to Figshare data and execute queries in the Squirrel SQL Client.
-
Natively Connect to QuickBooks Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to QuickBooks data. Leverage the native support for ODBC in PHP.
-
Query Everhour Data in DataGrip
Create a Data Source for Everhour in DataGrip and use SQL to query live Everhour data.
-
Getting Started with the CData ODBC Driver for Instagram
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Instagram.
-
Model, Search, and Visualize Live Discord Data in ThoughtSpot
Use CData Connect AI to connect to live Discord data for modeling, searching, and visualizing.
-
Publish Reports with Yelp Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Yelp data.
-
How to Connect to & Open Timely Data in Microsoft Excel
This article uses the CData ODBC driver for Timely to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Provide OData Services of Google Translate Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Translate data by developing a WCF Service Application.
-
Create Informatica Mappings From/To an ODBC Data Source for Sendwithus
Create an ODBC connection to Sendwithus in Informatica and browse and transfer Sendwithus data.
-
How to Connect to Live QuickBooks Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your QuickBooks data for you.
-
Automate Salesforce CRM Analytics Data Replication to Azure Synapse
Use CData Sync to customize and automate Salesforce CRM Analytics data replication to Azure Synapse.
-
Automated Continuous Freshteam Replication to Oracle
Use CData Sync for automated, continuous, customizable Freshteam replication to Oracle.
-
DataBind Controls to HubDB Data in C++Builder
DataBind to HubDB data in C++Builder with standard components and controls.
-
Use JayDeBeApi to access GetResponse Data in Python
Use standard Python scripting and the development environment of your choice to access live GetResponse data.
-
Automate Procore Data Replication to SAP HANA
Use CData Sync to customize and automate Procore data replication to SAP HANA.
-
Getting Started with the CData Power BI Connector for Salesforce
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Salesforce.