CData Software - Knowledge Base
Recent Articles
-
How to create an RPA flow for Discourse Data in UiPath Studio
Use the Discourse ODBC Driver to create workflows that access real-time Discourse data without any coding.
-
Automated Freshteam Data Replication to Teradata
Use CData Sync to Customize and automate Freshteam data replication to Teradata.
-
Build a Simple VCL Application for Ontraport Data
How to build a simple VCL Application to view Ontraport data in RAD Studio using the CData ODBC Driver for Ontraport.
-
A PostgreSQL Interface for Kafka Data (MySQL Remoting via JDBC)
Use the Remoting features of the Kafka JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Apps with Live Strava Data Using the Low-Code Development Platform of Mendix
Connect Strava data with Mendix to build apps using the CData API Driver for JDBC.
-
How to use SQLAlchemy ORM to access Salesforce Data 360 Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Salesforce Data 360 data.
-
BigCommerce Reporting in OBIEE with the BigCommerce JDBC Driver
Deploy the BigCommerce JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Query SAP Hybris C4C Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAP Hybris C4C data from Node.js.
-
Use Biml to Build SSIS Tasks to Replicate QuickBooks Time Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate QuickBooks Time data to SQL Server.
-
Use ChatGPT to Talk to Your Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Instagram data for you.
-
Query SAP Concur Data as a MySQL Database in Node.js
Execute MySQL queries against SAP Concur data from Node.js.
-
Automated Continuous SAP ByDesign Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to AlloyDB.
-
Prepare, Blend, and Analyze Beeminder Data in Alteryx Designer (ODBC)
Build workflows to access live Beeminder data for self-service data analytics.
-
Create a Data Access Object for Gumroad Data using JDBI
A brief overview of creating a SQL Object API for Gumroad data in JDBI.
-
Build a PostgreSQL Interface for Sage Intacct Data using the CData JDBC Driver
Use the Remoting features of the Sage Intacct JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Reports from Notion Data in Looker Studio
Use CData Connect AI to gain access to live Notion data and create custom reports in Looker Studio.
-
Load Pipedrive Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Pipedrive data to a database.
-
Integrate Open WebUI with Live Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Confluence data from within the chat interface.
-
Work with CloudConvert Data in FoxPro
Load CloudConvert data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Shopify Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Shopify replication to Google Cloud SQL.
-
Build Automated Workflows with Live QuickBooks Online Data in Workato
Use CData Connect AI to connect to live QuickBooks Online data and build automated workflows in Workato.
-
How to Easily Query Salesforce CRM Analytics Data in OpenOffice Base
Connect to Salesforce CRM Analytics data in OpenOffice Base using the CData ODBC Driver for Salesforce CRM Analytics and generate reports with live data insights.
-
Connect to Zoho Projects 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 Zoho Projects data.
-
Build Semantic Layer Views for PolarTeamPro Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for PolarTeamPro data.
-
DataBind GitHub Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for GitHub with the DevExpress Windows Forms and Web controls to provide GitHub data to a chart.
-
Connect to Highrise Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Highrise data in Airbyte.
-
Integrate Live Spark Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Spark data from within the IDE.
-
Integrating Antigravity CLI with SAP SuccessFactors LMS data via CData CLI
Connect SAP SuccessFactors LMS data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating GitHub Copilot with Rootly 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.
-
Connect to TaxJar Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for TaxJar to connect to TaxJar data and execute queries in PowerBuilder.
-
How to Visualize Datadog Data in Python with pandas
Use pandas and other modules to analyze and visualize live Datadog data in Python.
-
Getting Started with the CData SSIS Components for Google Search
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Search.
-
Analyze Copper Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Copper data in Microsoft R Open.
-
Getting Started with the CData JDBC Driver for Access
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Access.
-
Query Salesforce Data 360 Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Salesforce Data 360 entities in PHP by modeling them as objects.
-
DataBind SingleStore Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SingleStore with the DevExpress Windows Forms and Web controls to provide SingleStore data to a chart.
-
How to publish and share Couchbase Data dashboards with Tableau Server
The CData ODBC driver for Couchbase enables you integrate Couchbase data into Tableau dashboards.
-
Rapidly Develop Certinia-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 Certinia.
-
Create Square Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Square data access from reports, embedded analytics, and more.
-
How to update Oracle Service Cloud from Excel
This article explains how to transfer data from Excel to Oracle Service Cloud using the Excel Add-In for Oracle Service Cloud.
-
Use the CData Software ODBC Driver for Superchat in MicroStrategy
Connect to Superchat data in MicroStrategy Developer using the CData Software ODBC Driver for Superchat.
-
Connect to Shippo from Asprova with CData Software ODBC Driver for Shippo
This article shows how to connect faster to Shippo data from Asprova.
-
Publish Crystal Reports on MySQL Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MySQL data.
-
MailChimp Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on MailChimp facts in real time.
-
Automated Continuous NASA Replication to Databricks
Use CData Sync for automated, continuous, customizable NASA replication to Databricks.
-
DataBind Charts to Azure Analysis Services Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Azure Analysis Services data 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.
-
Automated Workable Data Replication to Teradata
Use CData Sync to Customize and automate Workable data replication to Teradata.
-
Publish Reports with Amazon Marketplace Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Amazon Marketplace data.
-
Connect to Monday.com Data in Jaspersoft Studio
Execute SQL to remote Monday.com data in Jaspersoft Studio.
-
How to Access HelloSign Data Using Entity Framework
This article shows how to access HelloSign data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Replicate Vercel Data from PowerShell
Write a quick PowerShell script to query Vercel data. Use connectivity to the live data to replicate Vercel data to SQL Server.
-
Getting Started with the CData Tableau Connector for Freshservice
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create a Data Access Object for Coda Data using JDBI
A brief overview of creating a SQL Object API for Coda data in JDBI.
-
Back Up Teradata data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Teradata. In this article, we will employ an SSIS workflow to populate a database with Teradata data data.
-
Connect to Redshift Data in DBeaver
Use the CData ODBC Driver to connect to Redshift data in DBeaver.
-
Connect to Sage 200 Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Sage 200 data in Airbyte.
-
Automate CSV Data Replication to Couchbase
Use CData Sync to Customize and automate CSV data replication to Couchbase.
-
Process & Analyze Azure Data Lake Storage Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Azure Data Lake Storage Data.
-
Analyze eBay Analytics Data in Cognos Analytics
Use CData Connect AI to connect to eBay Analytics Data from Cognos Analytics and analyze live eBay Analytics data.
-
Replicate Recurly Data to Multiple Databases via the CData Sync CLI
Replicate Recurly data to disparate databases with a single configuration.
-
Build MVC Applications with Connectivity to Splunk Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Splunk from an ASP.NET MVC application.
-
Integrate Theia IDE with Live Aweber Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Aweber data from within the development environment.
-
Access Live Cvent Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Cvent data from your Google Sheets.
-
Creating SAP Ariba Procurement-Connected Applications in Unqork
You can use CData Connect AI to feed SAP Ariba Procurement data to Unqork and build custom business apps.
-
Integrate Cline with Live Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Oracle Financials Cloud data from within your IDE.
-
A PostgreSQL Interface for QuickBooks Data (MySQL Remoting via JDBC)
Use the Remoting features of the QuickBooks JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Claude Code CLI with CockroachDB 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 Live Asana Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Asana data securely in real time.
-
Automated Continuous HubSpot Replication to MySQL
Use CData Sync for automated, continuous, customizable HubSpot replication to MySQL.
-
Getting Started with the CData Tableau Connector for Authorize.Net
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Authorize.Net.
-
Getting Started with the CData Power BI Connector for Oracle
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Oracle.
-
Use Claude to Talk to Your Bright Data 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 Bright Data data for you.
-
Connect to RSS Feeds through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with RSS Feeds using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate with Paymo Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Paymo data in SnapLogic.
-
Automate BigCommerce Integration Tasks from PowerShell
Are you in search of a quick and easy way to access BigCommerce data from PowerShell? This article demonstrates how to utilize the BigCommerce Cmdlets for tasks like connecting to BigCommerce data, automating operations, downloading data, and more.
-
How to Connect to Zoho Projects Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Zoho Projects data. Leverage the pyodbc module for ODBC in Python.
-
Build Voice Agents in ElevenLabs with access to Live Perplexity Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Perplexity data.
-
Access Live Vault CRM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Vault CRM data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create SAP Hybris C4C Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP Hybris C4C from PowerBI.com to create Power BI Dataflows with real-time data.
-
Prepare, Blend, and Analyze Paylocity Data in Alteryx Designer (ODBC)
Build workflows to access live Paylocity data for self-service data analytics.
-
Build QuickBooks Time-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to QuickBooks Time data and build web apps with connectivity to live QuickBooks Time data.
-
Build OneNote-Connected Apps in Choreo
Use CData Connect AI to connect to OneNote Data from Choreo and build custom apps using live OneNote data.
-
Import Google Ads Data Using Azure Data Factory
Use CData Connect AI to connect to Google Ads Data from Azure Data Factory and import live Google Ads data.
-
How to Build an ETL App for PabblySubscriptions Data in Python with CData
Create ETL applications and real-time data pipelines for PabblySubscriptions data in Python with petl.
-
Replicate Multiple Freshteam Accounts
Replicate multiple Freshteam accounts to one or many databases.
-
Connect to OpenWeatherMap 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 OpenWeatherMap and work with OpenWeatherMap data in your FileMaker application.
-
Create Pushbullet Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Pushbullet from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live MySQL Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate MySQL data into the statistical analysis tools available in SAS JMP. This article shows how to use MySQL data in the Graph Builder and Query Builder.
-
Getting Started with the CData Tableau Connector for SpaceX
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrating GitHub Copilot with Elasticsearch 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.
-
Automated Continuous ClickTime Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ClickTime replication to Google BigQuery.
-
Link Apify with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Apify data in Filemaker Pro for Mac or Windows.
-
How to Use a Microsoft Access Database to Update Slack Data in Real Time
Update Slack data by creating a linked table in Microsoft Access with the CData Slack ODBC Driver.
-
Query SendGrid Data in DataGrip
Create a Data Source for SendGrid in DataGrip and use SQL to query live SendGrid data.
-
Automated Continuous Copper Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Copper replication to Amazon Redshift.
-
How to publish and share Outlook Data dashboards with Tableau Server
The CData ODBC driver for Outlook enables you integrate Outlook data into Tableau dashboards.
-
Replicate EmailOctopus Data from PowerShell
Write a quick PowerShell script to query EmailOctopus data. Use connectivity to the live data to replicate EmailOctopus data to SQL Server.
-
Use the CData ODBC Driver for IBM Informix from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for IBM Informix to connect to IBM Informix data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring IBM Informix data in Excel.
-
How to connect PolyBase to Adobe Experience Manager
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Adobe Experience Manager data.
-
Connect to Stack Exchange Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Stack Exchange data using standard SQL.