CData Software - Knowledge Base
Recent Articles
-
Query Live Splunk 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 Splunk directly from the development environment.
-
Use Biml to Build SSIS Tasks to Replicate eBay Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate eBay to SQL Server.
-
Integrate ZarMoney Data in Pentaho Data Integration
Build ETL pipelines based on ZarMoney in the Pentaho Data Integration tool.
-
Migrating data from Zoho Projects to Google BigQuery using CData SSIS Components.
Easily push Zoho Projects to Google BigQuery using the CData SSIS Tasks for Zoho Projects and Google BigQuery.
-
Natively Connect to Zoho Recruit Data in PHP
The CData ODBC driver for Zoho Recruit enables you to create PHP applications with connectivity to Zoho Recruit. Leverage the native support for ODBC in PHP.
-
Automated Continuous Google Tasks Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Tasks replication to PostgreSQL.
-
Analyze Facebook Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Facebook and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Natively Connect to Google Ad Manager Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Ad Manager. Leverage the native support for ODBC in PHP.
-
Visualize eBay Data in TIBCO Spotfire through ADO.NET
Integrate eBay into dashboards in TIBCO Spotfire.
-
How to Visualize DB2 Data in Python with pandas
Use pandas and other modules to analyze and visualize live IBM DB2 in Python.
-
How to Visualize Adobe Analytics Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Adobe Analytics in Python.
-
How to Seamlessly Import Demio Data into IBM SPSS Modeler
Integrate Demio data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Excel Data in the Pentaho Report Designer
Publish reports based on Microsoft Excel in the Pentaho BI tool.
-
Visualize Live LionDesk Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live LionDesk using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData API Server to Access Azure DevOps Data in Microsoft PowerPivot
Use the CData API Server to connect to live Azure DevOps in the Power Pivot business intelligence tool.
-
Access Cloudflare Data from MySQL in PHP
Connect to Cloudflare through the standard MySQL libraries in PHP.
-
Build Apps with Live Pinecone Data Using the Low-Code Development Platform of Mendix
Connect Pinecone with Mendix to build apps using the CData API Driver for JDBC.
-
Easily Integrate Rebilly Data in Lazarus Pascal IDE
Learn how to easily integrate live Rebilly in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to JobNimbus Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for JobNimbus in the Denodo Virtual DataPort Administrator.
-
Automate Hubstaff Data Replication to Couchbase
Use CData Sync to Customize and automate Hubstaff replication to Couchbase.
-
How to Access Live Box Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Box enables you to integrate Box into workflows built using Microsoft Power Automate Desktop.
-
Seamlessly Bring Quickbase Data into Retool Using CData Connect AI
Integrate Quickbase data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Visualize PhantomBuster Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to PhantomBuster.
-
Import and Visualize LionDesk Data in Power View
Create data visualizations based on LionDesk in Excel.
-
Automate Sage 200 Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Sage 200 and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Bind Live MongoDB Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live MongoDB data
-
Connect to OnePageCrm Data in RazorSQL
Connect to OnePageCrm from wizards and query OnePageCrm from the GUI in the RazorSQL database management tool.
-
Validate Azure Data Lake Storage Data with QuerySurge
Access and validate Azure Data Lake Storage in QuerySurge using the CData JDBC Driver.
-
Operational Reporting on Browserless Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Browserless.
-
Connect Zuora to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Zuora using the CData Python MCP Server.
-
Use the CData Software JDBC Driver for Foursquare in MicroStrategy
Connect to Foursquare in MicroStrategy Developer using the CData Software JDBC Driver for Foursquare.
-
How to Work with ConstantContact Data in ETL Validator JDBC
Connect to ConstantContact from ETL Validator jobs using the CData Software JDBC Driver.
-
Analyze Gumroad Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Gumroad in Microsoft R Open.
-
Create Informatica Mappings From/To a JDBC Data Source for ZohoInvoice
Create ZohoInvoice data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData Software JDBC Driver for Campaigner in MicroStrategy Desktop
Connect to Campaigner in MicroStrategy Desktop using the CData Software JDBC Driver for Campaigner.
-
Build a Simple VCL Application for Azure DevOps Data
How to build a simple VCL Application to view Azure DevOps in RAD Studio using the CData ODBC Driver for Azure DevOps.
-
Create Informatica Mappings From/To an ODBC Data Source for Nuclia
Create an ODBC connection to Nuclia in Informatica and browse and transfer Nuclia.
-
Analyze Live Sage Cloud Accounting Data in SAS Viya
Use CData Connect AI to connect to Sage Business Cloud Accounting from SAS Viya and deploy self-service analytics using live Sage Business Cloud Accounting.
-
Create SSAS Tabular Models from Salesforce Marketing Data
How to build a SQL Server Analysis Service Tabular Model from Salesforce Marketing Cloud using CData drivers.
-
Replicate Multiple IBM Informix Accounts
Replicate multiple IBM Informix accounts to one or many databases.
-
Consume Presto OData Feeds in PowerBuilder
This article demonstrates how to consume Presto as OData feeds from PowerBuilder using the API Server.
-
Access Superchat Data from MySQL in PHP
Connect to Superchat through the standard MySQL libraries in PHP.
-
Connect to Avaza in SpagoBI
Create reports featuring live Avaza in SpagoBI Studio. Host Avaza reports on SpagoBI Server.
-
Import and Visualize Tanda Data in Power View
Create data visualizations based on Tanda in Excel.
-
Build AlloyDB Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google AlloyDB and build visualizations in Tableau.
-
Bidirectional Access to Jira Assets Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Jira Assets in Filemaker Pro for Mac or Windows.
-
Getting Started with the CData Power BI Connector for Yelp
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Replicate Sage Cloud Accounting Data to Multiple Databases
Replicate Sage Business Cloud Accounting to disparate databases with a point-and-click configuration.
-
Replicate Oracle HCM Cloud Data to Multiple Databases via the CData Sync CLI
Replicate Oracle HCM Cloud to disparate databases with a single configuration.
-
Build AI Agents with SAP SuccessFactors LMS 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 SAP SuccessFactors LMS through CData Connect AI.
-
Analyze YouTube Analytics Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of YouTube Analytics and visualize live YouTube Analytics in Infragistics Reveal.
-
Integrating Antigravity CLI with Factorial via CData CLI
Connect Factorial to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Cline with Live Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Power BI XMLA from within your IDE.
-
How to create OData federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for OData in MySQL .
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Flowlu
Provide connectivity to Flowlu through an SAP BusinessObjects universe.
-
Connect to Zoho CRM Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrating LlamaIndex with Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Snowflake in real time.
-
Visualize Jira Assets Data in TIBCO Spotfire through ADO.NET
Integrate Jira Assets into dashboards in TIBCO Spotfire.
-
Import Real-Time Cloudflare Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Cloudflare in ColdFusion.
-
Import Real-Time Blackbaud FE NXT Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Blackbaud FE NXT in ColdFusion.
-
Egnyte Reporting in OBIEE with the Egnyte JDBC Driver
Deploy the Egnyte JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Sugar CRM 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 Sugar CRM into TIBCO Spotfire.
-
Connect to Adobe Commerce Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Adobe Commerce and the Script function in FileMaker Pro to connect to Adobe Commerce and work with Adobe Commerce in your FileMaker application.
-
Automated Continuous ZohoMarketingHub Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to Google Cloud SQL.
-
Create a Data Access Object for Anaplan Data using JDBI
A brief overview of creating a SQL Object API for Anaplan in JDBI.
-
Query Anaplan Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Anaplan from Node.js.
-
Automated Continuous WooCommerce Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable WooCommerce replication to OneLake in Microsoft Fabric.
-
Build Azure Analysis Services-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Azure Analysis Services Data from Zoho Analytics and import live Azure Analysis Services.
-
Connect to WordPress Data in ACL Analytics
Connect to WordPress via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to WordPress.
-
How to Connect DBeaver to ZohoPeople via a JDBC Driver
Manage ZohoPeople with visual tools in DBeaver like the query browser.
-
Build Dashboards with Nuclia Data in Dundas BI
Create dynamic dashboards and perform analytics based on Nuclia in Dundas BI.
-
How to Connect to Live Zoho Projects 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 Projects without replication.
-
Automated Continuous Google Ads Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Ads replication to Apache Kafka.
-
How to Create Power BI Visual Reports with Real-Time Slack Data
Use CData Power BI Connectors to visualize Slack in Power BI.
-
Bind Live Highrise Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Highrise data
-
A PostgreSQL Interface for ZarMoney Data (MySQL Remoting via JDBC)
Use the Remoting features of the ZarMoney JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Vertica Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Vertica for you.
-
Connect to Intercom Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Apollo Data in DBeaver
Use the CData ODBC Driver to connect to Apollo in DBeaver.
-
Integrate with live ADP Data in Jitterbit
Use CData Connect AI to connect to and integrate live ADP in Jitterbit.
-
Prepare, Blend, and Analyze Zendesk Data in Alteryx Designer (Connect AI)
Build workflows to access live Zendesk for self-service data analytics.
-
Create SSAS Tabular Models from Teamgate Data
How to build a SQL Server Analysis Service Tabular Model from Teamgate using CData drivers.
-
Connect to MongoDB in SpagoBI
Create reports featuring live MongoDB in SpagoBI Studio. Host MongoDB reports on SpagoBI Server.
-
Integrate with WooCommerce Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy WooCommerce to a JSON file on disk.
-
Build Semantic Layer Views for Salesforce Marketing Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Salesforce Marketing Cloud.
-
Replicate SAP HANA XS Advanced Data to Multiple Databases via the CData Sync CLI
Replicate SAP HANA XS Advanced to disparate databases with a single configuration.
-
Stream Telegram Data into Apache Kafka Topics
Access and stream Telegram in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Visualize Salesforce CRM Analytics Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Salesforce CRM Analytics in Python.
-
Manage Hugging Face Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Hugging Face.
-
How to Query Live Trello Data in Perplexity MacOS Desktop
Connect to and query live Trello Data in Perplexity Desktop using CData MCP Server.
-
Analyze SurveyMonkey Data in Looker
Use CData Connect AI to connect to SurveyMonkey Data from Looker and build custom apps using live SurveyMonkey.
-
How to Connect the Power BI Service to Redis: Complete Guide
Connect to the CData Software Power BI Connector for Redis from PowerBI.com to provide real-time Redis across the organization.
-
SAP ByDesign Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP ByDesign facts in real time.
-
How to work with Aha! Data in Apache Spark using SQL
Access and process Aha! Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live CSV Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live CSV data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create Dynamic Pushbullet Grids Using the Infragistics XamDataGrid
Learn how you can connect Pushbullet to Infragistics XamDataGrid to build dynamic grids.
-
How to connect Amazon QuickSight to Salesforce Pardot Data
Create a connection to Salesforce Pardot in CData Connect AI and insert Salesforce Pardot into Amazon QuickSight SPICE to build interactive dashboards.
-
Visualize BigQuery 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 Google BigQuery into TIBCO Spotfire.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Codat
Provide connectivity to Codat through an SAP BusinessObjects universe.
-
How to Access Vimeo Data Using Entity Framework
This article shows how to access Vimeo using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.