CData Software - Knowledge Base
Recent Articles
-
DataBind Controls to Freshdesk Data in C++Builder
DataBind to Freshdesk data in C++Builder with standard components and controls.
-
Easily Integrate Adobe Commerce Data in Lazarus Pascal IDE
Learn how to easily integrate live Adobe Commerce data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live Notion Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Notion data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Access ADP Data Using Entity Framework
This article shows how to access ADP data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Adobe Experience Manager Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Adobe Experience Manager.
-
Getting Started with the CData Tableau Connector for Redis
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Redis.
-
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.
-
How to Connect DBeaver to Beeminder via a JDBC Driver
Manage Beeminder data with visual tools in DBeaver like the query browser.
-
Migrating data from Google Tasks to Databricks using CData SSIS Components.
Easily push Google Tasks data to Databricks using the CData SSIS Tasks for Google Tasks and Databricks.
-
Bind Live Basecamp Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Basecamp data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to integrate BigQuery with Apache Airflow
Access and process BigQuery data in Apache Airflow using the CData JDBC Driver.
-
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 data into a Java-based ORM framework, Hibernate.
-
How to create Visio diagrams from OneNote Data
Automatically update OneNote data with the changes you make to Visio master shapes.
-
Visualize Live Float Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Float data.
-
Visualize PingOne Data in Sisense
Create an ElastiCube in Sisense app with access to PingOne data.
-
DataBind Controls to Zoho Creator Data in C++Builder
DataBind to Zoho Creator data in C++Builder with standard components and controls.
-
Automated Continuous Email Replication to Vertica
Use CData Sync for automated, continuous, customizable Email replication to Vertica.
-
Connect to Invoiced Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Invoiced and the SQL Gateway to access Invoiced data from Google Apps Script.
-
Provide OData Services of Hubstaff Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Hubstaff data by developing a WCF Service Application.
-
Integrate Pipeline CRM Data in the Pentaho Report Designer
Publish reports based on Pipeline CRM data in the Pentaho BI tool.
-
Integrate PDFMonkey with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate PDFMonkey with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to PDFMonkey data.
-
Getting Started with the CData Python Connector for MessageBird
Learn to install and license the CData Python Connector and configure a connection to live MessageBird data.
-
Connecting Moonlit Workflow with Aweber Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Aweber data in real time.
-
Connect to JotForm Data in Jaspersoft Studio
Execute SQL to remote JotForm data in Jaspersoft Studio.
-
Visualize Snapchat Ads Data in Sisense
Create an ElastiCube in Sisense app with access to Snapchat Ads data.
-
Integrate with Hive Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Hive data in SnapLogic.
-
Build Vault CRM-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Vault CRM data without replication.
-
Connect to EnterpriseDB Data from a Connection Pool in Jetty
The EnterpriseDB JDBC Driver supports connection pooling: This article shows how to connect faster to EnterpriseDB data from Web apps in Jetty.
-
Build MailChimp-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live MailChimp data.
-
Replicate PagerDuty Data from PowerShell
Write a quick PowerShell script to query PagerDuty data. Use connectivity to the live data to replicate PagerDuty data to SQL Server.
-
Rapidly Develop Power BI XMLA-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 Power BI XMLA.
-
Publish Cohere-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Cohere data.
-
Build MVC Applications with Connectivity to Clari Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Clari from an ASP.NET MVC application.
-
Connect to CampaignMonitor Data in Aqua Data Studio
Access CampaignMonitor data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Google Cloud Storage Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to SQLite.
-
Choosing the Best Method to Connect Campaigner to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Campaigner data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to create Egnyte federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Egnyte data in MySQL .
-
Create Datasets from Short.io in Domo Workbench and Build Visualizations of Short.io Data in Domo
Use the CData Software ODBC Driver for Short.io to create datasets from Short.io data in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData ODBC Driver for QuickBooks Time
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for QuickBooks Time.
-
Use the CData Software ODBC Driver for Neo4J in SAS for Real-Time Reporting and Analytics
Connect to real-time Neo4J data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Neo4J.
-
Bridge Figshare Connectivity with Apache NiFi
Access and process Figshare data in Apache NiFi using the CData JDBC Driver.
-
Import and Visualize FreshBooks Data in Power View
Create data visualizations based on FreshBooks data in Excel.
-
Integrating GitHub Copilot with ZohoPeople 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.
-
Replicate Postmark Data in Heroku for Use in Salesforce Connect
Replicate Postmark data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Query ZohoMarketingHub Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ZohoMarketingHub data from Node.js.
-
Bridge XML Connectivity with Apache NiFi
Access and process XML data in Apache NiFi using the CData JDBC Driver.
-
Access Excel Data from MySQL in PHP
Connect to Excel through the standard MySQL libraries in PHP.
-
Connect to Telegram Data from PowerBuilder via JDBC
This article demonstrates how to access Telegram data from PowerBuilder using the Telegram JDBC Driver.
-
Connect to Parallel Data in JRuby
Create a simple JRuby app with access to live Parallel data.
-
Connect to Couchbase Data in RazorSQL
Connect to Couchbase from wizards and query Couchbase data from the GUI in the RazorSQL database management tool.
-
Create Reports with Moosend Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Moosend data.
-
Interact with Live Vertica Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Vertica data.
-
Access NetSuite Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access NetSuite data from your Oracle system.
-
Automated Continuous HelloSign Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable HelloSign replication to PostgreSQL.
-
Object-Relational Mapping (ORM) with Omnisend 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 Omnisend data into a Java-based ORM framework, Hibernate.
-
Replicate Stripe Data in Heroku for Use in Salesforce Connect
Replicate Stripe data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Consume NetSuite OData Feeds in SAP Lumira
Use the API Server to create data visualizations on NetSuite feeds that reflect any changes in SAP Lumira.
-
Use Biml to Build SSIS Tasks to Replicate Elasticsearch Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Elasticsearch data to SQL Server.
-
Integrating Boomi Agentstudio with Square Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Square data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Square Replication to MySQL
Use CData Sync for automated, continuous, customizable Square replication to MySQL.
-
Integrate Clari Data in the Pentaho Report Designer
Publish reports based on Clari data in the Pentaho BI tool.
-
Getting Started with the CData Tableau Connector for Airtable
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Airtable.
-
Rapidly Develop Access-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 Access.
-
Connect to and Query Google Contacts Data in QlikView over ODBC
Create data visualizations with Google Contacts data in QlikView.
-
Integrate Live Notion Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Notion data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Back Up Jumpseller 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 Jumpseller data data.
-
How to Connect to ChartMogul Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ChartMogul data. Leverage the pyodbc module for ODBC in Python.
-
How to Work with SAP Business Warehouse Data in AWS Glue Jobs Using JDBC
Connect to SAP Business Warehouse from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Figshare Data in RazorSQL
Connect to Figshare from wizards and query Figshare data from the GUI in the RazorSQL database management tool.
-
How to Access Live SageHR Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SageHR enables you to integrate SageHR data into workflows built using Microsoft Power Automate Desktop.
-
Migrating data from Tickspot to Databricks using CData SSIS Components.
Easily push Tickspot data to Databricks using the CData SSIS Tasks for Tickspot and Databricks.
-
Connecting Agentforce with Amazon Marketplace Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Amazon Marketplace data for you.
-
Visualize Ontraport Data in Sisense
Create an ElastiCube in Sisense app with access to Ontraport data.
-
Automated Continuous Outlook Replication to Databricks
Use CData Sync for automated, continuous, customizable Outlook replication to Databricks.
-
Integrate Amazon Marketplace Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Amazon Marketplace data and integrate live Amazon Marketplace data into your Power Automate tasks.
-
Automated Continuous Cvent Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Cvent replication to Apache Kafka.
-
How to Easily Query Excel Online Data in OpenOffice Base
Connect to Excel Online data in OpenOffice Base using the CData ODBC Driver for Excel Online and generate reports with live data insights.
-
Connect to Testmonitor Data in JRuby
Create a simple JRuby app with access to live Testmonitor data.
-
Prepare, Blend, and Analyze Azure Synapse Data in Alteryx Designer (ODBC)
Build workflows to access live Azure Synapse data for self-service data analytics.
-
Access Live Google Search Results in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Search results from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Load Microsoft Teams Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Teams data to a database.
-
Connect to SAP BusinessObjects BI Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP BusinessObjects BI in FileMaker Pro to connect to SAP BusinessObjects BI and work with SAP BusinessObjects BI data in your FileMaker applications.
-
Build Dashboards with Box Data in DBxtra
Create dynamic dashboards and perform analytics based on Box data in DBxtra.
-
Connect to Zoho Creator Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Zoho Creator data.
-
Connect to HubSpot Data in CloverDX (formerly CloverETL)
Transfer HubSpot data using the visual workflow in the CloverDX data integration tool.
-
Integrating GitHub Copilot with Smartsheet 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.
-
How to connect to BenchmarkEmail Data with Squirrel SQL client
Connect to BenchmarkEmail data and execute queries in the Squirrel SQL Client.
-
Explore Geographical Relationships in LDAP Objects with Power Map
Create data visualizations with LDAP objects in Power Map.
-
Moving Data from Tally to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Tally data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Access Live Authorize.Net Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Authorize.Net enables you to integrate Authorize.Net data into workflows built using Microsoft Power Automate Desktop.
-
Migrating data from SAP Ariba Procurement to Snowflake using CData SSIS Components.
Easily push SAP Ariba Procurement data to Snowflake using the CData SSIS Tasks for SAP Ariba Procurement and Snowflake.
-
Access Live Monday.com Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Monday.com data from your Excel spreadsheets.
-
How to Connect the Power BI Service to Rebilly: Complete Guide
Connect to the CData Software Power BI Connector for Rebilly from PowerBI.com to provide real-time Rebilly data across the organization.
-
Build Data Flows from Timely to SQL Server using SSIS
Easily back up Timely data to SQL Server using the SSIS components for Timely.
-
Stream Kintone Data into Apache Kafka Topics
Access and stream Kintone data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live Avalara AvaTax Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Avalara AvaTax data into the statistical analysis tools available in SAS JMP. This article shows how to use Avalara AvaTax data in the Graph Builder and Query Builder.
-
Getting Started with the CData JDBC Driver for GetResponse
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for GetResponse.
-
Automated Continuous Freshdesk Replication to Vertica
Use CData Sync for automated, continuous, customizable Freshdesk replication to Vertica.
-
Connect to Dropbox Data from a Connection Pool in Jetty
The Dropbox JDBC Driver supports connection pooling: This article shows how to connect faster to Dropbox data from Web apps in Jetty.
-
Integrate with Presto Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Presto data to a JSON file on disk.