CData Software - Knowledge Base
Recent Articles
-
Establish a Live Connection with SendGrid Data using Tableau Bridge
The CData ODBC Driver for SendGrid enables you to integrate live SendGrid into Tableau Cloud dashboards using the Tableau Bridge.
-
Getting Started with the CData Power BI Connector for Highrise
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Highrise.
-
Connect to ADP Data in Google Apps Script via Connect AI
Use CData Connect AI to access ADP in Google Apps Script.
-
Getting Started with the CData ADO.NET Provider for SAS xpt
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAS xpt.
-
Use the CData Software JDBC Driver for ConvertAPI in MicroStrategy Desktop
Connect to ConvertAPI in MicroStrategy Desktop using the CData Software JDBC Driver for ConvertAPI.
-
Analyze Oracle Service Cloud Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Oracle Service Cloud and visualize live Oracle Service Cloud in Infragistics Reveal.
-
Migrating data from SAP HANA to Databricks using CData SSIS Components.
Easily push SAP HANA to Databricks using the CData SSIS Tasks for SAP HANA and Databricks.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP SuccessFactors LMS
Create an ODBC connection to SAP SuccessFactors LMS in Informatica and browse and transfer SAP SuccessFactors LMS.
-
Visualize Pinterest Data in TIBCO Spotfire through OData
Integrate Pinterest into dashboards in TIBCO Spotfire.
-
Visualize Azure DevOps 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 Azure DevOps into TIBCO Spotfire.
-
Connect to Pipeliner CRM Data from a Connection Pool in JBoss
Integrate Pipeliner CRM into Java servlets: Use the Management Console in JBoss to install the Pipeliner CRM JDBC Driver.
-
Access Live FHIR 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 FHIR through MCP integration.
-
Deploy the ADO.NET Provider for Tanda on an SSRS Report Server
Connect to Tanda from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Automate Opsgenie Data Replication to SAP HANA
Use CData Sync to customize and automate Opsgenie replication to SAP HANA.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Slack using the Model Context Protocol.
-
DataBind Charts to Brex Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Brex from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Automated Continuous Delighted Replication to MySQL
Use CData Sync for automated, continuous, customizable Delighted replication to MySQL.
-
Create Dynamic Greenhouse Grids Using the Infragistics XamDataGrid
Learn how you can connect Greenhouse to Infragistics XamDataGrid to build dynamic grids.
-
How to Query FreshBooks Data in MySQL Workbench
Execute MySQL queries against live FreshBooks from MySQL Workbench.
-
Object-Relational Mapping (ORM) with Aircall Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Aircall into a Java-based ORM framework, Hibernate.
-
Automated Continuous Access Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Access replication to delimited files (CSV/TSV).
-
How to import Greenplum Data into Apache Solr
Use the CData Software JDBC Driver for Greenplum in Data Import Handler and create an automated import of Pivotal GreenPlum to Apache Solr Enterprise Search platform.
-
Integrating Cursor CLI with Sybase IQ 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.
-
Integrating Cursor CLI with Bitly 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.
-
Integrate Cline with Live BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live BigCommerce from within your IDE.
-
Migrating data from Asana to Databricks using CData SSIS Components.
Easily push Asana to Databricks using the CData SSIS Tasks for Asana and Databricks.
-
How to Connect to & Open Twitter Ads Data in Microsoft Excel
This article uses the CData ODBC driver for Twitter Ads to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Highrise Data in Jaspersoft Studio
Execute SQL to remote Highrise CRM in Jaspersoft Studio.
-
Integrate eBay Analytics Data in the Pentaho Report Designer
Publish reports based on eBay Analytics in the Pentaho BI tool.
-
Automated Continuous Printify Replication to Snowflake
Use CData Sync for automated, continuous, customizable Printify replication to Snowflake.
-
Validate Sybase Data with QuerySurge
Access and validate Sybase in QuerySurge using the CData JDBC Driver.
-
Connect to Klipfolio Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Oracle Service Cloud Data from MySQL in Amazon QuickSight
Connect to Oracle Service Cloud and build visualizations of Oracle Service Cloud using a MySQL Connection in Amazon QuickSight.
-
How to integrate Metabase with Microsoft Exchange Data
Use CData Connect AI to connect to live Microsoft Exchange and create an interactive dashboard in Metabase from Microsoft Exchange.
-
Analyze Webex Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Webex with the CData JDBC Driver for Webex.
-
How to Connect to GitLab Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to GitLab. Leverage the pyodbc module for ODBC in Python.
-
How to connect to Bitbucket Data in DBVisualizer
Integrate Bitbucket with visual data analysis tools and data connection wizards in DBVisualizer
-
Connecting Moonlit Workflow with MariaDB 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 MariaDB in real time.
-
Connect to NetSuite SuiteAnalytics Data from AWS Glue
Use CData Connect AI to gain access to live NetSuite SuiteAnalytics from your AWS Glue jobs.
-
How to Visualize Facebook Ads 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 Facebook Ads in Python.
-
Getting Started with the CData ODBC Driver for Notion
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Notion.
-
Connect SendInBlue to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SendInBlue with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Live FHIR Data in PostGresSQL Interface through CData Connect AI
Create a live connection to FHIR in CData Connect AI and connect to your FHIR from PostgreSQL.
-
Replicate OneNote Data from PowerShell
Write a quick PowerShell script to query Microsoft OneNote. Use connectivity to the live data to replicate Microsoft OneNote to SQL Server.
-
How to Connect DBeaver to Everhour via a JDBC Driver
Manage Everhour with visual tools in DBeaver like the query browser.
-
Replicate Salesforce Pardot Data in Heroku for Use in Salesforce Connect
Replicate Salesforce Pardot to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Getting Started with the CData Tableau Connector for RSS
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for RSS.
-
Extract, Transform, and Load LinkedIn Data in Informatica PowerCenter
Create a simple Workflow for LinkedIn in Informatica PowerCenter.
-
How to integrate Azure DevOps with Apache Airflow
Access and process Azure DevOps in Apache Airflow using the CData JDBC Driver.
-
Query Google Directory Data in DataGrip
Create a Data Source for Google Directory in DataGrip and use SQL to query live Google Directory.
-
Build Charts with Pipeline CRM Data in Clear Analytics
Create dynamic charts and perform analytics based on Pipeline CRM in Clear Analytics.
-
Analyze Zoho Inventory Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Zoho Inventory and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrating Adobe Experience Manager Data in Talend Cloud Data Management Platform
Connect Adobe Experience Manager Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Adobe Experience Manager.
-
Create SSAS Tabular Models from Bugsnag Data
How to build a SQL Server Analysis Service Tabular Model from Bugsnag using CData drivers.
-
How to create Strava federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Strava in MySQL .
-
Integrate BambooHR Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to BambooHR and integrate live BambooHR into your Power Automate tasks.
-
Integrating Kiro CLI with Drip 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.
-
Object-Relational Mapping (ORM) with Adobe Experience Manager Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Adobe Experience Manager into a Java-based ORM framework, Hibernate.
-
Build Short.io-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Short.io and build web apps with connectivity to live Short.io.
-
Design BIRT Reports on FTP Data
Provide current FTP Servers to your embedded analytics.
-
How to Access Azure DevOps Data Using Entity Framework
This article shows how to access Azure DevOps using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Dashboards and Visualize Live Adobe Analytics Data in Geckoboard
Use CData Connect AI to connect to live Adobe Analytics and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Bridge QuickBooks Online Connectivity with Apache NiFi
Access and process QuickBooks Online in Apache NiFi using the CData JDBC Driver.
-
Automated LDAP Objects Replication to Teradata
Use CData Sync to Customize and automate LDAP replication to Teradata.
-
Create Sugar CRM-Connected Nintex Workflows
Use CData Connect AI to connect to Sugar CRM Data from Nintex Workflow Cloud and build custom workflows using live Sugar CRM.
-
Stream Elorus Data into Apache Kafka Topics
Access and stream Elorus in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Replicate Multiple GetResponse Accounts via the CData Sync CLI
Replicate multiple GetResponse accounts to one or many databases.
-
Build Azure Synapse-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Azure Synapse to explore live Azure Synapse Data in Cursor to assist with building Azure Synapse-powered applications.
-
Add Harvest Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Harvest with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Biml to Build SSIS Tasks to Replicate Contentful Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Contentful to SQL Server.
-
Visualize Zoho Creator Data in TIBCO Spotfire through ADO.NET
Integrate Zoho Creator into dashboards in TIBCO Spotfire.
-
DataBind Charts to MessageBird Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to MessageBird from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Analyze Spark Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Spark from Power Pivot. You will use the Table Import Wizard to load Apache Spark SQL. You can visually build the import query or use any SQL supported by the driver.
-
Extract, Transform, and Load Elorus Data in Informatica PowerCenter
Create a simple Workflow for Elorus in Informatica PowerCenter.
-
Moving Data from Odoo to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Odoo data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Microsoft Copilot Studio to talk to your Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Snowflake for you.
-
Build Jira-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Jira Data and create custom apps in Mendix.
-
Bind Live Bitbucket Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Bitbucket data
-
Enable the Paddle JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Paddle.
-
Create Klaviyo Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Klaviyo from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Microsoft Ads using the Model Context Protocol.
-
Integrate Act CRM Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Act CRM and integrate live Act CRM into your Power Automate tasks.
-
Integrate FreeAgent Data in Pentaho Data Integration
Build ETL pipelines based on FreeAgent in the Pentaho Data Integration tool.
-
Use the CData Software JDBC Driver for Google Tasks in MicroStrategy Web
Connect to Google Tasks in MicroStrategy Web using the CData Software JDBC Driver for Google Tasks.
-
Connect to Qualaroo Data in JRuby
Create a simple JRuby app with access to live Qualaroo.
-
Back Up Atlassian Confluence to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Confluence. In this article, we will employ an SSIS workflow to populate a database with Atlassian Confluence data.
-
Automated Continuous Excel Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Excel replication to Amazon Redshift.
-
Integrate Live Google Analytics Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create Stripe-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Stripe Data from OutSystems and build custom enterprise apps using live Stripe.
-
DataBind Charts to Printful Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Printful from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Integrating HBase Data in Talend Cloud Data Management Platform
Connect HBase Data with Talend Cloud Data Management Platform using the CData JDBC Driver for HBase.
-
Connect to Redis Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Redis using standard SQL.
-
Bind Live Tally Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Tally data
-
Import Real-Time Workday Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Workday in ColdFusion.
-
Visualize PostgreSQL Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to PostgreSQL.
-
Use Dash to Build to Web Apps on Basecamp Data
Create Python applications that use pandas and Dash to build Basecamp-connected web apps.
-
Validate SendGrid Data with QuerySurge
Access and validate SendGrid in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Spark Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Spark replication to delimited files (CSV/TSV).
-
Create Power BI Reports on Real-Time Productboard Data
Use the CData ODBC Driver for Productboard to visualize Productboard in Power BI Desktop.
-
Access SAP Netweaver Gateway Data from MySQL in PHP
Connect to SAP Netweaver Gateway through the standard MySQL libraries in PHP.