CData Software - Knowledge Base
Recent Articles
-
Use the CData Software JDBC Driver for Dynamics CRM in MicroStrategy
Connect to Dynamics CRM data in MicroStrategy Developer using the CData Software JDBC Driver for Dynamics CRM.
-
Build an OLAP Cube in SSAS from Gmail Data
Establish a connection to Gmail data data from SQL Server Analysis Services, and use the Gmail Data Provider to build OLAP cubes for use in analytics and reporting.
-
Back Up Workday data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Workday. In this article, we will employ an SSIS workflow to populate a database with Workday data data.
-
Build a PostgreSQL Interface for Azure Data Lake Storage Data using the CData JDBC Driver
Use the Remoting features of the Azure Data Lake Storage JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Crystal Reports on Rootly Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Rootly data.
-
Integrate Live Kintone Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Kintone data from within the IDE.
-
Using the CData Software ODBC Driver for Wistia in PyCharm
Connect to Wistia as an ODBC data source in PyCharm using the CData Software ODBC Driver for Wistia.
-
Validate Salesforce Data with QuerySurge
Access and validate Salesforce data in QuerySurge using the CData JDBC Driver.
-
Replicate Microsoft Teams Data from PowerShell
Write a quick PowerShell script to query Microsoft Teams data. Use connectivity to the live data to replicate Microsoft Teams data to SQL Server.
-
Replicate Rootly Data to Multiple Databases via the CData Sync CLI
Replicate Rootly data to disparate databases with a single configuration.
-
Easily Integrate NASA Data in Lazarus Pascal IDE
Learn how to easily integrate live NASA data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Cursor with Live Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Zoho Inventory data from within the editor.
-
Build Data Flows from Azure Data Lake Storage to SQL Server using SSIS
Easily back up Azure Data Lake Storage data to SQL Server using the SSIS components for Azure Data Lake Storage.
-
Operational Reporting on Printify Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Printify data.
-
Integrate Live DB2 Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live DB2 data from within the IDE.
-
DataBind Controls to Acumatica Data in Delphi
DataBind to Acumatica data in Delphi with standard data access components and controls.
-
Integrate with Live Microsoft Entra ID Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Entra ID from the MuleSoft Anypoint Platform to integrate live Microsoft Entra ID data into custom reports and dashboards.
-
Access Live Salesforce CRM Analytics Data in Excel 365 Online (Excel for the web)
Connect to Salesforce CRM Analytics data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous Excel Replication to SingleStore
Use CData Sync for automated, continuous, customizable Excel replication to SingleStore.
-
Process & Analyze Recurly Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Recurly Data.
-
Automate CapsuleCRM Data Replication to SAP HANA
Use CData Sync to customize and automate CapsuleCRM data replication to SAP HANA.
-
Build Semantic Layer Views for FormSite Data in APOS Live Data Gateway
Use the CData Connector for FormSite in APOS Live Data Gateway to build Semantic Layer Views for FormSite data.
-
Choosing the Best Method to Connect Stack Exchange to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Stack Exchange data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Replicate ShipEngine Data to Multiple Databases via the CData Sync CLI
Replicate ShipEngine data to disparate databases with a single configuration.
-
Integrate Live Freshdesk Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Freshdesk data to Blue Prism using the CData ODBC Driver for Freshdesk to create automated workflows for repetitive business tasks.
-
Build Data Flows from Copper to SQL Server using SSIS
Easily back up Copper data to SQL Server using the SSIS components for Copper.
-
Natively Connect to Sentry Data in PHP
The CData ODBC driver for Sentry enables you to create PHP applications with connectivity to Sentry data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Gong Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Gong replication to AlloyDB.
-
Integrate DocuSign Data into Power Automate Desktop using CData Connect
CData Connect for DocuSign Data enables you to integrate DocuSign data into workflows built using Microsoft Power Automate Desktop.
-
Replicate Landbot Data in Heroku for Use in Salesforce Connect
Replicate Landbot data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Getting Started with the CData Tableau Connector for Suadeo
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Suadeo.
-
Import Real-Time Freshservice Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Freshservice data in ColdFusion.
-
Automated Continuous SpaceX Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SpaceX replication to Azure SQL Database.
-
Choosing the Best Method to Connect Confluence to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Confluence data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Informatica Mappings From/To a JDBC Data Source for HBase
Create HBase data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Model LinkedIn Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and LinkedIn, enabling the direct import of real-time LinkedIn data.
-
Build SingleStore Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SingleStore data and build visualizations in Tableau.
-
Integrate Devin with Live TaxJar Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live TaxJar data.
-
Visualize Live Phoenix Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Phoenix data.
-
Connect to Microsoft Teams Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Microsoft Teams data.
-
How to Easily Query Retently Data in OpenOffice Base
Connect to Retently data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Bidirectional Access to Active Directory Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Active Directory data in Filemaker Pro for Mac or Windows.
-
Process & Analyze Perplexity Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Perplexity Data.
-
Visualize Jira Data in TIBCO Spotfire through ADO.NET
Integrate Jira data into dashboards in TIBCO Spotfire.
-
Access Lakebase Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Lakebase data from your Oracle system.
-
How to create an RPA flow for Printify Data in UiPath Studio
Use the Printify ODBC Driver to create workflows that access real-time Printify data without any coding.
-
Automated Continuous Elorus Replication to SQLite
Use CData Sync for automated, continuous, customizable Elorus replication to SQLite.
-
Build MVC Applications with Connectivity to SuiteCRM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SuiteCRM from an ASP.NET MVC application.
-
Automated Continuous Mixpanel Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Mixpanel replication to Amazon Redshift.
-
Automated Continuous Salesforce Marketing Replication to Snowflake
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Snowflake.
-
Build Apps with Live Freshsales Data Using the Low-Code Development Platform of Mendix
Connect Freshsales data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to and Visualize Live Unbounce Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Unbounce data.
-
Visualize Excel Data in TIBCO Spotfire through OData
Integrate Excel data into dashboards in TIBCO Spotfire.
-
How to Seamlessly Import SuiteCRM Data into IBM SPSS Modeler
Integrate SuiteCRM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access FHIR 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 FHIR data.
-
Getting Started with the CData Tableau Connector for Postmark
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to Kintone Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Kintone.
-
Query Live Lakebase Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Lakebase data through a conversational interface.
-
Connect Planio to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Planio data using the CData Python MCP Server.
-
How to Visualize Toggl Data in Python with pandas
Use pandas and other modules to analyze and visualize live Toggl data in Python.
-
Connect to and Query WooCommerce Data in QlikView over ODBC
Create data visualizations with WooCommerce data in QlikView.
-
How to use SQLAlchemy ORM to access Wistia Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Wistia data.
-
Build Apps with Live ServiceDesk Plus data in Adalo using CData Connect AI
Use CData Connect AI to integrate live ServiceDesk Plus data into the Adalo platform and build custom mobile and web applications with real-time ServiceDesk Plus data.
-
Analyze Microsoft Dataverse Data in Cognos Analytics
Use CData Connect AI to connect to Microsoft Dataverse Data from Cognos Analytics and analyze live Microsoft Dataverse data.
-
Access Live Sage Cloud Accounting Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sage Cloud Accounting data from your Google Sheets.
-
Access Live IBM Informix 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 IBM Informix data through MCP integration.
-
Connect to ZohoMarketingHub Data in RazorSQL
Connect to ZohoMarketingHub from wizards and query ZohoMarketingHub data from the GUI in the RazorSQL database management tool.
-
Create Informatica Mappings From/To an ODBC Data Source for Sybase
Create an ODBC connection to Sybase in Informatica and browse and transfer Sybase data.
-
Connect to IBM Informix Data in Ruby
Connect to IBM Informix data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Live Samanage Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Samanage data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Cassandra Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Cassandra data through CData Connect AI using different applications and tools.
-
Connect to Invoiced Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Invoiced as an External Source in Dremio.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Aircall
Provide connectivity to Aircall data through an SAP BusinessObjects universe.
-
Operational Reporting on Twilio Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Twilio data.
-
Integrate Dify with Live MongoDB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live MongoDB data.
-
A PostgreSQL Interface for OneNote Data (MySQL Remoting via JDBC)
Use the Remoting features of the OneNote JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Zoom 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 Zoom data into TIBCO Spotfire.
-
Getting Started with the CData SSIS Components for Supabase
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Supabase.
-
Replicate Adobe Analytics Data from PowerShell
Write a quick PowerShell script to query Adobe Analytics data. Use connectivity to the live data to replicate Adobe Analytics data to SQL Server.
-
Operational Reporting on Neo4J Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Neo4J data.
-
A PostgreSQL Interface for Qualaroo Data (MySQL Remoting via JDBC)
Use the Remoting features of the Qualaroo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData ODBC Driver for Salesforce from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Salesforce to connect to Salesforce data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Salesforce data in Excel.
-
Model, Search, and Visualize Live Zoom Data in ThoughtSpot
Use CData Connect AI to connect to live Zoom data for modeling, searching, and visualizing.
-
How to connect to Salesforce Marketing Data with Squirrel SQL client
Connect to Salesforce Marketing data and execute queries in the Squirrel SQL Client.
-
Connect to Superchat Data in HULFT Integrate
Connect to Superchat as a JDBC data source in HULFT Integrate
-
Create Informatica Mappings From/To a JDBC Data Source for Pipedrive
Create Pipedrive data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use CData Connect AI to Access Apify Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Apify data in the Power Pivot business intelligence tool.
-
How to integrate Metabase with Highrise Data
Use CData Connect AI to connect to live Highrise data and create an interactive dashboard in Metabase from Highrise data.
-
How to connect to ServiceNow Data from Spring Boot
Connect to ServiceNow in a Spring Boot Application using the CData JDBC Driver for ServiceNow
-
Integrate Theia IDE with Live Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Dropbox data from within the development environment.
-
Connect to Confluence from a Connection Pool in WebLogic
Use the CData JDBC Driver for Confluence to connect to Confluence data from Web applications running on WebLogic.
-
How to connect Amazon QuickSight to Salesforce Data
Create a connection to Salesforce data in CData Connect AI and insert Salesforce data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Seamlessly Import Supabase Data into IBM SPSS Modeler
Integrate Supabase data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Cursor with Live Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Amazon DynamoDB data from within the editor.
-
Access CampaignMonitor 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 CampaignMonitor data.
-
Use the CData Software ODBC Driver for Sybase IQ in SAS for Real-Time Reporting and Analytics
Connect to real-time Sybase IQ data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Sybase IQ.
-
Integrating Cursor with Dynamics CRM 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 connect to Kintone Data from IntelliJ
Integrate connectivity to Kintone data with wizards in IntelliJ.
-
Analyze Bright Data Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Bright Data data in Microsoft R Open.
-
Automated Continuous GitLab Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable GitLab replication to Google BigQuery.