CData Software - Knowledge Base
Recent Articles
-
Add Zoho Inventory to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Zoho Inventory with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Live Oracle Financials Cloud in PostGresSQL Interface through CData Connect AI
Create a live connection to Oracle Financials Cloud in CData Connect AI and connect to your Oracle Financials Cloud from PostgreSQL.
-
Easily Integrate Salesloft in Lazarus Pascal IDE
Learn how to easily integrate live Salesloft in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Access Live Avro in Visual Studio Code via Cline
Run the CData MCP Server for Avro on Windows Subsytem for Linux (WSL) and connect to live Apache Avro from the Cline extension in Visual Studio Code.
-
Connect to SAP Ariba Source from Crystal Reports
Use CData Connect AI to connect to and report on live SAP Ariba Source from Crystal Reports.
-
Connect to Zendesk from a Connection Pool in Jetty
The Zendesk JDBC Driver supports connection pooling: This article shows how to connect faster to Zendesk from Web apps in Jetty.
-
Analyze Phoenix with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Phoenix from Power Pivot. You will use the Table Import Wizard to load Apache Phoenix. You can visually build the import query or use any SQL supported by the driver.
-
DataBind Controls to LinkedIn in Delphi
DataBind to LinkedIn in Delphi with standard data access components and controls.
-
Operational Reporting on Quickbase from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Quickbase.
-
Query Confluence in ColdFusion
Write standard ColdFusion data access code to connect to Atlassian Confluence.
-
Access Email from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Email from HeidiSQL.
-
Connect to Instagram in Aqua Data Studio
Access Instagram from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Using the CData Software ODBC Driver for Oracle in PyCharm
Connect to Oracle as an ODBC data source in PyCharm using the CData Software ODBC Driver for Oracle.
-
Connect to Jira from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Atlassian Jira using standard SQL.
-
Connect to Teradata from a Connection Pool in WebLogic
Use the CData JDBC Driver for Teradata to connect to Teradata from Web applications running on WebLogic.
-
DataBind BigQuery to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for BigQuery with the DevExpress Windows Forms and Web controls to provide Google BigQuery to a chart.
-
Build SAP ByDesign-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP ByDesign and create custom apps in Mendix.
-
Access Live Shopify Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Shopify data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Explore Geographical Relationships in Avalara AvaTax with Power Map
Create data visualizations with Avalara AvaTax in Power Map.
-
Integrate Elasticsearch with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Elasticsearch with External Services.
-
Import Real-Time Salesforce Marketing via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Salesforce Marketing Cloud in ColdFusion.
-
Automated Continuous Zuora Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Zuora replication to Amazon Redshift.
-
Visualize Workday in TIBCO Spotfire through ADO.NET
Integrate Workday into dashboards in TIBCO Spotfire.
-
Build Semantic Layer Views for Asana in APOS Live Data Gateway
Use the CData Connector for Asana in APOS Live Data Gateway to build Semantic Layer Views for Asana.
-
Connect to Google Contacts in JRuby
Create a simple JRuby app with access to live Google Contacts.
-
Build Databricks Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Databricks and build visualizations in Tableau Cloud.
-
Build Semantic Layer Views for Blackbaud FE NXT in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Blackbaud FE NXT.
-
Connect to Salesforce Pardot in RapidMiner
Integrate Salesforce Pardot with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData Excel Add-In for Sage 200
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Sage 200.
-
How to connect Amazon QuickSight to Sage 200
Create a connection to Sage 200 in CData Connect AI and insert Sage 200 into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to MailChimp from HeidiSQL
Use CData Connect AI to connect to and query live MailChimp from HeidiSQL.
-
Operational Reporting on Impala from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Apache Impala.
-
Google Directory Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Directory through CData Connect AI using different applications and tools.
-
Build Visualizations of Microsoft Project in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft Project in Birst.
-
How to Use a Microsoft Access Database to Update Sage Intacct in Real Time
Update Sage Intacct data by creating a linked table in Microsoft Access with the CData Sage Intacct ODBC Driver.
-
Import MySQL into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access MySQL. In this article, you will use the OData format to import MySQL into Microsoft Power Query.
-
Establish a Live Connection with BigCommerce using Tableau Bridge
The CData ODBC Driver for BigCommerce enables you to integrate live BigCommerce into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect to Live Redis 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 Redis for you.
-
How to Query Live Zoho Projects in Claude Desktop
Connect to and query live Zoho Projects in Claude Desktop using the CData MCP Server.
-
Build Unbounce-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Unbounce and build web apps with connectivity to live Unbounce.
-
Automated Continuous Sugar CRM Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Sugar CRM replication to Microsoft Access.
-
Working with SingleStore in LINQPad
Execute LINQ queries to SingleStore in LINQPad.
-
Explore Geographical Relationships in DocuSign with Power Map
Create data visualizations with DocuSign in Power Map.
-
Connect to JDBC-ODBC Bridge in CloverDX (formerly CloverETL)
Transfer JDBC-ODBC Bridge using the visual workflow in the CloverDX data integration tool.
-
Connect to Google Contacts in RapidMiner
Integrate Google Contacts with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Datasets from Neo4J in Domo Workbench and Build Visualizations of Neo4J in Domo
Use the CData Software ODBC Driver for Neo4J to create datasets from Neo4J in Domo Workbench and then build visualizations in the Domo service.
-
Viewing Sybase in RAD Studio Data Explorer
How to view Sybase in RAD Studio Data Explorer using the CData ODBC Driver for Sybase.
-
Connect to Instagram from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Instagram using standard SQL.
-
How to create XML federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for XML Files in MySQL .
-
Automated Continuous QuickBooks Time Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to OneLake in Microsoft Fabric.
-
Integrating LangGraph with Twitter Ads via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Twitter Ads within automated workflows.
-
How to Create Power BI Visual Reports with Real-Time Sybase IQ
Use CData Power BI Connectors to visualize Sybase IQ in Power BI.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP Ariba Procurement
Create an ODBC connection to SAP Ariba Procurement in Informatica and browse and transfer SAP Ariba Procurement.
-
Automated Continuous SuiteCRM Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Microsoft Access.
-
Publish Reports with Oracle Sales in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Sales.
-
Connect to SAP Ariba Procurement from AWS Glue
Use CData Connect AI to gain access to live SAP Ariba Procurement from your AWS Glue jobs.
-
Prepare, Blend, and Analyze Reckon in Alteryx Designer (Connect AI)
Build workflows to access live Reckon for self-service data analytics.
-
Easily Integrate BambooHR in Lazarus Pascal IDE
Learn how to easily integrate live BambooHR in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live SFTP in Coginiti Pro
Connect to and query live SFTP from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Create Power BI Visual Reports with Real-Time Shippo
Use CData Power BI Connectors to visualize Shippo in Power BI.
-
Create Reports with Oracle in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Database.
-
Add Jira Assets to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Jira Assets with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live Sage Intacct in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Sage Intacct from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to import Google Search Results into Apache Solr
Use the CData Software JDBC Driver for Google Search in Data Import Handler and create an automated import of Google Search to Apache Solr Enterprise Search platform.
-
Creating Azure Data Lake Storage-Connected Applications in Unqork
You can use CData Connect AI to feed Azure Data Lake Storage to Unqork and build custom business apps.
-
How to import Adobe Commerce into Apache Solr
Use the CData Software JDBC Driver for Adobe Commerce in Data Import Handler and create an automated import of Adobe Commerce to Apache Solr Enterprise Search platform.
-
Build Dashboards with SharePoint in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft SharePoint in DBxtra.
-
Connect to Sage Intacct in Jaspersoft Studio
Execute SQL to remote Sage Intacct in Jaspersoft Studio.
-
Automated Continuous Tableau CRM Analytics Replication to Databricks
Use CData Sync for automated, continuous, customizable Tableau CRM Analytics replication to Databricks.
-
Use Biml to Build SSIS Tasks to Replicate Cvent to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Cvent to SQL Server.
-
How to Visualize CouchDB Data in Python with pandas
Use pandas and other modules to analyze and visualize live Apache CouchDB in Python.
-
Design BIRT Reports on IBM Informix
Provide current IBM Informix to your embedded analytics.
-
How to Visualize SuiteCRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live SuiteCRM in Python.
-
Enable the Oracle JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Oracle Database.
-
Query Epicor Kinetic in DataGrip
Create a Data Source for Epicor Kinetic in DataGrip and use SQL to query live Epicor Kinetic.
-
Create SAP HANA XS Advanced Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP HANA XS Advanced data access from reports, embedded analytics, and more.
-
Build AI Agents with Instagram Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
How to pipe FTP to CSV in PowerShell
Use standard PowerShell cmdlets to access FTP tables.
-
Build Agents in Relevance AI with Access to Live Amazon DynamoDB via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Amazon DynamoDB within intelligent agent workflows.
-
Connecting Mastra with SAP SuccessFactors 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 data across 300+ enterprise sources no replication required.
-
Establish a Live Connection with Sage Cloud Accounting using Tableau Bridge
The CData ODBC Driver for Sage Cloud Accounting enables you to integrate live Sage Business Cloud Accounting into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect to Live Couchbase 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 Couchbase for you.
-
How to connect SharePoint with eBay Analytics through external lists
Provide eBay Analytics to SharePoint users as an external list.
-
How to Connect to Live Microsoft Planner from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Microsoft Planner through natural language.
-
Easily Integrate SuiteCRM in Lazarus Pascal IDE
Learn how to easily integrate live SuiteCRM in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live Salesforce Marketing in TIBCO Data Virtualization
-