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
-
Configure the CData JDBC Driver for WooCommerce in a Connection Pool in Tomcat
Connect to WooCommerce from a connection pool in Tomcat.
-
Connect to and Visualize Live Redis in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Redis.
-
Analyze Bing Search Results in SAP Analytics Cloud
Use CData Connect Cloud to create an OData API on top of Bing Search and visualize Bing Search in SAP Analytics Cloud.
-
Import ADP into the Power BI Service for Visualizations
Use CData Connect Cloud to connect to ADP and provide access to live ADP for custom reports in the Power BI Service.
-
Build Dashboards with CockroachDB in Dundas BI
Create dynamic dashboards and perform analytics based on CockroachDB in Dundas BI.
-
Publish Twitter Ads-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Twitter Ads.
-
How to import Printify into Apache Solr
Use the CData Software JDBC Driver for Printify in Data Import Handler and create an automated import of Printify to Apache Solr Enterprise Search platform.
-
Automated Continuous Neo4J Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Neo4J replication to Apache Cassandra.
-
Access Live Excel Online in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Excel Online from your Excel spreadsheets.
-
Automated Continuous Asana Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Asana replication to Amazon Redshift.
-
Publish Crystal Reports on SharePoint
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft SharePoint.
-
Bidirectional Access to Power BI XMLA from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Power BI XMLA in Filemaker Pro for Mac or Windows.
-
Analyze Phoenix in Infragistics Reveal
Use the CData API Server to create an OData API on top of Apache Phoenix and visualize live Apache Phoenix in Ingragistics Reveal.
-
Use the CData API Server to Access HubSpot in Microsoft PowerPivot
Use the CData API Server to connect to live HubSpot in the Power Pivot business intelligence tool.
-
How to Import Data from Snapchat Ads into Google Sheets
Import Snapchat Ads into a Google spreadsheet that is automatically refreshed.
-
Create Power BI Reports on Real-Time Box
Use the CData ODBC Driver for Box to visualize Box in Power BI Desktop.
-
Analyze Microsoft Project in Infragistics Reveal
Use CData Connect Cloud to create on OData API on top of Microsoft Project and visualize live Microsoft Project in Infragistics Reveal.
-
Access Live Microsoft Dataverse in AWS Lambda
Connect to live Microsoft Dataverse (CDS) in AWS Lambda using the CData JDBC Driver.
-
Manage Azure Table in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Azure Table.
-
Access Microsoft Teams from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Teams from HeidiSQL.
-
Use the CData Software ODBC Driver for Zoho Creator in MicroStrategy
Connect to Zoho Creator in MicroStrategy Developer using the CData Software ODBC Driver for Zoho Creator.
-
Connect to Cvent from a Connection Pool in Jetty
The Cvent JDBC Driver supports connection pooling: This article shows how to connect faster to Cvent from Web apps in Jetty.
-
How to create ClickUp federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ClickUp in MySQL .
-
Rapidly Develop Pipedrive-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.
-
Building Dynamic Web Pages with Google Directory Using AngularJS
Create single-page applications with live connectivity to Google Directory using the CData API Server.
-
Work with FHIR in FoxPro
Load FHIR into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Informatica Mappings From/To an ODBC Data Source for PingOne
Create an ODBC connection to PingOne in Informatica and browse and transfer PingOne.
-
Connect to Cloudant from Asprova with CData Software ODBC Driver for Cloudant
This article shows how to connect faster to Cloudant data from Asprova.
-
Visualize Act-On in Tableau
The CData ODBC driver for Act-On enables you integrate Act-On into Tableau dashboards.
-
Connect and Visualize Live SAP Concur Data in Databricks Lakehouse Federation with CData Connect Cloud
Use CData Connect Cloud to integrate live SAP Concur into the Databricks platform and create visualization dashboards with real-time SAP Concur.
-
View Reports on Real-Time Redis in Power BI Report Server
Use the CData ODBC Driver for Redis to visualize Redis in Power BI Desktop and then publish them to Power BI Report Server.
-
Stream TaxJar into Apache Kafka Topics
Access and stream TaxJar in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Salesforce Marketing from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Salesforce Marketing Cloud, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Sage Intacct Visualizations in Tableau Cloud
Use CData Connect Cloud to connect to live Sage Intacct and build visualizations in Tableau Cloud.
-
Visualize GraphQL from Tableau
Use the Tableau Desktop business intelligence tool to connect to GraphQL.
-
How to Connect to & Open FHIR in Microsoft Excel
This article uses the CData ODBC driver for FHIR to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
DataBind Controls to Access in Delphi
DataBind to Microsoft Access in Delphi with standard data access components and controls.
-
Query EnterpriseDB in ColdFusion
Write standard ColdFusion data access code to connect to EnterpriseDB.
-
Prepare, Blend, and Analyze Odoo in Alteryx Designer (Connect Cloud)
Build workflows to access live Odoo ERP for self-service data analytics.
-
Migrating data from Coinbase to Google BigQuery using CData SSIS Components.
Easily push Coinbase to Google BigQuery using the CData SSIS Tasks for Coinbase and Google BigQuery.
-
Integrate ClickUp in Pentaho Data Integration
Build ETL pipelines based on ClickUp in the Pentaho Data Integration tool.
-
Integrate with Zuora in JReport Designer
Create charts and reports based on Zuora in JReport Designer.
-
Visualize Microsoft Project in Tableau
The CData ODBC driver for Microsoft Project enables you integrate Microsoft Project into Tableau dashboards.
-
Integrate with SAP Business One in SnapLogic
Use CData Connect Cloud to connect to and integrate with live SAP Business One in SnapLogic.
-
Configure the CData JDBC Driver for Microsoft Dataverse in a Connection Pool in Tomcat
Connect to Microsoft Dataverse (CDS) from a connection pool in Tomcat.
-
How to create Visio diagrams from Databricks
Automatically update Databricks with the changes you make to Visio master shapes.
-
How to connect to Amazon S3 from IntelliJ
Integrate connectivity to Amazon S3 with wizards in IntelliJ.
-
Connect and Visualize Live SAP Business One Data in Databricks Lakehouse Federation with CData Connect Cloud
Use CData Connect Cloud to integrate live SAP Business One into the Databricks platform and create visualization dashboards with real-time SAP Business One.
-
Connect to Excel Online from Asprova with CData Software ODBC Driver for Excel Online
This article shows how to connect faster to Excel Online data from Asprova.
-
Use the CData Software ODBC Driver for HBase in MicroStrategy
Connect to Apache HBase in MicroStrategy Developer using the CData Software ODBC Driver for HBase.
-
Visualize Live Parquet in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Apache Parquet.
-
How to publish and share ADP dashboards with Tableau Server
The CData ODBC driver for ADP enables you integrate ADP into Tableau dashboards.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for TaxJar
Provide connectivity to TaxJar through an SAP BusinessObjects universe.
-
Publish Quickbase-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Quickbase.
-
Access Live Salesforce Data Cloud in Coginiti Pro
Connect to and query live Salesforce Data Cloud from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Query Zuora in DataGrip
Create a Data Source for Zuora in DataGrip and use SQL to query live Zuora.
-
Automated Continuous Microsoft OneLake Replication to SQLite
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to SQLite.
-
How to Work with Redshift in ETL Validator JDBC
Connect to Redshift from ETL Validator jobs using the CData Software JDBC Driver.
-
Analyze Dropbox in Infragistics Reveal
Use the CData API Server to create an OData API on top of Dropbox and visualize live Dropbox in Ingragistics Reveal.
-
Migrating data from Parquet to Databricks using CData SSIS Components.
Easily push Apache Parquet to Databricks using the CData SSIS Tasks for Parquet and Databricks.
-
ETL BigQuery in Oracle Data Integrator
This article shows how to transfer Google BigQuery into a data warehouse using Oracle Data Integrator.
-
Visualize Twitter in TIBCO Spotfire through ADO.NET
Integrate Twitter into dashboards in TIBCO Spotfire.
-
Create Data Visualizations in Cognos BI with Dynamics GP
Access Microsoft Dynamics GP as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect and Visualize Live BigQuery Data in Databricks Lakehouse Federation with CData Connect Cloud
Use CData Connect Cloud to integrate live Google BigQuery into the Databricks platform and create visualization dashboards with real-time Google BigQuery.
-
Visualize Live Google Directory in the Power BI Service
Use CData Connect Cloud to connect to live Google Directory and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to work with Azure Synapse in Apache Spark using SQL
Access and process Azure Synapse in Apache Spark using the CData Software JDBC Driver.
-
Manage Typeform in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Typeform.
-
Integrate Reckon in the Pentaho Report Designer
Publish reports based on Reckon in the Pentaho BI tool.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Parquet
Provide connectivity to Apache Parquet through an SAP BusinessObjects universe.
-
Prepare, Blend, and Analyze PayPal in Alteryx Designer (ODBC)
Build workflows to access live PayPal for self-service data analytics.
-
Automated Continuous YouTube Analytics Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Microsoft Access.
-
How to integrate HDFS with Apache Airflow
Access and process Apache HDFS in Apache Airflow using the CData JDBC Driver.
-
Automate Oracle Service Cloud Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Oracle Service Cloud from PowerShell? This article demonstrates how to utilize the Oracle Service Cloud Cmdlets for tasks like connecting to Oracle Service Cloud, automating operations, downloading data, and more.
-
Creating Sansan-Connected Applications in Unqork
You can use CData Connect Cloud to feed Sansan to Unqork and build custom business apps.
-
Rapidly Develop Reckon Accounts Hosted-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.
-
LINQ to Printify
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 Printify Data Provider.
-
How to import Sage Intacct into Apache Solr
Use the CData Software JDBC Driver for Sage Intacct in Data Import Handler and create an automated import of Sage Intacct to Apache Solr Enterprise Search platform.
-
How to publish and share Printful dashboards with Tableau Server
The CData ODBC driver for Printful enables you integrate Printful into Tableau dashboards.
-
How to pipe Cosmos DB to CSV in PowerShell
Use standard PowerShell cmdlets to access Cosmos DB tables.
-
Automate Clio Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Clio from PowerShell? This article demonstrates how to utilize the Clio Cmdlets for tasks like connecting to Clio, automating operations, downloading data, and more.
-
Create Informatica Mappings From/To a JDBC Data Source for Sage Cloud Accounting
Create Sage Cloud Accounting data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query Outreach.io in ColdFusion
Write standard ColdFusion data access code to connect to Outreach.io.
-
Create Data Visualizations in Cognos BI with Active Directory
Access Active Directory as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to connect to Smartsheet with Squirrel SQL client
Connect to Smartsheet and execute queries in the Squirrel SQL Client.
-
Feed ActiveCampaign into FineReport
How to set ActiveCampaign as a JDBC data source in FineReport.
-
Analyze Oracle Service Cloud in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Oracle Service Cloud and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Todoist from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Todoist using standard SQL.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Coinbase
Provide connectivity to Coinbase through an SAP BusinessObjects universe.
-
Analyze SAP Fieldglass in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP Fieldglass and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zenefits
Provide connectivity to Zenefits through an SAP BusinessObjects universe.
-
How to connect to Spark from IntelliJ
Integrate connectivity to Apache Spark SQL with wizards in IntelliJ.
-
Replicate Facebook to Multiple Databases via the CData Sync CLI
Replicate Facebook to disparate databases with a single configuration.
-
Use Dash to Build to Web Apps on Microsoft Planner
Create Python applications that use pandas and Dash to build Microsoft Planner-connected web apps.
-
Access Typeform as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Typeform from your Oracle system.
-
Connect to Veeva Vault in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Live Dynamics NAV in AWS Lambda
Connect to live Microsoft Dynamics NAV in AWS Lambda using the CData JDBC Driver.
-
Connect to Google Search Results in HULFT Integrate
Connect to Google Search as a JDBC data source in HULFT Integrate
-
Visualize Excel Online 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 Excel Online into TIBCO Spotfire.
-
DataBind Charts to Sage 50 UK
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Sage 50 UK 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.
-
Build ServiceNow-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ServiceNow.