CData Software - Knowledge Base
Recent Articles
-
Visualize Act CRM Data in TIBCO Spotfire through ADO.NET
Integrate Act CRM data into dashboards in TIBCO Spotfire.
-
Analyze SFTP Data in Cognos Analytics
Use CData Connect AI to connect to SFTP Data from Cognos Analytics and analyze live SFTP data.
-
How to Query Live Humanity Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Humanity data data in natural language using Python.
-
Use Dash to Build Web Apps on NetSuite SuiteAnalytics Data via CData Connect AI
Build interactive Dash web apps on live NetSuite SuiteAnalytics data using pandas and the CData Connect AI Python SDK.
-
Use Dash to Build to Web Apps on Zoho CRM Data
Create Python applications that use pandas and Dash to build Zoho CRM-connected web apps.
-
How to import FreeAgent Data into Apache Solr
Use the CData Software JDBC Driver for FreeAgent in Data Import Handler and create an automated import of FreeAgent data to Apache Solr Enterprise Search platform.
-
Access Stripe Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Stripe data from HeidiSQL.
-
Access Live EmailOctopus Data in Coginiti Pro
Connect to and query live EmailOctopus data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Live Apollo 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 Apollo data from within the IDE.
-
How to Seamlessly Import Timely Data into IBM SPSS Modeler
Integrate Timely data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Redis Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Redis data from your Google Sheets.
-
Access Teamgate Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Teamgate data from your Oracle system.
-
Integrate with live SAP HANA XS Advanced Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAP HANA XS Advanced data in Jitterbit.
-
Visualize Templated 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 Templated data into TIBCO Spotfire.
-
Use the CData Software ODBC Driver for Exact Online in MicroStrategy
Connect to Exact Online data in MicroStrategy Developer using the CData Software ODBC Driver for Exact Online.
-
Build Semantic Layer Views for LDAP Objects in APOS Live Data Gateway
Use the CData Connector for LDAP in APOS Live Data Gateway to build Semantic Layer Views for LDAP objects.
-
Manage Parquet Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Parquet.
-
How to Connect to Live ConstantContact 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 ConstantContact data for you.
-
How to Connect to Live Pipedrive Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Pipedrive data without replication.
-
How to create Visio diagrams from SAS Data Sets Data
Automatically update SAS Data Sets data with the changes you make to Visio master shapes.
-
Query Twilio Data in ColdFusion
Write standard ColdFusion data access code to connect to Twilio data.
-
Use JayDeBeApi to access iContact Data in Python
Use standard Python scripting and the development environment of your choice to access live iContact data.
-
Access Live Planio Data in Coginiti Pro
Connect to and query live Planio data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect to Live Dynamics CRM Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Dynamics CRM data for you.
-
Integrating Kiro with Wave Financial Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Build Semantic Layer Views for Spark Data in APOS Live Data Gateway
Use the CData Connector for Spark in APOS Live Data Gateway to build Semantic Layer Views for Spark data.
-
Enable the Teamgate JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Teamgate data.
-
Testmonitor Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Testmonitor facts in real time.
-
Visualize PabblySubscriptions Data in TIBCO Spotfire through ADO.NET
Integrate PabblySubscriptions data into dashboards in TIBCO Spotfire.
-
Build Shopify-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Shopify data and build web apps with connectivity to live Shopify data.
-
Integrating EnterpriseDB Data in Talend Cloud Data Management Platform
Connect EnterpriseDB Data with Talend Cloud Data Management Platform using the CData JDBC Driver for EnterpriseDB.
-
Integrating LangGraph with Klaviyo Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Klaviyo data within automated workflows.
-
Connecting Agentforce with Google Search Results 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 Search results for you.
-
Analyze SFTP Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SFTP from Power Pivot. You will use the Table Import Wizard to load SFTP data. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData Software JDBC Driver for Redshift in MicroStrategy
Connect to Redshift data in MicroStrategy Developer using the CData Software JDBC Driver for Redshift.
-
Use CData Connect AI to Access Zoho Inventory Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Zoho Inventory data in the Power Pivot business intelligence tool.
-
Integrate Pinterest with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Pinterest with External Services.
-
Use Azure AI Foundry to Talk to Your Bitly 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 Bitly data for you.
-
Create Dashboards and Visualize Live Shippo Data in Geckoboard
Use CData Connect AI to connect to live Shippo data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build ZohoExpense-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to ZohoExpense Data from Zoho Analytics and import live ZohoExpense data.
-
Access Oracle Eloqua Reporting Data from MySQL in PHP
Connect to Oracle Eloqua Reporting through the standard MySQL libraries in PHP.
-
Use the CData Software ODBC Driver for Sage Intacct in SAS for Real-Time Reporting and Analytics
Connect to real-time Sage Intacct data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Sage Intacct.
-
Working with EmailOctopus Data in LINQPad
Execute LINQ queries to EmailOctopus data in LINQPad.
-
Build Pipelines with Live Mode Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Mode from Google Cloud Data Fusion, enabling the integration of live Mode data into the building and management of effective data pipelines.
-
Model SparkPost Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SparkPost, enabling the direct import of real-time SparkPost data.
-
Connect to Salesforce Data 360 Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Salesforce Data 360 data from Filemaker Pro on Mac.
-
How to Build an ETL App for ZohoInvoice Data in Python with CData Connect AI
Extract and transform live ZohoInvoice data in Python with petl and the CData Connect AI Python SDK.
-
Getting Started with the CData Power BI Connector for Unbounce
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Easily Integrate SAP HANA XS Advanced Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP HANA XS Advanced data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect and Visualize Live SuiteCRM Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SuiteCRM data into the Databricks platform and create visualization dashboards with real-time SuiteCRM data.
-
Connect SAP Concur Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP Concur data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Google Spanner Data from PowerBuilder via JDBC
This article demonstrates how to access Google Spanner data from PowerBuilder using the Google Spanner JDBC Driver.
-
Query MySQL Data in ColdFusion
Write standard ColdFusion data access code to connect to MySQL data.
-
Connect to Landbot Data in JRuby
Create a simple JRuby app with access to live Landbot data.
-
Migrating data from MailerSend to Snowflake using CData SSIS Components.
Easily push MailerSend data to Snowflake using the CData SSIS Tasks for MailerSend and Snowflake.
-
Analyze HDFS Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze HDFS data with the CData JDBC Driver for HDFS.
-
Query Rebilly Data in DataGrip
Create a Data Source for Rebilly in DataGrip and use SQL to query live Rebilly data.
-
Query Zoho Projects Data as a SQL Server Database in Node.js
Execute SQL Server queries against Zoho Projects data from Node.js.
-
Import Salesforce Data Using Azure Data Factory
Use CData Connect AI to connect to Salesforce Data from Azure Data Factory and import live Salesforce data.
-
How to use SQLAlchemy ORM to access SageHR Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SageHR data.
-
Connect MySQL to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect MySQL with IBM WebSphere for seamless data integration and connectivity.
-
How to connect PolyBase to Cosmos DB
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Cosmos DB data.
-
Analyze Salesforce Marketing Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Salesforce Marketing data and visualize Salesforce Marketing data in SAP Analytics Cloud.
-
Connect to Active Directory Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Active Directory as an External Source in Dremio.
-
Prepare, Blend, and Analyze iContact Data in Alteryx Designer (Connect AI)
Build workflows to access live iContact data for self-service data analytics.
-
Automated Continuous HCL Domino Replication to MySQL
Use CData Sync for automated, continuous, customizable HCL Domino replication to MySQL.
-
Connect to ServiceDesk Plus Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live ServiceDesk Plus data.
-
Integrating Antigravity CLI with Sentry data via CData CLI
Connect Sentry data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate with Cassandra Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Cassandra data to a JSON file on disk.
-
Build Data Flows from Klaviyo to SQL Server using SSIS
Easily back up Klaviyo data to SQL Server using the SSIS components for Klaviyo.
-
Connect to Omnisend Data from a Connection Pool in Jetty
The Omnisend JDBC Driver supports connection pooling: This article shows how to connect faster to Omnisend data from Web apps in Jetty.
-
Access AdRoll Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live AdRoll data from HeidiSQL.
-
Connecting Mastra with ActiveCampaign 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 ActiveCampaign data, no replication required.
-
How to Connect to Live Zoho Inventory Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Zoho Inventory data for you.
-
Connect to PolarTeamPro from Asprova with CData Software ODBC Driver for PolarTeamPro
This article shows how to connect faster to PolarTeamPro data from Asprova.
-
Excel Spreadsheet Automation on Retently Data with the QUERY Formula
Pull data from Retently, automate spreadsheets, and more with the QUERY formula.
-
How to Seamlessly Import Hive Data into IBM SPSS Modeler
Integrate Hive data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Bridge Guru Connectivity with Apache NiFi
Access and process Guru data in Apache NiFi using the CData JDBC Driver.
-
Use Grok to Talk to Your Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Workday data for you.
-
Amazon Athena Reporting in OBIEE with the Amazon Athena JDBC Driver
Deploy the Amazon Athena JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connecting GenSpark with Oracle Sales Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Oracle Sales data without any replication or custom integration required.
-
Automate Jira Data Replication to SAP HANA
Use CData Sync to customize and automate Jira data replication to SAP HANA.
-
How to Connect to Live Salesloft Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Salesloft data for you.
-
Connect to ServiceDesk Plus Data in Ruby
Connect to ServiceDesk Plus data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Reports from eBay Data in Looker Studio
Use CData Connect AI to gain access to live eBay data and create custom reports in Looker Studio.
-
Build MVC Applications with Connectivity to Opsgenie Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Opsgenie from an ASP.NET MVC application.
-
Connect to Google Calendar Data in Aqua Data Studio
Access Google Calendar data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate MongoDB with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate MongoDB with External Services.
-
Connect to Mailjet Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Mailjet Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Live Elasticsearch Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Elasticsearch data to Blue Prism using the CData ODBC Driver for Elasticsearch to create automated workflows for repetitive business tasks.
-
Integrating GitHub Copilot with HBase data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Access Live XML Data in TIBCO Data Virtualization
Use the XML Tibco DV Adapter to create a XML data data source in TIBCO Data Virtualization Studio and gain access to live XML data from your TDV Server.
-
A PostgreSQL Interface for Yelp Data (MySQL Remoting via JDBC)
Use the Remoting features of the Yelp JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData SSIS Components for TaxJar
Complete guide to installing, licensing, and connecting with the CData SSIS Components for TaxJar.
-
Connecting GenSpark with Cosmos DB Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Cosmos DB data without any replication or custom integration required.
-
Use Databricks Agent Bricks to Talk to Your SFTP Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SFTP data for you.
-
Integrate Google's Antigravity Agent with Live Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Neo4J data using the Model Context Protocol.
-
How to create HDFS federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for HDFS data in MySQL .
-
Getting Started with the CData Python Connector for GetResponse
Learn to install and license the CData Python Connector and configure a connection to live GetResponse data.
-
How to connect Amazon QuickSight to Sage 200 Data
Create a connection to Sage 200 data in CData Connect AI and insert Sage 200 data into Amazon QuickSight SPICE to build interactive dashboards.