CData Software - Knowledge Base
Recent Articles
-
Validate Salesloft Data with QuerySurge
Access and validate Salesloft data in QuerySurge using the CData JDBC Driver.
-
Integrating LlamaIndex with IBM Informix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on IBM Informix data in real time.
-
Connect to Google Ads in SpagoBI
Create reports featuring live Google Ads data in SpagoBI Studio. Host Google Ads reports on SpagoBI Server.
-
Zendesk Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Zendesk data through CData Connect AI using different applications and tools.
-
Integrate with ZohoDesk Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ZohoDesk data to a JSON file on disk.
-
Connect to Active Directory Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Active Directory Data and connect to Active Directory data in Akorbi Digital RunMyProcess.
-
How to Connect to Live Grafana 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 Grafana data for you.
-
Automated Continuous Gumroad Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Gumroad replication to PostgreSQL.
-
A PostgreSQL Interface for Jira Data using the CData ODBC Driver
Use the SQL Gateway and Jira ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous FormSite Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable FormSite replication to Azure SQL Database.
-
Use JayDeBeApi to access Campaigner Data in Python
Use standard Python scripting and the development environment of your choice to access live Campaigner data.
-
Seamlessly Bring Apollo Data into Retool Using CData Connect AI
Integrate Apollo data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Getting Started with the CData ODBC Driver for Parallel
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Parallel.
-
Edit and Search External Impala Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Impala data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Impala Data objects that you can access from apps and the dashboard.
-
Integrate Dify with Live SAP Ariba Source 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 Source data.
-
Use Azure AI Foundry to Talk to Your NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics data for you.
-
Build Dashboards with Accelo Data in DBxtra
Create dynamic dashboards and perform analytics based on Accelo data in DBxtra.
-
Enable the SendInBlue JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SendInBlue data.
-
Gumroad Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Gumroad facts in real time.
-
Connect to Act CRM Data in RapidMiner
Integrate Act CRM data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automate Oracle HCM Cloud Data Replication to Azure Synapse
Use CData Sync to customize and automate Oracle HCM Cloud data replication to Azure Synapse.
-
Extract, Transform, and Load Active Directory Data in Informatica PowerCenter
Create a simple Workflow for Active Directory data in Informatica PowerCenter.
-
Automated Continuous Pipedrive Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Pipedrive replication to PostgreSQL.
-
Create Dashboards and Visualize Live Oracle Sales Data in Geckoboard
Use CData Connect AI to connect to live Oracle Sales data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate Live SAP HANA XS Advanced Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP HANA XS Advanced data to Blue Prism using the CData ODBC Driver for SAP HANA XS Advanced to create automated workflows for repetitive business tasks.
-
How to Work with ClickUp Data in ETL Validator JDBC
Connect to ClickUp from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect SharePoint with Dynamics 365 Business Central Data through external lists
Provide Dynamics 365 Business Central data to SharePoint users as an external list.
-
Integrate Real-Time Access to SAP Hybris C4C in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP Hybris C4C data in real time.
-
Query OData Services through ODBC in Node.js
Use node-odbc to execute SQL queries against OData services from Node.js.
-
How to publish and share Act CRM Data dashboards with Tableau Server
The CData ODBC driver for Act CRM enables you integrate Act CRM data into Tableau dashboards.
-
Create Redshift Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Redshift data access from reports, embedded analytics, and more.
-
Visualize Live Epicor Kinetic Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Epicor Kinetic data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect Oracle Eloqua to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Oracle Eloqua data using the CData Python MCP Server.
-
How to Create Power BI Visual Reports with Real-Time Guru Data
Use CData Power BI Connectors to visualize Guru data in Power BI.
-
Access Live Oracle Financials Cloud Data in Excel 365 Online (Excel for the web)
Connect to Oracle Financials Cloud data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to CSV Data in Ruby
Connect to CSV data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Databricks: Option to Disable SELECT version() Execution
Learn how to disable the execution of SELECT version() in Databricks to improve performance and avoid unnecessary queries.
-
How to use SQLAlchemy ORM to access Typeform Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Typeform data.
-
Write a Simple Go Application to work with Yelp Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Yelp data.
-
Integrate Pinecone with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Pinecone with External Services.
-
Build Square Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Square data and build visualizations in Tableau Cloud.
-
Access Basecamp Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Basecamp data.
-
Build Data Flows from ADP to SQL Server using SSIS
Easily back up ADP data to SQL Server using the SSIS components for ADP.
-
Connect to LinkedIn Data from PowerBuilder via ADO.NET
This article demonstrates how to access LinkedIn data from Appeon PowerBuilder using the CData ADO.NET Provider for LinkedIn.
-
Build Data Flows from SQL Server to Certinia through SSIS
Easily push SQL Server data to Certinia using the CData SSIS Tasks for Certinia.
-
ETL Egnyte in Oracle Data Integrator
This article shows how to transfer Egnyte data into a data warehouse using Oracle Data Integrator.
-
View Reports on Real-Time Hacker News Data in Power BI Report Server
Use the CData ODBC Driver for Hacker News to visualize Hacker News data in Power BI Desktop and then publish them to Power BI Report Server.
-
Query ZohoInvoice Data in DataGrip
Create a Data Source for ZohoInvoice in DataGrip and use SQL to query live ZohoInvoice data.
-
Import SAS Data Sets Data Using Azure Data Factory
Use CData Connect AI to connect to SAS Data Sets Data from Azure Data Factory and import live SAS Data Sets data.
-
Access Live Facebook Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Facebook data from your Excel spreadsheets.
-
Build Semantic Layer Views for MongoDB Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for MongoDB data.
-
How to integrate Metabase with BigCommerce Data
Use CData Connect AI to connect to live BigCommerce data and create an interactive dashboard in Metabase from BigCommerce data.
-
Connect to Oracle HCM Cloud Data from HeidiSQL
Use CData Connect AI to connect to and query live Oracle HCM Cloud data from HeidiSQL.
-
Use the CData Software JDBC Driver for Postmark in MicroStrategy
Connect to Postmark data in MicroStrategy Developer using the CData Software JDBC Driver for Postmark.
-
Build Agents in Relevance AI with Access to Live Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Databricks data within intelligent agent workflows.
-
Use Databricks Agent Bricks to Talk to Your NetSuite SuiteAnalytics Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your NetSuite SuiteAnalytics data for you.
-
Build Visualizations of Aircall Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Aircall data in Birst.
-
Connect to Calendly Data in NetBeans
Connect to Calendly data in NetBeans with the data source configuration wizard.
-
Connect to SendInBlue Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SendInBlue data using standard SQL.
-
Automated Continuous Google Campaign Manager 360 Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Apache Kafka.
-
Import Adobe Commerce Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Adobe Commerce Data and provide access to live Adobe Commerce data for custom reports in the Power BI Service.
-
How to use SQLAlchemy ORM to access Retently Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Retently data.
-
Getting Started with the CData Python Connector for Missive
Learn to install and license the CData Python Connector and configure a connection to live Missive data.
-
Back Up Codat 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 Codat data data.
-
Create Datasets from Teamgate in Domo Workbench and Build Visualizations of Teamgate Data in Domo
Use the CData Software ODBC Driver for Teamgate to create datasets from Teamgate data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to PostgreSQL from Asprova with CData Software ODBC Driver for PostgreSQL
This article shows how to connect faster to PostgreSQL data from Asprova.
-
Connect to Adobe Target Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Adobe Target as an External Source in Dremio.
-
Automated Continuous LDAP Replication to Amazon S3
Use CData Sync for automated, continuous, customizable LDAP replication to Amazon S3.
-
Automated Continuous Instantly Replication to MongoDB
Use CData Sync for automated, continuous, customizable Instantly replication to MongoDB.
-
Configure the CData JDBC Driver for Samanage in a Connection Pool in Tomcat
Connect to Samanage data from a connection pool in Tomcat.
-
Add MailerSend Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for MailerSend with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Timely Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Timely replication to Amazon Redshift.
-
Integrate Open WebUI with Live WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live WooCommerce data from within the chat interface.
-
Integrate Devin with Live Cloudant Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Cloudant data.
-
Automated Continuous EmailOctopus Replication to MongoDB
Use CData Sync for automated, continuous, customizable EmailOctopus replication to MongoDB.
-
Connect to Opsgenie Data in Aqua Data Studio
Access Opsgenie data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate OpenCode with Live SAP Hybris C4C Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live SAP Hybris C4C data from within your AI coding agent.
-
Connect to Teamwork Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Teamwork and work with Teamwork data in your FileMaker applications.
-
How to integrate Instagram with Apache Airflow
Access and process Instagram data in Apache Airflow using the CData JDBC Driver.
-
Integrate Goose with Live FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live FTP data from within the local AI agent.
-
Build a PostgreSQL Interface for Placid Data using the CData JDBC Driver
Use the Remoting features of the Placid JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Apps with Live Dotmailer Data Using the Low-Code Development Platform of Mendix
Connect Dotmailer data with Mendix to build apps using the CData API Driver for JDBC.
-
Automate Amazon DynamoDB Data Replication to Azure Synapse
Use CData Sync to customize and automate Amazon DynamoDB data replication to Azure Synapse.
-
Back Up Bullhorn CRM data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Bullhorn CRM. In this article, we will employ an SSIS workflow to populate a database with Bullhorn CRM data data.
-
Automated Continuous Google Directory Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Directory replication to Apache Cassandra.
-
Getting Started with the CData Tableau Connector for Wave Financial
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Wave Financial.
-
Visualize Stripe Data in TIBCO Spotfire through OData
Integrate Stripe data into dashboards in TIBCO Spotfire.
-
Rapidly Develop SAP Fieldglass-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by SAP Fieldglass.
-
Access AgileCRM Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for AgileCRM data.
-
Getting Started with the CData Power BI Connector for PayPal
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for PayPal.
-
Connect to Salesforce CRM Analytics Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Salesforce CRM Analytics as an External Source in Dremio.
-
Connect Zoho Books to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Zoho Books data using the CData Python MCP Server.
-
Build Attio-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Attio Data from Zoho Analytics and import live Attio data.
-
How to Connect to Live Mailjet Data 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 Mailjet data through natural language.
-
Build Kintone-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Kintone data without replication.
-
Connect to Adobe Experience Manager in SpagoBI
Create reports featuring live Adobe Experience Manager data in SpagoBI Studio. Host Adobe Experience Manager reports on SpagoBI Server.
-
Integrate Open WebUI with Live Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft Dataverse data from within the chat interface.
-
Connect to Amazon Marketplace Data in Jaspersoft Studio
Execute SQL to remote Amazon Marketplace data in Jaspersoft Studio.
-
Create Informatica Mappings From/To a JDBC Data Source for Mailjet
Create Mailjet data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Agents in Relevance AI with Access to Live Cloudflare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Cloudflare data within intelligent agent workflows.