CData Software - Knowledge Base
Recent Articles
-
Using the CData Software ODBC Driver for Templated in PyCharm
Connect to Templated as an ODBC data source in PyCharm using the CData Software ODBC Driver for Templated.
-
Access ScrapingBee Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ScrapingBee from HeidiSQL.
-
How to Query Impala Data in MySQL Workbench
Execute MySQL queries against live Apache Impala from MySQL Workbench.
-
Back Up Google Search to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Search. In this article, we will employ an SSIS workflow to populate a database with Google Search data.
-
How to Connect DBeaver to Sugar CRM via a JDBC Driver
Manage Sugar CRM with visual tools in DBeaver like the query browser.
-
Integrate Theia IDE with Live Certinia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrating GitHub Copilot CLI with Nuclia 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.
-
Getting Started with the CData Power BI Connector for Productboard
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Choosing the Best Method to Connect Clari to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Clari from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Quaderno Replication to MongoDB
Use CData Sync for automated, continuous, customizable Quaderno replication to MongoDB.
-
DataBind Zoom Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Zoom to a chart.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for HubSpot
Provide connectivity to HubSpot through an SAP BusinessObjects universe.
-
Create Power BI Reports on Real-Time Amazon S3 Data
Use the CData ODBC Driver for Amazon S3 to visualize Amazon S3 in Power BI Desktop.
-
Automated Continuous ShipStation Replication to MySQL
Use CData Sync for automated, continuous, customizable ShipStation replication to MySQL.
-
How to integrate JobNimbus with Apache Airflow
Access and process JobNimbus in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Google Tasks Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Tasks replication to Databricks.
-
Access Live Monday.com Data in Coginiti Pro
Connect to and query live Monday.com from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build AI/ML Models with Live SAP Business Warehouse Data using Dataiku
Connect SAP Business Warehouse Data with Dataiku using the CData JDBC Driver for SAP Business Warehouse.
-
Use the CData Software ODBC Driver for Salesforce Data 360 in MicroStrategy Web
Connect to Salesforce Data 360 in MicroStrategy Web using the CData Software ODBC Driver for Salesforce Data 360.
-
Back Up Oracle HCM Cloud to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Oracle HCM Cloud. In this article, we will employ an SSIS workflow to populate a database with Oracle HCM Cloud data.
-
How to Design AlloyDB Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to AlloyDB from mobile and tablet Power Apps.
-
Integrate Live LinkedIn Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to LinkedIn and integrate live LinkedIn into apps built in Microsoft Power Apps.
-
Explore Geographical Relationships in Google Analytics Data with Power Map
Create data visualizations with Google Analytics in Power Map.
-
How to connect to eBay Data from Spring Boot
Connect to eBay in a Spring Boot Application using the CData JDBC Driver for eBay
-
How to Connect the Power BI Service to Landbot: Complete Guide
Connect to the CData Software Power BI Connector for Landbot from PowerBI.com to provide real-time Landbot across the organization.
-
LINQ to Teamwork 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 Teamwork Data Provider.
-
Connect to Marketo Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Marketo.
-
Create Twilio-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Twilio Data from OutSystems and build custom enterprise apps using live Twilio.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Salesforce Pardot within intelligent workflows.
-
Getting Started with the CData Python Connector for Zoho Inventory
Learn to install and license the CData Python Connector
-
Access Live Mode Data in Coginiti Pro
Connect to and query live Mode from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Google Forms Data in DBeaver
Use the CData ODBC Driver to connect to Google Forms in DBeaver.
-
Publish Crystal Reports on Apify Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Apify.
-
Connect to Bullhorn CRM Data in JRuby
Create a simple JRuby app with access to live Bullhorn CRM.
-
Use the CData Software ODBC Driver for Vercel in MicroStrategy
Connect to Vercel in MicroStrategy Developer using the CData Software ODBC Driver for Vercel.
-
Connect to CampaignMonitor Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for CampaignMonitor in the Denodo Virtual DataPort Administrator.
-
Create Data Visualizations in Cognos BI with Planio Data
Access Planio as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use Claude to Talk to Your Google Drive 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 Google Drive for you.
-
Use the CData Software ODBC Driver for Discourse in MicroStrategy Desktop
Connect to Discourse in MicroStrategy Desktop using the CData Software ODBC Driver for Discourse.
-
Use Manus AI to Talk to Your Cvent 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 Cvent.
-
Publish ZohoPeople-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZohoPeople.
-
Automate Aircall Data Replication to Azure Data Lake
Use CData Sync to customize and automate Aircall replication to Azure Data Lake.
-
Process & Analyze Zuora Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Zuora Data.
-
How to Access Short.io Data Using Entity Framework
This article shows how to access Short.io using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build MVC Applications with Connectivity to Instagram Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Instagram from an ASP.NET MVC application.
-
How to connect and process SAP HANA from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP HANA.
-
Use Dash to Build to Web Apps on Aha! Data
Create Python applications that use pandas and Dash to build Aha!-connected web apps.
-
Create Apps from BigQuery Data in Qlik Sense Cloud
Use CData Connect AI to connect to BigQuery Data and build apps from live Google BigQuery in Qlik Sense Cloud.
-
Getting Started with the CData Tableau Connector for Microsoft Teams
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Microsoft Teams.
-
Integrating Claude Code CLI with ServiceDesk Plus 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 SAP Fieldglass Accounts
Replicate multiple SAP Fieldglass accounts to one or many databases.
-
Build Automated Workflows with Live SendGrid Data in Workato
Use CData Connect AI to connect to live SendGrid and build automated workflows in Workato.
-
How to connect and process Odoo ERP from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Odoo ERP.
-
Build Trello-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Trello to explore live Trello Data in GitHub Copilot to assist with building Trello-powered applications.
-
How to Query Live Amazon Athena Data in Perplexity MacOS Desktop
Connect to and query live Amazon Athena Data in Perplexity Desktop using CData MCP Server.
-
Access BigQuery Data from MySQL in Amazon QuickSight
Connect to BigQuery and build visualizations of Google BigQuery using a MySQL Connection in Amazon QuickSight.
-
How to connect to Demio Data with Squirrel SQL client
Connect to Demio and execute queries in the Squirrel SQL Client.
-
Google Sheets Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Sheets through CData Connect AI using different applications and tools.
-
Build an OLAP Cube in SSAS from Snapchat Ads Data
Establish a connection to Snapchat Ads data from SQL Server Analysis Services, and use the Snapchat Ads Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect to SAP Ariba Source Data from IntelliJ
Integrate connectivity to SAP Ariba Source with wizards in IntelliJ.
-
Access GraphQL Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live GraphQL from HeidiSQL.
-
Connect to Yelp in SpagoBI
Create reports featuring live Yelp in SpagoBI Studio. Host Yelp reports on SpagoBI Server.
-
DataBind Paymo Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Paymo to a chart.
-
Build Dashboards with Harvest Data in Dundas BI
Create dynamic dashboards and perform analytics based on Harvest in Dundas BI.
-
Use the CData Software ODBC Driver for Facebook in MicroStrategy Desktop
Connect to Facebook in MicroStrategy Desktop using the CData Software ODBC Driver for Facebook.
-
Integrate Live Zoho Projects Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Zoho Projects and integrate live Zoho Projects into apps built in Microsoft Power Apps.
-
Analyze Twilio Data in Cognos Analytics
Use CData Connect AI to connect to Twilio Data from Cognos Analytics and analyze live Twilio.
-
Replicate Calendly Data to Multiple Databases via the CData Sync CLI
Replicate Calendly to disparate databases with a single configuration.
-
DataBind Access Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Access with the DevExpress Windows Forms and Web controls to provide Microsoft Access to a chart.
-
DataBind Controls to Parquet Data in C++Builder
DataBind to Apache Parquet in C++Builder with standard components and controls.
-
Getting Started with the CData JDBC Driver for Vercel
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Vercel.
-
Connect LDAP to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect LDAP with IBM WebSphere for seamless data integration and connectivity.
-
Connect to ServiceNow Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ServiceNow.
-
Integrate Microsoft Planner with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Microsoft Planner with External Services.
-
Build an OLAP Cube in SSAS from Jira Data
Establish a connection to Atlassian Jira data from SQL Server Analysis Services, and use the Jira Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Data Visualizations in Cognos BI with MongoDB Data
Access MongoDB as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Hive Data in Talend Cloud Data Management Platform
Connect Hive Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Hive.
-
Connect to xBase Data in Aqua Data Studio
Access xBase from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Authorize.Net-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Authorize.Net.
-
Getting Started with the CData Excel Add-In for ServiceDesk Plus
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ServiceDesk Plus.
-
Connect to SAP Netweaver Gateway Data in NetBeans
Connect to SAP Netweaver Gateway in NetBeans with the data source configuration wizard.
-
Validate Office 365 Data with QuerySurge
Access and validate Microsoft Office 365 in QuerySurge using the CData JDBC Driver.
-
How to update Active Directory from Excel
This article explains how to transfer data from Excel to Active Directory using the Excel Add-In for Active Directory.
-
Integrate Highrise Data in Pentaho Data Integration
Build ETL pipelines based on Highrise CRM in the Pentaho Data Integration tool.
-
Build Accelo-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Accelo and build web apps with connectivity to live Accelo.
-
How to Import Data from Neo4J into Google Sheets
Import Neo4J into a Google spreadsheet that is automatically refreshed.
-
Integrating Antigravity CLI with Unbounce via CData CLI
Connect Unbounce to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use Claude to Talk to Your OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your OData for you.
-
Building Dynamic Web Pages with Asana Data Using AngularJS
Create single-page applications with live connectivity to Asana using the CData API Server.
-
How to use SQLAlchemy ORM to access Teamwork Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Teamwork.
-
Connect to Vault CRM Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Veeva Vault & Vault CRM in the Denodo Virtual DataPort Administrator.
-
Automated Continuous FormSite Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable FormSite replication to Amazon Redshift.
-
Use the CData Software ODBC Driver for Blackbaud FE NXT in MicroStrategy Web
Connect to Blackbaud FE NXT in MicroStrategy Web using the CData Software ODBC Driver for Blackbaud FE NXT.
-
DataBind Charts to Humanity Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Humanity 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.
-
Import and Visualize Teamwork Data in Power View
Create data visualizations based on Teamwork in Excel.
-
Query FHIR Data as a MySQL Database in Node.js
Execute MySQL queries against FHIR from Node.js.
-
Connect Moosend to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Moosend with IBM WebSphere for seamless data integration and connectivity.
-
ETL eBay in Oracle Data Integrator
This article shows how to transfer eBay into a data warehouse using Oracle Data Integrator.
-
Automated Continuous PivotalTracker Replication to Amazon S3
Use CData Sync for automated, continuous, customizable PivotalTracker replication to Amazon S3.
-
Stream JSON Services into Apache Kafka Topics
Access and stream JSON in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.