CData Software - Knowledge Base
Recent Articles
-
How to Access SAP Business Warehouse Data Using Entity Framework
This article shows how to access SAP Business Warehouse using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData ODBC Driver for MailChimp
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for MailChimp.
-
Integrate LightSpeedRetail with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate LightSpeedRetail with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to LightSpeedRetail.
-
Connect to Webflow from a Connection Pool in WebLogic
Use the CData JDBC Driver for Webflow to connect to Webflow from Web applications running on WebLogic.
-
Connect to Azure DevOps from a Connection Pool in WebLogic
Use the CData JDBC Driver for Azure DevOps to connect to Azure DevOps from Web applications running on WebLogic.
-
Rapidly Develop XML-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 XML.
-
Analyze Telegram Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Telegram in Microsoft R Open.
-
Integrating OpenCode Terminal with SAP Hybris C4C 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.
-
Integrate LibreChat with Live ShipStation Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live ShipStation from within the chat interface.
-
Getting Started with the CData JDBC Driver for Salesforce CRM Analytics
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Salesforce CRM Analytics.
-
Connect to SAP SuccessFactors Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP SuccessFactors in the Denodo Virtual DataPort Administrator.
-
Work with Live SQL Analysis Services Data in Power Query
Use CData Connect AI to connect to SQL Analysis Services and work with live SQL Analysis Services in Microsoft Power Query.
-
Operational Reporting on Datadog Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Datadog.
-
Prepare, Blend, and Analyze Accelo Data in Alteryx Designer (ODBC)
Build workflows to access live Accelo for self-service data analytics.
-
How to load Slack data into Elasticsearch via Logstash
Introducing a simple method to load Slack data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
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.
-
Query DocuSign Data in ColdFusion
Write standard ColdFusion data access code to connect to DocuSign.
-
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.
-
Query PingOne Data from Node.js
Use the OData endpoint of the CData API Server to connect to your PingOne and perform CRUD operations on PingOne from Node.js.
-
Automate Recurly Data Replication to Azure Data Lake
Use CData Sync to customize and automate Recurly replication to Azure Data Lake.
-
Extract, Transform, and Load Oracle Sales Data in Informatica PowerCenter
Create a simple Workflow for Oracle Sales 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.
-
Connect to Spark Data from Crystal Reports
Use CData Connect AI to connect to and report on live Apache Spark SQL 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.
-
Automate Klipfolio Data Replication to Azure Data Lake
Use CData Sync to customize and automate Klipfolio replication to Azure Data Lake.
-
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.
-
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.
-
Build Act CRM-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Act CRM to explore live Act CRM Data in GitHub Copilot to assist with building Act CRM-powered applications.
-
Visualize ServiceNow Data in TIBCO Spotfire through ADO.NET
Integrate ServiceNow into dashboards in TIBCO Spotfire.
-
Automated Continuous Typeform Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Typeform replication to Amazon Redshift.
-
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 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.
-
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 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 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.
-
Work with MYOB AccountRight Data in FoxPro
Load MYOB AccountRight into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Build an ETL App for PivotalTracker Data in Python with CData
Create ETL applications and real-time data pipelines for PivotalTracker in Python with petl.
-
How to Connect DBeaver to Act-On via a JDBC Driver
Manage Act-On with visual tools in DBeaver like the query browser.
-
Use the CData Software ODBC Driver for Zoom in MicroStrategy
Connect to Zoom 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 in JReport Designer.
-
Import and Visualize PivotalTracker Data in Power View
Create data visualizations based on PivotalTracker in Excel.
-
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.
-
Use the CData Software JDBC Driver for Salesloft in MicroStrategy Desktop
Connect to Salesloft 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 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.
-
Connect to Timely Data from PowerBuilder via JDBC
This article demonstrates how to access Timely from PowerBuilder using the Timely JDBC Driver.
-
Use the CData Software JDBC Driver for LeadDesk in MicroStrategy Web
Connect to LeadDesk 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 for you.
-
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.
-
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 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 Microsoft Excel.
-
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 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 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 and build visualizations in Tableau.
-
How to connect to Salesforce Pardot Data in DBVisualizer
Integrate Salesforce Pardot 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 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.
-
Query GraphQL Data through ODBC in Node.js
Use node-odbc to execute SQL queries against GraphQL 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 & Force.com in your FileMaker applications.
-
Explore Geographical Relationships in SAP Ariba Source Data with Power Map
Create data visualizations with SAP Ariba Source 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 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.
-
Import Real-Time HDFS Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Apache HDFS 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.
-
Work with Front Data in FoxPro
Load Front 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.
-
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.
-
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 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.
-
Creating Amazon Marketplace-Connected Applications in Unqork
You can use CData Connect AI to feed Amazon Marketplace to Unqork and build custom business apps.
-
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 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 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 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 for you.
-
Natively Connect to Freshservice Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Freshservice. 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 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.
-
Getting Started with the CData Python Connector for Epicor Kinetic
Learn to install and license the CData Python Connector
-
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
-
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.
-
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 and visualize live Vertica in Infragistics Reveal.
-
Replicate Multiple Redis Accounts
Replicate multiple Redis accounts to one or many databases.