CData Software - Knowledge Base
Recent Articles
-
How to Work with Pinterest Data in ETL Validator JDBC
Connect to Pinterest from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Snapchat Ads Data in Pentaho Data Integration
Build ETL pipelines based on Snapchat Ads in the Pentaho Data Integration tool.
-
Use Biml to Build SSIS Tasks to Replicate Ontraport Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Ontraport to SQL Server.
-
Access Zuora Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zuora from your Oracle system.
-
How to connect to FTP Data from IntelliJ
Integrate connectivity to FTP Servers with wizards in IntelliJ.
-
Access Hive 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 Apache Hive.
-
Getting Started with the CData Power BI Connector for Printify
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build LinkedIn Ads-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live LinkedIn Ads and build LinkedIn Ads-connected web apps with Axios.
-
How to connect and process Flowlu from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Flowlu.
-
Connect to VWO Data as an External Source in Dremio
Use the CData JDBC Driver to connect to VWO as an External Source in Dremio.
-
Excel Spreadsheet Automation on Flowlu Data with the QUERY Formula
Pull data from Flowlu, automate spreadsheets, and more with the QUERY formula.
-
Prepare, Blend, and Analyze Certinia Data in Alteryx Designer (Connect AI)
Build workflows to access live Certinia for self-service data analytics.
-
Connect to NetSuite SuiteAnalytics Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with NetSuite SuiteAnalytics Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Easily Query Contentful Data in OpenOffice Base
Connect to Contentful data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Bitbucket Data from PowerBuilder via ADO.NET
This article demonstrates how to access Bitbucket from Appeon PowerBuilder using the CData ADO.NET Provider for Bitbucket.
-
How to connect to Supabase Data in DBVisualizer
Integrate Supabase with visual data analysis tools and data connection wizards in DBVisualizer
-
Build SAP Netweaver Gateway-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SAP Netweaver Gateway to explore live SAP Netweaver Gateway Data in GitHub Copilot to assist with building SAP Netweaver Gateway-powered applications.
-
Access Live Databricks Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Databricks data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Automated HDFS Data Replication to Teradata
Use CData Sync to Customize and automate Apache HDFS replication to Teradata.
-
Integrate Theia IDE with Live Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to Access Live Tally Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Tally enables you to integrate Tally ERP into workflows built using Microsoft Power Automate Desktop.
-
Build Semantic Layer Views for Cohere Data in APOS Live Data Gateway
Use the CData Connector for Cohere in APOS Live Data Gateway to build Semantic Layer Views for Cohere.
-
How to Connect to Live Dynamics 365 Business Central Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Dynamics 365 Business Central for you.
-
Integrate with Live MongoDB Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to MongoDB from the MuleSoft Anypoint Platform to integrate live MongoDB into custom reports and dashboards.
-
Validate Outlook Data with QuerySurge
Access and validate Outlook in QuerySurge using the CData JDBC Driver.
-
Stream Workable Data into Apache Kafka Topics
Access and stream Workable in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Parquet Data in DBeaver
Use the CData ODBC Driver to connect to Apache Parquet in DBeaver.
-
Establish a Live Connection with FormSite Data using Tableau Bridge
The CData ODBC Driver for FormSite enables you to integrate live FormSite into Tableau Cloud dashboards using the Tableau Bridge.
-
Write a Simple Go Application to work with Microsoft Teams Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Teams.
-
Use Biml to Build SSIS Tasks to Replicate Google Ad Manager Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Ad Manager to SQL Server.
-
Analyze SuiteCRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SuiteCRM in Microsoft R Open.
-
Access Live ZohoInvoice Data in Coginiti Pro
Connect to and query live ZohoInvoice from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build a Singer.io Tap for Zoho Recruit With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Zoho Recruit data using
-
Write a Simple Go Application to work with Rebilly Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Rebilly.
-
Use the CData Software JDBC Driver for Campaigner in MicroStrategy Web
Connect to Campaigner in MicroStrategy Web using the CData Software JDBC Driver for Campaigner.
-
How to connect to Eventbrite Data from IntelliJ
Integrate connectivity to Eventbrite with wizards in IntelliJ.
-
Moving Data from QuickBooks Online to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live QuickBooks Online data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Publish Teamwork-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Teamwork.
-
Access Teamwork Data from MySQL in Amazon QuickSight
Connect to Teamwork and build visualizations of Teamwork using a MySQL Connection in Amazon QuickSight.
-
Import WordPress Data Using Azure Data Factory
Use CData Connect AI to connect to WordPress Data from Azure Data Factory and import live WordPress.
-
LINQ to JobNimbus 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 JobNimbus Data Provider.
-
Publish SAP Fieldglass-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP Fieldglass.
-
Integrate SingleStore Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SingleStore and integrate live SingleStore into your Power Automate tasks.
-
Automated Continuous Outreach.io Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Outreach.io replication to Azure SQL Database.
-
Load Microsoft Entra ID Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Entra ID to a database.
-
Build Automated Workflows with Live ADP Data in Workato
Use CData Connect AI to connect to live ADP and build automated workflows in Workato.
-
A PostgreSQL Interface for Zoho Recruit Data (MySQL Remoting via JDBC)
Use the Remoting features of the Zoho Recruit JDBC Driver to create a PostgreSQL entry-point for data access.
-
Enable the Webflow JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Webflow.
-
Integrating GitHub Copilot CLI with ActiveCampaign 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.
-
Integrating Miro Data in Talend Cloud Data Management Platform
Connect Miro Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create a Data Access Object for Elasticsearch Data using JDBI
A brief overview of creating a SQL Object API for Elasticsearch in JDBI.
-
Analyze MYOB AccountRight Data in Cognos Analytics
Use CData Connect AI to connect to MYOB AccountRight Data from Cognos Analytics and analyze live MYOB AccountRight.
-
Import Real-Time QuickBooks Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use QuickBooks Desktop in ColdFusion.
-
How to use SQLAlchemy ORM to access Placid Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Placid.
-
SAP Fieldglass Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP Fieldglass facts in real time.
-
Connect to Nuclia Data in DBArtisan
Use wizards in DBArtisan to configure Nuclia as a data source.
-
Replicate Multiple Aircall Accounts via the CData Sync CLI
Replicate multiple Aircall accounts to one or many databases.
-
Connect to HubDB in SpagoBI
Create reports featuring live HubDB in SpagoBI Studio. Host HubDB reports on SpagoBI Server.
-
Connecting Pipedream with CouchDB 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 CouchDB data in real time.
-
Enable the VWO JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with VWO.
-
Manage Basecamp Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Basecamp.
-
How to load Klipfolio data into Elasticsearch via Logstash
Introducing a simple method to load Klipfolio data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Live Tavily Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Tavily to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to ZendeskSell from Asprova with CData Software ODBC Driver for ZendeskSell
This article shows how to connect faster to ZendeskSell data from Asprova.
-
Bridge Raisers Edge NXT Connectivity with Apache NiFi
Access and process Raisers Edge NXT in Apache NiFi using the CData JDBC Driver.
-
A PostgreSQL Interface for SAP Ariba Procurement Data using the CData ODBC Driver
Use the SQL Gateway and SAP Ariba Procurement ODBC Driver to create a PostgreSQL entry-point for data access.
-
Import and Visualize Sage 300 Data in Power View
Create data visualizations based on Sage 300 in Excel.
-
Visualize SFTP Data in Sisense
Create an ElastiCube in Sisense app with access to SFTP.
-
Automate Moosend Data Replication to Azure Synapse
Use CData Sync to customize and automate Moosend replication to Azure Synapse.
-
Visualize Close Data in Sisense
Create an ElastiCube in Sisense app with access to Close.
-
Use the CData Software ODBC Driver for Customer.io in MicroStrategy
Connect to Customer.io in MicroStrategy Developer using the CData Software ODBC Driver for Customer.io.
-
Getting Started with the CData SSIS Components for Perplexity
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Perplexity.
-
Automate SuiteCRM Data Replication to Azure Synapse
Use CData Sync to customize and automate SuiteCRM replication to Azure Synapse.
-
How to integrate Reckon Accounts Hosted with Apache Airflow
Access and process Reckon Accounts Hosted in Apache Airflow using the CData JDBC Driver.
-
Integrating OpenCode Terminal with Campaigner 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.
-
Import Real-Time Everhour Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Everhour in ColdFusion.
-
Import Real-Time ZendeskSell Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ZendeskSell in ColdFusion.
-
Connect to Epicor Kinetic Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Epicor Kinetic.
-
How to Create Power BI Visual Reports with Real-Time Qualaroo Data
Use CData Power BI Connectors to visualize Qualaroo in Power BI.
-
Automated Continuous OnePageCrm Replication to Vertica
Use CData Sync for automated, continuous, customizable OnePageCrm replication to Vertica.
-
How to Connect to Live Paylocity 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 Paylocity without replication.
-
Establish a Live Connection with Klaviyo Data using Tableau Bridge
The CData ODBC Driver for Klaviyo enables you to integrate live Klaviyo into Tableau Cloud dashboards using the Tableau Bridge.
-
Work with Live SAP Ariba Source Data in Power Query
Use CData Connect AI to connect to SAP Ariba Source and work with live SAP Ariba Source in Microsoft Power Query.
-
Configure the CData JDBC Driver for Google Analytics in a Connection Pool in Tomcat
Connect to Google Analytics from a connection pool in Tomcat.
-
Access Live PDFMonkey Data in Coginiti Pro
Connect to and query live PDFMonkey from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build AI/ML Models with Live Excel Data using Dataiku
Connect Excel Data with Dataiku using the CData JDBC Driver for Excel.
-
Visualize Klaviyo Data in TIBCO Spotfire through ADO.NET
Integrate Klaviyo into dashboards in TIBCO Spotfire.
-
Automated Continuous Excel Online Replication to Databricks
Use CData Sync for automated, continuous, customizable Excel Online replication to Databricks.
-
Build Agents in Relevance AI with Access to Live eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on eBay within intelligent agent workflows.
-
Getting Started with the CData Excel Add-In for ShipEngine
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ShipEngine.
-
Access Live Zuora Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Zuora data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to integrate Metabase with DB2 Data
Use CData Connect AI to connect to live IBM DB2 and create an interactive dashboard in Metabase from IBM DB2.
-
Build a PostgreSQL Interface for Wistia Data using the CData JDBC Driver
Use the Remoting features of the Wistia JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Apps from JSON Services in Qlik Sense Cloud
Use CData Connect AI to connect to JSON Services and build apps from live JSON in Qlik Sense Cloud.
-
Use the CData Software ODBC Driver for QuickBooks Online in MicroStrategy Web
Connect to QuickBooks Online in MicroStrategy Web using the CData Software ODBC Driver for QuickBooks Online.
-
Build Data Flows from Raisers Edge NXT to SQL Server using SSIS
Easily back up Raisers Edge NXT to SQL Server using the SSIS components for Raisers Edge NXT.
-
How to publish and share IBM Informix Data dashboards with Tableau Server
The CData ODBC driver for IBM Informix enables you integrate IBM Informix into Tableau dashboards.
-
Build Vertica-Connected Apps in Choreo
Use CData Connect AI to connect to Vertica Data from Choreo and build custom apps using live Vertica.
-
Integrating Bannerbear Data in Talend Cloud Data Management Platform
Connect Bannerbear Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to FreshBooks Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for FreshBooks to connect to FreshBooks and execute queries in PowerBuilder.