CData Software - Knowledge Base
Recent Articles
-
Connect and Visualize Live SAP Netweaver Gateway Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAP Netweaver Gateway into the Databricks platform and create visualization dashboards with real-time SAP Netweaver Gateway.
-
Analyze Power BI XMLA Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Power BI XMLA and visualize Power BI XMLA in SAP Analytics Cloud.
-
Build Data Flows from SQL Server to XML through SSIS
Easily push SQL Server data to XML using the CData SSIS Tasks for XML.
-
Model, Search, and Visualize Live FTP Data in ThoughtSpot
Use CData Connect AI to connect to live FTP Servers for modeling, searching, and visualizing.
-
Use Manus AI to Talk to Your Tally 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 Tally ERP.
-
Integrate Cursor with Live Gong Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Gong from within the editor.
-
Connect to Eventbrite Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Eventbrite.
-
Connect to Oracle Eloqua Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Oracle Eloqua Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
LINQ to Postmark Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Postmark Data Provider.
-
Replicate Multiple HubSpot Accounts via the CData Sync CLI
Replicate multiple HubSpot accounts to one or many databases.
-
Access Live PayPal Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate PayPal into the statistical analysis tools available in SAS JMP. This article shows how to use PayPal in the Graph Builder and Query Builder.
-
Integrate Keap Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Keap from Informatica Cloud.
-
Bidirectional Access to Epicor Kinetic Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Epicor Kinetic in Filemaker Pro for Mac or Windows.
-
Import Zuora Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Zuora Data and provide access to live Zuora for custom reports in the Power BI Service.
-
Connect to and Query Facebook Ads Data in QlikView over ODBC
Create data visualizations with Facebook Ads in QlikView.
-
Update a Google Calendar with a Microsoft Access Linked Table
This article explains how to update Google Calendar events by creating a linked table in Microsoft Access with the CData ODBC Driver for Google Apps.
-
Build Neo4J-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Neo4J to explore live Neo4J Data in Cursor to assist with building Neo4J-powered applications.
-
Analyze SAP Hybris C4C Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP Hybris C4C and visualize live SAP Hybris C4C in Infragistics Reveal.
-
Build a Simple VCL Application for Humanity Data
How to build a simple VCL Application to view Humanity in RAD Studio using the CData ODBC Driver for Humanity.
-
Create Data Visualizations Based On Jira Data in Mode
Use CData Connect AI to connect to Jira Data from Mode and build visualizations using live
-
ETL Qualaroo in Oracle Data Integrator
This article shows how to transfer Qualaroo into a data warehouse using Oracle Data Integrator.
-
Build SAP Concur Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP Concur and build visualizations in Tableau.
-
Automate Egnyte Data Replication to Azure Data Lake
Use CData Sync to customize and automate Egnyte replication to Azure Data Lake.
-
How to Connect to Live Vertica Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Vertica securely in real time.
-
Migrating data from Confluence to Google BigQuery using CData SSIS Components.
Easily push Atlassian Confluence to Google BigQuery using the CData SSIS Tasks for Confluence and Google BigQuery.
-
Connect to Workable from a Connection Pool in WebLogic
Use the CData JDBC Driver for Workable to connect to Workable from Web applications running on WebLogic.
-
Create Informatica Mappings From/To an ODBC Data Source for Egnyte
Create an ODBC connection to Egnyte in Informatica and browse and transfer Egnyte.
-
Visualize Drift Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Drift.
-
Query JobNimbus Data through ODBC in Node.js
Use node-odbc to execute SQL queries against JobNimbus from Node.js.
-
Analyze Zoho Projects Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zoho Projects from Power Pivot. You will use the Table Import Wizard to load Zoho Projects. You can visually build the import query or use any SQL supported by the driver.
-
How to connect PolyBase to OData
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live OData.
-
Connect to Copper Data in DBeaver
Use the CData ODBC Driver to connect to Copper in DBeaver.
-
Replicate SQL Server Data in Heroku for Use in Salesforce Connect
Replicate Microsoft SQL Server to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect Redshift to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Amazon Redshift using the CData Python MCP Server.
-
Connect MariaDB Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your MariaDB using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Publish Teamwork-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Teamwork.
-
Connect to Databricks Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Databricks using standard SQL.
-
Analyze Deel Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Deel from Power Pivot. You will use the Table Import Wizard to load Deel. You can visually build the import query or use any SQL supported by the driver.
-
How to connect to Bullhorn CRM Data with Squirrel SQL client
Connect to Bullhorn CRM and execute queries in the Squirrel SQL Client.
-
Build Sage Intacct-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Sage Intacct to explore live Sage Intacct Data in Cursor to assist with building Sage Intacct-powered applications.
-
Integrate with SAP HANA XS Advanced Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP HANA XS Advanced to a JSON file on disk.
-
Publish Reports with Superchat Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Superchat.
-
Add LDAP Objects to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for LDAP with the Informatica Enterprise Data Catalog to classify and organize data.
-
Enable the xBase JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with xBase.
-
Build Vertica-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Vertica Data and create custom apps in Mendix.
-
Automated Continuous BambooHR Replication to Databricks
Use CData Sync for automated, continuous, customizable BambooHR replication to Databricks.
-
Connect to and Visualize Live Gorgias Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Gorgias.
-
Automated Continuous CampaignMonitor Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to OneLake in Microsoft Fabric.
-
Connect to MailerLite Data in Aqua Data Studio
Access MailerLite from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate LibreChat with Live Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Avalara AvaTax from within the chat interface.
-
Import and Visualize Templated Data in Power View
Create data visualizations based on Templated in Excel.
-
Query Amazon S3 Data as a SQL Server Database in Node.js
Execute SQL Server queries against Amazon S3 from Node.js.
-
Use the CData SSIS Components to Insert New or Update Existing Office 365 Records from SQL Server
Easily push SQL Server data to Office 365 using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Office 365 or update existing records with data from a SQL Server database.
-
Replicate Multiple Parquet Accounts via the CData Sync CLI
Replicate multiple Parquet accounts to one or many databases.
-
Create Informatica Mappings From/To a JDBC Data Source for BigCommerce
Create BigCommerce data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Discord from Asprova with CData Software ODBC Driver for Discord
This article shows how to connect faster to Discord data from Asprova.
-
Automated Continuous Paymo Replication to Snowflake
Use CData Sync for automated, continuous, customizable Paymo replication to Snowflake.
-
How to Seamlessly Import PDFMonkey Data into IBM SPSS Modeler
Integrate PDFMonkey data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Enable the Amplitude JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Amplitude.
-
Getting Started with the CData SSIS Components for Confluence
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Confluence.
-
How to import JSON Services into Apache Solr
Use the CData Software JDBC Driver for JSON in Data Import Handler and create an automated import of JSON to Apache Solr Enterprise Search platform.
-
Visualize Live SAP Netweaver Gateway Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP Netweaver Gateway using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Work with Twitter Ads Data in AWS Glue Jobs Using JDBC
Connect to Twitter Ads from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access MarkLogic 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 MarkLogic.
-
Moving Data from Microsoft OneDrive to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Microsoft OneDrive data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Prepare, Blend, and Analyze Power BI XMLA Data in Alteryx Designer (Connect AI)
Build workflows to access live Power BI XMLA for self-service data analytics.
-
Integrate Live Sage 200 Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Sage 200 and integrate live Sage 200 into apps built in Microsoft Power Apps.
-
Analyze Freshteam Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Freshteam from Power Pivot. You will use the Table Import Wizard to load Freshteam. You can visually build the import query or use any SQL supported by the driver.
-
Connect to FHIR Data from AWS Glue
Use CData Connect AI to gain access to live FHIR from your AWS Glue jobs.
-
Integrate Real-Time Access to Oracle HCM Cloud in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Oracle HCM Cloud in real time.
-
Connect to and Query RSS Feeds in QlikView over ODBC
Create data visualizations with RSS Feeds in QlikView.
-
Automated Continuous Todoist Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Todoist replication to PostgreSQL.
-
How to Query Marketo Data in MySQL Workbench
Execute MySQL queries against live Marketo from MySQL Workbench.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Redis
Provide connectivity to Redis through an SAP BusinessObjects universe.
-
Connect to and Query Zoom Data in QlikView over ODBC
Create data visualizations with Zoom in QlikView.
-
Publish Reports with TaxJar Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date TaxJar.
-
Connect to Placid Data in RazorSQL
Connect to Placid from wizards and query Placid from the GUI in the RazorSQL database management tool.
-
Integrating Dataiku with Google Directory 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 Directory.
-
Create Informatica Mappings From/To an ODBC Data Source for HCL Domino
Create an ODBC connection to HCL Domino in Informatica and browse and transfer HCL Domino.
-
Build Automated Okta-Connected Workflows in Zapier
Use CData Connect AI to connect to live Okta and build automated workflows in Zapier.
-
Build Humanity-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Humanity.
-
Use the CData Software ODBC Driver for Bright Data in MicroStrategy Desktop
Connect to Bright Data in MicroStrategy Desktop using the CData Software ODBC Driver for Bright Data.
-
Connect to Zoho CRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Zoho CRM.
-
How to Connect to Live Apollo Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Apollo without replication.
-
How to connect to Reckon Accounts Hosted Data in DBVisualizer
Integrate Reckon Accounts Hosted with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Query Live Gmail Data in Claude Desktop
Connect to and query live Gmail Data in Claude Desktop using CData MCP Server.
-
How to update Microsoft Teams from Excel
This article explains how to transfer data from Excel to Microsoft Teams using the Excel Add-In for Microsoft Teams.
-
Publish Reports with Close Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Close.
-
Connect to Azure DevOps Data in Aqua Data Studio
Access Azure DevOps from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData Software JDBC Driver for PostgreSQL in MicroStrategy
Connect to PostgreSQL in MicroStrategy Developer using the CData Software JDBC Driver for PostgreSQL.
-
How to work with Hacker News Data in Apache Spark using SQL
Access and process Hacker News Data in Apache Spark using the CData Software JDBC Driver.
-
Build Semantic Layer Views for Google Ads Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Ads.
-
Integrating Kiro CLI with Greenhouse 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 integrate Brex with Apache Airflow
Access and process Brex in Apache Airflow using the CData JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Power BI XMLA
Provide connectivity to Power BI XMLA through an SAP BusinessObjects universe.
-
How to Access Live Copper Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Copper enables you to integrate Copper into workflows built using Microsoft Power Automate Desktop.
-
Analyze Azure Table Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Azure Table Storage and visualize live Azure Table Storage in Infragistics Reveal.
-
Use the CData Software ODBC Driver for Microsoft Entra ID in MicroStrategy
Connect to Microsoft Entra ID in MicroStrategy Developer using the CData Software ODBC Driver for Microsoft Entra ID.
-
Integrate ZohoExpense with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ZohoExpense with External Services.
-
Use the CData Software ODBC Driver for SQL Server in MicroStrategy Desktop
Connect to Microsoft SQL Server in MicroStrategy Desktop using the CData Software ODBC Driver for SQL Server.