Model Context Protocol (MCP) finally gives AI models a way to access the business data needed to make them really useful at work. CData MCP Servers have the depth and performance to make sure AI has access to all of the answers.
Try them now for free →
CData Software - Knowledge Base
Recent Articles
-
Create YouTube Analytics-Connected Business Apps in AppSheet
Connect to YouTube Analytics via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to YouTube Analytics.
-
Excel Spreadsheet Automation on Zenefits with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Access Live SAP ByDesign in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Business ByDesign from your Excel spreadsheets.
-
Connect to Live HCL Domino in MicroStrategy through CData Connect Cloud
Create a live connection to HCL Domino in CData Connect Cloud and connect to your HCL Domino from MicroStrategy.
-
Process & Analyze LinkedIn Ads in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live LinkedIn Ads .
-
Automated Continuous QuickBooks Time Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Amazon Redshift.
-
How to work with Printify in Apache Spark using SQL
Access and process Printify in Apache Spark using the CData Software JDBC Driver.
-
Use Dash to Build to Web Apps on Sugar CRM
Create Python applications that use pandas and Dash to build Sugar CRM-connected web apps.
-
Connect to Cosmos DB through External Services in Salesforce
Use CData Connect Cloud to securely connect Salesforce External Services with Cosmos DB using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to connect to Azure Table with Squirrel SQL client
Connect to Azure Table Storage and execute queries in the Squirrel SQL Client.
-
How to connect to GitHub in DBVisualizer
Integrate GitHub with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData Software JDBC Driver for Cosmos DB in MicroStrategy
Connect to Azure Cosmos DB in MicroStrategy Developer using the CData Software JDBC Driver for Cosmos DB.
-
Connect to Unbounce in RazorSQL
Connect to Unbounce from wizards and query Unbounce from the GUI in the RazorSQL database management tool.
-
Access Live WooCommerce in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to WooCommerce from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Using the CData Software ODBC Driver for Zoho Projects in PyCharm
Connect to Zoho Projects as an ODBC data source in PyCharm using the CData Software ODBC Driver for Zoho Projects.
-
Use the CData Software JDBC Driver for Sybase in MicroStrategy
Connect to Sybase in MicroStrategy Developer using the CData Software JDBC Driver for Sybase.
-
Access Live Bullhorn CRM in Excel (Desktop) via Connect Cloud
Use CData Connect Cloud to gain access to live Bullhorn CRM from your Excel spreadsheets.
-
How to Query Live Dynamics 365 Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft Dynamics 365 data in natural language using Python.
-
LINQ to Basecamp
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 Basecamp Data Provider.
-
How to connect to CSV from IntelliJ
Integrate connectivity to CSV/TSV Files with wizards in IntelliJ.
-
Integrate with PostgreSQL in JReport Designer
Create charts and reports based on PostgreSQL in JReport Designer.
-
Automate SAS Data Sets Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAS Data Sets from PowerShell? This article demonstrates how to utilize the SAS Data Sets Cmdlets for tasks like connecting to SAS Data Sets, automating operations, downloading data, and more.
-
Create Reports from Splunk in Looker Studio
Use CData Connect Cloud to gain access to live Splunk and create custom reports in Looker Studio.
-
Import Real-Time Zoho CRM via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zoho CRM in ColdFusion.
-
Build Databricks-Connected Web Apps with Axios and CData Connect Cloud
Use CData Connect Cloud to connect to live Databricks and build Databricks-connected web apps with Axios.
-
Access Live QuickBooks Online in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live QuickBooks Online from your Excel spreadsheets.
-
Connect to Dynamics 365 Business Central from Crystal Reports
Use CData Connect Cloud to connect to and report on live Dynamics 365 Business Central from Crystal Reports.
-
Rapidly Develop Couchbase-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Automated Continuous Google Spanner Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Spanner replication to SQL Server.
-
Visualize Snapchat Ads from Tableau
Use the Tableau Desktop business intelligence tool to connect to Snapchat Ads.
-
Work with Clio in FoxPro
Load Clio into a FoxPro database. This article includes full code and a walk-through of the process.
-
Using the CData Software ODBC Driver for MarkLogic in PyCharm
Connect to MarkLogic as an ODBC data source in PyCharm using the CData Software ODBC Driver for MarkLogic.
-
Visualize Live Printful in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Printful.
-
How to create Visio diagrams from OData Services
Automatically update OData with the changes you make to Visio master shapes.
-
Connect to Zendesk in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zendesk and the SQL Gateway to access Zendesk from Google Apps Script.
-
How to Connect to Cassandra in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apache Cassandra. Leverage the pyodbc module for ODBC in Python.
-
Connect to Drift from a Connection Pool in WebLogic
Use the CData JDBC Driver for Drift to connect to Drift from Web applications running on WebLogic.
-
How to Work with Salesforce Pardot in AWS Glue Jobs Using JDBC
Connect to Salesforce Pardot from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Xero in NetBeans
Connect to Xero Accounting in NetBeans with the data source configuration wizard.
-
How to Access Redshift Using Entity Framework
This article shows how to access Amazon Redshift using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
ETL Redshift in Oracle Data Integrator
This article shows how to transfer Amazon Redshift into a data warehouse using Oracle Data Integrator.
-
Use the CData Software JDBC Driver for DB2 in MicroStrategy Desktop
Connect to IBM DB2 in MicroStrategy Desktop using the CData Software JDBC Driver for DB2.
-
Automated Continuous Office 365 Replication to MongoDB
Use CData Sync for automated, continuous, customizable Office 365 replication to MongoDB.
-
How to work with Sugar CRM in Apache Spark using SQL
Access and process Sugar CRM in Apache Spark using the CData Software JDBC Driver.
-
Work with Live Trello in Power Query
Use CData Connect Cloud to connect to Trello and work with live Trello in Microsoft Power Query.
-
Integrating Twitter Ads in Talend Cloud Data Management Platform
-
