CData Software - Knowledge Base
Recent Articles
-
Integrate with Live Hive Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Hive from the MuleSoft Anypoint Platform to integrate live Apache Hive into custom reports and dashboards.
-
DataBind Controls to QuickBooks Data in C++Builder
DataBind to QuickBooks Desktop in C++Builder with standard components and controls.
-
Connect to SFTP from a Connection Pool in WebLogic
Use the CData JDBC Driver for SFTP to connect to SFTP from Web applications running on WebLogic.
-
Integrating LangGraph with Xero Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Xero Accounting within automated workflows.
-
Create Datasets from Klaviyo in Domo Workbench and Build Visualizations of Klaviyo Data in Domo
Use the CData Software ODBC Driver for Klaviyo to create datasets from Klaviyo in Domo Workbench and then build visualizations in the Domo service.
-
Build Data Flows from SQL Server to GitHub through SSIS
Easily push SQL Server data to GitHub using the CData SSIS Tasks for GitHub.
-
How to Connect to Live Facebook Ads Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Facebook Ads without replication.
-
Connect to JSON Services in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for JSON in Airbyte.
-
Integrate with SAP Hybris C4C Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP Hybris C4C to a JSON file on disk.
-
Trigger Google Campaign Manager 360 IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Google Campaign Manager 360 with standard wizards in Logic Apps.
-
Create Reports with Insightly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Insightly.
-
Analyze Jira Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Atlassian Jira and visualize Atlassian Jira in SAP Analytics Cloud.
-
Create Microsoft Exchange Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Microsoft Exchange data access from reports, embedded analytics, and more.
-
Connect to Facebook Ads Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Facebook Ads to connect to Facebook Ads and execute queries in PowerBuilder.
-
Build a Simple VCL Application for Google Forms Data
How to build a simple VCL Application to view Google Forms in RAD Studio using the CData ODBC Driver for Google Forms.
-
Use CData Connect AI to Access Monday.com Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Monday.com in the Power Pivot business intelligence tool.
-
Access Google Tasks Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Tasks from your Oracle system.
-
How to Connect the Power BI Service to Scrapfly: Complete Guide
Connect to the CData Software Power BI Connector for Scrapfly from PowerBI.com to provide real-time Scrapfly across the organization.
-
How to use SQLAlchemy ORM to access Accelo Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Accelo.
-
How to Connect DBeaver to Amplitude via a JDBC Driver
Manage Amplitude with visual tools in DBeaver like the query browser.
-
Connect and Visualize Live Greenplum Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Pivotal GreenPlum into the Databricks platform and create visualization dashboards with real-time Pivotal GreenPlum.
-
How to Access Authorize.Net Data Using Entity Framework
This article shows how to access Authorize.Net using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Visualizations of SAS Data Sets Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAS Data Sets in Birst.
-
Use the CData ODBC Driver for Oracle HCM Cloud from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Oracle HCM Cloud to connect to Oracle HCM Cloud from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Oracle HCM Cloud in Excel.
-
Analyze Zoho Recruit Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Zoho Recruit in Microsoft R Open.
-
Explore Geographical Relationships in DB2 Data with Power Map
Create data visualizations with IBM DB2 in Power Map.
-
Automated Continuous Attio Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Attio replication to Amazon Redshift.
-
Access Webflow 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 Webflow.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Instagram to Power BI dashboards. Simply drag and drop Instagram into data visuals on the Power BI canvas.
-
Integrate Live Microsoft Entra ID Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft Entra ID to Blue Prism using the CData ODBC Driver for Microsoft Entra ID to create automated workflows for repetitive business tasks.
-
Automate SendInBlue Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SendInBlue from PowerShell? This article demonstrates how to utilize the SendInBlue Cmdlets for tasks like connecting to SendInBlue, automating operations, downloading data, and more.
-
Load Klipfolio Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Klipfolio to a database.
-
Automated Continuous SendGrid Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SendGrid replication to AlloyDB.
-
Access Live Google Campaign Manager 360 Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google Campaign Manager 360 from your Excel spreadsheets.
-
Access Live SAP Fieldglass Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Fieldglass from your Google Sheets.
-
How to Connect DBeaver to LinkedIn via a JDBC Driver
Manage LinkedIn with visual tools in DBeaver like the query browser.
-
Automate Snapchat Ads Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Snapchat Ads from PowerShell? This article demonstrates how to utilize the Snapchat Ads Cmdlets for tasks like connecting to Snapchat Ads, automating operations, downloading data, and more.
-
Load Twilio Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Twilio to a database.
-
A PostgreSQL Interface for Reckon Accounts Hosted Data using the CData ODBC Driver
Use the SQL Gateway and Reckon Accounts Hosted ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connecting Mastra with Adobe Commerce Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Adobe Commerce, no replication required.
-
Easily Integrate SurveyMonkey Data in Lazarus Pascal IDE
Learn how to easily integrate live SurveyMonkey in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Create Power BI Visual Reports with Real-Time ZohoMarketingHub Data
Use CData Power BI Connectors to visualize ZohoMarketingHub in Power BI.
-
How to Connect DBeaver to Perigon via a JDBC Driver
Manage Perigon with visual tools in DBeaver like the query browser.
-
Automated Continuous GitLab Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable GitLab replication to Apache Cassandra.
-
Connect to iContact 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 iContact and work with iContact in your FileMaker application.
-
Import SAS Data Sets Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAS Data Sets. In this article, you will use the OData format to import SAS Data Sets into Microsoft Power Query.
-
How to work with BigCommerce Data in Apache Spark using SQL
Access and process BigCommerce Data in Apache Spark using the CData Software JDBC Driver.
-
Zendesk Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Zendesk through CData Connect AI using different applications and tools.
-
Create a Data Access Object for MailerSend Data using JDBI
A brief overview of creating a SQL Object API for MailerSend in JDBI.
-
Integrating LangGraph with Azure DevOps Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Azure DevOps within automated workflows.
-
Create Calendly Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Calendly data access from reports, embedded analytics, and more.
-
Visualize Live Odoo Data in the Power BI Service
Use CData Connect AI to connect to live Odoo ERP and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to Live Paylocity 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 Paylocity through natural language.
-
Analyze Dynamics 365 Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Microsoft Dynamics 365 and visualize live Microsoft Dynamics 365 in Infragistics Reveal.
-
How to Seamlessly Import Shortcut Data into IBM SPSS Modeler
Integrate Shortcut data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Campaigner Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Campaigner and the SQL Gateway to access Campaigner from Google Apps Script.
-
Access Live Google Cloud Storage Data in TIBCO Data Virtualization
Use the Google Cloud Storage Tibco DV Adapter to create a Google Cloud Storage data source in TIBCO Data Virtualization Studio and gain access to live Google Cloud Storage from your TDV Server.
-
Build Apps with Live Klipfolio Data Using the Low-Code Development Platform of Mendix
Connect Klipfolio with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to ZohoExpense Data in Aqua Data Studio
Access ZohoExpense from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Zoho Books-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Zoho Books Data from Klipfolio and build custom visualizations using live Zoho Books.
-
How to Import Data from Elasticsearch into Google Sheets
Import Elasticsearch into a Google spreadsheet that is automatically refreshed.
-
Getting Started with the CData Tableau Connector for ZohoInvoice
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate with Live Azure Data Lake Storage Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Azure Data Lake Storage from the MuleSoft Anypoint Platform to integrate live Azure Data Lake Storage into custom reports and dashboards.
-
Connect to and Query Simplesat Data in QlikView over ODBC
Create data visualizations with Simplesat in QlikView.
-
Natively Connect to SAP BusinessObjects BI Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAP BusinessObjects BI. Leverage the native support for ODBC in PHP.
-
Integrate Real-Time Access to SAP Hybris C4C in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP Hybris C4C in real time.
-
Natively Connect to Reckon Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Reckon. Leverage the native support for ODBC in PHP.
-
Connect Oracle Eloqua to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Oracle Eloqua using the CData Python MCP Server.
-
Connect to XML Data in RapidMiner
Integrate XML Files with standard components and data source configuration wizards in RapidMiner Studio.
-
Bind Live SAS Data Sets Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAS Data Sets data
-
Connect to EmailOctopus Data as an External Source in Dremio
Use the CData JDBC Driver to connect to EmailOctopus as an External Source in Dremio.
-
Load PabblySubscriptions Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load PabblySubscriptions to a database.
-
How to load Shippo data into Elasticsearch via Logstash
Introducing a simple method to load Shippo data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Back Up PhantomBuster 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 PhantomBuster data.
-
Connect to Perigon Data in DBArtisan
Use wizards in DBArtisan to configure Perigon as a data source.
-
Connect to Grafana Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Grafana and the SQL Gateway to access Grafana from Google Apps Script.
-
How to Connect to Live SQL Analysis Services 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 SQL Analysis Services for you.
-
Access Live Facebook Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Facebook from your Excel spreadsheets.
-
Access Azure Analysis Services Data from MySQL in PHP
Connect to Azure Analysis Services through the standard MySQL libraries in PHP.
-
Getting Started with the CData JDBC Driver for Egnyte
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Egnyte.
-
Use ChatGPT to Talk to Your WordPress 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 WordPress for you.
-
Connect to HDFS Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for HDFS and the Script function in FileMaker Pro to connect to HDFS and work with Apache HDFS in your FileMaker application.
-
How to Work with SendPulse Data in ETL Validator JDBC
Connect to SendPulse from ETL Validator jobs using the CData Software JDBC Driver.
-
Query Live Salesforce CRM Analytics Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Salesforce CRM Analytics directly from the development environment.
-
Publish Beeminder-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Beeminder.
-
Connect Supabase to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Supabase with IBM WebSphere for seamless data integration and connectivity.
-
Import Adobe Commerce Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Adobe Commerce Data and provide access to live Adobe Commerce for custom reports in the Power BI Service.
-
Use the CData Software JDBC Driver for Discourse in MicroStrategy
Connect to Discourse in MicroStrategy Developer using the CData Software JDBC Driver for Discourse.
-
A PostgreSQL Interface for Planio Data using the CData ODBC Driver
Use the SQL Gateway and Planio ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to and Query SAP Fieldglass Data in QlikView over ODBC
Create data visualizations with SAP Fieldglass in QlikView.
-
Design BIRT Reports on Reckon Accounts Hosted Data
Provide current Reckon Accounts Hosted to your embedded analytics.
-
Visualize Highrise Data in TIBCO Spotfire through OData
Integrate Highrise CRM into dashboards in TIBCO Spotfire.
-
How to Query Live Zoho Creator Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Zoho Creator data in natural language using Python.
-
Build Avalara AvaTax-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Avalara AvaTax to explore live Avalara AvaTax Data in GitHub Copilot to assist with building Avalara AvaTax-powered applications.
-
Working with Strava Data in LINQPad
Execute LINQ queries to Strava in LINQPad.
-
Connect to Short.io from Asprova with CData Software ODBC Driver for Short.io
This article shows how to connect faster to Short.io data from Asprova.
-
Build Dashboards with AgileCRM Data in DBxtra
Create dynamic dashboards and perform analytics based on AgileCRM in DBxtra.
-
Query Oracle Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Oracle Database from Node.js.
-
Build MVC Applications with Connectivity to PostgreSQL Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access PostgreSQL from an ASP.NET MVC application.
-
Connect to SharePoint Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Microsoft SharePoint from Filemaker Pro on Mac.