CData Software - Knowledge Base
Recent Articles
-
Bidirectional Access to RabbitMQ Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate RabbitMQ in Filemaker Pro for Mac or Windows.
-
LINQ to LionDesk 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 LionDesk Data Provider.
-
Build a Singer.io Tap for Bannerbear With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Bannerbear data using
-
Connect to Contentful Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Contentful.
-
Use the CData Software JDBC Driver for Bullhorn CRM in MicroStrategy Desktop
Connect to Bullhorn CRM in MicroStrategy Desktop using the CData Software JDBC Driver for Bullhorn CRM.
-
Access Jira Data from MySQL in Amazon QuickSight
Connect to Jira and build visualizations of Atlassian Jira using a MySQL Connection in Amazon QuickSight.
-
Create SSAS Tabular Models from Simplesat Data
How to build a SQL Server Analysis Service Tabular Model from Simplesat using CData drivers.
-
Build Dashboards with Grafana Data in DBxtra
Create dynamic dashboards and perform analytics based on Grafana in DBxtra.
-
How to Connect Flowise AI Agents to Live MYOB AccountRight Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live MYOB AccountRight without replication.
-
Automated Continuous Optimizely Replication to MongoDB
Use CData Sync for automated, continuous, customizable Optimizely replication to MongoDB.
-
Clockify Reporting in OBIEE with the Clockify JDBC Driver
Deploy the Clockify JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Hubstaff Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Hubstaff from your Oracle system.
-
Connect to and Query SendInBlue Data in QlikView over ODBC
Create data visualizations with SendInBlue in QlikView.
-
Creating FHIR-Connected Applications in Unqork
You can use CData Connect AI to feed FHIR to Unqork and build custom business apps.
-
Replicate Multiple Keap Accounts
Replicate multiple Keap accounts to one or many databases.
-
Connect to LinkedIn Ads Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for LinkedIn Ads and the SQL Gateway to access LinkedIn Ads from Google Apps Script.
-
Integrate with Live Avro Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Avro from the MuleSoft Anypoint Platform to integrate live Apache Avro into custom reports and dashboards.
-
Build Outreach.io Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Outreach.io and build visualizations in Tableau Cloud.
-
Getting Started with the CData Tableau Connector for Adobe Commerce
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Adobe Commerce.
-
Building Dynamic Web Pages with Twitter Ads Data Using AngularJS
Create single-page applications with live connectivity to Twitter Ads using the CData API Server.
-
Automated Continuous Hive Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Hive replication to Apache Cassandra.
-
A PostgreSQL Interface for Act CRM Data using the CData ODBC Driver
Use the SQL Gateway and Act CRM ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate LibreChat with Live Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Snapchat Ads from within the chat interface.
-
Easily Integrate OnePageCrm Data in Lazarus Pascal IDE
Learn how to easily integrate live OnePageCrm in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect Google Drive Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Google Drive data in real time using natural language.
-
Integrate with live PostgreSQL Data in Jitterbit
Use CData Connect AI to connect to and integrate live PostgreSQL in Jitterbit.
-
Use the CData Software ODBC Driver for Google Ads in MicroStrategy
Connect to Google Ads in MicroStrategy Developer using the CData Software ODBC Driver for Google Ads.
-
Integrate Salesforce Pardot Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Salesforce Pardot from Informatica Cloud.
-
Access Excel Online 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 Microsoft Excel Online.
-
Import Jira Assets Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Jira Assets Data and provide access to live Jira Assets for custom reports in the Power BI Service.
-
Access Live Azure Data Lake Storage Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Azure Data Lake Storage from your Excel spreadsheets.
-
Query Microsoft Teams Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Microsoft Teams entities in PHP by modeling them as objects.
-
Query, Visualize, and Share live Google Spanner Data in Redash
Use CData Connect AI to connect to live Google Spanner in Redash for querying, visualizing, and sharing.
-
Bridge PostgreSQL Connectivity with Apache NiFi
Access and process PostgreSQL in Apache NiFi using the CData JDBC Driver.
-
Integrate Jira Assets with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Jira Assets with External Services.
-
How to Easily Query ConvertAPI Data in OpenOffice Base
Connect to ConvertAPI data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to connect SharePoint with Marketo Data through external lists
Provide Marketo to SharePoint users as an external list.
-
Create Informatica Mappings From/To a JDBC Data Source for Qualaroo
Create Qualaroo data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize Marketo Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Marketo into TIBCO Spotfire.
-
Connect to Bullhorn CRM Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Bullhorn CRM Data and connect to Bullhorn CRM in Akorbi Digital RunMyProcess.
-
Access Live Egnyte Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Egnyte in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Zendesk Data in the Pentaho Report Designer
Publish reports based on Zendesk in the Pentaho BI tool.
-
Import Authorize.Net Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Authorize.Net. In this article, you will use the OData format to import Authorize.Net into Microsoft Power Query.
-
Build a PostgreSQL Interface for Teamwork Data using the CData JDBC Driver
Use the Remoting features of the Teamwork JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Crystal Reports on Zoho Books Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zoho Books.
-
Automated Continuous SAP Hybris C4C Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Apache Kafka.
-
Automate Dynamics 365 Data Replication to SAP HANA
Use CData Sync to customize and automate Microsoft Dynamics 365 replication to SAP HANA.
-
How to Work with ZohoSubscriptions Data in AWS Glue Jobs Using JDBC
Connect to ZohoSubscriptions from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Automated Azure Analysis Services-Connected Workflows in Zapier
Use CData Connect AI to connect to live Azure Analysis Services and build automated workflows in Zapier.
-
Analyze GitLab Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of GitLab and visualize live GitLab in Infragistics Reveal.
-
Connect to Opsgenie Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Opsgenie to connect to Opsgenie and execute queries in PowerBuilder.
-
Build Dashboards with Paddle Data in Dundas BI
Create dynamic dashboards and perform analytics based on Paddle in Dundas BI.
-
Build SAS xpt-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAS xpt Data and create custom apps in Mendix.
-
Use the CData Software ODBC Driver for Salesforce CRM Analytics in MicroStrategy
Connect to Salesforce CRM Analytics in MicroStrategy Developer using the CData Software ODBC Driver for Salesforce CRM Analytics.
-
Excel Spreadsheet Automation on Tickspot Data with the QUERY Formula
Pull data from Tickspot, automate spreadsheets, and more with the QUERY formula.
-
Moving Data from Outreach.io to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Outreach.io data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Biml to Build SSIS Tasks to Replicate SAP Netweaver Gateway Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Netweaver Gateway to SQL Server.
-
Provide OData Services of Wistia Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Wistia by developing a WCF Service Application.
-
Automated Continuous IBM Cloud Object Storage Replication to AlloyDB
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to AlloyDB.
-
Automate Perplexity Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Perplexity from PowerShell? This article demonstrates how to utilize the Perplexity Cmdlets for tasks like connecting to Perplexity, automating operations, downloading data, and more.
-
How to Connect to Live Basecamp 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 Basecamp for you.
-
Moving Data from Scrapfly to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Scrapfly data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating Sugar CRM Data in Talend Cloud Data Management Platform
Connect Sugar CRM Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Sugar CRM.
-
Create Azure Data Lake Storage Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Azure Data Lake Storage from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData API Server to Access Azure Data Lake Storage Data in Microsoft PowerPivot
Use the CData API Server to connect to live Azure Data Lake Storage in the Power Pivot business intelligence tool.
-
Getting Started with the CData SSIS Components for Opsgenie
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Opsgenie.
-
Connect to Oracle Financials Cloud Data from a Connection Pool in Jetty
The Oracle Financials Cloud JDBC Driver supports connection pooling: This article shows how to connect faster to Oracle Financials Cloud from Web apps in Jetty.
-
Integrating Tavily Data in Talend Cloud Data Management Platform
Connect Tavily Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Import Data from Confluence into Google Sheets
Import Atlassian Confluence into a Google spreadsheet that is automatically refreshed.
-
Salesloft Reporting in OBIEE with the Salesloft JDBC Driver
Deploy the Salesloft JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connecting Mastra with Dynamics 365 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 Microsoft Dynamics 365, no replication required.
-
Build Workday-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Workday and build web apps with connectivity to live Workday.
-
How to create an RPA flow for Reckon Accounts Hosted Data in UiPath Studio
Use the Reckon Accounts Hosted ODBC Driver to create workflows that access real-time Reckon Accounts Hosted without any coding.
-
Query Nethunt Data in ColdFusion
Write standard ColdFusion data access code to connect to Nethunt.
-
Access Live Datadog Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Datadog in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Visualize Instagram Data in Python with pandas
Use pandas and other modules to analyze and visualize live Instagram in Python.
-
Create Power BI Reports on Real-Time Parquet Data
Use the CData ODBC Driver for Parquet to visualize Apache Parquet in Power BI Desktop.
-
Create Snapchat Ads-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Snapchat Ads Data from OutSystems and build custom enterprise apps using live Snapchat Ads.
-
Build Oracle Eloqua Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Oracle Eloqua and build visualizations in Tableau Cloud.
-
Enable the iContact JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with iContact.
-
Prepare, Blend, and Analyze BigCommerce Data in Alteryx Designer (Connect AI)
Build workflows to access live BigCommerce for self-service data analytics.
-
Integrate LightSpeedRetail Data in Pentaho Data Integration
Build ETL pipelines based on LightSpeedRetail in the Pentaho Data Integration tool.
-
Access Snowflake Data from MySQL in PHP
Connect to Snowflake through the standard MySQL libraries in PHP.
-
Connect to Spark Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Spark to connect to Apache Spark SQL and execute queries in PowerBuilder.
-
Use the CData Software ODBC Driver for Nuclia in SAS for Real-Time Reporting and Analytics
Connect to real-time Nuclia in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Nuclia.
-
Automated SAP Data Replication to Teradata
Use CData Sync to Customize and automate SAP ERP/NetWeaver replication to Teradata.
-
How to Access SAP HANA Data Using Entity Framework
This article shows how to access SAP HANA using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData SSIS Components for Zoho Projects
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Zoho Projects.
-
Getting Started with the CData ADO.NET Provider for Gong
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build Visualizations of Paddle Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Paddle in Birst.
-
Build a PostgreSQL Interface for SendGrid Data using the CData JDBC Driver
Use the Remoting features of the SendGrid JDBC Driver to create a PostgreSQL entry-point for data access.
-
Manage REST Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for REST.
-
Connecting GenSpark with SAS Data Sets Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAS Data Sets without any replication or custom integration required.
-
Bridge Foursquare Connectivity with Apache NiFi
Access and process Foursquare in Apache NiFi using the CData JDBC Driver.
-
Build Semantic Layer Views for MarkLogic Data in APOS Live Data Gateway
Use the CData Connector for MarkLogic in APOS Live Data Gateway to build Semantic Layer Views for MarkLogic.
-
Automated Continuous Azure Data Lake Storage Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Amazon Redshift.
-
Connect to Adobe Target Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Adobe Target using standard SQL.
-
Visualize Presto Data in TIBCO Spotfire through OData
Integrate Presto into dashboards in TIBCO Spotfire.
-
Publish Crystal Reports on Float Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Float.
-
Create Okta-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Okta Data from Klipfolio and build custom visualizations using live Okta.