CData Software - Knowledge Base
Recent Articles
-
Create Datasets from Marketo in Domo Workbench and Build Visualizations of Marketo Data in Domo
Use the CData Software ODBC Driver for Marketo to create datasets from Marketo in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Freshdesk Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Freshdesk replication to IBM DB2.
-
Integrating GitHub Copilot CLI with Auth0 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.
-
Connect to Gmail Data in Google Apps Script via Connect AI
Use CData Connect AI to access Gmail in Google Apps Script.
-
Create Reports with OData Services in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date OData.
-
Bidirectional Access to HelloSign Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate HelloSign in Filemaker Pro for Mac or Windows.
-
Build Apps with Live Apache Spark SQL in Adalo using CData Connect AI
Use CData Connect AI to integrate live Apache Spark SQL into the Adalo platform and build custom mobile and web applications with real-time Apache Spark SQL.
-
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.
-
How to use SQLAlchemy ORM to access SFTP Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SFTP.
-
How to Connect DBeaver to Mocean via a JDBC Driver
Manage Mocean 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! 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 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 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 & Force.com 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 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 in JReport Designer.
-
Analyze CouchDB Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Apache CouchDB with the CData JDBC Driver for CouchDB.
-
Explore Geographical Relationships in Amazon Marketplace Data with Power Map
Create data visualizations with Amazon Marketplace 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 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 in your FileMaker application.
-
Connect to Freshdesk Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Freshdesk.
-
Connect to Microsoft OneDrive Data in ACL Analytics
Connect to Microsoft OneDrive via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft OneDrive.
-
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.
-
Load Redis Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Redis 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 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 Business Cloud Accounting from MySQL Workbench.
-
Connect to and Query ZohoExpense Data in QlikView over ODBC
Create data visualizations with ZohoExpense in QlikView.
-
Connect to Zoho Projects Data from AWS Glue
Use CData Connect AI to gain access to live Zoho Projects 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 from within the local AI agent.
-
How to connect to ClickUp Data from IntelliJ
Integrate connectivity to ClickUp 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.
-
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 Veeva Vault & Vault CRM 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 and build web apps with connectivity to live SAP Netweaver Gateway.
-
Connect to Neo4J Data in CloverDX (formerly CloverETL)
Transfer Neo4J 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 into Tableau dashboards.
-
Getting Started with the CData Python Connector for Databricks
Learn to install and license the CData Python Connector
-
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.
-
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.
-
How to connect and process Google Tasks from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Tasks.
-
Access Live Greenplum Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Pivotal GreenPlum 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 through MCP integration.
-
Migrating data from SAP ByDesign to Databricks using CData SSIS Components.
Easily push SAP Business ByDesign 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 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 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 CRM & ERP 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 in Power Apps.
-
Connect to Neo4J Data from PowerBuilder via ADO.NET
This article demonstrates how to access Neo4J from Appeon PowerBuilder using the CData ADO.NET Provider for Neo4J.
-
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 for you.
-
Build an OLAP Cube in SSAS from Salesforce CRM Analytics Data
Establish a connection to Salesforce CRM Analytics 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 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 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Snapchat Ads in Excel.
-
Connect BigCommerce Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your BigCommerce using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Greenplum-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Greenplum to explore live Greenplum Data in GitHub Copilot to assist with building Greenplum-powered applications.
-
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.
-
Connect to Spark Data in RapidMiner
Integrate Apache Spark SQL 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 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 from PowerShell? This article demonstrates how to utilize the VWO Cmdlets for tasks like connecting to VWO, 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 to SQL Server using the SSIS components for Google Cloud Storage.
-
Integrating Antigravity CLI with Teamgate via CData CLI
Connect Teamgate 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 from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Tanda.
-
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 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 Business Cloud Accounting 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 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 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 into Microsoft Power Query.
-
Replicate Trello Data from PowerShell
Write a quick PowerShell script to query Trello. Use connectivity to the live data to replicate Trello 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 without any coding.
-
Connect to Okta Data in Google Apps Script via Connect AI
Use CData Connect AI to access Okta in Google Apps Script.
-
Migrating data from Freshservice to Snowflake using CData SSIS Components.
Easily push Freshservice 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.
-
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 from PostgreSQL.
-
Visualize Adobe Commerce Data in Sisense
Create an ElastiCube in Sisense app with access to Adobe Commerce.
-
How to Connect DBeaver to WooCommerce via a JDBC Driver
Manage WooCommerce with visual tools in DBeaver like the query browser.
-
Replicate Multiple Figshare Accounts
Replicate multiple Figshare accounts to one or many databases.
-
How to Query Live Tally Data in Claude Desktop
Connect to and query live Tally Data in Claude Desktop using CData MCP Server.
-
Build Charts with Sage 300 Data in Clear Analytics
Create dynamic charts and perform analytics based on Sage 300 in Clear Analytics.
-
How to integrate SAP Business Warehouse with Apache Airflow
Access and process SAP Business Warehouse 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 in Dundas BI.
-
Work with FTP Data in FoxPro
Load FTP Servers 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 & Force.com. 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 to Perplexity Data in DBArtisan
Use wizards in DBArtisan to configure Perplexity as a data source.
-
Connect to HBase Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for HBase and the SQL Gateway to access Apache HBase from Google Apps Script.