CData Software - Knowledge Base
Recent Articles
-
Link HelloSign with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate HelloSign data in Filemaker Pro for Mac or Windows.
-
Build Apps with Live Spark data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Spark data into the Adalo platform and build custom mobile and web applications with real-time Spark data.
-
Build AI/ML Models with Live Microsoft Ads Data using Dataiku
Connect Microsoft Ads Data with Dataiku using the CData JDBC Driver for Microsoft Ads.
-
Write a Simple Go Application to work with Exa Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Exa data.
-
Query Live Cosmos DB 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 Cosmos DB data through a conversational interface.
-
How to use SQLAlchemy ORM to access SFTP Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SFTP data.
-
How to Connect DBeaver to Mocean via a JDBC Driver
Manage Mocean data with visual tools in DBeaver like the query browser.
-
Integrate Live Aha! Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Aha! data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect REST Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your REST data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Live Kintone Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Kintone data through MCP integration.
-
Automated Continuous Salesloft Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Salesloft replication to AlloyDB.
-
Build Salesforce Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Salesforce data and build visualizations in Tableau.
-
Analyze Epicor Kinetic Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Epicor Kinetic data with the CData JDBC Driver for Epicor Kinetic.
-
Automated Continuous MessageBird Replication to Snowflake
Use CData Sync for automated, continuous, customizable MessageBird replication to Snowflake.
-
Integrate with Pinecone Data in JReport Designer
Create charts and reports based on Pinecone data in JReport Designer.
-
Analyze CouchDB Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze CouchDB data with the CData JDBC Driver for CouchDB.
-
Build AI Agents with SparkPost 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 SparkPost data through CData Connect AI.
-
Explore Geographical Relationships in Amazon Marketplace Data with Power Map
Create data visualizations with Amazon Marketplace data in Power Map.
-
Automated Continuous Azure Synapse Replication to Oracle
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Oracle.
-
How to Access Live IBM Informix Data in Power Automate Desktop via ODBC
The CData ODBC Driver for IBM Informix enables you to integrate IBM Informix data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Sybase Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Sybase and the Script function in FileMaker Pro to connect to Sybase and work with Sybase data in your FileMaker application.
-
Access Live Figshare Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Figshare data through MCP integration.
-
Connect to Freshdesk Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Freshdesk data.
-
Connect to Microsoft OneDrive Data in ACL Analytics
Connect to Microsoft OneDrive data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft OneDrive data.
-
Build Semantic Layer Views for Outreach.io Data in APOS Live Data Gateway
Use the CData Connector for Outreach.io in APOS Live Data Gateway to build Semantic Layer Views for Outreach.io data.
-
Load Redis Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Redis data to a database.
-
Connect to Real-Time ActiveCampaign Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for ActiveCampaign and Dataflow to import and use ActiveCampaign data in Power Apps.
-
LinkedIn Reporting in OBIEE with the LinkedIn JDBC Driver
Deploy the LinkedIn JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Query Sage Cloud Accounting Data in MySQL Workbench
Execute MySQL queries against live Sage Cloud Accounting data from MySQL Workbench.
-
Connect to and Query ZohoExpense Data in QlikView over ODBC
Create data visualizations with ZohoExpense data in QlikView.
-
Connect to Zoho Projects Data from AWS Glue
Use CData Connect AI to gain access to live Zoho Projects data from your AWS Glue jobs.
-
Integrate Adobe Target with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Adobe Target with External Services.
-
Integrate Goose with Live Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Microsoft Teams data from within the local AI agent.
-
How to connect to ClickUp Data from IntelliJ
Integrate connectivity to ClickUp data with wizards in IntelliJ.
-
Add Highrise Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Highrise with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Campaigner Data in Google Apps Script via Connect AI
Use CData Connect AI to access Campaigner data in Google Apps Script.
-
Connecting GenSpark with Vault CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Vault CRM data without any replication or custom integration required.
-
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 Neo4J Data in CloverDX (formerly CloverETL)
Transfer Neo4J data using the visual workflow in the CloverDX data integration tool.
-
How to publish and share PolarTeamPro Data dashboards with Tableau Server
The CData ODBC driver for PolarTeamPro enables you integrate PolarTeamPro data into Tableau dashboards.
-
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.
-
Integrating Dataiku with Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Google Ad Manager 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.
-
How to connect and process Google Tasks data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Tasks data.
-
Access Live Greenplum Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Greenplum data from your Excel spreadsheets.
-
Access Live eBay Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live eBay data through MCP integration.
-
Automated Continuous Scrapfly Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Scrapfly replication to Azure SQL Database.
-
Migrating data from SAP ByDesign to Databricks using CData SSIS Components.
Easily push SAP ByDesign data to Databricks using the CData SSIS Tasks for SAP ByDesign and Databricks.
-
Create Reports from SAP Netweaver Gateway Data in Looker Studio
Use CData Connect AI to gain access to live SAP Netweaver Gateway data and create custom reports in Looker Studio.
-
Replicate Multiple Marketo Accounts via the CData Sync CLI
Replicate multiple Marketo accounts to one or many databases.
-
How to Query Live Sage 200 Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Sage 200 data data in natural language using Python.
-
How to Access Live NetSuite Data in Power Automate Desktop via ODBC
The CData ODBC Driver for NetSuite enables you to integrate NetSuite data into workflows built using Microsoft Power Automate Desktop.
-
Build Data Flows from SQL Server to AlloyDB through SSIS
Easily push SQL Server data to AlloyDB using the CData SSIS Tasks for AlloyDB.
-
Connect to Real-Time Jodoo Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Jodoo data in Power Apps.
-
Connect to Neo4J Data from PowerBuilder via ADO.NET
This article demonstrates how to access Neo4J data from Appeon PowerBuilder using the CData ADO.NET Provider for Neo4J.
-
Integrate Dify with Live Suadeo 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 Suadeo data.
-
Connecting Agentforce with Microsoft Entra ID Data 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 Microsoft Entra ID data for you.
-
Build an OLAP Cube in SSAS from Salesforce CRM Analytics Data
Establish a connection to Salesforce CRM Analytics data data from SQL Server Analysis Services, and use the Salesforce CRM Analytics Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Salesloft Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Salesloft data access from reports, embedded analytics, and more.
-
Connect to Google Analytics Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Analytics Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Brex Data in DBeaver
Use the CData ODBC Driver to connect to Brex data in DBeaver.
-
Use the CData ODBC Driver for Snapchat Ads from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Snapchat Ads to connect to Snapchat Ads data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Snapchat Ads data in Excel.
-
Connect BigCommerce Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your BigCommerce data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
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.
-
Connect to Spark Data in RapidMiner
Integrate Spark data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software ODBC Driver for GetResponse in MicroStrategy Desktop
Connect to GetResponse data in MicroStrategy Desktop using the CData Software ODBC Driver for GetResponse.
-
Automate VWO Integration Tasks from PowerShell
Are you in search of a quick and easy way to access VWO data from PowerShell? This article demonstrates how to utilize the VWO Cmdlets for tasks like connecting to VWO data, automating operations, downloading data, and more.
-
Integrating Claude Code CLI with Google Cloud Storage 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.
-
Automated Continuous LeadDesk Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable LeadDesk replication to PostgreSQL.
-
Building Dynamic Web Pages with Act CRM Data Using AngularJS
Create single-page applications with live connectivity to Act CRM using the CData API Server.
-
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.
-
Integrating Antigravity CLI with Teamgate data via CData CLI
Connect Teamgate data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Cassandra Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Cassandra data access from reports, embedded analytics, and more.
-
How to connect and process Tanda data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Tanda data.
-
Using the CData Software ODBC Driver for Figshare in PyCharm
Connect to Figshare as an ODBC data source in PyCharm using the CData Software ODBC Driver for Figshare.
-
Access Live Jira Assets Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Jira Assets data through MCP integration.
-
Visualize Sage Cloud Accounting 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 Sage Cloud Accounting data into TIBCO Spotfire.
-
Automated Continuous Google Cloud Storage Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to Google Cloud SQL.
-
Access Live Smartsheet Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Smartsheet data through MCP integration.
-
How to Connect the Power BI Service to Salesforce Data 360: Complete Guide
Connect to the CData Software Power BI Connector for Salesforce Data 360 from PowerBI.com to provide real-time Salesforce Data 360 data across the organization.
-
Use the CData ODBC Driver for Pipedrive in Microsoft Power Query
You can use the CData Pipedrive ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Pipedrive data into Microsoft Power Query.
-
Replicate Trello Data from PowerShell
Write a quick PowerShell script to query Trello data. Use connectivity to the live data to replicate Trello data to SQL Server.
-
How to create an RPA flow for MarkLogic Data in UiPath Studio
Use the MarkLogic ODBC Driver to create workflows that access real-time MarkLogic data without any coding.
-
Connect to Okta Data in Google Apps Script via Connect AI
Use CData Connect AI to access Okta data in Google Apps Script.
-
Migrating data from Freshservice to Snowflake using CData SSIS Components.
Easily push Freshservice data to Snowflake using the CData SSIS Tasks for Freshservice and Snowflake.
-
Build AI/ML Models with Live DB2 Data using Dataiku
Connect DB2 Data with Dataiku using the CData JDBC Driver for DB2.
-
Build Semantic Layer Views for ZohoInvoice Data in APOS Live Data Gateway
Use the CData Connector for ZohoInvoice in APOS Live Data Gateway to build Semantic Layer Views for ZohoInvoice data.
-
Connect to Live Snowflake Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Snowflake in CData Connect AI and connect to your Snowflake data from PostgreSQL.
-
Visualize Adobe Commerce Data in Sisense
Create an ElastiCube in Sisense app with access to Adobe Commerce data.
-
How to Connect DBeaver to WooCommerce via a JDBC Driver
Manage WooCommerce data with visual tools in DBeaver like the query browser.
-
Replicate Multiple Figshare Accounts
Replicate multiple Figshare accounts to one or many databases.
-
Query Live Figshare 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 Figshare data through a conversational interface.
-
Build ZohoExpense-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for ZohoExpense Data and create custom apps in Bubble.
-
Build Charts with Sage 300 Data in Clear Analytics
Create dynamic charts and perform analytics based on Sage 300 data in Clear Analytics.
-
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.
-
Work with FTP Data in FoxPro
Load FTP data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Natively Connect to Salesforce Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Salesforce data. Leverage the native support for ODBC in PHP.
-
Process & Analyze Redshift Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Redshift Data.
-
Connect and Visualize Live Egnyte Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Egnyte data into the Databricks platform and create visualization dashboards with real-time Egnyte data.