CData Software - Knowledge Base
Recent Articles
-
Query Redshift Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Amazon Redshift and perform CRUD operations on Redshift from Node.js.
-
Connect to Parallel Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Parallel in the Denodo Virtual DataPort Administrator.
-
Build a Singer.io Tap for MailerSend With the CData Python Connector
Learn how to easily build a Singer.io Tap for live MailerSend data using
-
How to Access Customer.io Data Using Entity Framework
This article shows how to access Customer.io using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automate Recurly Data Replication to Azure Data Lake
Use CData Sync to customize and automate Recurly replication to Azure Data Lake.
-
Build Highrise-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Highrise Data and create custom apps in Bubble.
-
Extract, Transform, and Load Oracle Sales Data in Informatica PowerCenter
Create a simple Workflow for Oracle Sales in Informatica PowerCenter.
-
Access Oracle Eloqua 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 Oracle Eloqua.
-
Using the CData Software ODBC Driver for CloudConvert in PyCharm
Connect to CloudConvert as an ODBC data source in PyCharm using the CData Software ODBC Driver for CloudConvert.
-
Use Dash to Build to Web Apps on Dynamics NAV Data
Create Python applications that use pandas and Dash to build Dynamics NAV-connected web apps.
-
Query, Visualize, and Share live FTP Data in Redash
Use CData Connect AI to connect to live FTP Servers in Redash for querying, visualizing, and sharing.
-
Visualize CloudConvert Data in Tableau
The CData ODBC driver for CloudConvert enables you integrate CloudConvert into Tableau dashboards.
-
Create Informatica Mappings From/To an ODBC Data Source for Shopify
Create an ODBC connection to Shopify in Informatica and browse and transfer Shopify.
-
Getting Started with the CData Power BI Connector for Short.io
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automated Continuous Microsoft Teams Replication to SQL Server
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to SQL Server.
-
Visualize ServiceNow Data in TIBCO Spotfire through ADO.NET
Integrate ServiceNow into dashboards in TIBCO Spotfire.
-
Create Email-Connected Dashboards in Grafana
Connect to Email Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Email.
-
Use the CData Software ODBC Driver for Klaviyo in MicroStrategy Desktop
Connect to Klaviyo in MicroStrategy Desktop using the CData Software ODBC Driver for Klaviyo.
-
Automate Samanage Data Replication to Azure Synapse
Use CData Sync to customize and automate Samanage replication to Azure Synapse.
-
Work with Timely Data in FoxPro
Load Timely into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Productboard Data from PowerBuilder via JDBC
This article demonstrates how to access Productboard from PowerBuilder using the Productboard JDBC Driver.
-
Integrating Cursor CLI with SendPulse 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 connect to AfterShip Data from IntelliJ
Integrate connectivity to AfterShip with wizards in IntelliJ.
-
Connect to Timely Data from PowerBuilder via JDBC
This article demonstrates how to access Timely from PowerBuilder using the Timely JDBC Driver.
-
Azure Analysis Services Reporting in OBIEE with the Azure Analysis Services JDBC Driver
Deploy the Azure Analysis Services JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use Claude to Talk to Your QuickBooks Time 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 QuickBooks Time for you.
-
Create Informatica Mappings From/To a JDBC Data Source for Aircall
Create Aircall data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Snowflake within intelligent workflows.
-
Access Live Twitter Ads Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Twitter Ads from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous Azure DevOps Replication to Vertica
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Vertica.
-
Connect to and Visualize Live Campaigner Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Campaigner.
-
How to Build an ETL App for SAP Concur Data in Python with CData
Create ETL applications and real-time data pipelines for SAP Concur in Python with petl.
-
Consume Microsoft Teams OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Microsoft Teams feeds that reflect any changes in SAP Lumira.
-
How to connect to Salesforce Pardot Data in DBVisualizer
Integrate Salesforce Pardot with visual data analysis tools and data connection wizards in DBVisualizer
-
Validate Active Directory Data with QuerySurge
Access and validate Active Directory in QuerySurge using the CData JDBC Driver.
-
Build ActiveCampaign-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for ActiveCampaign to explore live ActiveCampaign Data in Cursor to assist with building ActiveCampaign-powered applications.
-
Back Up Coinbase 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 Coinbase data.
-
Automated Continuous ShipStation Replication to SingleStore
Use CData Sync for automated, continuous, customizable ShipStation replication to SingleStore.
-
Connect to Salesforce Data in Claris FileMaker Pro
Use the CData ODBC Driver for Salesforce in FileMaker Pro to connect to Salesforce and work with Salesforce & Force.com in your FileMaker applications.
-
Configure the CData JDBC Driver for Pinecone in a Connection Pool in Tomcat
Connect to Pinecone from a connection pool in Tomcat.
-
Create Trello Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Trello from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect Amazon QuickSight to Facebook Data
Create a connection to Facebook in CData Connect AI and insert Facebook into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Oracle Sales from Asprova with CData Software ODBC Driver for Oracle Sales
This article shows how to connect faster to Oracle Sales data from Asprova.
-
Work with Front Data in FoxPro
Load Front into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to SAP HANA Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP HANA to connect to SAP HANA and execute queries in PowerBuilder.
-
Connect to Jodoo Data in DBeaver
Use the CData ODBC Driver to connect to Jodoo in DBeaver.
-
Use the CData Software JDBC Driver for TigerGraph in MicroStrategy Desktop
Connect to TigerGraph in MicroStrategy Desktop using the CData Software JDBC Driver for TigerGraph.
-
How to Work with AfterShip Data in ETL Validator JDBC
Connect to AfterShip from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Anaplan Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Anaplan.
-
Back Up Shopify to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Shopify. In this article, we will employ an SSIS workflow to populate a database with Shopify data.
-
Import Office 365 Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Office 365 Data and provide access to live Microsoft Office 365 for custom reports in the Power BI Service.
-
How to integrate Zoho Books with Apache Airflow
Access and process Zoho Books in Apache Airflow using the CData JDBC Driver.
-
Connect to Mouseflow Data from a Connection Pool in JBoss
Integrate Mouseflow into Java servlets: Use the Management Console in JBoss to install the Mouseflow JDBC Driver.
-
Building Dynamic Web Pages with ADP Data Using AngularJS
Create single-page applications with live connectivity to ADP using the CData API Server.
-
Moving Data from Brex to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Brex data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Viewing Mouseflow Data in RAD Studio Data Explorer
How to view Mouseflow in RAD Studio Data Explorer using the CData ODBC Driver for Mouseflow.
-
How to create Visio diagrams from Pipedrive Data
Automatically update Pipedrive with the changes you make to Visio master shapes.
-
Migrating data from SurveyMonkey to Google BigQuery using CData SSIS Components.
Easily push SurveyMonkey to Google BigQuery using the CData SSIS Tasks for SurveyMonkey and Google BigQuery.
-
How to Query Live Mixpanel Data in Claude Desktop
Connect to and query live Mixpanel Data in Claude Desktop using CData MCP Server.
-
How to Access Live Billsby Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Billsby from the Cline extension in Visual Studio Code.
-
Use JayDeBeApi to access Exa Data in Python
Use standard Python scripting and the development environment of your choice to access live Exa.
-
DataBind Controls to Nuclia Data in Delphi
DataBind to Nuclia in Delphi with standard data access components and controls.
-
How to connect Amazon QuickSight to Okta Data
Create a connection to Okta in CData Connect AI and insert Okta into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrating GitHub Copilot CLI with Printful 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.
-
Analyze Short.io Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Short.io from Power Pivot. You will use the Table Import Wizard to load Short.io. You can visually build the import query or use any SQL supported by the driver.
-
Write a Simple Go Application to work with Mouseflow Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Mouseflow.
-
Use Grok to Talk to Your ActiveCampaign 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 ActiveCampaign for you.
-
Analyze Vertica Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Vertica and visualize live Vertica in Infragistics Reveal.
-
Getting Started with the CData ADO.NET Provider for Sendwithus
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to connect PolyBase to Oracle
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Oracle Database.
-
Query eBay Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume eBay entities in PHP by modeling them as objects.
-
How to connect SharePoint with Recurly Data through external lists
Provide Recurly to SharePoint users as an external list.
-
How to Access Live CockroachDB Data in Visual Studio Code via Cline
Run CData MCP Server for CockroachDB on Windows Subsytem for Linux (WSL) and connect to live CockroachDB from the Cline extension in Visual Studio Code.
-
Connect to Active Directory Data from Crystal Reports
Use CData Connect AI to connect to and report on live Active Directory from Crystal Reports.
-
Create Informatica Mappings From/To an ODBC Data Source for Redis
Create an ODBC connection to Redis in Informatica and browse and transfer Redis.
-
Automated Continuous Teamwork Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Teamwork replication to Google Cloud SQL.
-
Working with Salesforce Data in LINQPad
Execute LINQ queries to Salesforce & Force.com in LINQPad.
-
Connecting Moonlit Workflow with IBM Informix 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 IBM Informix in real time.
-
Back Up MailChimp to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for MailChimp. In this article, we will employ an SSIS workflow to populate a database with MailChimp data.
-
Connect Foursquare to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Foursquare with IBM WebSphere for seamless data integration and connectivity.
-
Configure the CData JDBC Driver for QuickBooks in a Connection Pool in Tomcat
Connect to QuickBooks Desktop from a connection pool in Tomcat.
-
Connect PostgreSQL Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your PostgreSQL using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to import Mailjet Data into Apache Solr
Use the CData Software JDBC Driver for Mailjet in Data Import Handler and create an automated import of Mailjet to Apache Solr Enterprise Search platform.
-
Access Live Teamgate Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Teamgate data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Deploy the ADO.NET Provider for VWO on an SSRS Report Server
Connect to VWO 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.
-
How to Query Live Bullhorn CRM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Bullhorn CRM data in natural language using Python.
-
Use Microsoft Copilot Studio to talk to your Authorize.Net 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 Authorize.Net for you.
-
Working with SpaceX Data in LINQPad
Execute LINQ queries to SpaceX in LINQPad.
-
Create LinkedIn Ads Dataflows on PowerBI.com
Connect to the CData Power BI Connector for LinkedIn Ads from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build ADP-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for ADP Data and create custom apps in Bubble.
-
Trigger Dynamics 365 IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Dynamics 365 with standard wizards in Logic Apps.
-
How to Create Power BI Visual Reports with Real-Time Apify Data
Use CData Power BI Connectors to visualize Apify in Power BI.
-
Build Voice Agents in ElevenLabs with access to Live Power BI XMLA Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Power BI XMLA.
-
Workday Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Workday facts in real time.
-
Prepare, Blend, and Analyze Cloudflare Data in Alteryx Designer (ODBC)
Build workflows to access live Cloudflare for self-service data analytics.
-
Integrate with live Google Drive Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google Drive in Jitterbit.
-
Connect to Salesloft Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Salesloft in the Denodo Virtual DataPort Administrator.
-
How to work with ZohoPeople Data in Apache Spark using SQL
Access and process ZohoPeople Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Kintone Data from PowerBuilder via ADO.NET
This article demonstrates how to access Kintone from Appeon PowerBuilder using the CData ADO.NET Provider for Kintone.
-
Extend Google Sheets with Grafana Data
Make calls to Grafana from Google Apps Script via the API Server.