CData Software - Knowledge Base
Recent Articles
-
Integrating Gumloop with Apify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Apify data within automated workflows.
-
Build Dashboards with Parallel Data in Dundas BI
Create dynamic dashboards and perform analytics based on Parallel data in Dundas BI.
-
Connect to Clio Data in JRuby
Create a simple JRuby app with access to live Clio data.
-
Use the CData Software JDBC Driver for Salesforce CRM Analytics in MicroStrategy Web
Connect to Salesforce CRM Analytics data in MicroStrategy Web using the CData Software JDBC Driver for Salesforce CRM Analytics.
-
Automate Nuclia Data Replication to Couchbase
Use CData Sync to Customize and automate Nuclia data replication to Couchbase.
-
A PostgreSQL Interface for Marketo Data (MySQL Remoting via JDBC)
Use the Remoting features of the Marketo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Dify with Live Grafana 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 Grafana data.
-
Connect to Instantly in SpagoBI
Create reports featuring live Instantly data in SpagoBI Studio. Host Instantly reports on SpagoBI Server.
-
Amazon DynamoDB Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Amazon DynamoDB data through CData Connect AI using different applications and tools.
-
Create MailerLite-Connected Dashboards in Grafana
Connect to MailerLite Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to MailerLite data.
-
Build a Singer.io Tap for Dynamics CRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Dynamics CRM data using the CData Python Connector.
-
Query Close Data in ColdFusion
Write standard ColdFusion data access code to connect to Close data.
-
How to create an RPA flow for CampaignMonitor Data in UiPath Studio
Use the CampaignMonitor ODBC Driver to create workflows that access real-time CampaignMonitor data without any coding.
-
Connect to Google Search Results from AWS Glue
Use CData Connect AI to gain access to live Google Search results from your AWS Glue jobs.
-
Write a Simple Go Application to work with BenchmarkEmail Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to BenchmarkEmail data.
-
Build AI Agents with HBase Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live HBase data through CData Connect AI.
-
Integrate Adobe Target with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Adobe Target with External Services.
-
Migrating data from Webex to Google BigQuery using CData SSIS Components.
Easily push Webex data to Google BigQuery using the CData SSIS Tasks for Webex and Google BigQuery.
-
Connect to Phoenix Data in NetBeans
Connect to Phoenix data in NetBeans with the data source configuration wizard.
-
How to Create Power BI Visual Reports with Real-Time HCL Domino Data
Use CData Power BI Connectors to visualize HCL Domino data in Power BI.
-
Integrate with LDAP Objects using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy LDAP objects to a JSON file on disk.
-
Interact with Live BambooHR Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live BambooHR data.
-
Access Mixpanel Data from MySQL in PHP
Connect to Mixpanel through the standard MySQL libraries in PHP.
-
Import Real-Time ADP Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ADP data in ColdFusion.
-
Use the CData Software JDBC Driver for Attio in MicroStrategy Web
Connect to Attio data in MicroStrategy Web using the CData Software JDBC Driver for Attio.
-
How to connect SharePoint with REST Data through external lists
Provide REST data to SharePoint users as an external list.
-
Build an OLAP Cube in SSAS from Klaviyo Data
Establish a connection to Klaviyo data data from SQL Server Analysis Services, and use the Klaviyo Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to use SQLAlchemy ORM to access Gong Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Gong data.
-
Connecting Moonlit Workflow with CockroachDB 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 CockroachDB data in real time.
-
Query Live SAP HANA XS Advanced Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live SAP HANA XS Advanced data through a conversational interface.
-
Integrating LlamaIndex with Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Freshdesk data in real time.
-
View Reports on Real-Time Beeminder Data in Power BI Report Server
Use the CData ODBC Driver for Beeminder to visualize Beeminder data in Power BI Desktop and then publish them to Power BI Report Server.
-
Feed Coda Data into FineReport
How to set Coda data as a JDBC data source in FineReport.
-
Build SAP Netweaver Gateway-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP Netweaver Gateway data and build web apps with connectivity to live SAP Netweaver Gateway data.
-
Connect to SAP Ariba Source in SpagoBI
Create reports featuring live SAP Ariba Source data in SpagoBI Studio. Host SAP Ariba Source reports on SpagoBI Server.
-
Integrating LangChain with Salesforce Data 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Salesforce Data 360 data within automated workflows.
-
Connect to Neo4J Data in CloverDX (formerly CloverETL)
Transfer Neo4J data using the visual workflow in the CloverDX data integration tool.
-
Access Live Eventbrite Data in Coginiti Pro
Connect to and query live Eventbrite data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData Python Connector for Databricks
Learn to install and license the CData Python Connector and configure a connection to live Databricks data.
-
Publish Reports with SharePoint Excel Services Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SharePoint Excel Services data.
-
Connect to Lakebase Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Lakebase Data and connect to Lakebase data in Akorbi Digital RunMyProcess.
-
How to connect and process Smartsheet data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Smartsheet data.
-
Publish Salesforce Marketing-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Salesforce Marketing data.
-
How to Connect to Salesforce Data 360 Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Salesforce Data 360 data. Leverage the pyodbc module for ODBC in Python.
-
Google Translate Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Translate facts in real time.
-
Connect to Klipfolio Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Klipfolio data.
-
Back Up BigCommerce data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for BigCommerce. In this article, we will employ an SSIS workflow to populate a database with BigCommerce data data.
-
Automated Continuous Aircall Replication to Databricks
Use CData Sync for automated, continuous, customizable Aircall replication to Databricks.
-
Replicate Multiple Humanity Accounts
Replicate multiple Humanity accounts to one or many databases.
-
Build Apps with Live Figshare data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Figshare data into the Adalo platform and build custom mobile and web applications with real-time Figshare data.
-
Connect to FormSite Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for FormSite data.
-
View Reports on Real-Time LDAP Objects in Power BI Report Server
Use the CData ODBC Driver for LDAP to visualize LDAP objects in Power BI Desktop and then publish them to Power BI Report Server.
-
Build ConstantContact-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live ConstantContact data and build ConstantContact-connected web apps with Axios.
-
Connect to Google Sheets Data in Aqua Data Studio
Access Google Sheets data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData Software JDBC Driver for Postmark in MicroStrategy Desktop
Connect to Postmark data in MicroStrategy Desktop using the CData Software JDBC Driver for Postmark.
-
Connect to Couchbase Data in NetBeans
Connect to Couchbase data in NetBeans with the data source configuration wizard.
-
Replicate ShipStation Data to Multiple Databases via the CData Sync CLI
Replicate ShipStation data to disparate databases with a single configuration.
-
Automated Continuous Azure Data Lake Storage Replication to SingleStore
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to SingleStore.
-
Create NetSuite-Connected Dashboards in Grafana
Connect to NetSuite Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to NetSuite data.
-
Build a PostgreSQL Interface for AlloyDB Data using the CData JDBC Driver
Use the Remoting features of the AlloyDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Build an ETL App for Outlook Data in Python with CData
Create ETL applications and real-time data pipelines for Outlook data in Python with petl.
-
Connect to Odoo Data in HULFT Integrate
Connect to Odoo as a JDBC data source in HULFT Integrate
-
Create MySQL-Connected Nintex Workflows
Use CData Connect AI to connect to MySQL Data from Nintex Workflow Cloud and build custom workflows using live MySQL data.
-
Integrate Cline with Live Dynamics NAV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Dynamics NAV data from within your IDE.
-
Import and Visualize LeadDesk Data in Power View
Create data visualizations based on LeadDesk data in Excel.
-
How to Connect to Live Box 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 Box data for you.
-
Use Dash to Build Web Apps on Freshservice Data via CData Connect AI
Build interactive Dash web apps on live Freshservice data using pandas and the CData Connect AI Python SDK.
-
Build Anaplan-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Anaplan data and build web apps with connectivity to live Anaplan data.
-
Access Live Cloudflare Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Cloudflare data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous Google Search Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Search replication to Google Cloud SQL.
-
Build Data Flows from Google Cloud Storage to SQL Server using SSIS
Easily back up Google Cloud Storage data to SQL Server using the SSIS components for Google Cloud Storage.
-
Getting Started with the CData ODBC Driver for Discourse
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Discourse.
-
Create Informatica Mappings From/To an ODBC Data Source for LinkedIn Ads
Create an ODBC connection to LinkedIn Ads in Informatica and browse and transfer LinkedIn Ads data.
-
Analyze Slack Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Slack data and visualize Slack data in SAP Analytics Cloud.
-
How to connect to Reckon Accounts Hosted Data with Squirrel SQL client
Connect to Reckon Accounts Hosted data and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData Power BI Connector for Brex
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to connect to Missive Data from IntelliJ
Integrate connectivity to Missive data with wizards in IntelliJ.
-
How to load Egnyte data into Elasticsearch via Logstash
Introducing a simple method to load Egnyte data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Voice Agents in ElevenLabs with access to Live Azure Data Lake Storage Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Azure Data Lake Storage data.
-
Connect to Hugging Face Data in HULFT Integrate
Connect to Hugging Face as a JDBC data source in HULFT Integrate
-
Query Azure Synapse Data as a MySQL Database in Node.js
Execute MySQL queries against Azure Synapse data from Node.js.
-
Migrating data from FreshBooks to Snowflake using CData SSIS Components.
Easily push FreshBooks data to Snowflake using the CData SSIS Tasks for FreshBooks and Snowflake.
-
Integrate AgileCRM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate AgileCRM with External Services.
-
Build Redis-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Redis data.
-
Integrate Live Act-On Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Act-On data to Blue Prism using the CData ODBC Driver for Act-On to create automated workflows for repetitive business tasks.
-
Query SAP Concur Data in DataGrip
Create a Data Source for SAP Concur in DataGrip and use SQL to query live SAP Concur data.
-
How to create Square federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Square data in MySQL .
-
Building Dynamic Web Pages with Elasticsearch Data Using AngularJS
Create single-page applications with live connectivity to Elasticsearch using the CData API Server.
-
Create SurveyMonkey-Connected Nintex Workflows
Use CData Connect AI to connect to SurveyMonkey Data from Nintex Workflow Cloud and build custom workflows using live SurveyMonkey data.
-
Access Live ActiveCampaign Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ActiveCampaign data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Extract, Transform, and Load HubDB Data in Informatica PowerCenter
Create a simple Workflow for HubDB data in Informatica PowerCenter.
-
How to integrate SAP Business Warehouse with Apache Airflow
Access and process SAP Business Warehouse data in Apache Airflow using the CData JDBC Driver.
-
Build Dashboards with Vimeo Data in Dundas BI
Create dynamic dashboards and perform analytics based on Vimeo data in Dundas BI.
-
Operational Reporting on Phoenix Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Phoenix data.
-
How to connect to Jira Assets Data from Spring Boot
Connect to Jira Assets in a Spring Boot Application using the CData JDBC Driver for Jira Assets
-
Analyze Klipfolio Data in Looker
Use CData Connect AI to connect to Klipfolio Data from Looker and build custom apps using live Klipfolio data.
-
Build Pipelines with Live MySQL Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to MySQL from Google Cloud Data Fusion, enabling the integration of live MySQL data into the building and management of effective data pipelines.
-
Query Live Wistia Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Wistia data directly from the development environment.
-
Automated Continuous MarkLogic Replication to SQLite
Use CData Sync for automated, continuous, customizable MarkLogic replication to SQLite.
-
Work with Google Ads Data in FoxPro
Load Google Ads data into a FoxPro database. This article includes full code and a walk-through of the process.