CData Software - Knowledge Base
Recent Articles
-
How to use SQLAlchemy ORM to access Sentry Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sentry data.
-
Build Dashboards with Aweber Data in DBxtra
Create dynamic dashboards and perform analytics based on Aweber data in DBxtra.
-
Add Couchbase Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Couchbase with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData ODBC Driver for Optimizely
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Optimizely.
-
Build Agents in Relevance AI with Access to Live iContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on iContact data within intelligent agent workflows.
-
Build Sage Cloud Accounting Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Sage Cloud Accounting data and build visualizations in Tableau.
-
Build Office 365 Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Office 365 data and build visualizations in Tableau Cloud.
-
Migrating data from Guru to Google BigQuery using CData SSIS Components.
Easily push Guru data to Google BigQuery using the CData SSIS Tasks for Guru and Google BigQuery.
-
Use Azure AI Foundry to Talk to Your Apollo 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 Apollo data for you.
-
Connect to Live Microsoft Dataverse Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Microsoft Dataverse in CData Connect AI and connect to your Microsoft Dataverse data from PostgreSQL.
-
Natively Connect to Oracle Eloqua Reporting Data in PHP
The CData ODBC driver for Oracle Eloqua Reporting enables you to create PHP applications with connectivity to Oracle Eloqua Reporting data. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData ADO.NET Provider for Oracle Eloqua
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Oracle Eloqua.
-
Connecting Mastra with Power BI XMLA 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 Power BI XMLA data, no replication required.
-
Access DocuSign Data from MySQL in PHP
Connect to DocuSign through the standard MySQL libraries in PHP.
-
Automated Continuous Salesforce CRM Analytics Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Apache Kafka.
-
Build an OLAP Cube in SSAS from JotForm Data
Establish a connection to JotForm data data from SQL Server Analysis Services, and use the JotForm Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to SAP Business One Data in Aqua Data Studio
Access SAP Business One data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Import IBM Informix Data Using Azure Data Factory
Use CData Connect AI to connect to IBM Informix Data from Azure Data Factory and import live IBM Informix data.
-
How to Seamlessly Import AlloyDB Data into IBM SPSS Modeler
Integrate AlloyDB data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create SendInBlue Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SendInBlue from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Discord Data in JRuby
Create a simple JRuby app with access to live Discord data.
-
Back Up Invoiced data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Invoiced data data.
-
Connect to Codat Data from PowerBuilder via JDBC
This article demonstrates how to access Codat data from PowerBuilder using the Codat JDBC Driver.
-
Jodoo Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Jodoo facts in real time.
-
Use Microsoft Copilot Studio to talk to your Perplexity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Perplexity data for you.
-
Visualize Hive Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Hive data.
-
Integrating Aha! Data in Talend Cloud Data Management Platform
Connect Aha! Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Import Real-Time SendPulse Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SendPulse data in ColdFusion.
-
Create Informatica Mappings From/To an ODBC Data Source for Tickspot
Create an ODBC connection to Tickspot in Informatica and browse and transfer Tickspot data.
-
Use CData Connect AI to Access Sugar CRM Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Sugar CRM data in the Power Pivot business intelligence tool.
-
Excel Spreadsheet Automation on QuickBooks Time Data with the QUERY Formula
Pull data from QuickBooks Time, automate spreadsheets, and more with the QUERY formula.
-
Integrating Gumloop with Yelp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Yelp data within automated workflows.
-
Rapidly Develop Short.io-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 Short.io.
-
Connect to CloudConvert Data in RazorSQL
Connect to CloudConvert from wizards and query CloudConvert data from the GUI in the RazorSQL database management tool.
-
Easily Integrate ClickTime Data in Lazarus Pascal IDE
Learn how to easily integrate live ClickTime data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect Google Ads to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Ads data using the CData Python MCP Server.
-
Connect to Templated 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 Templated and work with Templated data in your FileMaker application.
-
Connect to Sybase IQ Data in Claris FileMaker Pro
Use the CData ODBC Driver for Sybase IQ in FileMaker Pro to connect to Sybase IQ and work with Sybase IQ data in your FileMaker applications.
-
Visualize Live Zuora Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Zuora data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Moving Data from Cohere to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Cohere data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Databricks Agent Bricks to Talk to Your Jumpseller Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Jumpseller data for you.
-
Build Semantic Layer Views for BambooHR Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for BambooHR data.
-
Integrate OpenCode with Live VWO Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live VWO data from within your AI coding agent.
-
How to connect to Vimeo Data in DBVisualizer
Integrate Vimeo data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Pipelines with Live Azure Analysis Services Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Azure Analysis Services from Google Cloud Data Fusion, enabling the integration of live Azure Analysis Services data into the building and management of effective data pipelines.
-
Connecting Mastra with Yelp 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 Yelp data, no replication required.
-
Create JSON Dataflows on PowerBI.com
Connect to the CData Power BI Connector for JSON from PowerBI.com to create Power BI Dataflows with real-time data.
-
DataBind Tally Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Tally with the DevExpress Windows Forms and Web controls to provide Tally data to a chart.
-
Build Jira Assets Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Jira Assets data and build visualizations in Tableau.
-
Build AI/ML Models with Live Adobe Commerce Data using Dataiku
Connect Adobe Commerce Data with Dataiku using the CData JDBC Driver for Adobe Commerce.
-
Query, Visualize, and Share live GraphQL Data in Redash
Use CData Connect AI to connect to live GraphQL data in Redash for querying, visualizing, and sharing.
-
Publish Qualaroo-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Qualaroo data.
-
Enable the OneNote JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with OneNote data.
-
How to Connect to & Open QuickBooks Data in Microsoft Excel
This article uses the CData ODBC driver for QuickBooks to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Kintone Data in the Pentaho Report Designer
Publish reports based on Kintone data in the Pentaho BI tool.
-
How to connect and process Azure Data Catalog data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Azure Data Catalog data.
-
How to Connect to Live Avro 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 Avro data for you.
-
Establish a Live Connection with Mixpanel Data using Tableau Bridge
The CData ODBC Driver for Mixpanel enables you to integrate live Mixpanel data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to ZohoPeople Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ZohoPeople and the SQL Gateway to access ZohoPeople data from Google Apps Script.
-
How to Access Live Sage 300 Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Sage 300 enables you to integrate Sage 300 data into workflows built using Microsoft Power Automate Desktop.
-
Build AI/ML Models with Live NASA Data using Dataiku
Connect NASA Data with Dataiku using the CData API Driver for JDBC.
-
Publish MySQL-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live MySQL data.
-
How to Connect to Live Marketo Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Marketo data for you.
-
How to Connect to Live Cloudant Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Cloudant data without replication.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Azure DevOps
Provide connectivity to Azure DevOps data through an SAP BusinessObjects universe.
-
Build Data Flows from Zuora to SQL Server using SSIS
Easily back up Zuora data to SQL Server using the SSIS components for Zuora.
-
Connect to Google Translate Data in CloverDX (formerly CloverETL)
Transfer Google Translate data using the visual workflow in the CloverDX data integration tool.
-
Connect to SurveyMonkey Data in RapidMiner
Integrate SurveyMonkey data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Sugar CRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Sugar CRM replication to IBM DB2.
-
Integrate Cline with Live Figshare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Figshare data from within your IDE.
-
Automated Continuous Mode Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Mode replication to Amazon Redshift.
-
Connect to Real-Time GetResponse Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use GetResponse data in Power Apps.
-
Build a Simple VCL Application for Airtable Data
How to build a simple VCL Application to view Airtable data in RAD Studio using the CData ODBC Driver for Airtable.
-
How to Work with Autopilot Data in ETL Validator JDBC
Connect to Autopilot from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating Short.io Data in Talend Cloud Data Management Platform
Connect Short.io Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build GraphQL-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to GraphQL Data from Zoho Analytics and import live GraphQL data.
-
Write a Simple Go Application to work with OnePageCrm Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to OnePageCrm data.
-
Automated Continuous Tanda Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Tanda replication to Amazon S3.
-
Automated Continuous Greenhouse Replication to Oracle
Use CData Sync for automated, continuous, customizable Greenhouse replication to Oracle.
-
Build a Simple VCL Application for iContact Data
How to build a simple VCL Application to view iContact data in RAD Studio using the CData ODBC Driver for iContact.
-
Automated Continuous CSV Replication to Vertica
Use CData Sync for automated, continuous, customizable CSV replication to Vertica.
-
Analyze Odoo Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Odoo from Power Pivot. You will use the Table Import Wizard to load Odoo data. You can visually build the import query or use any SQL supported by the driver.
-
Viewing Elorus Data in RAD Studio Data Explorer
How to view Elorus data in RAD Studio Data Explorer using the CData ODBC Driver for Elorus.
-
Build Data Flows from Float to SQL Server using SSIS
Easily back up Float data to SQL Server using the SSIS components for Float.
-
Automated Continuous JobNimbus Replication to SQLite
Use CData Sync for automated, continuous, customizable JobNimbus replication to SQLite.
-
Build Apps with Live Flowlu Data Using the Low-Code Development Platform of Mendix
Connect Flowlu data with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Salesforce Replication to MySQL
Use CData Sync for automated, continuous, customizable Salesforce replication to MySQL.
-
Integrate Salesforce Marketing Data in Pentaho Data Integration
Build ETL pipelines based on Salesforce Marketing data in the Pentaho Data Integration tool.
-
Analyze Acumatica Data in Cognos Analytics
Use CData Connect AI to connect to Acumatica Data from Cognos Analytics and analyze live Acumatica data.
-
Use the CData Software JDBC Driver for Act CRM in MicroStrategy
Connect to Act CRM data in MicroStrategy Developer using the CData Software JDBC Driver for Act CRM.
-
Getting Started with the CData JDBC Driver for Sentry
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Sentry.
-
Automated Continuous Microsoft Entra ID Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to Google BigQuery.
-
How to connect SharePoint with Wave Financial Data through external lists
Provide Wave Financial data to SharePoint users as an external list.
-
Build xBase Visualizations in Tableau Cloud
Use CData Connect AI to connect to live xBase data and build visualizations in Tableau Cloud.
-
SAP Hybris C4C Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP Hybris C4C data through CData Connect AI using different applications and tools.
-
Connect to OneNote Data in NetBeans
Connect to OneNote data in NetBeans with the data source configuration wizard.
-
Getting Started with the CData Connect AI Python SDK for Vault CRM
Install the CData Connect AI Python SDK to read and write live Vault CRM data with standard DB-API 2.0 Python code.
-
Easily Integrate Microsoft Exchange Data in Lazarus Pascal IDE
Learn how to easily integrate live Microsoft Exchange data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automate ZohoMarketingHub Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ZohoMarketingHub data from PowerShell? This article demonstrates how to utilize the ZohoMarketingHub Cmdlets for tasks like connecting to ZohoMarketingHub data, automating operations, downloading data, and more.
-
Build Data Flows from Pushbullet to SQL Server using SSIS
Easily back up Pushbullet data to SQL Server using the SSIS components for Pushbullet.