CData Software - Knowledge Base
Recent Articles
-
Create Informatica Mappings From/To a JDBC Data Source for Zoho Inventory
Create Zoho Inventory data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Building Dynamic Web Pages with NetSuite Data Using AngularJS
Create single-page applications with live connectivity to NetSuite using the CData API Server.
-
Validate SageHR Data with QuerySurge
Access and validate SageHR in QuerySurge using the CData JDBC Driver.
-
Query Cloudant Data as a SQL Server Database in Node.js
Execute SQL Server queries against IBM Cloudant from Node.js.
-
Automated Continuous Retently Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Retently replication to AlloyDB.
-
Getting Started with the CData Power BI Connector for Airtable
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Airtable.
-
Connect and Visualize Live Azure Analysis Services Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Azure Analysis Services into the Databricks platform and create visualization dashboards with real-time Azure Analysis Services.
-
How to connect to Amazon Athena Data with Squirrel SQL client
Connect to Amazon Athena and execute queries in the Squirrel SQL Client.
-
Analyze Codat Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Codat with the CData JDBC Driver for Codat.
-
Connect to Zoho Books Data in NetBeans
Connect to Zoho Books in NetBeans with the data source configuration wizard.
-
How to Query BenchmarkEmail Data in MySQL Workbench
Execute MySQL queries against live BenchmarkEmail from MySQL Workbench.
-
Object-Relational Mapping (ORM) with Elasticsearch 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 Elasticsearch into a Java-based ORM framework, Hibernate.
-
Model, Search, and Visualize Live YouTube Analytics Data in ThoughtSpot
Use CData Connect AI to connect to live YouTube Analytics for modeling, searching, and visualizing.
-
Add Yelp Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Yelp with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Easily Query Microsoft Teams Data in OpenOffice Base
Connect to Microsoft Teams data in OpenOffice Base using the CData ODBC Driver for Microsoft Teams and generate reports with live data insights.
-
Automated Continuous Lakebase Replication to Vertica
Use CData Sync for automated, continuous, customizable Lakebase replication to Vertica.
-
Visualize Live OnePageCrm Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live OnePageCrm.
-
Import Real-Time Retently Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Retently in ColdFusion.
-
Model Microsoft Exchange Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Microsoft Exchange, enabling the direct import of real-time Microsoft Exchange.
-
Connect to AgileCRM Data in RapidMiner
Integrate AgileCRM with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Kiro CLI with Helpscout 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.
-
Build Charts with Amazon Athena Data in Clear Analytics
Create dynamic charts and perform analytics based on Amazon Athena in Clear Analytics.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Quickbase
Provide connectivity to Quickbase through an SAP BusinessObjects universe.
-
How to Work with FreeAgent Data in ETL Validator JDBC
Connect to FreeAgent from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect Gmail to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Gmail with IBM WebSphere for seamless data integration and connectivity.
-
Build AI/ML Models with Live Acumatica Data using Dataiku
Connect Acumatica Data with Dataiku using the CData JDBC Driver for Acumatica.
-
Analyze AlloyDB Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Google AlloyDB and visualize live Google AlloyDB in Infragistics Reveal.
-
Access SAP Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP ERP/NetWeaver from HeidiSQL.
-
Automated Continuous PolarTeamPro Replication to Snowflake
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to Snowflake.
-
Connect ADP to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ADP with IBM WebSphere for seamless data integration and connectivity.
-
Build a Simple VCL Application for SAP Fieldglass Data
How to build a simple VCL Application to view SAP Fieldglass in RAD Studio using the CData ODBC Driver for SAP Fieldglass.
-
Analyze Impala Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Apache Impala and visualize live Apache Impala in Infragistics Reveal.
-
How to import Google Ads Data into Apache Solr
Use the CData Software JDBC Driver for Google Ads in Data Import Handler and create an automated import of Google Ads to Apache Solr Enterprise Search platform.
-
Deploy the ADO.NET Provider for MailChimp on an SSRS Report Server
Connect to MailChimp from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrating Clio Data in Talend Cloud Data Management Platform
Connect Clio Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Query Front Data in MySQL Workbench
Execute MySQL queries against live Front from MySQL Workbench.
-
How to Easily Query Deel Data in OpenOffice Base
Connect to Deel data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to connect Amazon QuickSight to Microsoft Planner Data
Create a connection to Microsoft Planner in CData Connect AI and insert Microsoft Planner into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Automated Highrise-Connected Workflows in Zapier
Use CData Connect AI to connect to live Highrise CRM and build automated workflows in Zapier.
-
DataBind Controls to SQL Server Data in C++Builder
DataBind to Microsoft SQL Server in C++Builder with standard components and controls.
-
Build Visualizations of Gong Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Gong in Birst.
-
DataBind Controls to Oracle Eloqua Data in Delphi
DataBind to Oracle Eloqua in Delphi with standard data access components and controls.
-
How to update Smartsheet from Excel
This article explains how to transfer data from Excel to Smartsheet using the Excel Add-In for Smartsheet.
-
Connect Mouseflow to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Mouseflow with IBM WebSphere for seamless data integration and connectivity.
-
A PostgreSQL Interface for Quickbase Data using the CData ODBC Driver
Use the SQL Gateway and Quickbase ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Boomi Agentstudio with Act CRM Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Act CRM, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Perform Batch Operations with TaxJar Data in Apache NiFi
Connect to TaxJar and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Import and Visualize ConstantContact Data in Power View
Create data visualizations based on ConstantContact in Excel.
-
How to connect to Jira Assets Data from IntelliJ
Integrate connectivity to Jira Assets with wizards in IntelliJ.
-
Connect to FreeAgent Data in HULFT Integrate
Connect to FreeAgent as a JDBC data source in HULFT Integrate
-
Integrate Azure Table Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Azure Table Storage and integrate live Azure Table Storage into your Power Automate tasks.
-
Query GitLab Data as a SQL Server Database in Node.js
Execute SQL Server queries against GitLab from Node.js.
-
How to Access Typeform Data Using Entity Framework
This article shows how to access Typeform using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Query Live EnterpriseDB Data in Perplexity MacOS Desktop
Connect to and query live EnterpriseDB Data in Perplexity Desktop using CData MCP Server.
-
Viewing Suadeo Data in RAD Studio Data Explorer
How to view Suadeo in RAD Studio Data Explorer using the CData ODBC Driver for Suadeo.
-
Automate FreshBooks Integration Tasks from PowerShell
Are you in search of a quick and easy way to access FreshBooks from PowerShell? This article demonstrates how to utilize the FreshBooks Cmdlets for tasks like connecting to FreshBooks, automating operations, downloading data, and more.
-
Connect to Pipedrive Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Pipedrive in the Denodo Virtual DataPort Administrator.
-
Build Marketo-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Marketo.
-
Connect to and Query Greenplum Data in QlikView over ODBC
Create data visualizations with Pivotal GreenPlum in QlikView.
-
Integrating LangGraph with Redshift Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Amazon Redshift within automated workflows.
-
Connect to Authorize.Net Data in Aqua Data Studio
Access Authorize.Net from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to create Jira Assets federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Jira Assets in MySQL .
-
DataBind Charts to SendGrid Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SendGrid 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.
-
Publish Presto-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Presto.
-
Building Dynamic Web Pages with Oracle Eloqua Reporting Data Using AngularJS
Create single-page applications with live connectivity to Oracle Eloqua Reporting using the CData API Server.
-
Build AI Agents with Avalara AvaTax Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Avalara AvaTax through CData Connect AI.
-
Connect to CouchDB Data in Claris FileMaker Pro
Use the CData ODBC Driver for CouchDB in FileMaker Pro to connect to CouchDB and work with Apache CouchDB in your FileMaker applications.
-
Integrating OpenCode Terminal with Amazon Athena 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.
-
Validate Bannerbear Data with QuerySurge
Access and validate Bannerbear in QuerySurge using the CData JDBC Driver.
-
Bridge JotForm Connectivity with Apache NiFi
Access and process JotForm in Apache NiFi using the CData JDBC Driver.
-
Import Real-Time Sage 200 Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Sage 200 in ColdFusion.
-
Create Dynamic Superchat Grids Using the Infragistics XamDataGrid
Learn how you can connect Superchat to Infragistics XamDataGrid to build dynamic grids.
-
Working with EnterpriseDB Data in LINQPad
Execute LINQ queries to EnterpriseDB in LINQPad.
-
Connect to Excel Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Excel and the Script function in FileMaker Pro to connect to Excel and work with Microsoft Excel in your FileMaker application.
-
Analyze Acumatica Data in Looker
Use CData Connect AI to connect to Acumatica Data from Looker and build custom apps using live Acumatica ERP.
-
Use the CData Software ODBC Driver for Rebilly in SAS for Real-Time Reporting and Analytics
Connect to real-time Rebilly in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Rebilly.
-
Connect to Superchat Data from PowerBuilder via JDBC
This article demonstrates how to access Superchat from PowerBuilder using the Superchat JDBC Driver.
-
Access Live Stripe Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Stripe into the statistical analysis tools available in SAS JMP. This article shows how to use Stripe in the Graph Builder and Query Builder.
-
Integrating Kiro CLI with Samanage 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.
-
Getting Started with the CData Power BI Connector for Cosmos DB
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Cosmos DB.
-
Replicate Multiple Oracle Eloqua Accounts
Replicate multiple Oracle Eloqua accounts to one or many databases.
-
Integrating Cursor CLI with Google Directory 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.
-
Build Raisers Edge NXT-Connected Apps in Choreo
Use CData Connect AI to connect to Raisers Edge NXT Data from Choreo and build custom apps using live Raisers Edge NXT.
-
Analyze Asana Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Asana and visualize live Asana in Infragistics Reveal.
-
Connect to Google Search Results in ACL Analytics
Connect to Google Search via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Search.
-
Automated Continuous Facebook Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Facebook replication to Apache Cassandra.
-
DataBind Controls to xBase Data in C++Builder
DataBind to xBase in C++Builder with standard components and controls.
-
Write a Simple Go Application to work with FTP Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to FTP Servers.
-
How to Connect to Live Procore Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Procore through natural language.
-
Create Power BI Reports on Real-Time Delighted Data
Use the CData ODBC Driver for Delighted to visualize Delighted in Power BI Desktop.
-
How to connect to CampaignMonitor Data with Squirrel SQL client
Connect to CampaignMonitor and execute queries in the Squirrel SQL Client.
-
Replicate Nethunt Data from PowerShell
Write a quick PowerShell script to query Nethunt. Use connectivity to the live data to replicate Nethunt to SQL Server.
-
Build Google Sheets-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Sheets and build Google Sheets-connected web apps with Axios.
-
Connect to Vault CRM Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Veeva Vault & Vault CRM in Airbyte.
-
Natively Connect to Microsoft Dataverse Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Dataverse (CDS). Leverage the native support for ODBC in PHP.
-
Create Informatica Mappings From/To a JDBC Data Source for Perplexity
Create Perplexity data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Zoho CRM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Zoho CRM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating Cursor CLI with SAP BusinessObjects BI 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.
-
Integrate with Pipedrive Data in JReport Designer
Create charts and reports based on Pipedrive in JReport Designer.
-
Automated Continuous Front Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Front replication to Google Cloud SQL.