CData Software - Knowledge Base
Recent Articles
-
Create Dashboards and Visualize Live Workday Data in Geckoboard
Use CData Connect AI to connect to live Workday data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Viewing Adobe Target Data in RAD Studio Data Explorer
How to view Adobe Target data in RAD Studio Data Explorer using the CData ODBC Driver for Adobe Target.
-
Connect to AdRoll Data in JRuby
Create a simple JRuby app with access to live AdRoll data.
-
Build AI/ML Models with Live Contentful Data using Dataiku
Connect Contentful Data with Dataiku using the CData API Driver for JDBC.
-
How to Visualize ChargeOver Data in Python with pandas
Use pandas and other modules to analyze and visualize live ChargeOver data in Python.
-
Use the CData Software ODBC Driver for Grafana in SAS for Real-Time Reporting and Analytics
Connect to real-time Grafana data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Grafana.
-
How to Connect to Live Outreach.io Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Outreach.io data for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for OnePageCrm
Provide connectivity to OnePageCrm data through an SAP BusinessObjects universe.
-
Query, Visualize, and Share live Toggl Data in Redash
Use CData Connect AI to connect to live Toggl data in Redash for querying, visualizing, and sharing.
-
Import and Visualize DocuSign Data in Power View
Create data visualizations based on DocuSign data in Excel.
-
Publish Reports with Jodoo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Jodoo data.
-
Build Sage 300-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Sage 300 data and build web apps with connectivity to live Sage 300 data.
-
Analyze SingleStore Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SingleStore data with the CData JDBC Driver for SingleStore.
-
Build MVC Applications with Connectivity to Wave Financial Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Wave Financial from an ASP.NET MVC application.
-
Process & Analyze DocuSign Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live DocuSign Data.
-
Create Reckon Accounts Hosted-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Reckon Accounts Hosted Data from OutSystems and build custom enterprise apps using live Reckon Accounts Hosted data.
-
Build QuickBooks Time-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live QuickBooks Time data.
-
How to import Dotmailer Data into Apache Solr
Use the CData Software JDBC Driver for Dotmailer in Data Import Handler and create an automated import of Dotmailer data to Apache Solr Enterprise Search platform.
-
Visualize SAP HANA Data in Sisense
Create an ElastiCube in Sisense app with access to SAP HANA data.
-
Replicate Trello Data to Multiple Databases via the CData Sync CLI
Replicate Trello data to disparate databases with a single configuration.
-
Connect to TaxJar Data from a Connection Pool in Jetty
The TaxJar JDBC Driver supports connection pooling: This article shows how to connect faster to TaxJar data from Web apps in Jetty.
-
Build AfterShip-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live AfterShip data and build AfterShip-connected web apps with Axios.
-
How to Work with WooCommerce Data in ETL Validator JDBC
Connect to WooCommerce from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Paylocity Data in ACL Analytics
Connect to Paylocity data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Paylocity data.
-
Automate ElevenLabs Data Replication to Couchbase
Use CData Sync to Customize and automate ElevenLabs data replication to Couchbase.
-
Connect and Query Live WooCommerce Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live WooCommerce data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to Oracle Sales Data from AWS Glue
Use CData Connect AI to gain access to live Oracle Sales data from your AWS Glue jobs.
-
Build Semantic Layer Views for Dynamics NAV Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Dynamics NAV data.
-
Design BIRT Reports on Avro Data
Provide current Avro data to your embedded analytics.
-
Enable the Sentry JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Sentry data.
-
How to Easily Query Factorial Data in OpenOffice Base
Connect to Factorial data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Acumatica Data from HeidiSQL
Use CData Connect AI to connect to and query live Acumatica data from HeidiSQL.
-
How to import VWO Data into Apache Solr
Use the CData Software JDBC Driver for VWO in Data Import Handler and create an automated import of VWO data to Apache Solr Enterprise Search platform.
-
Replicate Perigon Data to Multiple Databases via the CData Sync CLI
Replicate Perigon data to disparate databases with a single configuration.
-
Moving Data from Aweber to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Aweber data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Visualize Live SAP BusinessObjects BI Data in the Power BI Service
Use CData Connect AI to connect to live SAP BusinessObjects BI data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to REST Data in DBeaver
Use the CData ODBC Driver to connect to REST data in DBeaver.
-
Automated Continuous Zuora Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Zuora replication to PostgreSQL.
-
Use Dash to Build Web Apps on DB2 Data via CData Connect AI
Build interactive Dash web apps on live DB2 data using pandas and the CData Connect AI Python SDK.
-
Connect to and Visualize Live Gumroad Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Gumroad data.
-
Work with Live Excel Online Data in Power Query
Use CData Connect AI to connect to Excel Online data and work with live Excel Online data in Microsoft Power Query.
-
Create Neo4J-Connected Nintex Workflows
Use CData Connect AI to connect to Neo4J Data from Nintex Workflow Cloud and build custom workflows using live Neo4J data.
-
Access Live Browserless Data in Coginiti Pro
Connect to and query live Browserless data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to connect SharePoint with PayPal Data through external lists
Provide PayPal data to SharePoint users as an external list.
-
Automated Continuous Oracle SCM Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Oracle SCM replication to Google Cloud SQL.
-
Integrate with live Reckon Accounts Hosted Data in Jitterbit
Use CData Connect AI to connect to and integrate live Reckon Accounts Hosted data in Jitterbit.
-
Connect to and Query Google Sheets Data in QlikView over ODBC
Create data visualizations with Google Sheets data in QlikView.
-
Visualize Attio Data in Tableau
The CData ODBC driver for Attio enables you integrate Attio data into Tableau dashboards.
-
Build Wave Financial-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Wave Financial data.
-
Create Bitly-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Bitly Data from Klipfolio and build custom visualizations using live Bitly data.
-
Build Charts with SAP Ariba Procurement Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP Ariba Procurement data in Clear Analytics.
-
Connect to and Visualize Live Grafana Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Grafana data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Kafka
Provide connectivity to Kafka data through an SAP BusinessObjects universe.
-
Explore Geographical Relationships in MYOB AccountRight Data with Power Map
Create data visualizations with MYOB AccountRight data in Power Map.
-
Bridge Simplesat Connectivity with Apache NiFi
Access and process Simplesat data in Apache NiFi using the CData JDBC Driver.
-
Use Azure AI Foundry to Talk to Your Apify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Apify data for you.
-
Analyze Live Testmonitor Data in SAS Viya
Use CData Connect AI to connect to Testmonitor data from SAS Viya and deploy self-service analytics using live Testmonitor data.
-
How to work with Spotify Data in Apache Spark using SQL
Access and process Spotify Data in Apache Spark using the CData Software JDBC Driver.
-
How to load Azure Table data into Elasticsearch via Logstash
Introducing a simple method to load Azure Table data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Analyze Paymo Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Paymo data in Microsoft R Open.
-
Access ConstantContact Data from MySQL in Amazon QuickSight
Connect to ConstantContact and build visualizations of ConstantContact data using a MySQL Connection in Amazon QuickSight.
-
Build Data Flows from ConstantContact to SQL Server using SSIS
Easily back up ConstantContact data to SQL Server using the SSIS components for ConstantContact.
-
Visualize Accelo Data in Sisense
Create an ElastiCube in Sisense app with access to Accelo data.
-
LINQ to Landbot 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 Landbot Data Provider.
-
Getting Started with the CData Connect AI Python SDK for Avalara AvaTax
Install the CData Connect AI Python SDK to read and write live Avalara AvaTax data with standard DB-API 2.0 Python code.
-
Use Biml to Build SSIS Tasks to Replicate Instagram Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Instagram data to SQL Server.
-
Visualize Live Shortcut Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Shortcut data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind Calendly Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Calendly data to a chart.
-
Build MVC Applications with Connectivity to Aweber Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Aweber from an ASP.NET MVC application.
-
Bridge Google Tasks Connectivity with Apache NiFi
Access and process Google Tasks data in Apache NiFi using the CData JDBC Driver.
-
Integrating LangGraph with Campaigner Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Campaigner data within automated workflows.
-
Visualize Klipfolio Data in Sisense
Create an ElastiCube in Sisense app with access to Klipfolio data.
-
Connect OpenWeatherMap Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your OpenWeatherMap data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Quaderno Data in Pentaho Data Integration
Build ETL pipelines based on Quaderno data in the Pentaho Data Integration tool.
-
Integrating Codex with Bugsnag 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.
-
Connect to ZohoSubscriptions Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ZohoSubscriptions to connect to ZohoSubscriptions data and execute queries in PowerBuilder.
-
Integrating ChargeOver Data in Talend Cloud Data Management Platform
Connect ChargeOver Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Getting Started with the CData Power BI Connector for Unbounce
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Zoom Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Zoom facts in real time.
-
Use the CData Software JDBC Driver for Mode in MicroStrategy Desktop
Connect to Mode data in MicroStrategy Desktop using the CData Software JDBC Driver for Mode.
-
Integrate with Live Kintone Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Kintone from the MuleSoft Anypoint Platform to integrate live Kintone data into custom reports and dashboards.
-
Connect to EmailOctopus Data from PowerBuilder via JDBC
This article demonstrates how to access EmailOctopus data from PowerBuilder using the EmailOctopus JDBC Driver.
-
Connect to Demio Data in DBArtisan
Use wizards in DBArtisan to configure Demio data as a data source.
-
Integrate with live FreshBooks Data in Jitterbit
Use CData Connect AI to connect to and integrate live FreshBooks data in Jitterbit.
-
How to Connect to Live YouTube Analytics Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your YouTube Analytics data for you.
-
Create Snowflake-Connected Dashboards in Grafana
Connect to Snowflake Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Snowflake data.
-
Connect to MYOB AccountRight in SpagoBI
Create reports featuring live MYOB AccountRight data in SpagoBI Studio. Host MYOB AccountRight reports on SpagoBI Server.
-
Build Apps with Live SageHR Data Using the Low-Code Development Platform of Mendix
Connect SageHR data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Printify Data in ACL Analytics
Connect to Printify data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Printify data.
-
Build Charts with Certinia Data in Clear Analytics
Create dynamic charts and perform analytics based on Certinia data in Clear Analytics.
-
Integrating Gumloop with Gong Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Gong data within automated workflows.
-
Build Data Flows from Productboard to SQL Server using SSIS
Easily back up Productboard data to SQL Server using the SSIS components for Productboard.
-
Connect to Lakebase Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Lakebase and the SQL Gateway to access Lakebase data from Google Apps Script.
-
Automated Continuous Sentry Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sentry replication to Apache Cassandra.
-
Automate Mixpanel Data Replication to Couchbase
Use CData Sync to Customize and automate Mixpanel data replication to Couchbase.
-
How to connect to AlloyDB Data with Squirrel SQL client
Connect to AlloyDB data and execute queries in the Squirrel SQL Client.
-
Access Live Teamgate Data in Coginiti Pro
Connect to and query live Teamgate data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Voice Agents in ElevenLabs with access to Live Teradata Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Teradata data.
-
Load Microsoft Planner Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Planner data to a database.
-
Back Up Spotify data 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 Spotify data data.