CData Software - Knowledge Base
Recent Articles
-
Import Real-Time Confluence Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Atlassian Confluence in ColdFusion.
-
How to Create Power BI Visual Reports with Real-Time CSV Data
Use CData Power BI Connectors to visualize CSV/TSV Files in Power BI.
-
Access Live Moosend Data in Coginiti Pro
Connect to and query live Moosend from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live AlloyDB Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google AlloyDB from your Google Sheets.
-
Create Dynamic SFTP Grids Using the Infragistics XamDataGrid
Learn how you can connect SFTP to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous LinkedIn Ads Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to Apache Cassandra.
-
Working with Snowflake Data in LINQPad
Execute LINQ queries to Snowflake in LINQPad.
-
How to Work with Microsoft Teams Data in AWS Glue Jobs Using JDBC
Connect to Microsoft Teams from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Shippo Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Shippo data access from reports, embedded analytics, and more.
-
Connect to Avalara AvaTax Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Avalara AvaTax in Airbyte.
-
Integrating Gumloop with BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on BambooHR within automated workflows.
-
Create Shortcut Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Shortcut data access from reports, embedded analytics, and more.
-
Automate Google Spanner Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Google Spanner and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Replicate MySQL Data to Multiple Databases via the CData Sync CLI
Replicate MySQL to disparate databases with a single configuration.
-
How to Connect to Live Microsoft Ads 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 Microsoft Ads for you.
-
Integrate Live Office 365 Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Microsoft Office 365 and integrate live Microsoft Office 365 into apps built in Microsoft Power Apps.
-
Publish Reports with ConvertKit Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ConvertKit.
-
Build Apps with Live Amazon S3 in Adalo using CData Connect AI
Use CData Connect AI to integrate live Amazon S3 into the Adalo platform and build custom mobile and web applications with real-time Amazon S3.
-
Publish Reports with Mailgun Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mailgun.
-
Integrate Real-Time Access to Adobe Commerce in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Adobe Commerce in real time.
-
How to publish and share Elasticsearch Data dashboards with Tableau Server
The CData ODBC driver for Elasticsearch enables you integrate Elasticsearch into Tableau dashboards.
-
How to Query Short.io Data in MySQL Workbench
Execute MySQL queries against live Short.io from MySQL Workbench.
-
Build Charts with Oracle Eloqua Reporting Data in Clear Analytics
Create dynamic charts and perform analytics based on Oracle Eloqua Reporting in Clear Analytics.
-
Getting Started with the CData JDBC Driver for Toggl
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Toggl.
-
Access Wrike Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Wrike from your Oracle system.
-
Integrating LangChain with Office 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Microsoft Office 365 within automated workflows.
-
How to create Attio federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Attio in MySQL .
-
Import Real-Time Typeform Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Typeform in ColdFusion.
-
Use Biml to Build SSIS Tasks to Replicate Google Ads Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Ads to SQL Server.
-
Connect to SpaceX Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to SpaceX and work with SpaceX in your FileMaker application.
-
Use Microsoft Copilot Studio to talk to your Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Greenhouse for you.
-
Import Real-Time CampaignMonitor Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use CampaignMonitor in ColdFusion.
-
Getting Started with the CData Python Connector for Avaza
Learn to install and license the CData Python Connector
-
Connect to SAS Data Sets Data from HeidiSQL
Use CData Connect AI to connect to and query live SAS Data Sets from HeidiSQL.
-
Connect to OneNote Data from PowerBuilder via JDBC
This article demonstrates how to access Microsoft OneNote from PowerBuilder using the OneNote JDBC Driver.
-
Integrate Oracle SCM Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Oracle SCM and integrate live Oracle SCM into your Power Automate tasks.
-
Automated Continuous Raisers Edge NXT Replication to Oracle
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Oracle.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Redis to Power BI dashboards. Simply drag and drop Redis into data visuals on the Power BI canvas.
-
Connect to Dotmailer Data in NetBeans
Connect to Dotmailer in NetBeans with the data source configuration wizard.
-
Automated Continuous Google Analytics Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Analytics replication to Azure SQL Database.
-
Connect to Odoo Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Odoo ERP.
-
Access Live BambooHR 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 BambooHR through MCP integration.
-
Migrating data from Kintone to Databricks using CData SSIS Components.
Easily push Kintone to Databricks using the CData SSIS Tasks for Kintone and Databricks.
-
Visualize SAP Fieldglass Data in TIBCO Spotfire through ADO.NET
Integrate SAP Fieldglass into dashboards in TIBCO Spotfire.
-
Prepare, Blend, and Analyze VWO Data in Alteryx Designer (ODBC)
Build workflows to access live VWO for self-service data analytics.
-
Visualize ZohoInvoice Data in TIBCO Spotfire through ADO.NET
Integrate ZohoInvoice into dashboards in TIBCO Spotfire.
-
Query Impala Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Apache Impala and perform CRUD operations on Impala from Node.js.
-
Using the CData Software ODBC Driver for Eventbrite in PyCharm
Connect to Eventbrite as an ODBC data source in PyCharm using the CData Software ODBC Driver for Eventbrite.
-
How to Query Live HCL Domino Data in Claude Desktop
Connect to and query live HCL Domino Data in Claude Desktop using CData MCP Server.
-
How to Connect to Live Amazon Athena 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 Amazon Athena for you.
-
Import Real-Time LightSpeedRetail Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use LightSpeedRetail in ColdFusion.
-
How to connect to FHIR Data from IntelliJ
Integrate connectivity to FHIR with wizards in IntelliJ.
-
Use the CData Software ODBC Driver for PivotalTracker in MicroStrategy Web
Connect to PivotalTracker in MicroStrategy Web using the CData Software ODBC Driver for PivotalTracker.
-
Use the CData Software JDBC Driver for Parallel in MicroStrategy Web
Connect to Parallel in MicroStrategy Web using the CData Software JDBC Driver for Parallel.
-
Extend Google Sheets with SAP Ariba Procurement Data
Make calls to SAP Ariba Procurement from Google Apps Script via the API Server.
-
Use Dash to Build to Web Apps on Slack Data
Create Python applications that use pandas and Dash to build Slack-connected web apps.
-
Analyze Bitbucket Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Bitbucket and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Use the CData ODBC Driver for Azure Data Catalog in Microsoft Power Query
You can use the CData Azure Data Catalog ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Azure Data Catalog into Microsoft Power Query.
-
Rapidly Develop Apify-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 Apify.
-
Build Square Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Square and build visualizations in Tableau.
-
DataBind Controls to Redis Data in Delphi
DataBind to Redis in Delphi with standard data access components and controls.
-
How to Seamlessly Import Hacker News Data into IBM SPSS Modeler
Integrate Hacker News data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize JSON Services in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load JSON into TIBCO Spotfire.
-
How to connect and process Asana from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Asana.
-
Publish Reports with Lakebase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Lakebase.
-
Connect to Datadog Data in JRuby
Create a simple JRuby app with access to live Datadog.
-
How to create Sugar CRM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Sugar CRM in MySQL .
-
Integrating Codex CLI with PhantomBuster 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 Live Snowflake Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Snowflake from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Snowflake.
-
Build Apps with Live LinkedIn Ads Data Using the Low-Code Development Platform of Mendix
Connect LinkedIn Ads with Mendix to build apps using the CData JDBC Driver for LinkedIn Ads.
-
Extract, Transform, and Load Brex Data in Informatica PowerCenter
Create a simple Workflow for Brex in Informatica PowerCenter.
-
Automated Continuous Shortcut Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Shortcut replication to Google Cloud SQL.
-
Use the CData Software JDBC Driver for Browserless in MicroStrategy Desktop
Connect to Browserless in MicroStrategy Desktop using the CData Software JDBC Driver for Browserless.
-
Query xBase Data in ColdFusion
Write standard ColdFusion data access code to connect to xBase.
-
Visualize LightSpeedRetail Data in Tableau
The CData ODBC driver for LightSpeedRetail enables you integrate LightSpeedRetail into Tableau dashboards.
-
How to Visualize Foursquare Data in Python with pandas
Use pandas and other modules to analyze and visualize live Foursquare in Python.
-
Use the CData Software JDBC Driver for Google Ad Manager in MicroStrategy Web
Connect to Google Ad Manager in MicroStrategy Web using the CData Software JDBC Driver for Google Ad Manager.
-
Integrating LlamaIndex with Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Salesforce & Force.com in real time.
-
Manage LinkedIn Ads Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for LinkedIn Ads.
-
Integrate Live HBase Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to HBase from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Apache HBase.
-
How to connect to CloudConvert Data from Spring Boot
Connect to CloudConvert in a Spring Boot Application using the CData API Driver for JDBC
-
Integrating LangChain with EnterpriseDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on EnterpriseDB within automated workflows.
-
Build a PostgreSQL Interface for CampaignMonitor Data using the CData JDBC Driver
Use the Remoting features of the CampaignMonitor JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SageHR Data in RazorSQL
Connect to SageHR from wizards and query SageHR from the GUI in the RazorSQL database management tool.
-
Connect to TaxJar Data in JRuby
Create a simple JRuby app with access to live TaxJar.
-
Integrate GraphQL Data in the Pentaho Report Designer
Publish reports based on GraphQL in the Pentaho BI tool.
-
Connect to Zoho Projects from Asprova with CData Software ODBC Driver for Zoho Projects
This article shows how to connect faster to Zoho Projects data from Asprova.
-
Automated Continuous PagerDuty Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable PagerDuty replication to Amazon Redshift.
-
Extend Google Sheets with Adobe Analytics Data
Make calls to Adobe Analytics from Google Apps Script via the API Server.
-
How to Query Live Suadeo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Suadeo data in natural language using Python.
-
Model, Search, and Visualize Live Blackbaud FE NXT Data in ThoughtSpot
Use CData Connect AI to connect to live Blackbaud FE NXT for modeling, searching, and visualizing.
-
Getting Started with the CData Excel Add-In for Pipeline CRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Pipeline CRM.
-
Create ActiveCampaign-Connected Nintex Workflows
Use CData Connect AI to connect to ActiveCampaign Data from Nintex Workflow Cloud and build custom workflows using live ActiveCampaign.
-
How to create Beeminder federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Beeminder in MySQL .
-
Connect to SAP Netweaver Gateway from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP Netweaver Gateway to connect to SAP Netweaver Gateway from Web applications running on WebLogic.
-
Getting Started with the CData Power BI Connector for Perigon
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Integrate with LeadDesk Data in JReport Designer
Create charts and reports based on LeadDesk in JReport Designer.
-
DataBind Controls to Airtable Data in Delphi
DataBind to Airtable in Delphi with standard data access components and controls.
-
Visualize Live Amazon Marketplace Data in the Power BI Service
Use CData Connect AI to connect to live Amazon Marketplace and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Migrating data from Avalara AvaTax to Google BigQuery using CData SSIS Components.
Easily push Avalara AvaTax to Google BigQuery using the CData SSIS Tasks for Avalara AvaTax and Google BigQuery.