CData Software - Knowledge Base
Recent Articles
-
Analyze Azure DevOps Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Azure DevOps data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Live Cvent Data in MicroStrategy through CData Connect AI
Create a live connection to Cvent Data in CData Connect AI and connect to your Cvent data from MicroStrategy.
-
Integrate Google's Vertex AI Agent with Live Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Sybase data within intelligent workflows.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Act CRM
Provide connectivity to Act CRM data through an SAP BusinessObjects universe.
-
Feed Sybase IQ Data into FineReport
How to set Sybase IQ data as a JDBC data source in FineReport.
-
Create Sybase-Connected Nintex Workflows
Use CData Connect AI to connect to Sybase Data from Nintex Workflow Cloud and build custom workflows using live Sybase data.
-
Connect IBM Informix to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live IBM Informix data using the CData Python MCP Server.
-
Trigger ADP IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for ADP with standard wizards in Logic Apps.
-
Getting Started with the CData JDBC Driver for OpenWeatherMap
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for OpenWeatherMap.
-
Automated Continuous OData Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable OData replication to delimited files (CSV/TSV).
-
Build Semantic Layer Views for Cassandra Data in APOS Live Data Gateway
Use the CData Connector for Cassandra in APOS Live Data Gateway to build Semantic Layer Views for Cassandra data.
-
Model Apollo Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Apollo, enabling the direct import of real-time Apollo data.
-
Build Semantic Layer Views for OpenWeatherMap Data in APOS Live Data Gateway
Use the CData Connector for OpenWeatherMap in APOS Live Data Gateway to build Semantic Layer Views for OpenWeatherMap data.
-
Integrate Live Google Translate Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Translate data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Analyze Sendwithus Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Sendwithus data and visualize live Sendwithus data in Infragistics Reveal.
-
How to Query Snowflake Data in MySQL Workbench
Execute MySQL queries against live Snowflake data from MySQL Workbench.
-
Explore Geographical Relationships in SAP Concur Data with Power Map
Create data visualizations with SAP Concur data in Power Map.
-
How to work with Xero Data in Apache Spark using SQL
Access and process Xero Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Google's Vertex AI Agent with Live GraphQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live GraphQL data within intelligent workflows.
-
Connecting Mastra with SAP Ariba Procurement 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 SAP Ariba Procurement data, no replication required.
-
Integrating LightSpeedRetail Data in Talend Cloud Data Management Platform
Connect LightSpeedRetail Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to connect to Vault CRM Data from Spring Boot
Connect to Vault CRM in a Spring Boot Application using the CData JDBC Driver for Vault CRM
-
Use ChatGPT to Talk to Your Klipfolio 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 Klipfolio data for you.
-
Visualize RabbitMQ 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 RabbitMQ data into TIBCO Spotfire.
-
How to connect to JotForm Data from Spring Boot
Connect to JotForm in a Spring Boot Application using the CData API Driver for JDBC
-
Write a Simple Go Application to work with Jodoo Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Jodoo data.
-
Connecting Moonlit Workflow with Shopify Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Shopify data in real time.
-
How to Connect the Power BI Service to Sage 300: Complete Guide
Connect to the CData Software Power BI Connector for Sage 300 from PowerBI.com to provide real-time Sage 300 data across the organization.
-
Connect ConstantContact Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ConstantContact data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Easily Query Reckon Data in OpenOffice Base
Connect to Reckon data in OpenOffice Base using the CData ODBC Driver for Reckon and generate reports with live data insights.
-
Getting Started with the CData Tableau Connector for SAP Hybris C4C
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP Hybris C4C.
-
Integrate Quickbase Data in Pentaho Data Integration
Build ETL pipelines based on Quickbase data in the Pentaho Data Integration tool.
-
How to Access Odoo Data Using Entity Framework
This article shows how to access Odoo data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Webflow Replication to SingleStore
Use CData Sync for automated, continuous, customizable Webflow replication to SingleStore.
-
How to Visualize Adobe Experience Manager 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 Experience Manager data in Python.
-
Using the CData Software ODBC Driver for Freshdesk in PyCharm
Connect to Freshdesk as an ODBC data source in PyCharm using the CData Software ODBC Driver for Freshdesk.
-
Automated Continuous Epicor Kinetic Replication to Snowflake
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Snowflake.
-
Integrate Live Twilio 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 Twilio data from within the IDE.
-
Replicate Multiple Office 365 Accounts via the CData Sync CLI
Replicate multiple Office 365 accounts to one or many databases.
-
A PostgreSQL Interface for Reply.io Data (MySQL Remoting via JDBC)
Use the Remoting features of the Reply.io JDBC Driver to create a PostgreSQL entry-point for data access.
-
Prepare, Blend, and Analyze HubDB Data in Alteryx Designer (ODBC)
Build workflows to access live HubDB data for self-service data analytics.
-
How to connect Amazon QuickSight to Paylocity Data
Create a connection to Paylocity data in CData Connect AI and insert Paylocity data into Amazon QuickSight SPICE to build interactive dashboards.
-
Getting Started with the CData JDBC Driver for Oracle Service Cloud
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Oracle Service Cloud.
-
How to Work with MessageBird Data in AWS Glue Jobs Using JDBC
Connect to MessageBird from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Query Oracle HCM Cloud Data in ColdFusion
Write standard ColdFusion data access code to connect to Oracle HCM Cloud data.
-
Connect to Google Ad Manager Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Ad Manager data from Appeon PowerBuilder using the CData ADO.NET Provider for Google Ad Manager.
-
Use the CData SSIS Components to Insert New or Update Existing Salesforce Pardot Records from SQL Server
Easily push SQL Server data to Salesforce Pardot using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Salesforce Pardot or update existing records with data from a SQL Server database.
-
Analyze Wistia Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Wistia data in Microsoft R Open.
-
How to use SQLAlchemy ORM to access Supabase Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Supabase data.
-
Automate Cosmos DB Data Replication to Azure Synapse
Use CData Sync to customize and automate Cosmos DB data replication to Azure Synapse.
-
Create Informatica Mappings From/To a JDBC Data Source for Sugar CRM
Create Sugar CRM data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect and Visualize Live LDAP Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live LDAP objects into the Databricks platform and create visualization dashboards with real-time LDAP objects.
-
A PostgreSQL Interface for Teamgate Data (MySQL Remoting via JDBC)
Use the Remoting features of the Teamgate JDBC Driver to create a PostgreSQL entry-point for data access.
-
Choosing the Best Method to Connect Instantly to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Instantly data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Work with Superchat Data in ETL Validator JDBC
Connect to Superchat from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Theia IDE with Live Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Instagram data from within the development environment.
-
Viewing Twilio Data in RAD Studio Data Explorer
How to view Twilio data in RAD Studio Data Explorer using the CData ODBC Driver for Twilio.
-
How to Access Live Zoho Creator Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Zoho Creator enables you to integrate Zoho Creator data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Presto Data in DBeaver
Use the CData ODBC Driver to connect to Presto data in DBeaver.
-
Getting Started with the CData ODBC Driver for Jumpseller
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Jumpseller.
-
Provide OData Services of Elorus Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Elorus data by developing a WCF Service Application.
-
How to Connect to & Open Teradata Data in Microsoft Excel
This article uses the CData ODBC driver for Teradata to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Goose with Live Bitbucket Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Bitbucket data from within the local AI agent.
-
Create Datasets from WooCommerce in Domo Workbench and Build Visualizations of WooCommerce Data in Domo
Use the CData Software ODBC Driver for WooCommerce to create datasets from WooCommerce data in Domo Workbench and then build visualizations in the Domo service.
-
How to Seamlessly Import Slack Data into IBM SPSS Modeler
Integrate Slack data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Process & Analyze JSON Services in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live JSON Services.
-
Create Informatica Mappings From/To a JDBC Data Source for Shippo
Create Shippo data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Choosing the Best Method to Connect Avaza to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Avaza data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Access Live MailerSend Data in Power Automate Desktop via ODBC
The CData ODBC Driver for MailerSend enables you to integrate MailerSend data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Acumatica Data in the Pentaho Report Designer
Publish reports based on Acumatica data in the Pentaho BI tool.
-
Automated Continuous SAP SuccessFactors Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to Amazon Redshift.
-
Integrate Dify with Live SAP Ariba Procurement 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 SAP Ariba Procurement data.
-
DataBind Charts to Strava Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Strava data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Access Freshdesk Data from MySQL in PHP
Connect to Freshdesk through the standard MySQL libraries in PHP.
-
Use the CData Software ODBC Driver for Greenplum in MicroStrategy Web
Connect to Greenplum data in MicroStrategy Web using the CData Software ODBC Driver for Greenplum.
-
Automate Adobe Target Data Replication to Azure Synapse
Use CData Sync to customize and automate Adobe Target data replication to Azure Synapse.
-
Add Twitter Ads Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Twitter Ads with the Informatica Enterprise Data Catalog to classify and organize data.
-
Import and Visualize Humanity Data in Power View
Create data visualizations based on Humanity data in Excel.
-
Connect to SAP ByDesign Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP ByDesign data.
-
Integrating Dataiku with SparkPost Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SparkPost data.
-
Visualize Live Google Analytics Data in the Power BI Service
Use CData Connect AI to connect to live Google Analytics data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to SendPulse Data in JRuby
Create a simple JRuby app with access to live SendPulse data.
-
Create CouchDB-Connected Nintex Workflows
Use CData Connect AI to connect to CouchDB Data from Nintex Workflow Cloud and build custom workflows using live CouchDB data.
-
How to connect to Redshift Data in DBVisualizer
Integrate Redshift data with visual data analysis tools and data connection wizards in DBVisualizer
-
Migrating data from SingleStore to Google BigQuery using CData SSIS Components.
Easily push SingleStore data to Google BigQuery using the CData SSIS Tasks for SingleStore and Google BigQuery.
-
How to Visualize eBay Data in Python with pandas
Use pandas and other modules to analyze and visualize live eBay data in Python.
-
Visualize Live Google Translate Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Translate data.
-
Integrate with ZohoSubscriptions Data in JReport Designer
Create charts and reports based on ZohoSubscriptions data in JReport Designer.
-
Build SpaceX-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SpaceX data.
-
Use CData Connect AI to Access Power BI XMLA Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Power BI XMLA data in the Power Pivot business intelligence tool.
-
Design BIRT Reports on SAP Hybris C4C Data
Provide current SAP Hybris C4C data to your embedded analytics.
-
Consume Klaviyo OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Klaviyo feeds that reflect any changes in SAP Lumira.
-
Automated SQL Server Data Replication to Teradata
Use CData Sync to Customize and automate SQL Server data replication to Teradata.
-
Connecting Pipedream with HDFS 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 HDFS data in real time.
-
How to Work with WooCommerce Data in AWS Glue Jobs Using JDBC
Connect to WooCommerce from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to connect to Cvent Data with Squirrel SQL client
Connect to Cvent data and execute queries in the Squirrel SQL Client.
-
Import Shopify Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Shopify Data and provide access to live Shopify data for custom reports in the Power BI Service.
-
Build a Singer.io Tap for Gumroad With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Gumroad data using the CData Python Connector.
-
Build Data Flows from SQL Server to Paylocity through SSIS
Easily push SQL Server data to Paylocity using the CData SSIS Tasks for Paylocity.
-
Connect Customer.io Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Customer.io data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.