CData Software - Knowledge Base
Recent Articles
-
How to Access Customer.io Data Using Entity Framework
This article shows how to access Customer.io data 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 data replication to Azure Data Lake.
-
Extract, Transform, and Load Oracle Sales Data in Informatica PowerCenter
Create a simple Workflow for Oracle Sales data in Informatica PowerCenter.
-
Build MVC Applications with Connectivity to Egnyte Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Egnyte from an ASP.NET MVC application.
-
Connect to Sage 200 Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Sage 200 data.
-
Connect to Spark Data from Crystal Reports
Use CData Connect AI to connect to and report on live Spark data from Crystal Reports.
-
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.
-
Automated Continuous FormSite Replication to MySQL
Use CData Sync for automated, continuous, customizable FormSite replication to MySQL.
-
Create Informatica Mappings From/To an ODBC Data Source for Shopify
Create an ODBC connection to Shopify in Informatica and browse and transfer Shopify data.
-
Automate Klipfolio Data Replication to Azure Data Lake
Use CData Sync to customize and automate Klipfolio data replication to Azure Data Lake.
-
Build Semantic Layer Views for Omnisend Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Omnisend data.
-
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.
-
Connect to and Visualize Live Dotmailer Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Dotmailer data.
-
Connect to Bullhorn CRM Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Bullhorn CRM data.
-
Visualize ServiceNow Data in TIBCO Spotfire through ADO.NET
Integrate ServiceNow data into dashboards in TIBCO Spotfire.
-
Automated Continuous Typeform Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Typeform replication to Amazon Redshift.
-
Build Mailgun-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Mailgun data.
-
Provide OData Services of Mocean Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Mocean data by developing a WCF Service Application.
-
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 data.
-
Excel Spreadsheet Automation on Lakebase Data with the QUERY Formula
Pull data from Lakebase, automate spreadsheets, and more with the QUERY formula.
-
Design BIRT Reports on Optimizely Data
Provide current Optimizely data to your embedded analytics.
-
Integrate ServiceNow with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ServiceNow with External Services.
-
Use the CData Software ODBC Driver for Klaviyo in MicroStrategy Desktop
Connect to Klaviyo data in MicroStrategy Desktop using the CData Software ODBC Driver for Klaviyo.
-
Connect to Google Cloud Storage Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Cloud Storage data.
-
Work with MYOB AccountRight Data in FoxPro
Load MYOB AccountRight data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect DBeaver to Act-On via a JDBC Driver
Manage Act-On data with visual tools in DBeaver like the query browser.
-
Use the CData Software ODBC Driver for Zoom in MicroStrategy
Connect to Zoom data in MicroStrategy Developer using the CData Software ODBC Driver for Zoom.
-
Integrate with Toggl Data in JReport Designer
Create charts and reports based on Toggl data in JReport Designer.
-
Integrating Cursor 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.
-
Use the CData Software JDBC Driver for Salesloft in MicroStrategy Desktop
Connect to Salesloft data in MicroStrategy Desktop using the CData Software JDBC Driver for Salesloft.
-
Visualize Live Basecamp Data in the Power BI Service
Use CData Connect AI to connect to live Basecamp data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Dataiku with Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Zoho Inventory data.
-
Connect to Timely Data from PowerBuilder via JDBC
This article demonstrates how to access Timely data from PowerBuilder using the Timely JDBC Driver.
-
Use the CData Software JDBC Driver for LeadDesk in MicroStrategy Web
Connect to LeadDesk data in MicroStrategy Web using the CData Software JDBC Driver for LeadDesk.
-
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 data for you.
-
Integrate Google's Vertex AI Agent with Live Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Snowflake data within intelligent workflows.
-
Create Campaigner-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Campaigner Data from Klipfolio and build custom visualizations using live Campaigner data.
-
Connect to CapsuleCRM Data as an External Source in Dremio
Use the CData JDBC Driver to connect to CapsuleCRM as an External Source in Dremio.
-
Replicate Tanda Data in Heroku for Use in Salesforce Connect
Replicate Tanda data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Publish Excel-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Excel data.
-
Connect to AfterShip Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live AfterShip data.
-
DataBind Box Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Box with the DevExpress Windows Forms and Web controls to provide Box data to a chart.
-
Automated Continuous Azure DevOps Replication to Vertica
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Vertica.
-
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 data in Python with petl.
-
Integrate Drip with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Drip with External Services.
-
Build Asana Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Asana data and build visualizations in Tableau.
-
How to connect to Salesforce Pardot Data in DBVisualizer
Integrate Salesforce Pardot data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to load CampaignMonitor data into Elasticsearch via Logstash
Introducing a simple method to load CampaignMonitor data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Back Up Coinbase 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 Coinbase data data.
-
Query GraphQL Data through ODBC in Node.js
Use node-odbc to execute SQL queries against GraphQL data from Node.js.
-
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 data in your FileMaker applications.
-
Explore Geographical Relationships in SAP Ariba Source Data with Power Map
Create data visualizations with SAP Ariba Source data in Power Map.
-
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 data in CData Connect AI and insert Facebook data 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.
-
Import Real-Time HDFS Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use HDFS data in ColdFusion.
-
Write a Simple Go Application to work with GetResponse Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to GetResponse data.
-
Work with Front Data in FoxPro
Load Front data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData Tableau Connector for Klaviyo
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Klaviyo.
-
Getting Started with the CData Excel Add-In for Pipedrive
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Pipedrive.
-
How to Work with AfterShip Data in ETL Validator JDBC
Connect to AfterShip from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Build an ETL App for ZohoDesk Data in Python with CData Connect AI
Extract and transform live ZohoDesk data in Python with petl and the CData Connect AI Python SDK.
-
Connect to MailChimp Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live MailChimp data.
-
Excel Spreadsheet Automation on Acumatica Data with the QUERY Formula
Pull data from Acumatica, automate spreadsheets, and more with the QUERY formula.
-
Back Up Shopify data 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 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 Office 365 data for custom reports in the Power BI Service.
-
Creating Amazon Marketplace-Connected Applications in Unqork
You can use CData Connect AI to feed Amazon Marketplace data to Unqork and build custom business apps.
-
Build ConstantContact-Connected Apps in Choreo
Use CData Connect AI to connect to ConstantContact Data from Choreo and build custom apps using live ConstantContact data.
-
Work with Live MailerLite Data in Power Query
Use CData Connect AI to connect to MailerLite data and work with live MailerLite data in Microsoft Power Query.
-
Manage Sage 300 Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Sage 300.
-
Connect to Mouseflow Data from a Connection Pool in JBoss
Integrate Mouseflow data 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.
-
How to Connect to & Open Mixpanel Data in Microsoft Excel
This article uses the CData ODBC driver for Mixpanel to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Viewing Mouseflow Data in RAD Studio Data Explorer
How to view Mouseflow data in RAD Studio Data Explorer using the CData ODBC Driver for Mouseflow.
-
Migrating data from SurveyMonkey to Google BigQuery using CData SSIS Components.
Easily push SurveyMonkey data to Google BigQuery using the CData SSIS Tasks for SurveyMonkey and Google BigQuery.
-
How to Connect to Live Azure DevOps 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 Azure DevOps data for you.
-
Natively Connect to Freshservice Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Freshservice data. Leverage the native support for ODBC in PHP.
-
How to Query Live Box Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Box data data in natural language using Python.
-
Use JayDeBeApi to access Exa Data in Python
Use standard Python scripting and the development environment of your choice to access live Exa data.
-
Getting Started with the CData Python Connector for Epicor Kinetic
Learn to install and license the CData Python Connector and configure a connection to live Epicor Kinetic data.
-
Create Data Visualizations Based On SAP Business One Data in Mode
Use CData Connect AI to connect to SAP Business One Data from Mode and build visualizations using live SAP Business One data.
-
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 data. You can visually build the import query or use any SQL supported by the driver.
-
Use Dash to Build to Web Apps on Zoho Projects Data
Create Python applications that use pandas and Dash to build Zoho Projects-connected web apps.
-
Analyze Vertica Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Vertica data and visualize live Vertica data in Infragistics Reveal.
-
Replicate Multiple Redis Accounts
Replicate multiple Redis accounts to one or many databases.
-
Integrate Open WebUI with Live Paymo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Paymo data from within the chat interface.
-
Replicate Klipfolio Data from PowerShell
Write a quick PowerShell script to query Klipfolio data. Use connectivity to the live data to replicate Klipfolio data to SQL Server.
-
Design BIRT Reports on TaxJar Data
Provide current TaxJar data to your embedded analytics.
-
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 data.
-
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.
-
Access Retently Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Retently data from HeidiSQL.
-
Integrate with live SageHR Data in Jitterbit
Use CData Connect AI to connect to and integrate live SageHR data in Jitterbit.
-
Automated Continuous Teamwork Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Teamwork replication to Google Cloud SQL.
-
Create HBase-Connected Nintex Workflows
Use CData Connect AI to connect to HBase Data from Nintex Workflow Cloud and build custom workflows using live HBase data.
-
Integrating Claude Code CLI with Certinia 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.
-
Migrating data from Reply.io to Databricks using CData SSIS Components.
Easily push Reply.io data to Databricks using the CData SSIS Tasks for Reply.io and Databricks.
-
Integrate Devin with Live VWO Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live VWO data.
-
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 data in real time.