CData Software - Knowledge Base
Recent Articles
-
Automated Continuous ZohoInvoice Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to Google Cloud SQL.
-
Connect Mistral AI to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Mistral AI using the CData Python MCP Server.
-
Use the CData ODBC Driver for Snowflake in Microsoft Power Query
You can use the CData Snowflake ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Snowflake into Microsoft Power Query.
-
Seamlessly Bring Dropbox Data into Retool Using CData Connect AI
Integrate Dropbox data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
DataBind Charts to Moosend Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Moosend from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Query RabbitMQ Data from Node.js
Use the OData endpoint of the CData API Server to connect to your RabbitMQ and perform CRUD operations on RabbitMQ from Node.js.
-
Build Semantic Layer Views for Vimeo Data in APOS Live Data Gateway
Use the CData Connector for Vimeo in APOS Live Data Gateway to build Semantic Layer Views for Vimeo.
-
Choosing the Best Method to Connect Outreach.io to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Outreach.io from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Grok to Talk to Your Azure Table 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 Azure Table Storage for you.
-
Analyze RSS Feeds with Power Pivot
This article walks you through the process of using the CData ODBC Driver for RSS from Power Pivot. You will use the Table Import Wizard to load RSS Feeds. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Google Ad Manager Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Vertica.
-
Build MVC Applications with Connectivity to Printify Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Printify from an ASP.NET MVC application.
-
How to Connect to & Open Google Translate Data in Microsoft Excel
This article uses the CData ODBC driver for Google Translate to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to LaunchDarkly Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for LaunchDarkly in the Denodo Virtual DataPort Administrator.
-
Create Dashboards and Visualize Live Salesforce Pardot Data in Geckoboard
Use CData Connect AI to connect to live Salesforce Pardot and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build NetSuite-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for NetSuite to explore live NetSuite Data in Gemini Code Assist to assist with building NetSuite-powered applications.
-
A PostgreSQL Interface for ClickUp Data using the CData ODBC Driver
Use the SQL Gateway and ClickUp ODBC Driver to create a PostgreSQL entry-point for data access.
-
Import and Visualize Eventbrite Data in Power View
Create data visualizations based on Eventbrite in Excel.
-
Automated Continuous Zoho Books Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Zoho Books replication to Amazon S3.
-
Create Informatica Mappings From/To a JDBC Data Source for Copper
Create Copper data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData Python Connector for Bitly
Learn to install and license the CData Python Connector
-
Back Up Azure DevOps to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Azure DevOps. In this article, we will employ an SSIS workflow to populate a database with Azure DevOps data.
-
DataBind Charts to Quaderno Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Quaderno from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Publish Reports with JDBC-ODBC Bridge Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date JDBC-ODBC Bridge.
-
Automate Spark Data Replication to SAP HANA
Use CData Sync to customize and automate Apache Spark SQL replication to SAP HANA.
-
How to Connect the Power BI Service to CircleCI: Complete Guide
Connect to the CData Software Power BI Connector for CircleCI from PowerBI.com to provide real-time CircleCI across the organization.
-
How to Work with Discourse Data in ETL Validator JDBC
Connect to Discourse from ETL Validator jobs using the CData Software JDBC Driver.
-
Automate Printful Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Printful from PowerShell? This article demonstrates how to utilize the Printful Cmdlets for tasks like connecting to Printful, automating operations, downloading data, and more.
-
Use the CData Software JDBC Driver for Instantly in MicroStrategy Desktop
Connect to Instantly in MicroStrategy Desktop using the CData Software JDBC Driver for Instantly.
-
Bind Live LeadDesk Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live LeadDesk data
-
DataBind Controls to Facebook Ads Data in Delphi
DataBind to Facebook Ads in Delphi with standard data access components and controls.
-
Deploy the ADO.NET Provider for Productboard on an SSRS Report Server
Connect to Productboard 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.
-
Connect to ElevenLabs Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ElevenLabs to connect to ElevenLabs and execute queries in PowerBuilder.
-
Integrate Humanity with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Humanity with External Services.
-
Use Claude to Talk to Your SAP ByDesign 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 SAP Business ByDesign for you.
-
Getting Started with the CData Power BI Connector for QuickBooks
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for QuickBooks.
-
Build Automated Avalara AvaTax-Connected Workflows in Zapier
Use CData Connect AI to connect to live Avalara AvaTax and build automated workflows in Zapier.
-
Automate Helpscout Data Replication to SAP HANA
Use CData Sync to customize and automate Helpscout replication to SAP HANA.
-
Integrating Boomi Agentstudio with HCL Domino Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to HCL Domino, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Live Sage 200 Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Sage 200 in CData Connect AI and connect to your Sage 200 from PostgreSQL.
-
Visualize Live Pushbullet Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Pushbullet.
-
Build Azure DevOps-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Azure DevOps Data and create custom apps in Mendix.
-
Query, Visualize, and Share live Couchbase Data in Redash
Use CData Connect AI to connect to live Couchbase in Redash for querying, visualizing, and sharing.
-
Access SAP Ariba Source 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 SAP Ariba Source.
-
Build Stripe Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Stripe and build visualizations in Tableau Cloud.
-
Access Live Humanity Data in Coginiti Pro
Connect to and query live Humanity from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Query Impala Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Impala entities in PHP by modeling them as objects.
-
Integrating Cursor CLI with Phoenix 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.
-
Build PayPal-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live PayPal.
-
How to Access Live Short.io Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Short.io enables you to integrate Short.io into workflows built using Microsoft Power Automate Desktop.
-
Import Google Directory Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Google Directory. In this article, you will use the OData format to import Google Directory into Microsoft Power Query.
-
Connect to Reckon Accounts Hosted Data in CloverDX (formerly CloverETL)
Transfer Reckon Accounts Hosted using the visual workflow in the CloverDX data integration tool.
-
Build Dashboards with MarkLogic Data in DBxtra
Create dynamic dashboards and perform analytics based on MarkLogic in DBxtra.
-
Integrate Presto Data into Power Automate Desktop using CData Connect
CData Connect for Presto Data enables you to integrate Presto into workflows built using Microsoft Power Automate Desktop.
-
How to Connect to & Open Email Data in Microsoft Excel
This article uses the CData ODBC driver for Email to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Calendly-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Calendly and build web apps with connectivity to live Calendly.
-
Connect to Rootly Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Rootly as an External Source in Dremio.
-
Connect to Drift Data in Ruby
Connect to Drift in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automate Klaviyo Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Klaviyo from PowerShell? This article demonstrates how to utilize the Klaviyo Cmdlets for tasks like connecting to Klaviyo, automating operations, downloading data, and more.
-
Create Qualaroo Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Qualaroo data access from reports, embedded analytics, and more.
-
DataBind LDAP Objects to the DevExpress Data Grid
Use the CData ADO.NET Provider for LDAP with the DevExpress Windows Forms and Web controls to provide LDAP to a chart.
-
Build Agents in Relevance AI with Access to Live Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Sugar CRM within intelligent agent workflows.
-
Import Instagram Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Instagram Data and provide access to live Instagram for custom reports in the Power BI Service.
-
Build Data Flows from SQL Server to LinkedIn through SSIS
Easily push SQL Server data to LinkedIn using the CData SSIS Tasks for LinkedIn.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Power BI XMLA within intelligent workflows.
-
Visualize Live ConvertAPI Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ConvertAPI using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Vault CRM Data as a SQL Server Database in Node.js
Execute SQL Server queries against Veeva Vault & Vault CRM from Node.js.
-
Visualize Qualaroo Data in TIBCO Spotfire through OData
Integrate Qualaroo into dashboards in TIBCO Spotfire.
-
Access RSS Feeds from MySQL in Amazon QuickSight
Connect to RSS and build visualizations of RSS Feeds using a MySQL Connection in Amazon QuickSight.
-
Integrate Live FTP Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live FTP Servers to Blue Prism using the CData ODBC Driver for FTP to create automated workflows for repetitive business tasks.
-
Access Live LightSpeedRetail Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate LightSpeedRetail into the statistical analysis tools available in SAS JMP. This article shows how to use LightSpeedRetail in the Graph Builder and Query Builder.
-
How to Work with Google Search Results in ETL Validator JDBC
Connect to Google Search from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect the Power BI Service to Perigon: Complete Guide
Connect to the CData Software Power BI Connector for Perigon from PowerBI.com to provide real-time Perigon across the organization.
-
Pipeliner CRM Reporting in OBIEE with the Pipeliner CRM JDBC Driver
Deploy the Pipeliner CRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Unbounce Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Unbounce and work with Unbounce in your FileMaker applications.
-
How to connect SharePoint with SAP Business One Data through external lists
Provide SAP Business One to SharePoint users as an external list.
-
Write a Simple Go Application to work with Zoho CRM Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zoho CRM.
-
Analyze Zendesk Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Zendesk with the CData JDBC Driver for Zendesk.
-
Publish Suadeo-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Suadeo.
-
Rapidly Develop Hugging Face-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 Hugging Face.
-
Import Oracle Sales Data Using Azure Data Factory
Use CData Connect AI to connect to Oracle Sales Data from Azure Data Factory and import live Oracle Sales.
-
Integrate Cline with Live Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Ads from within your IDE.
-
Build Semantic Layer Views for Jira Data in APOS Live Data Gateway
Use the CData Connector for Jira in APOS Live Data Gateway to build Semantic Layer Views for Atlassian Jira.
-
Integrating Claude Code with Presto Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Presto within assisted coding and automated development workflows.
-
Query ScrapingBee Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume ScrapingBee entities in PHP by modeling them as objects.
-
Connect to LinkedIn Ads Data from Crystal Reports
Use CData Connect AI to connect to and report on live LinkedIn Ads from Crystal Reports.
-
How to Build an ETL App for Drip Data in Python with CData
Create ETL applications and real-time data pipelines for Drip in Python with petl.
-
Analyze Raisers Edge NXT Data in Cognos Analytics
Use CData Connect AI to connect to Raisers Edge NXT Data from Cognos Analytics and analyze live Raisers Edge NXT.
-
Connect to and Query Shippo Data in QlikView over ODBC
Create data visualizations with Shippo in QlikView.
-
Getting Started with the CData Tableau Connector for Microsoft Ads
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Microsoft Ads.
-
Integrate ServiceNow Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ServiceNow from Informatica Cloud.
-
Work with Auth0 Data in FoxPro
Load Auth0 into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build SageHR-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SageHR.
-
Connect and Visualize Live Zendesk Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Zendesk into the Databricks platform and create visualization dashboards with real-time Zendesk.
-
Create ADP-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to ADP Data from Klipfolio and build custom visualizations using live ADP.
-
Getting Started with the CData ADO.NET Provider for Instantly
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build Elasticsearch-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Elasticsearch to explore live Elasticsearch Data in Claude Code to assist with building Elasticsearch-powered applications.
-
Connect to Discord Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Discord using standard SQL.
-
How to Connect the Power BI Service to ChargeOver: Complete Guide
Connect to the CData Software Power BI Connector for ChargeOver from PowerBI.com to provide real-time ChargeOver across the organization.
-
Connect ShipEngine to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ShipEngine using the CData Python MCP Server.