CData Software - Knowledge Base
Recent Articles
-
Back Up MongoDB to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for MongoDB. In this article, we will employ an SSIS workflow to populate a database with MongoDB data.
-
Access Live ZohoMarketingHub Data in AWS Lambda
Connect to live ZohoMarketingHub in AWS Lambda using the CData JDBC Driver.
-
Build Automated Google Ads-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Ads and build automated workflows in Zapier.
-
Use Dash to Build to Web Apps on Sage 200 Data
Create Python applications that use pandas and Dash to build Sage 200-connected web apps.
-
Access Live Retently Data in Coginiti Pro
Connect to and query live Retently from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating Gumloop with Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Atlassian Jira within automated workflows.
-
Bridge SAP Ariba Source Connectivity with Apache NiFi
Access and process SAP Ariba Source in Apache NiFi using the CData JDBC Driver.
-
Configure the CData JDBC Driver for SAS Data Sets in a Connection Pool in Tomcat
Connect to SAS Data Sets from a connection pool in Tomcat.
-
Connect to Live Zoho CRM Data in MicroStrategy through CData Connect AI
Create a live connection to Zoho CRM Data in CData Connect AI and connect to your Zoho CRM from MicroStrategy.
-
Use Biml to Build SSIS Tasks to Replicate Front Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Front to SQL Server.
-
Automated Continuous JSON Replication to MongoDB
Use CData Sync for automated, continuous, customizable JSON replication to MongoDB.
-
How to Access Live Gmail Data in Visual Studio Code via Cline
Run CData MCP Server for Gmail on Windows Subsytem for Linux (WSL) and connect to live Gmail from the Cline extension in Visual Studio Code.
-
How to Connect to Live Gmail Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Gmail for you.
-
Create Reports with Mouseflow Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mouseflow.
-
Build a Singer.io Tap for Snapchat Ads With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Snapchat Ads data using
-
Automated Continuous SurveyMonkey Replication to MongoDB
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to MongoDB.
-
A PostgreSQL Interface for DocuSign Data using the CData ODBC Driver
Use the SQL Gateway and DocuSign ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automate LaunchDarkly Integration Tasks from PowerShell
Are you in search of a quick and easy way to access LaunchDarkly from PowerShell? This article demonstrates how to utilize the LaunchDarkly Cmdlets for tasks like connecting to LaunchDarkly, automating operations, downloading data, and more.
-
Replicate Power BI XMLA Data from PowerShell
Write a quick PowerShell script to query Power BI XMLA. Use connectivity to the live data to replicate Power BI XMLA to SQL Server.
-
Build AI/ML Models with Live Azure Data Lake Storage Data using Dataiku
Connect Azure Data Lake Storage Data with Dataiku using the CData JDBC Driver for Azure Data Lake Storage.
-
Use the CData Software ODBC Driver for ShipStation in MicroStrategy
Connect to ShipStation in MicroStrategy Developer using the CData Software ODBC Driver for ShipStation.
-
Access Live Parallel Data in AWS Lambda
Connect to live Parallel in AWS Lambda using the CData JDBC Driver.
-
Back Up Postmark 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 Postmark data.
-
Access Live Asana 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 Asana through MCP integration.
-
Connect to Paylocity Data in DBArtisan
Use wizards in DBArtisan to configure Paylocity as a data source.
-
How to Connect to PhantomBuster Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to PhantomBuster. Leverage the pyodbc module for ODBC in Python.
-
Use the CData ODBC Driver for Stripe from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Stripe to connect to Stripe from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Stripe in Excel.
-
Visualize Egnyte Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Egnyte.
-
Connecting Moonlit Workflow with Microsoft Ads 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 Microsoft Ads in real time.
-
Automated WooCommerce Data Replication to Teradata
Use CData Sync to Customize and automate WooCommerce replication to Teradata.
-
Connect OpenWeatherMap to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect OpenWeatherMap with IBM WebSphere for seamless data integration and connectivity.
-
Extract, Transform, and Load Rebilly Data in Informatica PowerCenter
Create a simple Workflow for Rebilly in Informatica PowerCenter.
-
Connect to HDFS Data from a Connection Pool in Jetty
The HDFS JDBC Driver supports connection pooling: This article shows how to connect faster to Apache HDFS from Web apps in Jetty.
-
Use the CData Software JDBC Driver for SQL Analysis Services in MicroStrategy Desktop
Connect to SQL Analysis Services in MicroStrategy Desktop using the CData Software JDBC Driver for SQL Analysis Services.
-
Analyze Redshift Data in Cognos Analytics
Use CData Connect AI to connect to Redshift Data from Cognos Analytics and analyze live Amazon Redshift.
-
Create Amazon DynamoDB-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Amazon DynamoDB Data from OutSystems and build custom enterprise apps using live Amazon DynamoDB.
-
Connect to Mouseflow Data from a Connection Pool in Jetty
The Mouseflow JDBC Driver supports connection pooling: This article shows how to connect faster to Mouseflow from Web apps in Jetty.
-
Model Bullhorn CRM Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Bullhorn CRM, enabling the direct import of real-time Bullhorn CRM.
-
Easily Integrate Opsgenie Data in Lazarus Pascal IDE
Learn how to easily integrate live Opsgenie in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
DataBind Freshsales Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Freshsales to a chart.
-
Build Instantly-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Instantly.
-
Analyze Aha! Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Aha! from Power Pivot. You will use the Table Import Wizard to load Aha!. You can visually build the import query or use any SQL supported by the driver.
-
Build Apps with Live JotForm Data Using the Low-Code Development Platform of Mendix
Connect JotForm with Mendix to build apps using the CData API Driver for JDBC.
-
Publish Blackbaud FE NXT-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Blackbaud FE NXT.
-
Connect to Typeform Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Typeform using standard SQL.
-
Build Charts with XML Data in Clear Analytics
Create dynamic charts and perform analytics based on XML Files in Clear Analytics.
-
Salesforce Data 360 Reporting in OBIEE with the Salesforce Data 360 JDBC Driver
Deploy the Salesforce Data 360 JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Act-On-Connected Nintex Workflows
Use CData Connect AI to connect to Act-On Data from Nintex Workflow Cloud and build custom workflows using live Act-On.
-
Connect Smartsheet Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Smartsheet using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Consume Sybase OData Feeds in PowerBuilder
This article demonstrates how to consume Sybase as OData feeds from PowerBuilder using the API Server.
-
Integrate Live Oracle Eloqua Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Integrating LangGraph with Microsoft Ads Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft Ads within automated workflows.
-
Use Dash to Build to Web Apps on Power BI XMLA Data
Create Python applications that use pandas and Dash to build Power BI XMLA-connected web apps.
-
Connect to Trello Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Trello using standard SQL.
-
Build FormSite-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live FormSite.
-
Access LightSpeedRetail 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 LightSpeedRetail.
-
Use Biml to Build SSIS Tasks to Replicate Timely Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Timely to SQL Server.
-
Analyze Amazon DynamoDB Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Amazon DynamoDB and visualize live Amazon DynamoDB in Infragistics Reveal.
-
How to connect PolyBase to Retently
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Retently.
-
Connect to NetSuite Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time NetSuite CRM & ERP using standard SQL.
-
Import Real-Time Dynamics NAV Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Dynamics NAV in ColdFusion.
-
Explore Geographical Relationships in Microsoft Dataverse Data with Power Map
Create data visualizations with Microsoft Dataverse (CDS) in Power Map.
-
How to connect to Omnisend Data in DBVisualizer
Integrate Omnisend with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect DBeaver to Webflow via a JDBC Driver
Manage Webflow with visual tools in DBeaver like the query browser.
-
Connecting Mastra with SQL Analysis Services 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 SQL Analysis Services, no replication required.
-
Build Automated HCL Domino-Connected Workflows in Zapier
Use CData Connect AI to connect to live HCL Domino and build automated workflows in Zapier.
-
Automate Pinterest Data Replication to Azure Synapse
Use CData Sync to customize and automate Pinterest replication to Azure Synapse.
-
Connect to Real-Time Smartsheet Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Smartsheet and Dataflow to import and use Smartsheet in Power Apps.
-
Analyze SAP Business Warehouse Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Business Warehouse in Microsoft R Open.
-
Consume Redshift OData Feeds in PowerBuilder
This article demonstrates how to consume Amazon Redshift as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous SingleStore Replication to Vertica
Use CData Sync for automated, continuous, customizable SingleStore replication to Vertica.
-
How to Import Data from Oracle Sales into Google Sheets
Import Oracle Sales into a Google spreadsheet that is automatically refreshed.
-
Getting Started with the CData JDBC Driver for xBase
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for xBase.
-
Model, Search, and Visualize Live Sybase Data in ThoughtSpot
Use CData Connect AI to connect to live Sybase for modeling, searching, and visualizing.
-
Write a Simple Go Application to work with Google Translate Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Translate.
-
Integrating LangGraph with Confluence Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Atlassian Confluence within automated workflows.
-
Use the CData Software ODBC Driver for Outlook in MicroStrategy Desktop
Connect to Outlook in MicroStrategy Desktop using the CData Software ODBC Driver for Outlook.
-
How to connect to Hugging Face Data from IntelliJ
Integrate connectivity to Hugging Face with wizards in IntelliJ.
-
Integrate Open WebUI with Live API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live API from within the chat interface.
-
Easily Integrate ZohoInvoice Data in Lazarus Pascal IDE
Learn how to easily integrate live ZohoInvoice in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Query Live MarkLogic Data in Perplexity MacOS Desktop
Connect to and query live MarkLogic Data in Perplexity Desktop using CData MCP Server.
-
Create a Data Access Object for Sage 200 Data using JDBI
A brief overview of creating a SQL Object API for Sage 200 in JDBI.
-
How to Work with Impala Data in AWS Glue Jobs Using JDBC
Connect to Impala from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automate ZohoExpense Data Replication to Azure Synapse
Use CData Sync to customize and automate ZohoExpense replication to Azure Synapse.
-
Create a Data Access Object for Zoho Books Data using JDBI
A brief overview of creating a SQL Object API for Zoho Books in JDBI.
-
Integrate with live MariaDB Data in Jitterbit
Use CData Connect AI to connect to and integrate live MariaDB in Jitterbit.
-
Manage Xero Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Xero.
-
How to Use a Microsoft Access Database to Update Zoho Creator Data in Real Time
Update Zoho Creator data by creating a linked table in Microsoft Access with the CData Zoho Creator ODBC Driver.
-
Use Manus AI to Talk to Your SAP Fieldglass 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 SAP Fieldglass.
-
Stream Onfleet Data into Apache Kafka Topics
Access and stream Onfleet in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Foursquare Data in Ruby
Connect to Foursquare in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Visualize Azure Table Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Azure Table Storage in Python.
-
Import MySQL Data Using Azure Data Factory
Use CData Connect AI to connect to MySQL Data from Azure Data Factory and import live MySQL.
-
Choosing the Best Method to Connect MySQL to SQL Server: 5 Options Explained
Discover multiple ways to connect and use MySQL from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect Stack Exchange to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Stack Exchange with IBM WebSphere for seamless data integration and connectivity.
-
Bind Live CouchDB Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live CouchDB data
-
Enable the Phoenix JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Apache Phoenix.
-
Use Grok to Talk to Your Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Google Ads for you.
-
Use the CData Software JDBC Driver for Basecamp in MicroStrategy Desktop
Connect to Basecamp in MicroStrategy Desktop using the CData Software JDBC Driver for Basecamp.
-
How to connect to Kafka Data in DBVisualizer
Integrate Apache Kafka with visual data analysis tools and data connection wizards in DBVisualizer