CData Software - Knowledge Base
Recent Articles
-
Build an OLAP Cube in SSAS from LinkedIn Ads Data
Establish a connection to LinkedIn Ads data data from SQL Server Analysis Services, and use the LinkedIn Ads Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize Live SAP Ariba Procurement Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP Ariba Procurement data into custom reports in Power BI.
-
Connect to ServiceNow Data in HULFT Integrate
Connect to ServiceNow as a JDBC data source in HULFT Integrate
-
Getting Started with the CData Power BI Connector for Beeminder
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to connect PolyBase to LeadDesk
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live LeadDesk data.
-
Work with OnePageCrm Data in FoxPro
Load OnePageCrm data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Moving Data from Greenplum to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Greenplum data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Pipeliner CRM Data in RazorSQL
Connect to Pipeliner CRM from wizards and query Pipeliner CRM data from the GUI in the RazorSQL database management tool.
-
How to Connect to Live Paymo Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Paymo data for you.
-
How to Connect to SAP Fieldglass Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP Fieldglass data. Leverage the pyodbc module for ODBC in Python.
-
Connect to MYOB AccountRight Data in NetBeans
Connect to MYOB AccountRight data in NetBeans with the data source configuration wizard.
-
Connect to SAP Hybris C4C Data from a Connection Pool in Jetty
The SAP Hybris C4C JDBC Driver supports connection pooling: This article shows how to connect faster to SAP Hybris C4C data from Web apps in Jetty.
-
Build Semantic Layer Views for VWO Data in APOS Live Data Gateway
Use the CData Connector for VWO in APOS Live Data Gateway to build Semantic Layer Views for VWO data.
-
Use the CData ODBC Driver for MailerSend from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for MailerSend to connect to MailerSend data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring MailerSend data in Excel.
-
Connecting Mastra with Microsoft Ads 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 Microsoft Ads data, no replication required.
-
Visualize Certinia Data in Tableau
The CData ODBC driver for Certinia enables you integrate Certinia data into Tableau dashboards.
-
Build Data Flows from AfterShip to SQL Server using SSIS
Easily back up AfterShip data to SQL Server using the SSIS components for AfterShip.
-
Replicate YouTube Analytics Data from PowerShell
Write a quick PowerShell script to query YouTube Analytics data. Use connectivity to the live data to replicate YouTube Analytics data to SQL Server.
-
Connect to Tanda Data in RazorSQL
Connect to Tanda from wizards and query Tanda data from the GUI in the RazorSQL database management tool.
-
Connect to Kintone from a Connection Pool in WebLogic
Use the CData JDBC Driver for Kintone to connect to Kintone data from Web applications running on WebLogic.
-
Integrating Antigravity CLI with Paddle data via CData CLI
Connect Paddle data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData Excel Add-In for Retently
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Retently.
-
Integrate Open WebUI with Live Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Oracle SCM data from within the chat interface.
-
Connect to Webflow Data in RapidMiner
Integrate Webflow data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Boomi Agentstudio with HBase Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to HBase data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Analyze Pushbullet Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Pushbullet data with the CData JDBC Driver for Pushbullet.
-
Query Avalara AvaTax Data as a SQL Server Database in Node.js
Execute SQL Server queries against Avalara AvaTax data from Node.js.
-
Integrating Claude Code with Bitbucket Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Bitbucket data within assisted coding and automated development workflows.
-
Interact with Live GitHub Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live GitHub data.
-
A PostgreSQL Interface for Blackbaud FE NXT Data (MySQL Remoting via JDBC)
Use the Remoting features of the Blackbaud FE NXT JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build AI Agents with Yelp 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 Yelp data through CData Connect AI.
-
Automated Continuous Discourse Replication to SQL Server
Use CData Sync for automated, continuous, customizable Discourse replication to SQL Server.
-
Natively Connect to Adobe Target Data in PHP
The CData ODBC driver for Adobe Target enables you to create PHP applications with connectivity to Adobe Target data. Leverage the native support for ODBC in PHP.
-
Automated Salesforce Data Replication to Teradata
Use CData Sync to Customize and automate Salesforce data replication to Teradata.
-
Replicate Amazon DynamoDB Data to Multiple Databases via the CData Sync CLI
Replicate Amazon DynamoDB data to disparate databases with a single configuration.
-
Replicate Google Sheets Data to Multiple Databases via the CData Sync CLI
Replicate Google Sheets data to disparate databases with a single configuration.
-
Integrating Boomi Agentstudio with Freshdesk Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Freshdesk data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use the CData Software JDBC Driver for Helpscout in MicroStrategy Web
Connect to Helpscout data in MicroStrategy Web using the CData Software JDBC Driver for Helpscout.
-
How to load MongoDB data into Elasticsearch via Logstash
Introducing a simple method to load MongoDB data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData ODBC Driver for Eventbrite in Microsoft Power Query
You can use the CData Eventbrite ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Eventbrite data into Microsoft Power Query.
-
Connect to MongoDB Data from AWS Glue
Use CData Connect AI to gain access to live MongoDB data from your AWS Glue jobs.
-
Connecting Mastra with SAP Fieldglass 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 SAP Fieldglass data, no replication required.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Airtable
Provide connectivity to Airtable data through an SAP BusinessObjects universe.
-
Visualize Monday.com Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Monday.com data.
-
How to connect PolyBase to Shopify
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Shopify data.
-
Connect to Salesforce CRM Analytics Data from PowerBuilder via JDBC
This article demonstrates how to access Salesforce CRM Analytics data from PowerBuilder using the Salesforce CRM Analytics JDBC Driver.
-
Automated Continuous Sentry Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Sentry replication to PostgreSQL.
-
Automate Pushbullet Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Pushbullet data from PowerShell? This article demonstrates how to utilize the Pushbullet Cmdlets for tasks like connecting to Pushbullet data, automating operations, downloading data, and more.
-
Build Automated HBase-Connected Workflows in Zapier
Use CData Connect AI to connect to live HBase data and build automated workflows in Zapier.
-
Connect to Real-Time SharePoint Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SharePoint and Dataflow to import and use SharePoint data in Power Apps.
-
Natively Connect to Freshteam Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Freshteam data. Leverage the native support for ODBC in PHP.
-
Configure the CData JDBC Driver for Scrapfly in a Connection Pool in Tomcat
Connect to Scrapfly data from a connection pool in Tomcat.
-
How to Connect to Live ZohoSubscriptions Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live ZohoSubscriptions data without replication.
-
Build SingleStore-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SingleStore Data and create custom apps in Bubble.
-
Moving Data from Adobe Experience Manager to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Adobe Experience Manager data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Bugsnag Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Bugsnag replication to Amazon Redshift.
-
Exact Online Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Exact Online data through CData Connect AI using different applications and tools.
-
Use Biml to Build SSIS Tasks to Replicate ConstantContact Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ConstantContact data to SQL Server.
-
Automated Continuous Microsoft Entra ID Replication to Oracle
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to Oracle.
-
Connect to Google Sheets Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Sheets data.
-
How to Work with Shippo Data in AWS Glue Jobs Using JDBC
Connect to Shippo from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Live Tavily Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Tavily data.
-
Back Up Pipeliner CRM data 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 Pipeliner CRM data data.
-
Import Real-Time Authorize.Net Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Authorize.Net data in ColdFusion.
-
Use the CData ODBC Driver for Teradata in Microsoft Power Query
You can use the CData Teradata ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Teradata data into Microsoft Power Query.
-
Create a Data Access Object for Bannerbear Data using JDBI
A brief overview of creating a SQL Object API for Bannerbear data in JDBI.
-
Connect to Samanage Data in Aqua Data Studio
Access Samanage data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Dashboards with TigerGraph Data in DBxtra
Create dynamic dashboards and perform analytics based on TigerGraph data in DBxtra.
-
Visualize ZohoInvoice Data in Tableau
The CData ODBC driver for ZohoInvoice enables you integrate ZohoInvoice data into Tableau dashboards.
-
Use the CData Software JDBC Driver for MailChimp in MicroStrategy
Connect to MailChimp data in MicroStrategy Developer using the CData Software JDBC Driver for MailChimp.
-
Use the CData Software JDBC Driver for ZohoDesk in MicroStrategy Web
Connect to ZohoDesk data in MicroStrategy Web using the CData Software JDBC Driver for ZohoDesk.
-
How to Connect to Live Lakebase Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Lakebase data for you.
-
Getting Started with the CData SSIS Components for Miro
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Miro.
-
Publish Reports with Impala Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Impala data.
-
How to Connect to Live Printify Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Printify data securely in real time.
-
Create Data Visualizations in Cognos BI with Power BI XMLA Data
Access Power BI XMLA data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Back Up Basecamp data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Basecamp. In this article, we will employ an SSIS workflow to populate a database with Basecamp data data.
-
Create CSV-Connected Applications in Appsmith
Connect to CSV Data via CData Connect AI in Appsmith and create custom business applications with real-time access to CSV data.
-
Natively Connect to Snowflake Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Snowflake data. Leverage the native support for ODBC in PHP.
-
Add Azure Analysis Services Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Azure Analysis Services with the Informatica Enterprise Data Catalog to classify and organize data.
-
Moving Data from Microsoft Ads to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Microsoft Ads data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Consume Monday.com OData Feeds in PowerBuilder
This article demonstrates how to consume Monday.com data as OData feeds from PowerBuilder using the API Server.
-
How to create an RPA flow for Codat Data in UiPath Studio
Use the Codat ODBC Driver to create workflows that access real-time Codat data without any coding.
-
Visualize Sugar CRM Data in Tableau
The CData ODBC driver for Sugar CRM enables you integrate Sugar CRM data into Tableau dashboards.
-
Model, Search, and Visualize Live SAP SuccessFactors LMS Data in ThoughtSpot
Use CData Connect AI to connect to live SAP SuccessFactors LMS data for modeling, searching, and visualizing.
-
A PostgreSQL Interface for Presto Data using the CData ODBC Driver
Use the SQL Gateway and Presto ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to and Query CSV Data in QlikView over ODBC
Create data visualizations with CSV data in QlikView.
-
Create Informatica Mappings From/To an ODBC Data Source for PingOne
Create an ODBC connection to PingOne in Informatica and browse and transfer PingOne data.
-
Use the CData ODBC Driver for Keap in Microsoft Power Query
You can use the CData Keap ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Keap data into Microsoft Power Query.
-
Visualize Live Oracle SCM Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Oracle SCM data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software JDBC Driver for Jumpseller in MicroStrategy Desktop
Connect to Jumpseller data in MicroStrategy Desktop using the CData Software JDBC Driver for Jumpseller.
-
Manage Klipfolio Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Klipfolio.
-
Build an OLAP Cube in SSAS from Act-On Data
Establish a connection to Act-On data data from SQL Server Analysis Services, and use the Act-On Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate with Live Elasticsearch Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Elasticsearch from the MuleSoft Anypoint Platform to integrate live Elasticsearch data into custom reports and dashboards.
-
Create ConstantContact-Connected Nintex Workflows
Use CData Connect AI to connect to ConstantContact Data from Nintex Workflow Cloud and build custom workflows using live ConstantContact data.
-
A PostgreSQL Interface for Wrike Data (MySQL Remoting via JDBC)
Use the Remoting features of the Wrike JDBC Driver to create a PostgreSQL entry-point for data access.
-
LINQ to CapsuleCRM 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 CapsuleCRM Data Provider.
-
Natively Connect to HCL Domino Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to HCL Domino data. Leverage the native support for ODBC in PHP.
-
Integrate with Live ZohoSubscriptions Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to ZohoSubscriptions from the MuleSoft Anypoint Platform to integrate live ZohoSubscriptions data into custom reports and dashboards.
-
Integrate YouTube Analytics Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to YouTube Analytics data and integrate live YouTube Analytics data into your Power Automate tasks.