CData Software - Knowledge Base
Recent Articles
-
Integrating Antigravity CLI with Sugar CRM via CData CLI
Connect Sugar CRM to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous iContact Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable iContact replication to Google Cloud SQL.
-
Automated Continuous Avro Replication to Oracle
Use CData Sync for automated, continuous, customizable Avro replication to Oracle.
-
Build Dashboards with Microsoft Entra ID Data in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft Entra ID in Dundas BI.
-
Integrate Sage Intacct with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Sage Intacct with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Sage Intacct.
-
Consume Suadeo OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Suadeo feeds that reflect any changes in SAP Lumira.
-
Access Live SAP ByDesign Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live SAP Business ByDesign through MCP integration.
-
Replicate Multiple Quickbase Accounts via the CData Sync CLI
Replicate multiple Quickbase accounts to one or many databases.
-
Build Charts with HDFS Data in Clear Analytics
Create dynamic charts and perform analytics based on Apache HDFS in Clear Analytics.
-
Connect to Act-On from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Act-On, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Visualize Codat Data in Tableau
The CData ODBC driver for Codat enables you integrate Codat into Tableau dashboards.
-
How to connect to Spotify Data in DBVisualizer
Integrate Spotify with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Datadog Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Datadog replication to Google BigQuery.
-
Create Oracle-Connected Dashboards in Grafana
Connect to Oracle Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Oracle Database.
-
Rapidly Develop Cassandra-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 Cassandra.
-
Back Up ElevenLabs 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 ElevenLabs data.
-
Use Dash to Build to Web Apps on Google Ad Manager Data
Create Python applications that use pandas and Dash to build Google Ad Manager-connected web apps.
-
How to Work with EmailOctopus Data in AWS Glue Jobs Using JDBC
Connect to EmailOctopus from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
DataBind Controls to Aweber Data in Delphi
DataBind to Aweber in Delphi with standard data access components and controls.
-
How to Connect DBeaver to Cvent via a JDBC Driver
Manage Cvent with visual tools in DBeaver like the query browser.
-
Import and Visualize ZeroBounce Data in Power View
Create data visualizations based on ZeroBounce in Excel.
-
Connect to MailChimp Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live MailChimp from Filemaker Pro on Mac.
-
Create MYOB AccountRight Dataflows on PowerBI.com
Connect to the CData Power BI Connector for MYOB AccountRight from PowerBI.com to create Power BI Dataflows with real-time data.
-
Choosing the Best Method to Connect Azure Table to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Azure Table Storage from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Superchat Data in DBArtisan
Use wizards in DBArtisan to configure Superchat as a data source.
-
Connect to NetSuite Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for NetSuite CRM & ERP in the Denodo Virtual DataPort Administrator.
-
Build Twilio-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Twilio Data from Zoho Analytics and import live Twilio.
-
Integrating Boomi Agentstudio with Microsoft Teams Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft Teams, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Deploy the ADO.NET Provider for Blackbaud FE NXT on an SSRS Report Server
Connect to Blackbaud FE NXT 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.
-
Automated Continuous Sybase Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Sybase replication to PostgreSQL.
-
Connect to ZohoSubscriptions Data in HULFT Integrate
Connect to ZohoSubscriptions as a JDBC data source in HULFT Integrate
-
Create Dynamic FormSite Grids Using the Infragistics XamDataGrid
Learn how you can connect FormSite to Infragistics XamDataGrid to build dynamic grids.
-
Query Raisers Edge NXT Data as a SQL Server Database in Node.js
Execute SQL Server queries against Raisers Edge NXT from Node.js.
-
Connect to Printful Data from PowerBuilder via ADO.NET
This article demonstrates how to access Printful from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrating LlamaIndex with Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Apache Hive in real time.
-
Connect to Google Cloud Storage Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Cloud Storage and the SQL Gateway to access Google Cloud Storage from Google Apps Script.
-
Integrating Codex CLI with Auth0 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.
-
Automate Neo4J Data Replication to Couchbase
Use CData Sync to Customize and automate Neo4J replication to Couchbase.
-
Integrate Facebook Ads Data in the Pentaho Report Designer
Publish reports based on Facebook Ads in the Pentaho BI tool.
-
Connect to ZendeskSell Data from a Connection Pool in Jetty
The ZendeskSell JDBC Driver supports connection pooling: This article shows how to connect faster to ZendeskSell from Web apps in Jetty.
-
Visualize Mailgun Data in Tableau
The CData ODBC driver for Mailgun enables you integrate Mailgun into Tableau dashboards.
-
Build an OLAP Cube in SSAS from LightSpeedRetail Data
Establish a connection to LightSpeedRetail data from SQL Server Analysis Services, and use the LightSpeedRetail Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use Biml to Build SSIS Tasks to Replicate Harvest Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Harvest to SQL Server.
-
Back Up YouTube Analytics to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for YouTube Analytics. In this article, we will employ an SSIS workflow to populate a database with YouTube Analytics data.
-
Automate Basecamp Data Replication to Azure Synapse
Use CData Sync to customize and automate Basecamp replication to Azure Synapse.
-
Visualize Dynamics NAV 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 Microsoft Dynamics NAV into TIBCO Spotfire.
-
Integrating OpenCode Terminal with Airtable 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 Kintone Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Kintone replication to Google Cloud SQL.
-
Use the CData Software JDBC Driver for Drift in MicroStrategy
Connect to Drift in MicroStrategy Developer using the CData Software JDBC Driver for Drift.
-
How to Create Power BI Visual Reports with Real-Time Redshift Data
Use CData Power BI Connectors to visualize Amazon Redshift in Power BI.
-
How to connect and process Amazon Marketplace from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Amazon Marketplace.
-
Create Informatica Mappings From/To a JDBC Data Source for ZohoExpense
Create ZohoExpense data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Model CouchDB Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and CouchDB, enabling the direct import of real-time Apache CouchDB.
-
Connect to Google Ad Manager Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
DataBind ClickUp Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ClickUp to a chart.
-
Connect to Real-Time LeadDesk Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use LeadDesk in Power Apps.
-
Use the CData Software JDBC Driver for Google Directory in MicroStrategy Web
Connect to Google Directory in MicroStrategy Web using the CData Software JDBC Driver for Google Directory.
-
Prepare, Blend, and Analyze SageHR Data in Alteryx Designer (ODBC)
Build workflows to access live SageHR for self-service data analytics.
-
Moving Data from Vimeo to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Vimeo data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Zendesk Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zendesk from your Oracle system.
-
Extract, Transform, and Load REST Data in Informatica PowerCenter
Create a simple Workflow for REST in Informatica PowerCenter.
-
Getting Started with the CData Power BI Connector for ScrapingBee
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Configure the CData JDBC Driver for SAP HANA XS Advanced in a Connection Pool in Tomcat
Connect to SAP HANA XS Advanced from a connection pool in Tomcat.
-
Bidirectional Access to Pushbullet Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Pushbullet in Filemaker Pro for Mac or Windows.
-
Use the CData ODBC Driver for Procore from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Procore to connect to Procore from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Procore in Excel.
-
Establish a Live Connection with Hive Data using Tableau Bridge
The CData ODBC Driver for Hive enables you to integrate live Apache Hive into Tableau Cloud dashboards using the Tableau Bridge.
-
Natively Connect to Adobe Analytics Data in PHP
The CData ODBC driver for Adobe Analytics enables you to create PHP applications with connectivity to Adobe Analytics. Leverage the native support for ODBC in PHP.
-
Access SAP HANA Data from MySQL in PHP
Connect to SAP HANA through the standard MySQL libraries in PHP.
-
Build Instagram Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Instagram and build visualizations in Tableau Cloud.
-
How to Connect to Live Microsoft OneDrive Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Microsoft OneDrive without replication.
-
How to integrate Metabase with SharePoint Data
Use CData Connect AI to connect to live Microsoft SharePoint and create an interactive dashboard in Metabase from Microsoft SharePoint.
-
How to Visualize ShipStation Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live ShipStation in Python.
-
Create Reports from Snapchat Ads Data in Looker Studio
Use CData Connect AI to gain access to live Snapchat Ads and create custom reports in Looker Studio.
-
Write a Simple Go Application to work with OneNote Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft OneNote.
-
Getting Started with the CData ADO.NET Provider for Neo4J
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Neo4J.
-
Build Charts with Lakebase Data in Clear Analytics
Create dynamic charts and perform analytics based on Lakebase in Clear Analytics.
-
Connect to and Query Adobe Commerce Data in QlikView over ODBC
Create data visualizations with Adobe Commerce in QlikView.
-
Use Biml to Build SSIS Tasks to Replicate Couchbase Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Couchbase to SQL Server.
-
Creating eBay-Connected Applications in Unqork
You can use CData Connect AI to feed eBay to Unqork and build custom business apps.
-
Integrate Facebook Data in Pentaho Data Integration
Build ETL pipelines based on Facebook in the Pentaho Data Integration tool.
-
Connect Wistia to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Wistia with IBM WebSphere for seamless data integration and connectivity.
-
Use Databricks Agent Bricks to Talk to Your Basecamp Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Basecamp for you.
-
Build Visualizations of Dropbox Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Dropbox in Birst.
-
Access Live Highrise Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Highrise CRM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Oracle Eloqua Data in Sisense
Create an ElastiCube in Sisense app with access to Oracle Eloqua.
-
A PostgreSQL Interface for Snowflake Data (MySQL Remoting via JDBC)
Use the Remoting features of the Snowflake JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Grafana Data in MySQL Workbench
Execute MySQL queries against live Grafana from MySQL Workbench.
-
Connecting GenSpark with eBay Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to eBay without any replication or custom integration required.
-
Bidirectional Access to Sage 200 Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Sage 200 in Filemaker Pro for Mac or Windows.
-
Build Acumatica Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Acumatica ERP and build visualizations in Tableau Cloud.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Retently
Provide connectivity to Retently through an SAP BusinessObjects universe.
-
Add Unbounce Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Unbounce with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Impala Data into Power Automate Desktop using CData Connect
CData Connect for Impala Data enables you to integrate Apache Impala into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData Tableau Connector for Calendly
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Viewing MarkLogic Data in RAD Studio Data Explorer
How to view MarkLogic in RAD Studio Data Explorer using the CData ODBC Driver for MarkLogic.
-
Automated Continuous Freshservice Replication to Oracle
Use CData Sync for automated, continuous, customizable Freshservice replication to Oracle.
-
How to Visualize Shippo Data in Python with pandas
Use pandas and other modules to analyze and visualize live Shippo in Python.
-
Integrate LibreChat with Live Okta Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Okta from within the chat interface.
-
Write a Simple Go Application to work with Humanity Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Humanity.
-
Import Real-Time Monday.com Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Monday.com in ColdFusion.