CData Software - Knowledge Base
Recent Articles
-
Import Sage Intacct Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Sage Intacct Data and provide access to live Sage Intacct for custom reports in the Power BI Service.
-
Use Claude to Talk to Your Klaviyo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Klaviyo for you.
-
Connect to CircleCI Data in DBeaver
Use the CData ODBC Driver to connect to CircleCI in DBeaver.
-
Build EnterpriseDB-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for EnterpriseDB to explore live EnterpriseDB Data in Gemini Code Assist to assist with building EnterpriseDB-powered applications.
-
Connect to Avro Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Apache Avro in Airbyte.
-
Create a Data Access Object for Flowlu Data using JDBI
A brief overview of creating a SQL Object API for Flowlu in JDBI.
-
How to connect to Box Data in DBVisualizer
Integrate Box with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Pipedrive-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Pipedrive and build Pipedrive-connected web apps with Axios.
-
Connect to OpenWeatherMap Data in HULFT Integrate
Connect to OpenWeatherMap as a JDBC data source in HULFT Integrate
-
Connecting Moonlit Workflow with Oracle Sales 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 Oracle Sales in real time.
-
Connect to Coda Data in RazorSQL
Connect to Coda from wizards and query Coda from the GUI in the RazorSQL database management tool.
-
Automated Continuous Bullhorn CRM Replication to MySQL
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to MySQL.
-
Building Dynamic Web Pages with Guru Data Using AngularJS
Create single-page applications with live connectivity to Guru using the CData API Server.
-
Visualize Oracle HCM Cloud Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Oracle HCM Cloud.
-
Build SAS Data Sets-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAS Data Sets and build web apps with connectivity to live SAS Data Sets.
-
Automated Continuous PabblySubscriptions Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Apache Cassandra.
-
Automated Continuous MailChimp Replication to MySQL
Use CData Sync for automated, continuous, customizable MailChimp replication to MySQL.
-
Access Google Contacts Data from MySQL in PHP
Connect to Google Contacts through the standard MySQL libraries in PHP.
-
Build Visualizations of SendInBlue Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SendInBlue in Birst.
-
Build Dashboards with Sage Cloud Accounting Data in Dundas BI
Create dynamic dashboards and perform analytics based on Sage Business Cloud Accounting in Dundas BI.
-
Access Live Monday.com Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Monday.com from your Excel spreadsheets.
-
How to Visualize Webex Data in Python with pandas
Use pandas and other modules to analyze and visualize live Webex in Python.
-
Connect SAP Business Warehouse to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP Business Warehouse with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Google Spanner Data in the Pentaho Report Designer
Publish reports based on Google Spanner in the Pentaho BI tool.
-
Create ServiceNow-Connected Applications in Appsmith
Connect to ServiceNow Data via CData Connect AI in Appsmith and create custom business applications with real-time access to ServiceNow.
-
How to connect PolyBase to LinkedIn
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live LinkedIn.
-
Visualize OneNote 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 Microsoft OneNote into TIBCO Spotfire.
-
Integrate Live Pipedrive Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Build MVC Applications with Connectivity to Tally Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Tally from an ASP.NET MVC application.
-
How to Connect the Power BI Service to SharePoint Excel Services: Complete Guide
Connect to the CData Software Power BI Connector for SharePoint Excel Services from PowerBI.com to provide real-time SharePoint Excel Services across the organization.
-
Create Informatica Mappings From/To a JDBC Data Source for Flowlu
Create Flowlu data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Data Flows from Vimeo to SQL Server using SSIS
Easily back up Vimeo to SQL Server using the SSIS components for Vimeo.
-
Manage Keap Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Keap.
-
How to connect to Cosmos DB Data with Squirrel SQL client
Connect to Azure Cosmos DB and execute queries in the Squirrel SQL Client.
-
How to Connect to Live Sugar CRM 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 Sugar CRM for you.
-
How to Connect to Live Sybase Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Sybase for you.
-
Integrating Cursor CLI with Google Translate 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.
-
Replicate Multiple Pipeline CRM Accounts
Replicate multiple Pipeline CRM accounts to one or many databases.
-
LINQ to Timely 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 Timely Data Provider.
-
Connect to LeadDesk Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time LeadDesk using standard SQL.
-
Use the CData Software ODBC Driver for Outreach.io in MicroStrategy
Connect to Outreach.io in MicroStrategy Developer using the CData Software ODBC Driver for Outreach.io.
-
Connect Bullhorn CRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Bullhorn CRM using the CData Python MCP Server.
-
How to Work with Mixpanel Data in ETL Validator JDBC
Connect to Mixpanel from ETL Validator jobs using the CData Software JDBC Driver.
-
Automate FHIR Data Replication to Couchbase
Use CData Sync to Customize and automate FHIR replication to Couchbase.
-
How to publish and share Oracle Data dashboards with Tableau Server
The CData ODBC driver for Oracle enables you integrate Oracle Database into Tableau dashboards.
-
Replicate Multiple Jira Accounts
Replicate multiple Jira accounts to one or many databases.
-
Use the CData Software ODBC Driver for Vercel in MicroStrategy Web
Connect to Vercel in MicroStrategy Web using the CData Software ODBC Driver for Vercel.
-
Build Mailjet-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Mailjet Data in Cursor to assist with building Mailjet-powered applications.
-
Load Google Campaign Manager 360 Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Campaign Manager 360 to a database.
-
Automated Continuous MarkLogic Replication to MySQL
Use CData Sync for automated, continuous, customizable MarkLogic replication to MySQL.
-
How to connect PolyBase to Workable
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Workable.
-
Build Pipelines with Live Excel Online Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Excel Online from Google Cloud Data Fusion, enabling the integration of live Microsoft Excel Online into the building and management of effective data pipelines.
-
How to import Onfleet Data into Apache Solr
Use the CData Software JDBC Driver for Onfleet in Data Import Handler and create an automated import of Onfleet to Apache Solr Enterprise Search platform.
-
Access Live Sybase Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sybase from your Google Sheets.
-
Getting Started with the CData ADO.NET Provider for PhantomBuster
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to import Dynamics 365 Data into Apache Solr
Use the CData Software JDBC Driver for Dynamics 365 in Data Import Handler and create an automated import of Microsoft Dynamics 365 to Apache Solr Enterprise Search platform.
-
Analyze Flowlu Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Flowlu with the CData JDBC Driver for Flowlu.
-
Use Dash to Build to Web Apps on Teamgate Data
Create Python applications that use pandas and Dash to build Teamgate-connected web apps.
-
Add Workable Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Workable with the Informatica Enterprise Data Catalog to classify and organize data.
-
Design BIRT Reports on Bright Data Data
Provide current Bright Data to your embedded analytics.
-
Integrating Gumloop with Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Paylocity within automated workflows.
-
Access Live Zoho CRM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Zoho CRM from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Visualize Dynamics 365 Business Central Data in Python with pandas
Use pandas and other modules to analyze and visualize live Dynamics 365 Business Central in Python.
-
Publish Crystal Reports on Odoo Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Odoo ERP.
-
Integrating Kiro CLI with SAP ByDesign 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.
-
Create Data Visualizations in Cognos BI with Adobe Target Data
Access Adobe Target as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Query Live Microsoft Entra ID Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Microsoft Entra ID directly from the development environment.
-
Excel Spreadsheet Automation on FreshBooks Data with the QUERY Formula
Pull data from FreshBooks, automate spreadsheets, and more with the QUERY formula.
-
Back Up XML Files to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for XML. In this article, we will employ an SSIS workflow to populate a database with XML Files data.
-
Create Reports with Mode Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mode.
-
How to create Salesforce federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Salesforce & Force.com in MySQL .
-
How to Visualize Salesforce Data 360 Data in Python with pandas
Use pandas and other modules to analyze and visualize live Salesforce Data 360 in Python.
-
Connect to and Query Authorize.Net Data in QlikView over ODBC
Create data visualizations with Authorize.Net in QlikView.
-
How to Query Live Quaderno Data in Perplexity MacOS Desktop
Connect to and query live Quaderno Data in Perplexity Desktop using CData MCP Server.
-
Visualize Live SAP Business One Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP Business One using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Antigravity CLI with Salesforce & Force.com via CData CLI
Connect Salesforce & Force.com to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Automated Workflows with Live Amazon Athena Data in Workato
Use CData Connect AI to connect to live Amazon Athena and build automated workflows in Workato.
-
Automated Continuous Jira Replication to Databricks
Use CData Sync for automated, continuous, customizable Jira replication to Databricks.
-
Automated Continuous Square Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Square replication to Amazon S3.
-
Query SharePoint Data as a SQL Server Database in Node.js
Execute SQL Server queries against Microsoft SharePoint from Node.js.
-
Build WordPress-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for WordPress Data and create custom apps in Bubble.
-
Access SAP BusinessObjects BI 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 SAP BusinessObjects BI.
-
How to Access Templated Data Using Entity Framework
This article shows how to access Templated using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Google Spanner Data Replication to Teradata
Use CData Sync to Customize and automate Google Spanner replication to Teradata.
-
Getting Started with the CData ODBC Driver for MailChimp
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for MailChimp.
-
Integrate LightSpeedRetail with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate LightSpeedRetail with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to LightSpeedRetail.
-
Connect to Webflow from a Connection Pool in WebLogic
Use the CData JDBC Driver for Webflow to connect to Webflow from Web applications running on WebLogic.
-
Connect to Azure DevOps from a Connection Pool in WebLogic
Use the CData JDBC Driver for Azure DevOps to connect to Azure DevOps from Web applications running on WebLogic.
-
Publish Crystal Reports on Certinia Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Certinia.
-
Analyze Telegram Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Telegram in Microsoft R Open.
-
How to Build an ETL App for Intercom Data in Python with CData
Create ETL applications and real-time data pipelines for Intercom in Python with petl.
-
Automated Continuous SuiteCRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Amazon Redshift.
-
Access Live Attio Data in Coginiti Pro
Connect to and query live Attio from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData Tableau Connector for Notion
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate LibreChat with Live ShipStation Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live ShipStation from within the chat interface.
-
Easily Integrate Nuclia Data in Lazarus Pascal IDE
Learn how to easily integrate live Nuclia in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Google Cloud Storage-Connected Nintex Workflows
Use CData Connect AI to connect to Google Cloud Storage Data from Nintex Workflow Cloud and build custom workflows using live Google Cloud Storage.
-
Work with Live SQL Analysis Services Data in Power Query
Use CData Connect AI to connect to SQL Analysis Services and work with live SQL Analysis Services in Microsoft Power Query.
-
Operational Reporting on Datadog Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Datadog.
-
Use Grok to Talk to Your SAP Concur 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 SAP Concur for you.