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 Data Visualizations in Cognos BI with Impala
Access Apache Impala as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to and Query Confluence in QlikView over ODBC
Create data visualizations with Atlassian Confluence in QlikView.
-
Automated Continuous Pinterest Replication to Vertica
Use CData Sync for automated, continuous, customizable Pinterest replication to Vertica.
-
Connect to Invoiced in DBArtisan
Use wizards in DBArtisan to configure Invoiced as a data source.
-
Replicate FHIR from PowerShell
Write a quick PowerShell script to query FHIR. Use connectivity to the live data to replicate FHIR to SQL Server.
-
A PostgreSQL Interface for PostgreSQL using the CData ODBC Driver
Use the SQL Gateway and PostgreSQL ODBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze MySQL in SAP Analytics Cloud
Use CData Connect Cloud to create an OData API on top of MySQL and visualize MySQL in SAP Analytics Cloud.
-
Query OData Services as a SQL Server Database in Node.js
Execute SQL Server queries against OData from Node.js.
-
Connect to Basecamp in RapidMiner
Integrate Basecamp with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Splunk from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Splunk, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Microsoft Project as an External Data Source using PolyBase
Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Microsoft Project.
-
Automate Parquet Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Apache Parquet from PowerShell? This article demonstrates how to utilize the Parquet Cmdlets for tasks like connecting to Apache Parquet, automating operations, downloading data, and more.
-
Use the CData Software ODBC Driver for WordPress in MicroStrategy Web
Connect to WordPress in MicroStrategy Web using the CData Software ODBC Driver for WordPress.
-
How to publish and share SFTP dashboards with Tableau Server
The CData ODBC driver for SFTP enables you integrate SFTP into Tableau dashboards.
-
How to Query Live Bing Ads Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Bing Ads data in natural language using Python.
-
Create Informatica Mappings From/To an ODBC Data Source for PingOne
Create an ODBC connection to PingOne in Informatica and browse and transfer PingOne.
-
How to Access Live Reckon Accounts Hosted in Power Automate Desktop via ODBC
The CData ODBC Driver for Reckon Accounts Hosted enables you to integrate Reckon Accounts Hosted into workflows built using Microsoft Power Automate Desktop.
-
Connect to Printful in CloverDX (formerly CloverETL)
Transfer Printful using the visual workflow in the CloverDX data integration tool.
-
Edit and Search External FTP Objects in Salesforce Connect
Use CData Connect Server to securely provide OData feeds of FTP Servers to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create FTP objects that you can access from apps and the dashboard.
-
A PostgreSQL Interface for Highrise (MySQL Remoting via JDBC)
Use the Remoting features of the Highrise JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Neo4J from MySQL in Amazon QuickSight
Connect to Neo4J and build visualizations of Neo4J using a MySQL Connection in Amazon QuickSight.
-
Access Reckon from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Reckon from HeidiSQL.
-
DataBind Controls to JSON Services in Delphi
DataBind to JSON in Delphi with standard data access components and controls.
-
Connect to GMO MakeShop in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for GMO MakeShop and connect to GMO MakeShop in Akorbi Digital RunMyProcess.
-
Build GMO MakeShop-Connected Visualizations in datapine
Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live GMO MakeShop.
-
Work with Live Avalara AvaTax in Power Query
Use CData Connect Cloud to connect to Avalara AvaTax and work with live Avalara AvaTax in Microsoft Power Query.
-
Automated Continuous Epicor Kinetic Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to delimited files (CSV/TSV).
-
Connect to Slack from a Connection Pool in WebLogic
Use the CData JDBC Driver for Slack to connect to Slack from Web applications running on WebLogic.
-
Seamlessly Bring NetSuite into Retool Using CData Connect Cloud
Integrate NetSuite data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.
-
How to connect to SAP SuccessFactors in DBVisualizer
Integrate SAP SuccessFactors with visual data analysis tools and data connection wizards in DBVisualizer
-
How to create an RPA flow for Hive in UiPath Studio
Use the Hive ODBC Driver to create workflows that access real-time Apache Hive without any coding.
-
Use the CData Software ODBC Driver for Adobe Analytics in MicroStrategy Web
Connect to Adobe Analytics in MicroStrategy Web using the CData Software ODBC Driver for Adobe Analytics.
-
Create Dashboards and Visualize Live Yahoo! Japan Data Solution in Geckoboard
Use CData Connect Cloud to connect to live Yahoo! Japan Data Solution and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to connect to Monday.com in DBVisualizer
Integrate Monday.com with visual data analysis tools and data connection wizards in DBVisualizer
-
Edit and Search External Facebook Objects in Salesforce Connect
Use CData Connect Cloud to securely provide OData feeds of Facebook to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Facebook objects that you can access from apps and the dashboard.
-
Configure the CData JDBC Driver for Bing Search in a Connection Pool in Tomcat
Connect to Bing Search from a connection pool in Tomcat.
-
Connect to CSV from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for CSV to connect to CSV/TSV Files and execute queries in PowerBuilder.
-
Use the CData Software JDBC Driver for ClickUp in MicroStrategy
Connect to ClickUp in MicroStrategy Developer using the CData Software JDBC Driver for ClickUp.
-
PowerShell Scripting to Replicate Dynamics NAV to MySQL
Write a simple PowerShell script to replicate Microsoft Dynamics NAV to a MySQL database.
-
Visualize Live Twilio in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Twilio.
-
Access Live FHIR in Coginiti Pro
Connect to and query live FHIR from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData ODBC Driver for MySQL in Microsoft Power Query
You can use the CData MySQL ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import MySQL into Microsoft Power Query.
-
PowerShell Scripting to Replicate Twitter to MySQL
Write a simple PowerShell script to replicate Twitter to a MySQL database.
-
DataBind Charts to Amazon S3
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Amazon S3 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 Twitter Ads in SAP Analytics Cloud
Use CData Connect Cloud to create an OData API on top of Twitter Ads and visualize Twitter Ads in SAP Analytics Cloud.
-
How to connect to Reckon Accounts Hosted from IntelliJ
Integrate connectivity to Reckon Accounts Hosted with wizards in IntelliJ.
-
Analyze SAP BusinessObjects BI in Looker
Use CData Connect Cloud to connect to SAP BusinessObjects BI from Looker and build custom apps using live SAP BusinessObjects BI.
-
How to integrate SQL Server with Apache Airflow
Access and process Microsoft SQL Server in Apache Airflow using the CData JDBC Driver.
-
Build Visualizations of Oracle HCM Cloud in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Oracle HCM Cloud in Birst.
-
Access CouchDB 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 Apache CouchDB.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Reckon
Provide connectivity to Reckon through an SAP BusinessObjects universe.
-
How to Connect to NetSuite in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to NetSuite CRM & ERP. Leverage the pyodbc module for ODBC in Python.
-
A PostgreSQL Interface for SAP HANA (MySQL Remoting via JDBC)
Use the Remoting features of the SAP HANA JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Klaviyo in Jaspersoft Studio
Execute SQL to remote Klaviyo in Jaspersoft Studio.
-
Automated Continuous Xero Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Xero replication to Google BigQuery.
-
Connect to DocuSign in JRuby
Create a simple JRuby app with access to live DocuSign.
-
Using AngularJS to Build Dynamic Web Pages with GraphQL
Use the CData Connect Server to create GraphQL OData feeds and build single-page applications with live GraphQL.
-
Build Apps with Live Marketo in Adalo using CData Connect Cloud
Use CData Connect Cloud to integrate live Marketo into the Adalo platform and build custom mobile and web applications with real-time Marketo.
-
Connect to Stripe in DBArtisan
Use wizards in DBArtisan to configure Stripe as a data source.
-
Connect to Active Directory in JRuby
Create a simple JRuby app with access to live Active Directory.
-
How to create Google Campaign Manager 360 federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Campaign Manager 360 in MySQL .
-
Integrate Office 365 in Pentaho Data Integration
Build ETL pipelines based on Microsoft Office 365 in the Pentaho Data Integration tool.
-
Automated Continuous Adobe Analytics Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Google BigQuery.
-
Query SAP Ariba Procurement in DataGrip
Create a Data Source for SAP Ariba Procurement in DataGrip and use SQL to query live SAP Ariba Procurement.
-
How to work with Twitter Ads in Apache Spark using SQL
Access and process Twitter Ads in Apache Spark using the CData Software JDBC Driver.
-
Jira Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Jira facts in real time.
-
Use the CData ODBC Driver for WooCommerce in Microsoft Power Query
You can use the CData WooCommerce ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import WooCommerce into Microsoft Power Query.
-
How to Work with Google Contacts in AWS Glue Jobs Using JDBC
Connect to Google Contacts from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Microsoft Project-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for Microsoft Project and create custom apps in Mendix.
-
Create Calendly-Connected Nintex Workflows
Use CData Software Connect Server to connect to Calendly from Nintex Workflow Cloud and build custom workflows using live Calendly.
-
Integrate with Live Twitter in MuleSoft (via CData Connect Cloud)
Use CData Connect Cloud to connect to Twitter from the MuleSoft Anypoint Platform to integrate live Twitter into custom reports and dashboards.
-
Create Apps from FHIR in Qlik Sense Cloud
Use CData Connect Cloud to connect to FHIR and build apps from live FHIR in Qlik Sense Cloud.
-
Connect to SAP HANA from AWS Glue
Use CData Connect Cloud to gain access to live SAP HANA from your AWS Glue jobs.
-
Integrate Real-Time Access to Databricks in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Databricks in real time.
-
Create Zoho Inventory-Connected Visualizations in Klipfolio
Use CData Connect Cloud to connect to Zoho Inventory from Klipfolio and build custom visualizations using live Zoho Inventory.
-
Replicate Multiple Shopify Accounts via the CData Sync CLI
Replicate multiple Shopify accounts to one or many databases.
-
Query Instagram as a MySQL Database in Node.js
Execute MySQL queries against Instagram from Node.js.
-
Replicate Multiple Jira Service Management Accounts
Replicate multiple Jira Service Management accounts to one or many databases.
-
Import Unbounce into FileMaker Pro
Create reports that integrate Unbounce in Filemaker Pro.
-
How to Access Live GraphQL in Power Automate Desktop via ODBC
The CData ODBC Driver for GraphQL enables you to integrate GraphQL into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software ODBC Driver for Hive in SAS for Real-Time Reporting and Analytics
Connect to real-time Apache Hive in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Hive.
-
Integrate Live Couchbase into Blue Prism for Intelligent Robotic Process Automation (RPA)
-