CData Software - Knowledge Base
Recent Articles
-
Establish a Live Connection with Dotmailer Data using Tableau Bridge
The CData ODBC Driver for Dotmailer enables you to integrate live Dotmailer into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous GetResponse Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable GetResponse replication to Google Cloud SQL.
-
Integrating Kiro CLI with Guru 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.
-
Visualize Live Freshservice Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Freshservice into custom reports in Power BI.
-
Getting Started with the CData Tableau Connector for Drip
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build Apps with Live Shopify in Adalo using CData Connect AI
Use CData Connect AI to integrate live Shopify into the Adalo platform and build custom mobile and web applications with real-time Shopify.
-
Connect to CockroachDB Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for CockroachDB to connect to CockroachDB and execute queries in PowerBuilder.
-
Visualize Avro Data in TIBCO Spotfire through ADO.NET
Integrate Apache Avro into dashboards in TIBCO Spotfire.
-
Connect and Query Live Google Sheets Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Google Sheets into Databricks
-
Excel Spreadsheet Automation on AdRoll Data with the QUERY Formula
Pull data from AdRoll, automate spreadsheets, and more with the QUERY formula.
-
Access Live Gorgias Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Gorgias data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Access Live Monday.com Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Monday.com data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Replicate Retently Data to Multiple Databases via the CData Sync CLI
Replicate Retently to disparate databases with a single configuration.
-
Integrating Codex CLI with ElevenLabs 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 import Confluence Data into Apache Solr
Use the CData Software JDBC Driver for Confluence in Data Import Handler and create an automated import of Atlassian Confluence to Apache Solr Enterprise Search platform.
-
Perform Batch Operations with FTP Data in Apache NiFi
Connect to FTP Servers and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Visualize Live GraphQL Data in the Power BI Service
Use CData Connect AI to connect to live GraphQL and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Helpscout Data in Tableau
The CData ODBC driver for Helpscout enables you integrate Helpscout into Tableau dashboards.
-
Use the CData ODBC Driver for Recurly from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Recurly to connect to Recurly from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Recurly in Excel.
-
Use the CData API Server to Access Tickspot Data in Microsoft PowerPivot
Use the CData API Server to connect to live Tickspot in the Power Pivot business intelligence tool.
-
Consume Certinia OData Feeds in PowerBuilder
This article demonstrates how to consume Certinia as OData feeds from PowerBuilder using the API Server.
-
How to Build an ETL App for Amazon Marketplace Data in Python with CData
Create ETL applications and real-time data pipelines for Amazon Marketplace in Python with petl.
-
Build BigCommerce-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to BigCommerce and build web apps with connectivity to live BigCommerce.
-
Build Oracle Sales Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Oracle Sales and build visualizations in Tableau.
-
Access Live Oracle Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Oracle Database into the statistical analysis tools available in SAS JMP. This article shows how to use Oracle Database in the Graph Builder and Query Builder.
-
Create Dashboards and Visualize Live SingleStore Data in Geckoboard
Use CData Connect AI to connect to live SingleStore and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access Landbot Data from MySQL in Amazon QuickSight
Connect to Landbot and build visualizations of Landbot using a MySQL Connection in Amazon QuickSight.
-
Build MVC Applications with Connectivity to Optimizely Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Optimizely from an ASP.NET MVC application.
-
Connect Telegram Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Telegram using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Google Analytics Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Analytics replication to SingleStore.
-
ETL Onfleet in Oracle Data Integrator
This article shows how to transfer Onfleet into a data warehouse using Oracle Data Integrator.
-
Integrate Cline with Live Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Blackbaud FE NXT from within your IDE.
-
Migrating data from Blackbaud FE NXT to Google BigQuery using CData SSIS Components.
Easily push Blackbaud FE NXT to Google BigQuery using the CData SSIS Tasks for Blackbaud FE NXT and Google BigQuery.
-
Use Biml to Build SSIS Tasks to Replicate Flowlu Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Flowlu to SQL Server.
-
Connect to Hive Data in Ruby
Connect to Apache Hive in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Rapidly Develop Placid-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 Placid.
-
Provide OData Services of Office 365 Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft Office 365 by developing a WCF Service Application.
-
Replicate ClickTime Data in Heroku for Use in Salesforce Connect
Replicate ClickTime to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous EnterpriseDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to SingleStore.
-
Natively Connect to Slack Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Slack. Leverage the native support for ODBC in PHP.
-
How to Query Live Sentry Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Sentry data in natural language using Python.
-
Replicate Teradata Data to Multiple Databases
Replicate Teradata to disparate databases with a point-and-click configuration.
-
Query Mocean Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Mocean and perform CRUD operations on Mocean from Node.js.
-
Replicate Multiple Jumpseller Accounts via the CData Sync CLI
Replicate multiple Jumpseller accounts to one or many databases.
-
Visualize Salesforce CRM Analytics Data in TIBCO Spotfire through ADO.NET
Integrate Salesforce CRM Analytics into dashboards in TIBCO Spotfire.
-
Import and Visualize BenchmarkEmail Data in Power View
Create data visualizations based on BenchmarkEmail in Excel.
-
Integrating GitHub Copilot CLI with CampaignMonitor 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 Clio Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Clio from PowerShell? This article demonstrates how to utilize the Clio Cmdlets for tasks like connecting to Clio, automating operations, downloading data, and more.
-
Work with Google Drive Data in FoxPro
Load Google Drive into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live Miro Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Miro data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Close Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Close in the Denodo Virtual DataPort Administrator.
-
Connect to CSV Data in RapidMiner
Integrate CSV/TSV Files with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous eBay Replication to MongoDB
Use CData Sync for automated, continuous, customizable eBay replication to MongoDB.
-
Viewing Paddle Data in RAD Studio Data Explorer
How to view Paddle in RAD Studio Data Explorer using the CData ODBC Driver for Paddle.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Printful
Provide connectivity to Printful through an SAP BusinessObjects universe.
-
Publish Hacker News-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Hacker News.
-
DataBind CircleCI Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide CircleCI to a chart.
-
Connect to Square from a Connection Pool in WebLogic
Use the CData JDBC Driver for Square to connect to Square from Web applications running on WebLogic.
-
Natively Connect to ServiceDesk Plus Data in PHP
The CData ODBC driver for ServiceDesk Plus enables you to create PHP applications with connectivity to ServiceDesk Plus. Leverage the native support for ODBC in PHP.
-
How to load Toggl data into Elasticsearch via Logstash
Introducing a simple method to load Toggl data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate with JSON Services in JReport Designer
Create charts and reports based on JSON in JReport Designer.
-
Connect to Mocean Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Mocean in the Denodo Virtual DataPort Administrator.
-
A PostgreSQL Interface for Webflow Data using the CData ODBC Driver
Use the SQL Gateway and Webflow ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use Dash to Build to Web Apps on ClickTime Data
Create Python applications that use pandas and Dash to build ClickTime-connected web apps.
-
Query Notion Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Notion from Node.js.
-
Access Perigon Data from MySQL in PHP
Connect to Perigon through the standard MySQL libraries in PHP.
-
Operational Reporting on SAP Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP ERP/NetWeaver.
-
Automate ClickUp Data Replication to Azure Synapse
Use CData Sync to customize and automate ClickUp replication to Azure Synapse.
-
Use the CData API Server to Access Klipfolio Data in Microsoft PowerPivot
Use the CData API Server to connect to live Klipfolio in the Power Pivot business intelligence tool.
-
Automated Continuous GraphQL Replication to SingleStore
Use CData Sync for automated, continuous, customizable GraphQL replication to SingleStore.
-
Connect Auth0 to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Auth0 with IBM WebSphere for seamless data integration and connectivity.
-
Replicate Multiple Access Accounts via the CData Sync CLI
Replicate multiple Access accounts to one or many databases.
-
Build Data Flows from Clio to SQL Server using SSIS
Easily back up Clio to SQL Server using the SSIS components for Clio.
-
Build Pipelines with Live WordPress Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to WordPress from Google Cloud Data Fusion, enabling the integration of live WordPress into the building and management of effective data pipelines.
-
Use the CData ODBC Driver for Everhour from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Everhour to connect to Everhour from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Everhour in Excel.
-
DataBind Controls to Freshdesk Data in C++Builder
DataBind to Freshdesk in C++Builder with standard components and controls.
-
Integrate Apollo with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Apollo with External Services.
-
Integrate Jumpseller with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Jumpseller with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Jumpseller.
-
Access Live Notion Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Notion in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Add SharePoint Excel Services Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SharePoint Excel Services with the Informatica Enterprise Data Catalog to classify and organize data.
-
PivotalTracker Reporting in OBIEE with the PivotalTracker JDBC Driver
Deploy the PivotalTracker JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Data Flows from Gmail to SQL Server using SSIS
Easily back up Gmail to SQL Server using the SSIS components for Gmail.
-
Automate Everhour Data Replication to Couchbase
Use CData Sync to Customize and automate Everhour replication to Couchbase.
-
Analyze Sage 300 Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sage 300 from Power Pivot. You will use the Table Import Wizard to load Sage 300. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Adobe Experience Manager Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to connect to Foursquare Data from Spring Boot
Connect to Foursquare in a Spring Boot Application using the CData API Driver for JDBC
-
Query Bullhorn CRM Data as a SQL Server Database in Node.js
Execute SQL Server queries against Bullhorn CRM from Node.js.
-
Getting Started with the CData ADO.NET Provider for Customer.io
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Import Real-Time Zuora Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zuora in ColdFusion.
-
Migrating data from Google Tasks to Databricks using CData SSIS Components.
Easily push Google Tasks to Databricks using the CData SSIS Tasks for Google Tasks and Databricks.
-
How to Query Live Drip Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Drip data in natural language using Python.
-
Automated Continuous PayPal Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable PayPal replication to Google BigQuery.
-
Object-Relational Mapping (ORM) with Pipeliner CRM Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Pipeliner CRM into a Java-based ORM framework, Hibernate.
-
Connect to Bullhorn CRM from Asprova with CData Software ODBC Driver for Bullhorn CRM
This article shows how to connect faster to Bullhorn CRM data from Asprova.
-
How to connect SharePoint with Mocean Data through external lists
Provide Mocean to SharePoint users as an external list.
-
How to Query Live Wrike Data in Perplexity MacOS Desktop
Connect to and query live Wrike Data in Perplexity Desktop using CData MCP Server.
-
Connect to Adobe Analytics Data in CloverDX (formerly CloverETL)
Transfer Adobe Analytics using the visual workflow in the CloverDX data integration tool.
-
Build Reckon Accounts Hosted Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Reckon Accounts Hosted and build visualizations in Tableau Cloud.
-
Visualize PingOne Data in Sisense
Create an ElastiCube in Sisense app with access to PingOne.
-
Access Live Bannerbear Data in AWS Lambda
Connect to live Bannerbear in AWS Lambda using the CData JDBC Driver.