CData Software - Knowledge Base
Recent Articles
-
Create Reports from Azure Table Data in Looker Studio
Use CData Connect AI to gain access to live Azure Table data and create custom reports in Looker Studio.
-
Create a Data Access Object for Parallel Data using JDBI
A brief overview of creating a SQL Object API for Parallel data in JDBI.
-
Integrate MailerLite Data in Pentaho Data Integration
Build ETL pipelines based on MailerLite data in the Pentaho Data Integration tool.
-
How to Connect to Live Pipedrive 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 Pipedrive data for you.
-
Connect to SparkPost Data in NetBeans
Connect to SparkPost data in NetBeans with the data source configuration wizard.
-
Automated Continuous Amplitude Replication to Vertica
Use CData Sync for automated, continuous, customizable Amplitude replication to Vertica.
-
Bridge Miro Connectivity with Apache NiFi
Access and process Miro data in Apache NiFi using the CData JDBC Driver.
-
Create Dashboards and Visualize Live Google Drive Data in Geckoboard
Use CData Connect AI to connect to live Google Drive data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Query Redshift Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Redshift data from Node.js.
-
Confluence Reporting in OBIEE with the Confluence JDBC Driver
Deploy the Confluence JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access SAP Fieldglass 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 SAP Fieldglass data.
-
Choosing the Best Method to Connect Google Directory to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Directory data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Visualize Live Campaigner Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Campaigner data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind Templated Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Templated data to a chart.
-
Build MVC Applications with Connectivity to Flowlu Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Flowlu from an ASP.NET MVC application.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle Financials Cloud
Provide connectivity to Oracle Financials Cloud data through an SAP BusinessObjects universe.
-
Integrate Pushbullet Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Pushbullet data from Informatica Cloud.
-
Access Avro Data from MySQL in Amazon QuickSight
Connect to Avro and build visualizations of Avro data using a MySQL Connection in Amazon QuickSight.
-
Build a PostgreSQL Interface for Airtable Data using the CData JDBC Driver
Use the Remoting features of the Airtable JDBC Driver to create a PostgreSQL entry-point for data access.
-
Enable the Salesloft JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Salesloft data.
-
Visualize Live Sage 300 Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Sage 300 data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Apollo-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 Apollo data without replication.
-
Integrate Google's Vertex AI Agent with Live Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Jira Assets data within intelligent workflows.
-
Getting Started with the CData JDBC Driver for Zoho Inventory
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Zoho Inventory.
-
Connect to Act CRM from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Act CRM data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to SharePoint Excel Services Data in DBeaver
Use the CData ODBC Driver to connect to SharePoint Excel Services data in DBeaver.
-
Add Dropbox Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Dropbox with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous FHIR Replication to Vertica
Use CData Sync for automated, continuous, customizable FHIR replication to Vertica.
-
Establish a Live Connection with iContact Data using Tableau Bridge
The CData ODBC Driver for iContact enables you to integrate live iContact data into Tableau Cloud dashboards using the Tableau Bridge.
-
LINQ to SAP SuccessFactors LMS 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 SAP SuccessFactors LMS Data Provider.
-
DataBind Charts to Elasticsearch Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Elasticsearch data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Connect to WordPress Data in Ruby
Connect to WordPress data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Cloudant-Connected Applications in Appsmith
Connect to Cloudant Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Cloudant data.
-
Getting Started with the CData JDBC Driver for Qualaroo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Qualaroo.
-
Work with Mode Data in FoxPro
Load Mode data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Google Contacts Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Contacts data in Google Apps Script.
-
How to Access Zoom Data Using Entity Framework
This article shows how to access Zoom data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automate NASA Data Replication to Azure Synapse
Use CData Sync to customize and automate NASA data replication to Azure Synapse.
-
Access Live Workday Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Workday data from your Excel spreadsheets.
-
Build Dropbox Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Dropbox data and build visualizations in Tableau.
-
Using the CData Software ODBC Driver for Wrike in PyCharm
Connect to Wrike as an ODBC data source in PyCharm using the CData Software ODBC Driver for Wrike.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Datadog
Provide connectivity to Datadog data through an SAP BusinessObjects universe.
-
How to Build an ETL App for SparkPost Data in Python with CData
Create ETL applications and real-time data pipelines for SparkPost data in Python with petl.
-
Enable the Gumroad JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Gumroad data.
-
Build Shopify-Connected Apps in Choreo
Use CData Connect AI to connect to Shopify Data from Choreo and build custom apps using live Shopify data.
-
DataBind Controls to JSON Services in C++Builder
DataBind to JSON services in C++Builder with standard components and controls.
-
Dynamics NAV Reporting in OBIEE with the Dynamics NAV JDBC Driver
Deploy the Dynamics NAV JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Explore Geographical Relationships in Sage Intacct Data with Power Map
Create data visualizations with Sage Intacct data in Power Map.
-
How to Connect to Live Samanage Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Samanage data without replication.
-
How to integrate SharePoint Excel Services with Apache Airflow
Access and process SharePoint Excel Services data in Apache Airflow using the CData JDBC Driver.
-
Working with Dynamics NAV Data in LINQPad
Execute LINQ queries to Dynamics NAV data in LINQPad.
-
Import Real-Time ZohoPeople Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ZohoPeople data in ColdFusion.
-
Connect to Presto Data in RazorSQL
Connect to Presto from wizards and query Presto data from the GUI in the RazorSQL database management tool.
-
How to connect to SAP Fieldglass Data from IntelliJ
Integrate connectivity to SAP Fieldglass data with wizards in IntelliJ.
-
Use the CData Software ODBC Driver for SendInBlue in MicroStrategy Web
Connect to SendInBlue data in MicroStrategy Web using the CData Software ODBC Driver for SendInBlue.
-
Integrate OpenCode with Live Microsoft Ads Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Microsoft Ads data from within your AI coding agent.
-
Build Data Flows from QuickBooks to SQL Server using SSIS
Easily back up QuickBooks data to SQL Server using the SSIS components for QuickBooks.
-
Choosing the Best Method to Connect AgileCRM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use AgileCRM data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live Mode Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Mode data from your Google Sheets.
-
Enable the Vercel JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Vercel data.
-
Connect to and Visualize Live Google Campaign Manager 360 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Campaign Manager 360 data.
-
How to Connect to Live Sage 200 Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Sage 200 data without replication.
-
Model, Search, and Visualize Live Anaplan Data in ThoughtSpot
Use CData Connect AI to connect to live Anaplan data for modeling, searching, and visualizing.
-
Use Dash to Build to Web Apps on Lakebase Data
Create Python applications that use pandas and Dash to build Lakebase-connected web apps.
-
Model, Search, and Visualize Live Microsoft OneDrive Data in ThoughtSpot
Use CData Connect AI to connect to live Microsoft OneDrive data for modeling, searching, and visualizing.
-
Visualize ClickUp 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 ClickUp data into TIBCO Spotfire.
-
Connect to Oracle SCM Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Oracle SCM data.
-
Build AI/ML Models with Live Email Data using Dataiku
Connect Email Data with Dataiku using the CData JDBC Driver for Email.
-
How to Work with ActiveCampaign Data in AWS Glue Jobs Using JDBC
Connect to ActiveCampaign from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Live Zuora Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Zuora data into custom reports in Power BI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Contentful
Provide connectivity to Contentful data through an SAP BusinessObjects universe.
-
Integrate Workable with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Workable with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Workable data.
-
Replicate Multiple Vertica Accounts
Replicate multiple Vertica accounts to one or many databases.
-
How to Connect the Power BI Service to Outlook: Complete Guide
Connect to the CData Software Power BI Connector for Outlook from PowerBI.com to provide real-time Outlook data across the organization.
-
Automated Continuous Zoho Creator Replication to MongoDB
Use CData Sync for automated, continuous, customizable Zoho Creator replication to MongoDB.
-
Integrate Simplesat Data in the Pentaho Report Designer
Publish reports based on Simplesat data in the Pentaho BI tool.
-
Automated Continuous Chargebee Replication to Oracle
Use CData Sync for automated, continuous, customizable Chargebee replication to Oracle.
-
How to create an RPA flow for Google Cloud Storage Data in UiPath Studio
Use the Google Cloud Storage ODBC Driver to create workflows that access real-time Google Cloud Storage data without any coding.
-
Integrate with Harvest Data in JReport Designer
Create charts and reports based on Harvest data in JReport Designer.
-
Use Agno to Talk to Your Bitly Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Bitly data for you.
-
Connect and Query Live Freshservice Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Freshservice data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to WooCommerce Data in RazorSQL
Connect to WooCommerce from wizards and query WooCommerce data from the GUI in the RazorSQL database management tool.
-
Connect to Real-Time Act-On Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Act-On and Dataflow to import and use Act-On data in Power Apps.
-
Replicate ScrapingBee Data to Multiple Databases via the CData Sync CLI
Replicate ScrapingBee data to disparate databases with a single configuration.
-
Connect to Contentful Data in CloverDX (formerly CloverETL)
Transfer Contentful data using the visual workflow in the CloverDX data integration tool.
-
Connect to Splunk Data in ACL Analytics
Connect to Splunk data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Splunk data.
-
Easily Integrate Shippo Data in Lazarus Pascal IDE
Learn how to easily integrate live Shippo data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live CampaignMonitor Data in AWS Lambda
Connect to live CampaignMonitor data in AWS Lambda using the CData JDBC Driver.
-
Migrating data from Insightly to Databricks using CData SSIS Components.
Easily push Insightly data to Databricks using the CData SSIS Tasks for Insightly and Databricks.
-
Migrating data from Mocean to Databricks using CData SSIS Components.
Easily push Mocean data to Databricks using the CData SSIS Tasks for Mocean and Databricks.
-
Getting Started with the CData JDBC Driver for HubSpot
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for HubSpot.
-
Automated Continuous Zoho Inventory Replication to Databricks
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to Databricks.
-
How to Connect to Live ZohoInvoice Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live ZohoInvoice data securely in real time.
-
Integrating Claude Code CLI with Pinterest 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.
-
Analyze Toggl Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Toggl data in Microsoft R Open.
-
Use the CData Software ODBC Driver for Google Tasks in MicroStrategy Web
Connect to Google Tasks data in MicroStrategy Web using the CData Software ODBC Driver for Google Tasks.
-
Integrate Authorize.Net Data in the Pentaho Report Designer
Publish reports based on Authorize.Net data in the Pentaho BI tool.
-
Build BenchmarkEmail-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 BenchmarkEmail data without replication.
-
Integrating Cursor with Unbounce 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.
-
Natively Connect to Printify Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Printify data. Leverage the native support for ODBC in PHP.