CData Software - Knowledge Base
Recent Articles
-
Validate Klipfolio Data with QuerySurge
Access and validate Klipfolio in QuerySurge using the CData JDBC Driver.
-
Visualize Live Humanity Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Humanity.
-
Query Google Ad Manager Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Ad Manager entities in PHP by modeling them as objects.
-
Analyze Optimizely Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Optimizely from Power Pivot. You will use the Table Import Wizard to load Optimizely. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect to Live Avalara AvaTax Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Avalara AvaTax for you.
-
Integrate Live Salesforce CRM Analytics Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Salesforce CRM Analytics to Blue Prism using the CData ODBC Driver for Salesforce CRM Analytics to create automated workflows for repetitive business tasks.
-
How to Query Live Amazon Marketplace Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Amazon Marketplace data in natural language using Python.
-
Manage Unbounce Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Unbounce.
-
How to Connect to Live CSV 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 CSV/TSV Files for you.
-
How to connect to Greenhouse Data from IntelliJ
Integrate connectivity to Greenhouse with wizards in IntelliJ.
-
View Reports on Real-Time Zoho Books Data in Power BI Report Server
Use the CData ODBC Driver for Zoho Books to visualize Zoho Books in Power BI Desktop and then publish them to Power BI Report Server.
-
Build AI/ML Models with Live Azure Synapse Data using Dataiku
Connect Azure Synapse Data with Dataiku using the CData JDBC Driver for Azure Synapse.
-
Automate Avro Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Apache Avro from PowerShell? This article demonstrates how to utilize the Avro Cmdlets for tasks like connecting to Apache Avro, automating operations, downloading data, and more.
-
Integrate CloudConvert Data in Pentaho Data Integration
Build ETL pipelines based on CloudConvert in the Pentaho Data Integration tool.
-
Publish Reports with Highrise Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Highrise CRM.
-
Stream Raisers Edge NXT Data into Apache Kafka Topics
Access and stream Raisers Edge NXT in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build AI/ML Models with Live Foursquare Data using Dataiku
Connect Foursquare Data with Dataiku using the CData API Driver for JDBC.
-
Integrating Codex CLI with Atlassian Confluence 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 Work with LaunchDarkly Data in AWS Glue Jobs Using JDBC
Connect to LaunchDarkly from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Add Datadog Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Datadog with the Informatica Enterprise Data Catalog to classify and organize data.
-
Load Google Translate Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Translate to a database.
-
Build Visualizations of eBay Analytics Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of eBay Analytics in Birst.
-
Integrate Zuora Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zuora from Informatica Cloud.
-
How to publish and share FTP Data dashboards with Tableau Server
The CData ODBC driver for FTP enables you integrate FTP Servers into Tableau dashboards.
-
Connect CSV Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your CSV/TSV Files using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous EnterpriseDB Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Apache Kafka.
-
How to create Slack federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Slack in MySQL .
-
How to connect PolyBase to SAP Fieldglass
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP Fieldglass.
-
DataBind Charts to Pipedrive Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Pipedrive 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 Autopilot Data from a Connection Pool in JBoss
Integrate Autopilot into Java servlets: Use the Management Console in JBoss to install the Autopilot JDBC Driver.
-
How to Work with Shortcut Data in ETL Validator JDBC
Connect to Shortcut from ETL Validator jobs using the CData Software JDBC Driver.
-
Build AI/ML Models with Live TaxJar Data using Dataiku
Connect TaxJar Data with Dataiku using the CData JDBC Driver for TaxJar.
-
Build Semantic Layer Views for ServiceNow Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ServiceNow.
-
Integrating Codex CLI with Beeminder 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.
-
Integrate LibreChat with Live GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live GitHub from within the chat interface.
-
Use Dash to Build Web Apps on Oracle Financials Cloud Data via CData Connect AI
Build interactive Dash web apps on live Oracle Financials Cloud using pandas and the CData Connect AI Python SDK.
-
How to Query VWO Data in MySQL Workbench
Execute MySQL queries against live VWO from MySQL Workbench.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for GitHub
Provide connectivity to GitHub through an SAP BusinessObjects universe.
-
Build a Singer.io Tap for Strava With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Strava data using
-
Import and Visualize SAP Hybris C4C Data in Power View
Create data visualizations based on SAP Hybris C4C in Excel.
-
Back Up Exa 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 Exa data.
-
How to Work with Avro Data in AWS Glue Jobs Using JDBC
Connect to Avro from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Analyze Greenhouse Data in Cognos Analytics
Use CData Connect AI to connect to Greenhouse Data from Cognos Analytics and analyze live Greenhouse.
-
Integrate with Zoho Creator Data in JReport Designer
Create charts and reports based on Zoho Creator in JReport Designer.
-
Access Teamgate Data from MySQL in PHP
Connect to Teamgate through the standard MySQL libraries in PHP.
-
How to integrate Metabase with Microsoft Entra ID Data
Use CData Connect AI to connect to live Microsoft Entra ID and create an interactive dashboard in Metabase from Microsoft Entra ID.
-
Use the CData ODBC Driver for Teamwork from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Teamwork to connect to Teamwork from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Teamwork in Excel.
-
Automated Continuous Printify Replication to MongoDB
Use CData Sync for automated, continuous, customizable Printify replication to MongoDB.
-
Getting Started with the CData JDBC Driver for Perplexity
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Perplexity.
-
Access Live Cvent Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Cvent data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Getting Started with the CData Excel Add-In for Coda
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Coda.
-
Connect to Drip Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Analyze GetResponse Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze GetResponse in Microsoft R Open.
-
Connect to Parquet Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Operational Reporting on Jira Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Atlassian Jira.
-
Connect to Live Vertica Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Vertica in CData Connect AI and connect to your Vertica from PostgreSQL.
-
Connect Microsoft Ads Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft Ads using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Semantic Layer Views for SAP SuccessFactors LMS Data in APOS Live Data Gateway
Use the CData Connector for SAP SuccessFactors LMS in APOS Live Data Gateway to build Semantic Layer Views for SAP SuccessFactors LMS.
-
Provide OData Services of ClickTime Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ClickTime by developing a WCF Service Application.
-
Replicate Multiple Samanage Accounts
Replicate multiple Samanage accounts to one or many databases.
-
Replicate Recurly Data from PowerShell
Write a quick PowerShell script to query Recurly. Use connectivity to the live data to replicate Recurly to SQL Server.
-
Create Dashboards and Visualize Live Google Spanner Data in Geckoboard
Use CData Connect AI to connect to live Google Spanner and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Apps with Live Google Translate Data Using the Low-Code Development Platform of Mendix
Connect Google Translate with Mendix to build apps using the CData API Driver for JDBC.
-
Integrating GitHub Copilot CLI with BenchmarkEmail 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.
-
Create a Data Access Object for BigQuery Data using JDBI
A brief overview of creating a SQL Object API for Google BigQuery in JDBI.
-
How to Work with Instantly Data in ETL Validator JDBC
Connect to Instantly from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software JDBC Driver for Intercom in MicroStrategy Desktop
Connect to Intercom in MicroStrategy Desktop using the CData Software JDBC Driver for Intercom.
-
Connect to SendPulse Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Add Excel Online Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Excel Online with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous ADP Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ADP replication to OneLake in Microsoft Fabric.
-
Connect to Excel Online Data in NetBeans
Connect to Microsoft Excel Online in NetBeans with the data source configuration wizard.
-
Use the CData SSIS Components to Insert New or Update Existing Blackbaud FE NXT Records from SQL Server
Easily push SQL Server data to Blackbaud FE NXT using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Blackbaud FE NXT or update existing records with data from a SQL Server database.
-
LINQ to Stack Exchange 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 Stack Exchange Data Provider.
-
Access Live Marketo Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Marketo through MCP integration.
-
Integrating Cursor CLI with Dynamics NAV 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.
-
Automate HCL Domino Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live HCL Domino and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Access Moosend Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Moosend from HeidiSQL.
-
Connect to Avro Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Apache Avro.
-
Build Semantic Layer Views for Gmail Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Gmail.
-
Connect to Amazon Athena Data in DBeaver
Use the CData ODBC Driver to connect to Amazon Athena in DBeaver.
-
Integrate with Live Zendesk Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Zendesk from the MuleSoft Anypoint Platform to integrate live Zendesk into custom reports and dashboards.
-
Choosing the Best Method to Connect Shopify to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Shopify from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to import ClickTime Data into Apache Solr
Use the CData Software JDBC Driver for ClickTime in Data Import Handler and create an automated import of ClickTime to Apache Solr Enterprise Search platform.
-
Integrating Salesforce CRM Analytics Data in Talend Cloud Data Management Platform
Connect Salesforce CRM Analytics Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Salesforce CRM Analytics.
-
Build AI/ML Models with Live Instantly Data using Dataiku
Connect Instantly Data with Dataiku using the CData API Driver for JDBC.
-
Create Informatica Mappings From/To a JDBC Data Source for Amplitude
Create Amplitude data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect and process Intercom from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Intercom.
-
Automated Continuous Retently Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Retently replication to Google BigQuery.
-
Use Grok to Talk to Your CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your CockroachDB for you.
-
Analyze Cvent Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Cvent with the CData JDBC Driver for Cvent.
-
Using the CData Software ODBC Driver for Presto in PyCharm
Connect to Presto as an ODBC data source in PyCharm using the CData Software ODBC Driver for Presto.
-
Migrating data from Hacker News to Google BigQuery using CData SSIS Components.
Easily push Hacker News to Google BigQuery using the CData SSIS Tasks for Hacker News and Google BigQuery.
-
Trigger Dynamics CRM IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Dynamics CRM with standard wizards in Logic Apps.
-
Use Grok to Talk to Your Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Microsoft Planner for you.
-
DataBind Controls to Miro Data in Delphi
DataBind to Miro in Delphi with standard data access components and controls.
-
Build Semantic Layer Views for Cloudant Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for IBM Cloudant.
-
Model DocuSign Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and DocuSign, enabling the direct import of real-time DocuSign.
-
Build Automated Workflows with Live Phoenix Data in Workato
Use CData Connect AI to connect to live Apache Phoenix and build automated workflows in Workato.
-
Query Samanage Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Samanage from Node.js.
-
Build Apps with Live Zuora in Adalo using CData Connect AI
Use CData Connect AI to integrate live Zuora into the Adalo platform and build custom mobile and web applications with real-time Zuora.