CData Software - Knowledge Base
Recent Articles
-
How to connect to ClickTime Data from Spring Boot
Connect to ClickTime in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate Cloudant Data in Pentaho Data Integration
Build ETL pipelines based on Cloudant data in the Pentaho Data Integration tool.
-
ETL SharePoint Excel Services in Oracle Data Integrator
This article shows how to transfer SharePoint Excel Services data into a data warehouse using Oracle Data Integrator.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Cosmos DB
Provide connectivity to Cosmos DB data through an SAP BusinessObjects universe.
-
Connect to SAP Ariba Procurement Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live SAP Ariba Procurement data.
-
Query Shopify Data in ColdFusion
Write standard ColdFusion data access code to connect to Shopify data.
-
How to load Mode data into Elasticsearch via Logstash
Introducing a simple method to load Mode data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous PostgreSQL Replication to Databricks
Use CData Sync for automated, continuous, customizable PostgreSQL replication to Databricks.
-
Connect to Azure Synapse Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Azure Synapse data in the Denodo Virtual DataPort Administrator.
-
Connect to Adobe Target Data in DBeaver
Use the CData ODBC Driver to connect to Adobe Target data in DBeaver.
-
Build a PostgreSQL Interface for Twilio Data using the CData JDBC Driver
Use the Remoting features of the Twilio JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use ChatGPT to Talk to Your MongoDB 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 MongoDB data for you.
-
Import Testmonitor Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Testmonitor Data and provide access to live Testmonitor data for custom reports in the Power BI Service.
-
How to Work with Highrise Data in AWS Glue Jobs Using JDBC
Connect to Highrise from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Manus AI to Talk to Your Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Procore data.
-
Connect to Telegram Data in Jaspersoft Studio
Execute SQL to remote Telegram data in Jaspersoft Studio.
-
Replicate Multiple Airtable Accounts
Replicate multiple Airtable accounts to one or many databases.
-
Integrate Real-Time Access to SQL Server in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SQL Server data in real time.
-
Build BigCommerce-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for BigCommerce Data and create custom apps in Bubble.
-
Visualize Deel Data in TIBCO Spotfire through ADO.NET
Integrate Deel data into dashboards in TIBCO Spotfire.
-
Access Live ServiceNow Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ServiceNow data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to connect PolyBase to Demio
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Demio data.
-
Create Informatica Mappings From/To an ODBC Data Source for Bitbucket
Create an ODBC connection to Bitbucket in Informatica and browse and transfer Bitbucket data.
-
Choosing the Best Method to Connect MessageBird to SQL Server: 5 Options Explained
Discover multiple ways to connect and use MessageBird data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Databricks Data in ACL Analytics
Connect to Databricks data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Databricks data.
-
Build API-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live API data.
-
Integrate with Amazon Athena Data in JReport Designer
Create charts and reports based on Amazon Athena data in JReport Designer.
-
How to Build an ETL App for Gorgias Data in Python with CData
Create ETL applications and real-time data pipelines for Gorgias data in Python with petl.
-
How to integrate Bugsnag with Apache Airflow
Access and process Bugsnag data in Apache Airflow using the CData JDBC Driver.
-
Connect to Zoho Projects Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Zoho Projects data in Airbyte.
-
Connect to MYOB AccountRight Data in RapidMiner
Integrate MYOB AccountRight data with standard components and data source configuration wizards in RapidMiner Studio.
-
Analyze GitLab Data in Looker
Use CData Connect AI to connect to GitLab Data from Looker and build custom apps using live GitLab data.
-
Use Dash to Build to Web Apps on Bannerbear Data
Create Python applications that use pandas and Dash to build Bannerbear-connected web apps.
-
Connect to BambooHR Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to BambooHR and work with BambooHR data in your FileMaker application.
-
How to Visualize HBase Data in Python with pandas
Use pandas and other modules to analyze and visualize live HBase data in Python.
-
How to integrate Microsoft Teams with Apache Airflow
Access and process Microsoft Teams data in Apache Airflow using the CData JDBC Driver.
-
Automate Bullhorn CRM Data Replication to Azure Synapse
Use CData Sync to customize and automate Bullhorn CRM data replication to Azure Synapse.
-
How to Create Power BI Visual Reports with Real-Time Cosmos DB Data
Use CData Power BI Connectors to visualize Cosmos DB data in Power BI.
-
Access LDAP Objects from MySQL in PHP
Connect to LDAP through the standard MySQL libraries in PHP.
-
Connect to Jodoo Data from a Connection Pool in JBoss
Integrate Jodoo data into Java servlets: Use the Management Console in JBoss to install the Jodoo JDBC Driver.
-
Create Zoho CRM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Zoho CRM from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Create Power BI Visual Reports with Real-Time eBay Analytics Data
Use CData Power BI Connectors to visualize eBay Analytics data in Power BI.
-
Use Biml to Build SSIS Tasks to Replicate Salesforce Marketing Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Salesforce Marketing data to SQL Server.
-
DataBind Controls to Salesforce Data in Delphi
DataBind to Salesforce data in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for Redis in SAS for Real-Time Reporting and Analytics
Connect to real-time Redis data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Redis.
-
SSIS Components: The PerformUpgrade Method Failed
In this entry, you will find resolutions for the SSIS PerformUpgrade error.
-
Create Apps from ZohoPeople Data in Qlik Sense Cloud
Use CData Connect AI to connect to ZohoPeople Data and build apps from live ZohoPeople data in Qlik Sense Cloud.
-
Build Charts with Helpscout Data in Clear Analytics
Create dynamic charts and perform analytics based on Helpscout data in Clear Analytics.
-
Connect to Discourse Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Discourse and the SQL Gateway to access Discourse data from Google Apps Script.
-
Connect to Quickbase Data from PowerBuilder via JDBC
This article demonstrates how to access Quickbase data from PowerBuilder using the Quickbase JDBC Driver.
-
Automated Continuous Mocean Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Mocean replication to Apache Kafka.
-
How to Work with Sage 200 Data in ETL Validator JDBC
Connect to Sage 200 from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Datasets from HBase in Domo Workbench and Build Visualizations of HBase Data in Domo
Use the CData Software ODBC Driver for HBase to create datasets from HBase data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Asana Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Asana replication to Amazon S3.
-
Establish a Live Connection with Recurly Data using Tableau Bridge
The CData ODBC Driver for Recurly enables you to integrate live Recurly data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating LlamaIndex with SendPulse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SendPulse data in real time.
-
Integrate Cline with Live Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Freshservice data from within your IDE.
-
Build Automated Google Drive-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Drive data and build automated workflows in Zapier.
-
How to Visualize Discord Data in Python with pandas
Use pandas and other modules to analyze and visualize live Discord data in Python.
-
Prepare, Blend, and Analyze Marketo Data in Alteryx Designer (ODBC)
Build workflows to access live Marketo data for self-service data analytics.
-
Connect to Twilio Data in Jaspersoft Studio
Execute SQL to remote Twilio data in Jaspersoft Studio.
-
Use Agno to Talk to Your Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Redis data for you.
-
Integrate with live Guru Data in Jitterbit
Use CData Connect AI to connect to and integrate live Guru data in Jitterbit.
-
Connect to Google Cloud Storage Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Google Cloud Storage data from Filemaker Pro on Mac.
-
How to Connect to Live ZohoExpense Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live ZohoExpense data securely in real time.
-
Prepare, Blend, and Analyze Salesforce Pardot Data in Alteryx Designer (ODBC)
Build workflows to access live Salesforce Pardot data for self-service data analytics.
-
Automated Continuous EmailOctopus Replication to Amazon S3
Use CData Sync for automated, continuous, customizable EmailOctopus replication to Amazon S3.
-
Use the CData Software JDBC Driver for Exa in MicroStrategy
Connect to Exa data in MicroStrategy Developer using the CData Software JDBC Driver for Exa.
-
Automated Continuous Productboard Replication to Oracle
Use CData Sync for automated, continuous, customizable Productboard replication to Oracle.
-
Connect to and Visualize Live Pinecone Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Pinecone data.
-
Analyze Live SuiteCRM Data in SAS Viya
Use CData Connect AI to connect to SuiteCRM data from SAS Viya and deploy self-service analytics using live SuiteCRM data.
-
Model ShipEngine Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and ShipEngine, enabling the direct import of real-time ShipEngine data.
-
Create Apps from Bullhorn CRM Data in Qlik Sense Cloud
Use CData Connect AI to connect to Bullhorn CRM Data and build apps from live Bullhorn CRM data in Qlik Sense Cloud.
-
Publish Reports with Google Forms Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Forms data.
-
Stream Procore Data into Apache Kafka Topics
Access and stream Procore data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect to Intercom Data in DBVisualizer
Integrate Intercom data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Devin with Live Google Sheets 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 Google Sheets data.
-
How to connect PolyBase to Procore
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Procore data.
-
How to use SQLAlchemy ORM to access Oracle Financials Cloud Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle Financials Cloud data.
-
Automated Continuous Microsoft Ads Replication to SQL Server
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to SQL Server.
-
How to Connect the Power BI Service to SparkPost: Complete Guide
Connect to the CData Software Power BI Connector for SparkPost from PowerBI.com to provide real-time SparkPost data across the organization.
-
Connect to Hive Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Hive data.
-
Build Pipedrive-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Pipedrive data.
-
Bind Live Couchbase Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Couchbase data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Integrate Live SpaceX Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SpaceX data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating OpenCode with SAS Data Sets 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.
-
How to connect PolyBase to Clockify
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Clockify data.
-
How to integrate Metabase with WordPress Data
Use CData Connect AI to connect to live WordPress data and create an interactive dashboard in Metabase from WordPress data.
-
Automated Retently Data Replication to Teradata
Use CData Sync to Customize and automate Retently data replication to Teradata.
-
Integrate with Jira Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Jira data in SnapLogic.
-
How to Connect to Live Google Analytics 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 Google Analytics data through natural language.
-
DataBind Charts to Guru Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Guru 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.
-
Connect to SAP SuccessFactors Data in RazorSQL
Connect to SAP SuccessFactors from wizards and query SAP SuccessFactors data from the GUI in the RazorSQL database management tool.
-
Integrating Kiro with JobNimbus 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.
-
Enable the Browserless JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Browserless data.
-
Shopify Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Shopify data through CData Connect AI using different applications and tools.
-
Analyze Microsoft Teams Data in Looker
Use CData Connect AI to connect to Microsoft Teams Data from Looker and build custom apps using live Microsoft Teams data.
-
Connecting Mastra with AgileCRM 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 AgileCRM data, no replication required.
-
Getting Started with the CData ADO.NET Provider for FTP
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for FTP.
-
Automated Continuous Klaviyo Replication to MySQL
Use CData Sync for automated, continuous, customizable Klaviyo replication to MySQL.