CData Software - Knowledge Base
Recent Articles
-
Connect to ElevenLabs Data in CloverDX (formerly CloverETL)
Transfer ElevenLabs using the visual workflow in the CloverDX data integration tool.
-
Replicate Snapchat Ads Data in Heroku for Use in Salesforce Connect
Replicate Snapchat Ads to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build DB2-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live IBM DB2.
-
Build Phoenix-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Phoenix to explore live Phoenix Data in Cursor to assist with building Phoenix-powered applications.
-
Connect to Real-Time Paymo Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Paymo in Power Apps.
-
Working with SharePoint Data in LINQPad
Execute LINQ queries to Microsoft SharePoint in LINQPad.
-
How to Query Live ZohoMarketingHub Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ZohoMarketingHub data in natural language using Python.
-
Automated Continuous BenchmarkEmail Replication to Databricks
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to Databricks.
-
Integrate Live Hacker News Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Hacker News to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build OData-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for OData Services and create custom apps in Mendix.
-
How to connect to AfterShip Data in DBVisualizer
Integrate AfterShip with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate with Cvent Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Cvent in SnapLogic.
-
Getting Started with the CData Python Connector for Azure DevOps
Learn to install and license the CData Python Connector
-
Create SSAS Tabular Models from Apify Data
How to build a SQL Server Analysis Service Tabular Model from Apify using CData drivers.
-
Publish Crystal Reports on Basecamp Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Basecamp.
-
Integrating Antigravity CLI with Contentful via CData CLI
Connect Contentful to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automate Highrise Data Replication to Azure Data Lake
Use CData Sync to customize and automate Highrise CRM replication to Azure Data Lake.
-
Build Pipelines with Live Adobe Commerce Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Adobe Commerce from Google Cloud Data Fusion, enabling the integration of live Adobe Commerce into the building and management of effective data pipelines.
-
Automated Continuous Egnyte Replication to Snowflake
Use CData Sync for automated, continuous, customizable Egnyte replication to Snowflake.
-
Use the CData Software JDBC Driver for Google Translate in MicroStrategy Desktop
Connect to Google Translate in MicroStrategy Desktop using the CData Software JDBC Driver for Google Translate.
-
Use the CData ODBC Driver for BambooHR from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for BambooHR to connect to BambooHR from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring BambooHR in Excel.
-
Build AI Agents with Raisers Edge NXT Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Raisers Edge NXT through CData Connect AI.
-
Build Dashboards with Dynamics 365 Business Central Data in DBxtra
Create dynamic dashboards and perform analytics based on Dynamics 365 Business Central in DBxtra.
-
Choosing the Best Method to Connect Quickbase to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Quickbase from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Access NetSuite Data Using Entity Framework
This article shows how to access NetSuite CRM & ERP using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Semantic Layer Views for SAP HANA Data in APOS Live Data Gateway
Use the CData Connector for SAP HANA in APOS Live Data Gateway to build Semantic Layer Views for SAP HANA.
-
Integrating Antigravity CLI with Avalara AvaTax via CData CLI
Connect Avalara AvaTax to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
A PostgreSQL Interface for PhantomBuster Data (MySQL Remoting via JDBC)
Use the Remoting features of the PhantomBuster JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to import Zoho CRM Data into Apache Solr
Use the CData Software JDBC Driver for Zoho CRM in Data Import Handler and create an automated import of Zoho CRM to Apache Solr Enterprise Search platform.
-
Publish Crystal Reports on Notion Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Notion.
-
How to Design Sybase Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Sybase from mobile and tablet Power Apps.
-
Automated Continuous Everhour Replication to MongoDB
Use CData Sync for automated, continuous, customizable Everhour replication to MongoDB.
-
A PostgreSQL Interface for Zoom Data using the CData ODBC Driver
Use the SQL Gateway and Zoom ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Databricks-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Databricks and build web apps with connectivity to live Databricks.
-
Automate Oracle Service Cloud Data Replication to Azure Data Lake
Use CData Sync to customize and automate Oracle Service Cloud replication to Azure Data Lake.
-
Use Agno to Talk to Your SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Microsoft SQL Server for you.
-
Automated Continuous Zoom Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Zoom replication to delimited files (CSV/TSV).
-
Connect to ZeroBounce Data in RazorSQL
Connect to ZeroBounce from wizards and query ZeroBounce from the GUI in the RazorSQL database management tool.
-
Replicate Multiple Optimizely Accounts
Replicate multiple Optimizely accounts to one or many databases.
-
Getting Started with the CData JDBC Driver for Workday
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Workday.
-
Access Live Sybase Data in Coginiti Pro
Connect to and query live Sybase from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Access Live WooCommerce Data in Visual Studio Code via Cline
Run CData MCP Server for WooCommerce on Windows Subsytem for Linux (WSL) and connect to live WooCommerce from the Cline extension in Visual Studio Code.
-
How to Query Live Redshift Data in Claude Desktop
Connect to and query live Redshift Data in Claude Desktop using CData MCP Server.
-
Use ChatGPT to Talk to Your Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Google Search for you.
-
Integrating iContact Data in Talend Cloud Data Management Platform
Connect iContact Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Work with MailChimp Data in FoxPro
Load MailChimp into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Google Drive Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use JayDeBeApi to access BigQuery Data in Python
Use standard Python scripting and the development environment of your choice to access live Google BigQuery.
-
Migrating data from PhantomBuster to Google BigQuery using CData SSIS Components.
Easily push PhantomBuster to Google BigQuery using the CData SSIS Tasks for PhantomBuster and Google BigQuery.
-
Connect SAP Business Warehouse Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP Business Warehouse using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Analyze Highrise Data in Looker
Use CData Connect AI to connect to Highrise Data from Looker and build custom apps using live Highrise CRM.
-
Connect to Gmail Data in CloverDX (formerly CloverETL)
Transfer Gmail using the visual workflow in the CloverDX data integration tool.
-
Integrate Live Greenhouse Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
View Reports on Real-Time Productboard Data in Power BI Report Server
Use the CData ODBC Driver for Productboard to visualize Productboard in Power BI Desktop and then publish them to Power BI Report Server.
-
Query Avaza Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Avaza from Node.js.
-
Connect to Gorgias Data in DBArtisan
Use wizards in DBArtisan to configure Gorgias as a data source.
-
How to Connect to PagerDuty Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to PagerDuty. Leverage the pyodbc module for ODBC in Python.
-
Build Data Flows from Printful to SQL Server using SSIS
Easily back up Printful to SQL Server using the SSIS components for Printful.
-
Integrating WordPress Data in Talend Cloud Data Management Platform
Connect WordPress Data with Talend Cloud Data Management Platform using the CData JDBC Driver for WordPress.
-
Access Live YouTube Analytics Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live YouTube Analytics from your Google Sheets.
-
Natively Connect to CloudConvert Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to CloudConvert. Leverage the native support for ODBC in PHP.
-
Integrate SAP ByDesign Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Business ByDesign from Informatica Cloud.
-
DataBind Charts to Cohere Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Cohere 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.
-
How to connect PolyBase to Monday.com
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Monday.com.
-
Build QuickBooks Time-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for QuickBooks Time to explore live QuickBooks Time Data in GitHub Copilot to assist with building QuickBooks Time-powered applications.
-
Design BIRT Reports on Google Forms Data
Provide current Google Forms to your embedded analytics.
-
Create Cvent Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Cvent data access from reports, embedded analytics, and more.
-
How to Use a Microsoft Access Database to Update Google Contacts Data in Real Time
Update Google Contacts data by creating a linked table in Microsoft Access with the CData Google Contacts ODBC Driver.
-
ETL Basecamp in Oracle Data Integrator
This article shows how to transfer Basecamp into a data warehouse using Oracle Data Integrator.
-
How to Build an ETL App for Copper Data in Python with CData
Create ETL applications and real-time data pipelines for Copper in Python with petl.
-
DataBind Float Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Float to a chart.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Keap
Provide connectivity to Keap through an SAP BusinessObjects universe.
-
Use the CData Software JDBC Driver for BigCommerce in MicroStrategy Web
Connect to BigCommerce in MicroStrategy Web using the CData Software JDBC Driver for BigCommerce.
-
Automated Continuous eBay Replication to SQLite
Use CData Sync for automated, continuous, customizable eBay replication to SQLite.
-
Connect to Email Data from AWS Glue
Use CData Connect AI to gain access to live Email from your AWS Glue jobs.
-
Build Microsoft Planner-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Microsoft Planner Data and create custom apps in Bubble.
-
How to Access Live LinkedIn Ads Data in Power Automate Desktop via ODBC
The CData ODBC Driver for LinkedIn Ads enables you to integrate LinkedIn Ads into workflows built using Microsoft Power Automate Desktop.
-
Connect Paylocity Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Paylocity using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Build an ETL App for WordPress Data in Python with CData
Create ETL applications and real-time data pipelines for WordPress in Python with petl.
-
Use Microsoft Copilot Studio to talk to your Presto 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 Presto for you.
-
Connect to Brex Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Brex and work with Brex in your FileMaker applications.
-
Build Dashboards with AfterShip Data in Dundas BI
Create dynamic dashboards and perform analytics based on AfterShip in Dundas BI.
-
How to Query Unbounce Data in MySQL Workbench
Execute MySQL queries against live Unbounce from MySQL Workbench.
-
Back Up ClickUp 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 ClickUp data.
-
Visualize Live Vercel Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Vercel.
-
Access Hacker News 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 Hacker News.
-
Integrate Google Contacts with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Contacts with External Services.
-
Deploy the ADO.NET Provider for Parallel on an SSRS Report Server
Connect to Parallel 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.
-
Publish Reports with ZohoDesk Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZohoDesk.
-
Create SSAS Tabular Models from Odoo Data
How to build a SQL Server Analysis Service Tabular Model from Odoo ERP using CData drivers.
-
Access Box Data from MySQL in PHP
Connect to Box through the standard MySQL libraries in PHP.
-
Automated Continuous Calendly Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Calendly replication to Google Cloud SQL.
-
Migrating data from Exact Online to Google BigQuery using CData SSIS Components.
Easily push Exact Online to Google BigQuery using the CData SSIS Tasks for Exact Online and Google BigQuery.
-
Create Dynamic ZohoInvoice Grids Using the Infragistics XamDataGrid
Learn how you can connect ZohoInvoice to Infragistics XamDataGrid to build dynamic grids.
-
Create Reports with ActiveCampaign Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ActiveCampaign.
-
Natively Connect to PayPal Data in PHP
The CData ODBC driver for PayPal enables you to create PHP applications with connectivity to PayPal. Leverage the native support for ODBC in PHP.
-
Build Automated Google Contacts-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Contacts and build automated workflows in Zapier.
-
Extract, Transform, and Load Microsoft Ads Data in Informatica PowerCenter
Create a simple Workflow for Microsoft Ads in Informatica PowerCenter.
-
Getting Started with the CData Power BI Connector for Float
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
LINQ to AfterShip Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the AfterShip Data Provider.