CData Software - Knowledge Base
Recent Articles
-
Visualize Factorial 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 Factorial into TIBCO Spotfire.
-
Getting Started with the CData Python Connector for Microsoft Teams
Learn to install and license the CData Python Connector
-
Query ShipEngine Data as a MySQL Database in Node.js
Execute MySQL queries against ShipEngine from Node.js.
-
Use Microsoft Copilot Studio to talk to your Dropbox 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 Dropbox for you.
-
Automated Continuous Greenhouse Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Greenhouse replication to Amazon Redshift.
-
Automated Continuous Humanity Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Humanity replication to Google BigQuery.
-
Use CData Connect AI to Access Google Analytics Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Analytics in the Power Pivot business intelligence tool.
-
Easily Integrate Amazon DynamoDB Data in Lazarus Pascal IDE
Learn how to easily integrate live Amazon DynamoDB in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Microsoft Ads Data in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft Ads in FileMaker Pro to connect to Microsoft Ads and work with Microsoft Ads in your FileMaker applications.
-
How to connect and process Adobe Analytics from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Adobe Analytics.
-
Analyze Jira Assets Data in Looker
Use CData Connect AI to connect to Jira Assets Data from Looker and build custom apps using live Jira Assets.
-
Connect to GitLab Data in Jaspersoft Studio
Execute SQL to remote GitLab in Jaspersoft Studio.
-
Integrate Live Grafana Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Grafana to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Replicate Multiple Jira Accounts via the CData Sync CLI
Replicate multiple Jira accounts to one or many databases.
-
Aweber Reporting in OBIEE with the Aweber JDBC Driver
Deploy the Aweber JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to integrate VWO with Apache Airflow
Access and process VWO in Apache Airflow using the CData JDBC Driver.
-
How to Seamlessly Import ConstantContact Data into IBM SPSS Modeler
Integrate ConstantContact data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Stream Attio Data into Apache Kafka Topics
Access and stream Attio in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use Azure AI Foundry to Talk to Your Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Apache Phoenix for you.
-
Automated Continuous Invoiced Replication to Snowflake
Use CData Sync for automated, continuous, customizable Invoiced replication to Snowflake.
-
Connecting Agentforce with Active Directory Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Active Directory for you.
-
ETL Autopilot in Oracle Data Integrator
This article shows how to transfer Autopilot into a data warehouse using Oracle Data Integrator.
-
Import Real-Time Quickbase Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Quickbase in ColdFusion.
-
Use the CData Software ODBC Driver for Oracle Service Cloud in MicroStrategy Web
Connect to Oracle Service Cloud in MicroStrategy Web using the CData Software ODBC Driver for Oracle Service Cloud.
-
Model Twitter Ads Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Twitter Ads, enabling the direct import of real-time Twitter Ads.
-
Build Dashboards with SFTP Data in DBxtra
Create dynamic dashboards and perform analytics based on SFTP in DBxtra.
-
How to import Helpscout Data into Apache Solr
Use the CData Software JDBC Driver for Helpscout in Data Import Handler and create an automated import of Helpscout to Apache Solr Enterprise Search platform.
-
How to update Reckon from Excel
This article explains how to transfer data from Excel to Reckon using the Excel Add-In for Reckon.
-
Automated Continuous GitHub Replication to Vertica
Use CData Sync for automated, continuous, customizable GitHub replication to Vertica.
-
Access Mailgun 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 Mailgun.
-
Automate Nuclia Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Nuclia from PowerShell? This article demonstrates how to utilize the Nuclia Cmdlets for tasks like connecting to Nuclia, automating operations, downloading data, and more.
-
Create Dynamic GitHub Grids Using the Infragistics XamDataGrid
Learn how you can connect GitHub to Infragistics XamDataGrid to build dynamic grids.
-
Getting Started with the CData Connect AI Python SDK for Freshservice
Install the CData Connect AI Python SDK to read and write live Freshservice with standard DB-API 2.0 Python code.
-
Build an OLAP Cube in SSAS from Instagram Data
Establish a connection to Instagram data from SQL Server Analysis Services, and use the Instagram Data Provider to build OLAP cubes for use in analytics and reporting.
-
Natively Connect to Calendly Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Calendly. Leverage the native support for ODBC in PHP.
-
Create Reports with Postmark Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Postmark.
-
Integrate Autopilot with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Autopilot with External Services.
-
How to connect and process Vimeo from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Vimeo.
-
How to connect to Google Forms Data from Spring Boot
Connect to Google Forms in a Spring Boot Application using the CData API Driver for JDBC
-
Analyze Live Google Analytics Data in SAS Viya
Use CData Connect AI to connect to Google Analytics from SAS Viya and deploy self-service analytics using live Google Analytics.
-
Analyze Clio Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Clio in Microsoft R Open.
-
Connect HelloSign to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live HelloSign using the CData Python MCP Server.
-
Connecting Pipedream with Zuora Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Zuora data in real time.
-
Build Semantic Layer Views for ServiceNow Data in APOS Live Data Gateway
Use the CData Connector for ServiceNow in APOS Live Data Gateway to build Semantic Layer Views for ServiceNow.
-
Automated Continuous Jodoo Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Jodoo replication to Amazon Redshift.
-
Build a PostgreSQL Interface for Salesforce Pardot Data using the CData JDBC Driver
Use the Remoting features of the Salesforce Pardot JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Controls to Clio Data in Delphi
DataBind to Clio in Delphi with standard data access components and controls.
-
DataBind Controls to SAP SuccessFactors LMS Data in Delphi
DataBind to SAP SuccessFactors LMS in Delphi with standard data access components and controls.
-
Publish Reports with SAP Ariba Source Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Ariba Source.
-
Connect to WooCommerce Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for WooCommerce Data and connect to WooCommerce in Akorbi Digital RunMyProcess.
-
Connect to Stripe Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Stripe and the SQL Gateway to access Stripe from Google Apps Script.
-
Integrate Workable Data in Pentaho Data Integration
Build ETL pipelines based on Workable in the Pentaho Data Integration tool.
-
Prepare, Blend, and Analyze Zendesk Data in Alteryx Designer (ODBC)
Build workflows to access live Zendesk for self-service data analytics.
-
Publish Crystal Reports on Mixpanel Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Mixpanel.
-
Build Apps with Live HelloSign Data Using the Low-Code Development Platform of Mendix
Connect HelloSign with Mendix to build apps using the CData API Driver for JDBC.
-
Getting Started with the CData Power BI Connector for Pushbullet
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connecting Mastra with SAS Data Sets 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 SAS Data Sets, no replication required.
-
Choosing the Best Method to Connect Sugar CRM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sugar CRM from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Feed SAP SuccessFactors Data into FineReport
How to set SAP SuccessFactors as a JDBC data source in FineReport.
-
Automated Continuous SAP Hybris C4C Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to SQL Server.
-
Back Up IBM Informix to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for IBM Informix. In this article, we will employ an SSIS workflow to populate a database with IBM Informix data.
-
Access Act-On Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Act-On from your Oracle system.
-
Build Semantic Layer Views for Certinia Data in APOS Live Data Gateway
Use the CData Connector for Certinia in APOS Live Data Gateway to build Semantic Layer Views for Certinia.
-
Create Power BI Reports on Real-Time Quaderno Data
Use the CData ODBC Driver for Quaderno to visualize Quaderno in Power BI Desktop.
-
Replicate Multiple BenchmarkEmail Accounts
Replicate multiple BenchmarkEmail accounts to one or many databases.
-
Trigger Email IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Email with standard wizards in Logic Apps.
-
Use Azure AI Foundry to Talk to Your Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Trello for you.
-
How to Query Live Trello Data in Claude Desktop
Connect to and query live Trello Data in Claude Desktop using CData MCP Server.
-
Connect to Oracle Financials Cloud Data in Aqua Data Studio
Access Oracle Financials Cloud from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Explore Geographical Relationships in Zoho Creator Data with Power Map
Create data visualizations with Zoho Creator in Power Map.
-
How to Easily Query Planio Data in OpenOffice Base
Connect to Planio data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Analyze Xero Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Xero from Power Pivot. You will use the Table Import Wizard to load Xero Accounting. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect to Live Zoho Books 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 Zoho Books without replication.
-
Use the CData Software ODBC Driver for Shopify in MicroStrategy
Connect to Shopify in MicroStrategy Developer using the CData Software ODBC Driver for Shopify.
-
Connect to Zuora Data from HeidiSQL
Use CData Connect AI to connect to and query live Zuora from HeidiSQL.
-
How to work with SpaceX Data in Apache Spark using SQL
Access and process SpaceX Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Jira Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Jira as an External Source in Dremio.
-
DataBind Controls to ConvertAPI Data in C++Builder
DataBind to ConvertAPI in C++Builder with standard components and controls.
-
Connect to Confluence Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Confluence Data and connect to Atlassian Confluence in Akorbi Digital RunMyProcess.
-
Automate Sage 200 Data Replication to Azure Synapse
Use CData Sync to customize and automate Sage 200 replication to Azure Synapse.
-
How to import Zoho Inventory Data into Apache Solr
Use the CData Software JDBC Driver for Zoho Inventory in Data Import Handler and create an automated import of Zoho Inventory to Apache Solr Enterprise Search platform.
-
Integrate Real-Time Access to Facebook in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Facebook in real time.
-
Access Live Stripe Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Stripe from your Excel spreadsheets.
-
Analyze ZohoPeople Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ZohoPeople in Microsoft R Open.
-
How to Import Data from Azure Data Catalog into Google Sheets
Import Azure Data Catalog into a Google spreadsheet that is automatically refreshed.
-
Create Dashboards and Visualize Live Freshservice Data in Geckoboard
Use CData Connect AI to connect to live Freshservice and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate Live Elasticsearch Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Elasticsearch from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Elasticsearch.
-
Replicate Clio Data to Multiple Databases via the CData Sync CLI
Replicate Clio to disparate databases with a single configuration.
-
Connecting Agentforce with Google Ad Manager Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Google Ad Manager for you.
-
How to import Freshdesk Data into Apache Solr
Use the CData Software JDBC Driver for Freshdesk in Data Import Handler and create an automated import of Freshdesk to Apache Solr Enterprise Search platform.
-
Natively Connect to MessageBird Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MessageBird. Leverage the native support for ODBC in PHP.
-
Analyze Mixpanel Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Mixpanel in Microsoft R Open.
-
Bridge PabblySubscriptions Connectivity with Apache NiFi
Access and process PabblySubscriptions in Apache NiFi using the CData JDBC Driver.
-
A PostgreSQL Interface for Greenhouse Data (MySQL Remoting via JDBC)
Use the Remoting features of the Greenhouse JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Flowlu Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Flowlu using standard SQL.
-
Stream PostgreSQL Data into Apache Kafka Topics
Access and stream PostgreSQL in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Dynamic Productboard Grids Using the Infragistics XamDataGrid
Learn how you can connect Productboard to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData Software JDBC Driver for SFTP in MicroStrategy Web
Connect to SFTP in MicroStrategy Web using the CData Software JDBC Driver for SFTP.
-
Integrating Gumloop with Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Dropbox within automated workflows.
-
How to Access Opsgenie Data Using Entity Framework
This article shows how to access Opsgenie using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.