CData Software - Knowledge Base
Recent Articles
-
Integrate Google Cloud Storage with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Cloud Storage with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Cloud Storage data.
-
How to Seamlessly Import Office 365 Data into IBM SPSS Modeler
Integrate Office 365 data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Query Mistral AI Data in ColdFusion
Write standard ColdFusion data access code to connect to Mistral AI data.
-
Stream Datadog Data into Apache Kafka Topics
Access and stream Datadog data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Prepare, Blend, and Analyze OData Services in Alteryx Designer (ODBC)
Build workflows to access live OData services for self-service data analytics.
-
Build Charts with Jodoo Data in Clear Analytics
Create dynamic charts and perform analytics based on Jodoo data in Clear Analytics.
-
Getting Started with the CData ADO.NET Provider for Microsoft Entra ID
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Microsoft Entra ID.
-
Replicate MongoDB Data from PowerShell
Write a quick PowerShell script to query MongoDB data. Use connectivity to the live data to replicate MongoDB data to SQL Server.
-
Integrate Live EnterpriseDB Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live EnterpriseDB data from within the IDE.
-
Migrating data from Pingdom to Google BigQuery using CData SSIS Components.
Easily push Pingdom data to Google BigQuery using the CData SSIS Tasks for Pingdom and Google BigQuery.
-
Connect to Square Data in RapidMiner
Integrate Square data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Google Analytics Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google Analytics data from Crystal Reports.
-
Automate Timely Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Timely data from PowerShell? This article demonstrates how to utilize the Timely Cmdlets for tasks like connecting to Timely data, automating operations, downloading data, and more.
-
Automated Continuous Wave Financial Replication to Oracle
Use CData Sync for automated, continuous, customizable Wave Financial replication to Oracle.
-
Connect to HubDB Data in JRuby
Create a simple JRuby app with access to live HubDB data.
-
Access Live Float Data in AWS Lambda
Connect to live Float data in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Paymo in MicroStrategy Desktop
Connect to Paymo data in MicroStrategy Desktop using the CData Software ODBC Driver for Paymo.
-
Integrate with Couchbase Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Couchbase data in SnapLogic.
-
Build Apps with Live Dynamics 365 Business Central data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Dynamics 365 Business Central data into the Adalo platform and build custom mobile and web applications with real-time Dynamics 365 Business Central data.
-
Visualize Spark Data in TIBCO Spotfire through OData
Integrate Spark data into dashboards in TIBCO Spotfire.
-
Integrate SAS Data Sets with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAS Data Sets with External Services.
-
Visualize JDBC-ODBC Bridge Data in Sisense
Create an ElastiCube in Sisense app with access to JDBC-ODBC Bridge data.
-
Analyze FreeAgent Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze FreeAgent data with the CData JDBC Driver for FreeAgent.
-
How to Use a Microsoft Access Database to Update Lakebase Data in Real Time
Update Lakebase data by creating a linked table in Microsoft Access with the CData Lakebase ODBC Driver.
-
Automated Continuous ScrapingBee Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ScrapingBee replication to Apache Kafka.
-
Publish Crystal Reports on Microsoft Entra ID Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Entra ID data.
-
Replicate GraphQL Data from PowerShell
Write a quick PowerShell script to query GraphQL data. Use connectivity to the live data to replicate GraphQL data to SQL Server.
-
Connect to Real-Time AgileCRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use AgileCRM data in Power Apps.
-
Automated Continuous Azure Synapse Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Amazon S3.
-
Configure the CData JDBC Driver for Azure Table in a Connection Pool in Tomcat
Connect to Azure Table data from a connection pool in Tomcat.
-
Visualize Adobe Analytics Data in TIBCO Spotfire through ADO.NET
Integrate Adobe Analytics data into dashboards in TIBCO Spotfire.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SFTP
Provide connectivity to SFTP data through an SAP BusinessObjects universe.
-
Automate Microsoft Entra ID Data Replication to Azure Data Lake
Use CData Sync to customize and automate Microsoft Entra ID data replication to Azure Data Lake.
-
Analyze Sage Cloud Accounting Data in Cognos Analytics
Use CData Connect AI to connect to Sage Cloud Accounting Data from Cognos Analytics and analyze live Sage Cloud Accounting data.
-
Create Informatica Mappings From/To a JDBC Data Source for Brex
Create Brex data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Instantly Data in RapidMiner
Integrate Instantly data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Live SQL Analysis Services Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SQL Analysis Services from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SQL Analysis Services data.
-
Automate PolarTeamPro Data Replication to Azure Synapse
Use CData Sync to customize and automate PolarTeamPro data replication to Azure Synapse.
-
Validate Vimeo Data with QuerySurge
Access and validate Vimeo data in QuerySurge using the CData JDBC Driver.
-
How to integrate Apollo with Apache Airflow
Access and process Apollo data in Apache Airflow using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Front in MicroStrategy
Connect to Front data in MicroStrategy Developer using the CData Software JDBC Driver for Front.
-
Connect to Klipfolio Data in HULFT Integrate
Connect to Klipfolio as a JDBC data source in HULFT Integrate
-
How to Connect DBeaver to Beeminder via a JDBC Driver
Manage Beeminder data with visual tools in DBeaver like the query browser.
-
Integrating Qualaroo Data in Talend Cloud Data Management Platform
Connect Qualaroo Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate Cursor with Live JSON Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live JSON services from within the editor.
-
Replicate Pipeline CRM Data in Heroku for Use in Salesforce Connect
Replicate Pipeline CRM data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to create Visio diagrams from OneNote Data
Automatically update OneNote data with the changes you make to Visio master shapes.
-
Automated Continuous Asana Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Asana replication to Apache Cassandra.
-
Automated Continuous Epicor Kinetic Replication to SingleStore
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to SingleStore.
-
Integrate Cursor with Live DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live DB2 data from within the editor.
-
Prepare, Blend, and Analyze Supabase Data in Alteryx Designer (ODBC)
Build workflows to access live Supabase data for self-service data analytics.
-
How to load Chargebee data into Elasticsearch via Logstash
Introducing a simple method to load Chargebee data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to and Query REST Data in QlikView over ODBC
Create data visualizations with REST data in QlikView.
-
Build a PostgreSQL Interface for Mailjet Data using the CData JDBC Driver
Use the Remoting features of the Mailjet JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Controls to Zoho Creator Data in C++Builder
DataBind to Zoho Creator data in C++Builder with standard components and controls.
-
Automated Continuous Elasticsearch Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Azure SQL Database.
-
Provide OData Services of Hubstaff Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Hubstaff data by developing a WCF Service Application.
-
Integrate PDFMonkey with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate PDFMonkey with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to PDFMonkey data.
-
Build Data Flows from Amazon Marketplace to SQL Server using SSIS
Easily back up Amazon Marketplace data to SQL Server using the SSIS components for Amazon Marketplace.
-
Integrating SuiteCRM Data in Talend Cloud Data Management Platform
Connect SuiteCRM Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SuiteCRM.
-
How to work with NetSuite Data in Apache Spark using SQL
Access and process NetSuite Data in Apache Spark using the CData Software JDBC Driver.
-
Query Hive Data as a MySQL Database in Node.js
Execute MySQL queries against Hive data from Node.js.
-
Replicate PagerDuty Data from PowerShell
Write a quick PowerShell script to query PagerDuty data. Use connectivity to the live data to replicate PagerDuty data to SQL Server.
-
Using the CData Software ODBC Driver for Bannerbear in PyCharm
Connect to Bannerbear as an ODBC data source in PyCharm using the CData Software ODBC Driver for Bannerbear.
-
Connect to Sage 200 Data in RapidMiner
Integrate Sage 200 data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to and Visualize Live SAP Netweaver Gateway Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP Netweaver Gateway data.
-
Query Live Marketo Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Marketo data through a conversational interface.
-
Access Live MariaDB Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live MariaDB data from your Excel spreadsheets.
-
Integrate Dify with Live Oracle HCM Cloud Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Oracle HCM Cloud data.
-
Query ZohoMarketingHub Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ZohoMarketingHub data from Node.js.
-
Connect to Real-Time Pipeliner CRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Pipeliner CRM data in Power Apps.
-
Connect to ActiveCampaign Data in RazorSQL
Connect to ActiveCampaign from wizards and query ActiveCampaign data from the GUI in the RazorSQL database management tool.
-
Access Excel Data from MySQL in PHP
Connect to Excel through the standard MySQL libraries in PHP.
-
Analyze Exact Online Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Exact Online data and visualize Exact Online data in SAP Analytics Cloud.
-
Connect to Couchbase Data in RazorSQL
Connect to Couchbase from wizards and query Couchbase data from the GUI in the RazorSQL database management tool.
-
Connect to MessageBird Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for MessageBird and the SQL Gateway to access MessageBird data from Google Apps Script.
-
How to Seamlessly Import Avalara AvaTax Data into IBM SPSS Modeler
Integrate Avalara AvaTax data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build AI Agents with Jira Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Jira data through CData Connect AI.
-
Create Reports with Moosend Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Moosend data.
-
Automated Continuous HelloSign Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable HelloSign replication to PostgreSQL.
-
Build a Simple VCL Application for ZeroBounce Data
How to build a simple VCL Application to view ZeroBounce data in RAD Studio using the CData ODBC Driver for ZeroBounce.
-
Natively Connect to Google Analytics Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Analytics data. Leverage the native support for ODBC in PHP.
-
Import QuickBooks Time Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to QuickBooks Time Data and provide access to live QuickBooks Time data for custom reports in the Power BI Service.
-
Back Up Jumpseller data 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 Jumpseller data data.
-
Working with Humanity Data in LINQPad
Execute LINQ queries to Humanity data in LINQPad.
-
Build Zoho Inventory-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Zoho Inventory data and build Zoho Inventory-connected web apps with Axios.
-
Blackbaud FE NXT Reporting in OBIEE with the Blackbaud FE NXT JDBC Driver
Deploy the Blackbaud FE NXT JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Google Spanner Data in Sisense
Create an ElastiCube in Sisense app with access to Google Spanner data.
-
Connect to Exact Online Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Exact Online as an External Source in Dremio.
-
Integrating Dataiku with Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft Ads data.
-
Integrate with IBM Informix Data in JReport Designer
Create charts and reports based on IBM Informix data in JReport Designer.
-
Integrate Amazon Marketplace Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Amazon Marketplace data and integrate live Amazon Marketplace data into your Power Automate tasks.
-
Build CircleCI-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live CircleCI data.
-
How to Easily Query Excel Online Data in OpenOffice Base
Connect to Excel Online data in OpenOffice Base using the CData ODBC Driver for Excel Online and generate reports with live data insights.
-
How to create an RPA flow for Zoho Books Data in UiPath Studio
Use the Zoho Books ODBC Driver to create workflows that access real-time Zoho Books data without any coding.
-
Connect to Clari Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Clari and the SQL Gateway to access Clari data from Google Apps Script.
-
Write a Simple Go Application to work with OpenWeatherMap Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to OpenWeatherMap data.
-
Build Dashboards with Box Data in DBxtra
Create dynamic dashboards and perform analytics based on Box data in DBxtra.
-
Build MVC Applications with Connectivity to Airtable Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Airtable from an ASP.NET MVC application.
-
Connect to and Visualize Live Zoho CRM Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Zoho CRM data.