CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Box Replication to Snowflake
Use CData Sync for automated, continuous, customizable Box replication to Snowflake.
-
How to Access Live Simplesat Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Simplesat enables you to integrate Simplesat into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Stack Exchange Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Apache Cassandra.
-
How to connect to Toggl Data in DBVisualizer
Integrate Toggl with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Goose with Live EnterpriseDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live EnterpriseDB from within the local AI agent.
-
Connect to Salesforce Marketing Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Salesforce Marketing Cloud in Airbyte.
-
Connect to Microsoft Planner from a Connection Pool in WebLogic
Use the CData JDBC Driver for Microsoft Planner to connect to Microsoft Planner from Web applications running on WebLogic.
-
Replicate Multiple Sage 300 Accounts via the CData Sync CLI
Replicate multiple Sage 300 accounts to one or many databases.
-
How to create an RPA flow for Basecamp Data in UiPath Studio
Use the Basecamp ODBC Driver to create workflows that access real-time Basecamp without any coding.
-
How to Access GraphQL Data Using Entity Framework
This article shows how to access GraphQL using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Analyze SFTP Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SFTP and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Analyze Smartsheet Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Smartsheet and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous Cvent Replication to Oracle
Use CData Sync for automated, continuous, customizable Cvent replication to Oracle.
-
Connect to Active Directory Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Active Directory in the Denodo Virtual DataPort Administrator.
-
Access Live Gmail Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Gmail data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Chargebee Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Chargebee as an External Source in Dremio.
-
How to Connect DBeaver to Facebook Ads via a JDBC Driver
Manage Facebook Ads with visual tools in DBeaver like the query browser.
-
Automated Reckon Data Replication to Teradata
Use CData Sync to Customize and automate Reckon replication to Teradata.
-
Connect to Google Forms Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Forms and the SQL Gateway to access Google Forms from Google Apps Script.
-
How to Query Live TaxJar Data in Perplexity MacOS Desktop
Connect to and query live TaxJar Data in Perplexity Desktop using CData MCP Server.
-
Build AI Agents with Odoo 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 Odoo ERP through CData Connect AI.
-
Use the CData ODBC Driver for Short.io from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Short.io to connect to Short.io from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Short.io in Excel.
-
Build a PostgreSQL Interface for SpaceX Data using the CData JDBC Driver
Use the Remoting features of the SpaceX JDBC Driver to create a PostgreSQL entry-point for data access.
-
Choosing the Best Method to Connect Amazon S3 to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Amazon S3 from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate with MailerSend Data in JReport Designer
Create charts and reports based on MailerSend in JReport Designer.
-
Automated Continuous BenchmarkEmail Replication to SQLite
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to SQLite.
-
Access Live Basecamp Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Basecamp from your Excel spreadsheets.
-
Feed VWO Data into FineReport
How to set VWO as a JDBC data source in FineReport.
-
DataBind Controls to LionDesk Data in Delphi
DataBind to LionDesk in Delphi with standard data access components and controls.
-
Connecting Pipedream with Epicor Kinetic Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Epicor Kinetic data in real time.
-
Create SAP BusinessObjects BI Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP BusinessObjects BI from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Query Live IBM Informix Data in Claude Desktop
Connect to and query live IBM Informix Data in Claude Desktop using CData MCP Server.
-
Connect to Oracle Eloqua Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Oracle Eloqua and the SQL Gateway to access Oracle Eloqua from Google Apps Script.
-
How to Visualize Mistral AI Data in Python with pandas
Use pandas and other modules to analyze and visualize live Mistral AI in Python.
-
How to connect to MailChimp Data with Squirrel SQL client
Connect to MailChimp and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData SSIS Components for Google Campaign Manager 360
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Campaign Manager 360.
-
Migrating data from Dynamics NAV to Databricks using CData SSIS Components.
Easily push Microsoft Dynamics NAV to Databricks using the CData SSIS Tasks for Dynamics NAV and Databricks.
-
Load OnePageCrm Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load OnePageCrm to a database.
-
Explore Geographical Relationships in Oracle Financials Cloud Data with Power Map
Create data visualizations with Oracle Financials Cloud in Power Map.
-
Access Live Suadeo Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Suadeo into the statistical analysis tools available in SAS JMP. This article shows how to use Suadeo in the Graph Builder and Query Builder.
-
Build Charts with ServiceNow Data in Clear Analytics
Create dynamic charts and perform analytics based on ServiceNow in Clear Analytics.
-
Automated Planio Data Replication to Teradata
Use CData Sync to Customize and automate Planio replication to Teradata.
-
Integrating Cursor CLI with Google Drive 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.
-
Publish Crystal Reports on Everhour Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Everhour.
-
A PostgreSQL Interface for LionDesk Data using the CData ODBC Driver
Use the SQL Gateway and LionDesk ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Dataiku with HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live HubSpot.
-
Deploy the ADO.NET Provider for PostgreSQL on an SSRS Report Server
Connect to PostgreSQL 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.
-
Connect to Foursquare Data in HULFT Integrate
Connect to Foursquare as a JDBC data source in HULFT Integrate
-
Import Real-Time Salesforce Pardot Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Salesforce Pardot in ColdFusion.
-
Publish Wrike-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Wrike.
-
Integrating Gumloop with Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Facebook Ads within automated workflows.
-
Publish NetSuite-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live NetSuite CRM & ERP.
-
Connect Sage Intacct to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sage Intacct using the CData Python MCP Server.
-
Integrating Antigravity CLI with WooCommerce via CData CLI
Connect WooCommerce to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Google Cloud Storage using the Model Context Protocol.
-
Integrate Strava with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Strava with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Strava.
-
Connect to Productboard Data in HULFT Integrate
Connect to Productboard as a JDBC data source in HULFT Integrate
-
How to use SQLAlchemy ORM to access Exa Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Exa.
-
Access Live FreshBooks Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live FreshBooks through MCP integration.
-
Integrate SageHR Data in the Pentaho Report Designer
Publish reports based on SageHR in the Pentaho BI tool.
-
Visualize PolarTeamPro Data in Tableau
The CData ODBC driver for PolarTeamPro enables you integrate PolarTeamPro into Tableau dashboards.
-
Edit and Search Instagram External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Instagram to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Instagram objects that you can access from apps and the dashboard.
-
Build MVC Applications with Connectivity to Teamwork Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Teamwork from an ASP.NET MVC application.
-
How to connect to Chargebee Data with Squirrel SQL client
Connect to Chargebee and execute queries in the Squirrel SQL Client.
-
Integrating Claude Code CLI with Mode 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.
-
Building Dynamic Web Pages with Klaviyo Data Using AngularJS
Create single-page applications with live connectivity to Klaviyo using the CData API Server.
-
Integrating Antigravity CLI with Tanda via CData CLI
Connect Tanda to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Live Omnisend Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Omnisend to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Access Live Missive Data in AWS Lambda
Connect to live Missive in AWS Lambda using the CData JDBC Driver.
-
Automate Pingdom Data Replication to SAP HANA
Use CData Sync to customize and automate Pingdom replication to SAP HANA.
-
Connect to WordPress Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for WordPress in Airbyte.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Apache Avro to Power BI dashboards. Simply drag and drop Apache Avro into data visuals on the Power BI canvas.
-
Configure the CData JDBC Driver for GetResponse in a Connection Pool in Tomcat
Connect to GetResponse from a connection pool in Tomcat.
-
Integrate Open WebUI with Live Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft Teams from within the chat interface.
-
Use Microsoft Copilot Studio to talk to your Act CRM 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 Act CRM for you.
-
How to Connect to Live Oracle SCM Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Oracle SCM for you.
-
Automated Continuous Opsgenie Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Opsgenie replication to Apache Cassandra.
-
Integrating GitHub Copilot CLI with PhantomBuster 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 and Visualize Live EmailOctopus Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live EmailOctopus.
-
Import Real-Time ScrapingBee Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ScrapingBee in ColdFusion.
-
Use Claude to Talk to Your GitHub 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 GitHub for you.
-
Create SSAS Tabular Models from OpenWeatherMap Data
How to build a SQL Server Analysis Service Tabular Model from OpenWeatherMap using CData drivers.
-
DataBind eBay Analytics Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for eBay Analytics with the DevExpress Windows Forms and Web controls to provide eBay Analytics to a chart.
-
Automate Adobe Target Data Replication to SAP HANA
Use CData Sync to customize and automate Adobe Target replication to SAP HANA.
-
Connect to OData Services in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for OData in Airbyte.
-
How to Connect DBeaver to Productboard via a JDBC Driver
Manage Productboard with visual tools in DBeaver like the query browser.
-
How to Build an ETL App for Helpscout Data in Python with CData
Create ETL applications and real-time data pipelines for Helpscout in Python with petl.
-
How to Seamlessly Import Paddle Data into IBM SPSS Modeler
Integrate Paddle data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Pipelines with Live Office 365 Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Office 365 from Google Cloud Data Fusion, enabling the integration of live Microsoft Office 365 into the building and management of effective data pipelines.
-
Query CampaignMonitor Data in DataGrip
Create a Data Source for CampaignMonitor in DataGrip and use SQL to query live CampaignMonitor.
-
Getting Started with the CData Power BI Connector for Apify
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Access Live Drip Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Drip enables you to integrate Drip into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Odoo Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Odoo ERP replication to OneLake in Microsoft Fabric.
-
Visualize Bugsnag Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Bugsnag into TIBCO Spotfire.
-
Connect to GitHub Data in CloverDX (formerly CloverETL)
Transfer GitHub using the visual workflow in the CloverDX data integration tool.
-
Create Informatica Mappings From/To an ODBC Data Source for OData
Create an ODBC connection to OData in Informatica and browse and transfer OData.
-
Connect to BigQuery Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Migrating data from Mixpanel to Google BigQuery using CData SSIS Components.
Easily push Mixpanel to Google BigQuery using the CData SSIS Tasks for Mixpanel and Google BigQuery.
-
Getting Started with the CData Tableau Connector for Facebook
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Facebook.
-
Use the CData ODBC Driver for Vimeo from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Vimeo to connect to Vimeo from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Vimeo in Excel.