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
-
Automated Continuous Snapchat Ads Replication to SQLite
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to SQLite.
-
Create Apps from HubSpot in Qlik Sense Cloud
Use CData Connect Cloud to connect to HubSpot and build apps from live HubSpot in Qlik Sense Cloud.
-
Create a Data Access Object for Sage Intacct using JDBI
A brief overview of creating a SQL Object API for Sage Intacct in JDBI.
-
Automated Continuous SAP HANA XS Advanced Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to AlloyDB.
-
Access Sage 50 UK from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Sage 50 UK from HeidiSQL.
-
Create a Data Access Object for SharePoint using JDBI
A brief overview of creating a SQL Object API for Microsoft SharePoint in JDBI.
-
Choosing the Best Method to Connect Teradata to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Teradata from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Data Visualizations Based On Epicor Kinetic in Mode
Use CData Connect Cloud to connect to Epicor Kinetic from Mode and build visualizations using live
-
Author and Share Power BI Reports on Real-Time Dynamics 365 Business Central
Use the CData ODBC Driver for Dynamics 365 Business Central to visualize Dynamics 365 Business Central in Power BI Desktop and then upload to the Power BI service.
-
Automated Continuous Procore Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Procore replication to Amazon Redshift.
-
Replicate Multiple CSV Accounts
Replicate multiple CSV accounts to one or many databases.
-
Validate Dropbox with QuerySurge
Access and validate Dropbox in QuerySurge using the CData JDBC Driver.
-
Connect to Instagram from HeidiSQL
Use CData Connect Cloud to connect to and query live Instagram from HeidiSQL.
-
Automated Continuous Avalara AvaTax Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to IBM DB2.
-
Connect to HBase in RazorSQL
Connect to HBase from wizards and query Apache HBase from the GUI in the RazorSQL database management tool.
-
Configure the CData JDBC Driver for Bullhorn CRM in a Connection Pool in Tomcat
Connect to Bullhorn CRM from a connection pool in Tomcat.
-
Automated Continuous HDFS Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable HDFS replication to Amazon Redshift.
-
How to Work with LinkedIn Ads in AWS Glue Jobs Using JDBC
Connect to LinkedIn Ads from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Dynamics 365-Connected Visualizations in Klipfolio
Use CData Connect Cloud to connect to Dynamics 365 from Klipfolio and build custom visualizations using live Microsoft Dynamics 365.
-
Automated Continuous Avro Replication to Snowflake
Use CData Sync for automated, continuous, customizable Avro replication to Snowflake.
-
Connect to Certinia from a Connection Pool in JBoss
Integrate Certinia into Java servlets: Use the Management Console in JBoss to install the Certinia JDBC Driver.
-
Extract, Transform, and Load OneNote in Informatica PowerCenter
Create a simple Workflow for Microsoft OneNote in Informatica PowerCenter.
-
Build BigQuery Visualizations in Tableau Desktop
Use CData Connect Cloud to connect to live Google BigQuery and build visualizations in Tableau.
-
Process & Analyze xBase in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live xBase .
-
Use the CData Software JDBC Driver for SAP HANA in MicroStrategy Web
Connect to SAP HANA in MicroStrategy Web using the CData Software JDBC Driver for SAP HANA.
-
Use the CData Software JDBC Driver for Acumatica in MicroStrategy Web
Connect to Acumatica ERP in MicroStrategy Web using the CData Software JDBC Driver for Acumatica.
-
How to Connect the Power BI Service to Cloudant: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Visualize GitHub in TIBCO Spotfire through OData
Integrate GitHub into dashboards in TIBCO Spotfire.
-
Add Oracle HCM Cloud to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Oracle HCM Cloud with the Informatica Enterprise Data Catalog to classify and organize data.
-
PowerShell Scripting to Replicate eBay to MySQL
Write a simple PowerShell script to replicate eBay to a MySQL database.
-
Deploy the ADO.NET Provider for Sybase IQ on an SSRS Report Server
Connect to Sybase IQ from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Deploy the ADO.NET Provider for SAP on an SSRS Report Server
Connect to SAP ERP/NetWeaver from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Analyze Blackbaud FE NXT in SAP Analytics Cloud
Use CData Connect Cloud to create an OData API on top of Blackbaud FE NXT and visualize Blackbaud FE NXT in SAP Analytics Cloud.
-
Load Slack to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Slack to a database.
-
Replicate Multiple Google Ads Accounts
Replicate multiple Google Ads accounts to one or many databases.
-
Query Authorize.Net in ColdFusion
Write standard ColdFusion data access code to connect to Authorize.Net.
-
Deploy the ADO.NET Provider for SAP BusinessObjects BI on an SSRS Report Server
Connect to SAP BusinessObjects BI from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Access Unbounce from MySQL in Amazon QuickSight
Connect to Unbounce and build visualizations of Unbounce using a MySQL Connection in Amazon QuickSight.
-
Visualize Coinbase in TIBCO Spotfire through OData
Integrate Coinbase into dashboards in TIBCO Spotfire.
-
Integrate Live Office 365 into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to Office 365 from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Microsoft Office 365.
-
Write a Simple Go Application to work with XML on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to XML Files.
-
Create Square-Connected Nintex Workflows
Use CData Connect Cloud to connect to Square from Nintex Workflow Cloud and build custom workflows using live Square.
-
Bidirectional Access to SAP Netweaver Gateway from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP Netweaver Gateway in Filemaker Pro for Mac or Windows.
-
Integrate FHIR in Pentaho Data Integration
Build ETL pipelines based on FHIR in the Pentaho Data Integration tool.
-
How to Work with Klaviyo in ETL Validator JDBC
Connect to Klaviyo from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Hive-Connected Applications in Appsmith
Connect to Hive via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Apache Hive.
-
Automated Continuous Instagram Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Instagram replication to Google Cloud SQL.
-
Deploy the ADO.NET Provider for Zoho Projects on an SSRS Report Server
Connect to Zoho Projects from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Add QuickBooks to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for QuickBooks with the Informatica Enterprise Data Catalog to classify and organize data.
-
Viewing Zoho Projects in RAD Studio Data Explorer
How to view Zoho Projects in RAD Studio Data Explorer using the CData ODBC Driver for Zoho Projects.
-
Connect to Redis from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Redis to connect to Redis and execute queries in PowerBuilder.
-
Connect to and Query Zoom in QlikView over ODBC
Create data visualizations with Zoom in QlikView.
-
How to Seamlessly Import SAP ByDesign Data into IBM SPSS Modeler
Integrate SAP ByDesign data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to MariaDB in JRuby
Create a simple JRuby app with access to live MariaDB.
-
How to Connect to & Open Marketo in Microsoft Excel
This article uses the CData ODBC driver for Marketo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Informatica Mappings From/To a JDBC Data Source for Redis
Create Redis data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Box Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Box replication to Amazon Redshift.
-
Connect to Microsoft Project in NetBeans
Connect to Microsoft Project in NetBeans with the data source configuration wizard.
-
Build MailChimp-Connected Web Apps with Axios and CData Connect Cloud
Use CData Connect Cloud to connect to live MailChimp and build MailChimp-connected web apps with Axios.
-
Operational Reporting on LinkedIn from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote LinkedIn.
-
Automated Continuous Harvest Replication to Vertica
Use CData Sync for automated, continuous, customizable Harvest replication to Vertica.
-
Integrate Monday.com into Power Automate Desktop using CData Connect
CData Connect for Monday.com enables you to integrate Monday.com into workflows built using Microsoft Power Automate Desktop.
-
Use CData Connect Cloud to Access Yahoo! Japan Data Solution in Microsoft Power Pivot
Use CData Connect Cloud to connect to live Yahoo! Japan Data Solution in the Power Pivot business intelligence tool.
-
Back Up JSON to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for JSON. In this article, we will employ an SSIS workflow to populate a database with JSON data.
-
Visualize Live Unbounce in the Power BI Service
Use CData Software Connect Server to create a virtual SQL Server database for Unbounce and create custom reports in the Power BI Service.
-
Build Charts with Google Campaign Manager 360 in Clear Analytics
Create dynamic charts and perform analytics based on Google Campaign Manager 360 in Clear Analytics.
-
Create Act-On Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Act-On data access from reports, embedded analytics, and more.
-
Connect to Google Directory from HeidiSQL
Use CData Connect Cloud to connect to and query live Google Directory from HeidiSQL.
-
DataBind Charts to Jira Service Management
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Atlassian Jira Service Management 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.
-
Publish Google Ad Manager-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Ad Manager.
-
Use the CData Software ODBC Driver for Greenplum in MicroStrategy Web
Connect to Pivotal GreenPlum in MicroStrategy Web using the CData Software ODBC Driver for Greenplum.
-
Analyze Microsoft Exchange in Cognos Analytics
Use CData Connect Cloud to connect to Microsoft Exchange from Cognos Analytics and analyze live Microsoft Exchange.
-
How to Work with Okta in ETL Validator JDBC
Connect to Okta from ETL Validator jobs using the CData Software JDBC Driver.
-
Work with Oracle Eloqua in FoxPro
Load Oracle Eloqua into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous ShipStation Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ShipStation replication to IBM DB2.
-
Create Informatica Mappings From/To an ODBC Data Source for Azure Table
Create an ODBC connection to Azure Table in Informatica and browse and transfer Azure Table Storage.
-
Use the CData Software ODBC Driver for IBM Informix in SAS for Real-Time Reporting and Analytics
Connect to real-time IBM Informix in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for IBM Informix.
-
Automated Continuous MySQL Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable MySQL replication to PostgreSQL.
-
How to connect to Google Search Results from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for Google Search and work with Google Search in Microsoft Excel on Mac OS X.
-
How to work with QuickBooks in Apache Spark using SQL
Access and process QuickBooks in Apache Spark using the CData Software JDBC Driver.
-
Using AngularJS to Build Dynamic Web Pages with QuickBooks Time
Use the CData Connect Server to create QuickBooks Time OData feeds and build single-page applications with live QuickBooks Time.
-
Query, Visualize, and Share live Oracle Financials Cloud in Redash
Use CData Connect Cloud to connect to live Oracle Financials Cloud in Redash for querying, visualizing, and sharing.
-
Analyze Oracle Sales in R via JDBC
Use standard R functions and the development environment of your choice to analyze Oracle Sales with the CData JDBC Driver for Oracle Sales.
-
Google Ads Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Ads through CData Connect Cloud using different applications and tools.
-
Smartsheet Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Smartsheet facts in real time.
-
Build Instagram Visualizations in Tableau Desktop
Use CData Connect Cloud to connect to live Instagram and build visualizations in Tableau.
-
Build Data Flows from SQL Server to Bing Ads through SSIS
Easily push SQL Server data to Bing Ads using the CData SSIS Tasks for Bing Ads.
-
Build Dashboards with Cloudant in DBxtra
Create dynamic dashboards and perform analytics based on IBM Cloudant in DBxtra.
-
DataBind Charts to Oracle Service Cloud
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Service Cloud 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.
-
Create Reports from GMO MakeShop in Looker Studio
Use CData Connect Cloud to gain access to live GMO MakeShop and create custom reports in Looker Studio.
-
Integrating Salesforce Pardot in Talend Cloud Data Management Platform
-