CData Software - Knowledge Base
Recent Articles
-
Build a PostgreSQL Interface for Elasticsearch Data using the CData JDBC Driver
Use the Remoting features of the Elasticsearch JDBC Driver to create a PostgreSQL entry-point for data access.
-
View Reports on Real-Time Instantly Data in Power BI Report Server
Use the CData ODBC Driver for Instantly to visualize Instantly in Power BI Desktop and then publish them to Power BI Report Server.
-
Natively Connect to Odoo Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Odoo ERP. Leverage the native support for ODBC in PHP.
-
Automated Continuous xBase Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable xBase replication to Azure SQL Database.
-
Analyze Egnyte Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Egnyte from Power Pivot. You will use the Table Import Wizard to load Egnyte. You can visually build the import query or use any SQL supported by the driver.
-
Connect Amazon S3 Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Amazon S3 using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use Grok to Talk to Your Microsoft Ads 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 Ads for you.
-
How to Seamlessly Import JobNimbus Data into IBM SPSS Modeler
Integrate JobNimbus data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Choosing the Best Method to Connect Access to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Access from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Kiro CLI with Aircall 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 JotForm Data in PHP
The CData ODBC driver for JotForm enables you to create PHP applications with connectivity to JotForm. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData JDBC Driver for MongoDB
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for MongoDB.
-
How to connect to RabbitMQ Data from IntelliJ
Integrate connectivity to RabbitMQ with wizards in IntelliJ.
-
Create Datasets from Workable in Domo Workbench and Build Visualizations of Workable Data in Domo
Use the CData Software ODBC Driver for Workable to create datasets from Workable in Domo Workbench and then build visualizations in the Domo service.
-
Build Zoom-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Zoom Data in Cursor to assist with building Zoom-powered applications.
-
Extend Google Sheets with Snowflake Data
Make calls to Snowflake from Google Apps Script via the API Server.
-
Import Real-Time Hive Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Apache Hive in ColdFusion.
-
IBM Informix Reporting in OBIEE with the IBM Informix JDBC Driver
Deploy the IBM Informix JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating eBay Data in Talend Cloud Data Management Platform
Connect eBay Data with Talend Cloud Data Management Platform using the CData JDBC Driver for eBay.
-
Connect to PayPal Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live PayPal from Filemaker Pro on Mac.
-
How to create an RPA flow for SharePoint Data in UiPath Studio
Use the SharePoint ODBC Driver to create workflows that access real-time Microsoft SharePoint without any coding.
-
Getting Started with the CData ADO.NET Provider for XML
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for XML.
-
Create Power BI Reports on Real-Time Instagram Data
Use the CData ODBC Driver for Instagram to visualize Instagram in Power BI Desktop.
-
How to integrate Act-On with Apache Airflow
Access and process Act-On in Apache Airflow using the CData JDBC Driver.
-
Migrating data from Webex to Databricks using CData SSIS Components.
Easily push Webex to Databricks using the CData SSIS Tasks for Webex and Databricks.
-
Prepare, Blend, and Analyze Helpscout Data in Alteryx Designer (ODBC)
Build workflows to access live Helpscout for self-service data analytics.
-
Automated Continuous Dynamics 365 Business Central Replication to SQLite
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to SQLite.
-
Access Parquet Data from MySQL in PHP
Connect to Parquet through the standard MySQL libraries in PHP.
-
Visualize Clockify Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Clockify.
-
Integrating LangGraph with Cvent Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Cvent within automated workflows.
-
Automate LeadDesk Integration Tasks from PowerShell
Are you in search of a quick and easy way to access LeadDesk from PowerShell? This article demonstrates how to utilize the LeadDesk Cmdlets for tasks like connecting to LeadDesk, automating operations, downloading data, and more.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Xero Accounting within intelligent workflows.
-
Design BIRT Reports on Authorize.Net Data
Provide current Authorize.Net to your embedded analytics.
-
Bind Live Salesforce Marketing Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Salesforce Marketing data
-
Getting Started with the CData Excel Add-In for Tally
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Tally.
-
How to Connect DBeaver to Unbounce via a JDBC Driver
Manage Unbounce with visual tools in DBeaver like the query browser.
-
Getting Started with the CData SSIS Components for Amazon S3
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Amazon S3.
-
How to Query Demio Data in MySQL Workbench
Execute MySQL queries against live Demio from MySQL Workbench.
-
Build Semantic Layer Views for Twilio Data in APOS Live Data Gateway
Use the CData Connector for Twilio in APOS Live Data Gateway to build Semantic Layer Views for Twilio.
-
How to integrate Nuclia with Apache Airflow
Access and process Nuclia in Apache Airflow using the CData JDBC Driver.
-
Working with Zoho Projects Data in LINQPad
Execute LINQ queries to Zoho Projects in LINQPad.
-
Create Informatica Mappings From/To a JDBC Data Source for Raisers Edge NXT
Create Raisers Edge NXT data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Epicor Kinetic Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Epicor Kinetic.
-
Natively Connect to SQL Server Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft SQL Server. Leverage the native support for ODBC in PHP.
-
Build Data Flows from SQL Server to IBM Informix through SSIS
Easily push SQL Server data to IBM Informix using the CData SSIS Tasks for IBM Informix.
-
Access Live xBase Data in Coginiti Pro
Connect to and query live xBase from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Import Real-Time Mixpanel Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Mixpanel in ColdFusion.
-
Connect to Mailjet Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Mailjet in the Denodo Virtual DataPort Administrator.
-
Extract, Transform, and Load ZohoDesk Data in Informatica PowerCenter
Create a simple Workflow for ZohoDesk in Informatica PowerCenter.
-
Integrate Live LeadDesk Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live LeadDesk to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Harvest Data in DBArtisan
Use wizards in DBArtisan to configure Harvest as a data source.
-
Work with Google Directory Data in FoxPro
Load Google Directory into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Greenplum Data from MySQL in Amazon QuickSight
Connect to Greenplum and build visualizations of Pivotal GreenPlum using a MySQL Connection in Amazon QuickSight.
-
LINQ to BigCommerce 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 BigCommerce Data Provider.
-
Publish Confluence-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Atlassian Confluence.
-
Automated Continuous Sage Intacct Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Sage Intacct replication to AlloyDB.
-
Connect to PostgreSQL Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for PostgreSQL.
-
Query Freshsales Data as a MySQL Database in Node.js
Execute MySQL queries against Freshsales from Node.js.
-
Publish CloudConvert-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live CloudConvert.
-
Visualize Live Webex Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Webex.
-
Add Spark Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Spark with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to use SQLAlchemy ORM to access Oracle Eloqua Reporting Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle Eloqua Reporting.
-
Integrating GitHub Copilot CLI with Sage 200 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 Reports with Sugar CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sugar CRM.
-
How to Connect the Power BI Service to BigQuery: Complete Guide
Connect to the CData Software Power BI Connector for BigQuery from PowerBI.com to provide real-time Google BigQuery across the organization.
-
Visualize Live Zoom Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Zoom into custom reports in Power BI.
-
Publish Reports with FormSite Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date FormSite.
-
Work with PhantomBuster Data in FoxPro
Load PhantomBuster into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData JDBC Driver for Wrike
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Wrike.
-
Connect to Printful Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Printful to connect to Printful and execute queries in PowerBuilder.
-
Connect FHIR to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect FHIR with IBM WebSphere for seamless data integration and connectivity.
-
Build Google Campaign Manager 360 Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Campaign Manager 360 and build visualizations in Tableau Cloud.
-
Rapidly Develop Outlook-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 Outlook.
-
How to connect and process Airtable from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Airtable.
-
Connect to YouTube Analytics Data in JRuby
Create a simple JRuby app with access to live YouTube Analytics.
-
Integrate PostgreSQL Data into Power Automate Desktop using CData Connect
CData Connect for PostgreSQL Data enables you to integrate PostgreSQL into workflows built using Microsoft Power Automate Desktop.
-
Connect to Microsoft OneDrive Data in RazorSQL
Connect to Microsoft OneDrive from wizards and query Microsoft OneDrive from the GUI in the RazorSQL database management tool.
-
Connect to Cosmos DB Data in Ruby
Connect to Azure Cosmos DB in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Automated MailChimp-Connected Workflows in Zapier
Use CData Connect AI to connect to live MailChimp and build automated workflows in Zapier.
-
Use ChatGPT to Talk to Your Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Zoho Projects for you.
-
Connect Azure DevOps Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Azure DevOps using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Edit and Search Basecamp External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Basecamp to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Basecamp objects that you can access from apps and the dashboard.
-
Excel Spreadsheet Automation on PivotalTracker Data with the QUERY Formula
Pull data from PivotalTracker, automate spreadsheets, and more with the QUERY formula.
-
Deploy the ADO.NET Provider for Cloudflare on an SSRS Report Server
Connect to Cloudflare 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 Antigravity CLI with Templated via CData CLI
Connect Templated to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous Google Cloud Storage Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to Databricks.
-
Connect to Highrise Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Highrise Data and connect to Highrise CRM in Akorbi Digital RunMyProcess.
-
How to create an RPA flow for Google Calendar Data in UiPath Studio
Use the Google Calendar ODBC Driver to create workflows that access real-time Google Calendar without any coding.
-
Write a Simple Go Application to work with LinkedIn Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to LinkedIn.
-
Integrate Cline with Live Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Campaign Manager 360 from within your IDE.
-
SAP Hybris C4C Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP Hybris C4C facts in real time.
-
How to Connect to & Open Insightly Data in Microsoft Excel
This article uses the CData ODBC driver for Insightly to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Query Scrapfly Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Scrapfly and perform CRUD operations on Scrapfly from Node.js.
-
Model PostgreSQL Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and PostgreSQL, enabling the direct import of real-time PostgreSQL.
-
Create Amazon DynamoDB-Connected Dashboards in Grafana
Connect to Amazon DynamoDB Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Amazon DynamoDB.
-
Access Live Planio Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Planio data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Creating Google Cloud Storage-Connected Applications in Unqork
You can use CData Connect AI to feed Google Cloud Storage to Unqork and build custom business apps.
-
Design BIRT Reports on JobNimbus Data
Provide current JobNimbus to your embedded analytics.
-
Visualize Live Guru Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Guru using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to SAP HANA Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP HANA in Google Apps Script.