CData Software - Knowledge Base
Recent Articles
-
Back Up Reply.io to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Reply.io data.
-
Query Google Ads Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Ads from Node.js.
-
Integrating Zoom Data in Talend Cloud Data Management Platform
Connect Zoom Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to Smartsheet Data from a Connection Pool in JBoss
Integrate Smartsheet into Java servlets: Use the Management Console in JBoss to install the Smartsheet JDBC Driver.
-
Automate SendPulse Data Replication to Azure Synapse
Use CData Sync to customize and automate SendPulse replication to Azure Synapse.
-
How to Connect to Live Jira Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Atlassian Jira for you.
-
Query Mouseflow Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Mouseflow entities in PHP by modeling them as objects.
-
Choosing the Best Method to Connect CapsuleCRM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use CapsuleCRM from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect Retently to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Retently using the CData Python MCP Server.
-
Getting Started with the CData Tableau Connector for SAP Fieldglass
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP Fieldglass.
-
How to connect to MailChimp Data in DBVisualizer
Integrate MailChimp with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Cline with Live Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Oracle Service Cloud from within your IDE.
-
How to create an RPA flow for OneNote Data in UiPath Studio
Use the OneNote ODBC Driver to create workflows that access real-time Microsoft OneNote without any coding.
-
Integrate Dynamics 365 Business Central Data in the Pentaho Report Designer
Publish reports based on Dynamics 365 Business Central in the Pentaho BI tool.
-
Getting Started with the CData SSIS Components for Instagram
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Instagram.
-
Connect Salesforce CRM Analytics to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Salesforce CRM Analytics with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData ODBC Driver for LinkedIn Ads from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for LinkedIn Ads to connect to LinkedIn Ads from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring LinkedIn Ads in Excel.
-
Create Google Drive-Connected Applications in Appsmith
Connect to Google Drive Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Drive.
-
Back Up MarkLogic to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for MarkLogic. In this article, we will employ an SSIS workflow to populate a database with MarkLogic data.
-
How to Visualize Jumpseller Data in Python with pandas
Use pandas and other modules to analyze and visualize live Jumpseller in Python.
-
How to integrate Amazon S3 with Apache Airflow
Access and process Amazon S3 in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Outreach.io Replication to Vertica
Use CData Sync for automated, continuous, customizable Outreach.io replication to Vertica.
-
Use the CData API Server to Access MariaDB Data in Microsoft PowerPivot
Use the CData API Server to connect to live MariaDB in the Power Pivot business intelligence tool.
-
Build Semantic Layer Views for Copper Data in APOS Live Data Gateway
Use the CData Connector for Copper in APOS Live Data Gateway to build Semantic Layer Views for Copper.
-
Design BIRT Reports on CockroachDB Data
Provide current CockroachDB to your embedded analytics.
-
Query Impala Data in DataGrip
Create a Data Source for Impala in DataGrip and use SQL to query live Apache Impala.
-
Use Claude to Talk to Your Slack 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 Slack for you.
-
How to Work with BigCommerce Data in ETL Validator JDBC
Connect to BigCommerce from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Certinia from a Connection Pool in WebLogic
Use the CData JDBC Driver for Certinia to connect to Certinia from Web applications running on WebLogic.
-
Create Power BI Reports on Real-Time ZohoPeople Data
Use the CData ODBC Driver for ZohoPeople to visualize ZohoPeople in Power BI Desktop.
-
Building Dynamic Web Pages with Aha! Data Using AngularJS
Create single-page applications with live connectivity to Aha! using the CData API Server.
-
Access Live LinkedIn Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to LinkedIn from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Consume Klaviyo OData Feeds in PowerBuilder
This article demonstrates how to consume Klaviyo as OData feeds from PowerBuilder using the API Server.
-
Design BIRT Reports on Azure Table Data
Provide current Azure Table Storage to your embedded analytics.
-
Connect to Google Cloud Storage Data from a Connection Pool in Jetty
The Google Cloud Storage JDBC Driver supports connection pooling: This article shows how to connect faster to Google Cloud Storage from Web apps in Jetty.
-
Build Semantic Layer Views for Apify Data in APOS Live Data Gateway
Use the CData Connector for Apify in APOS Live Data Gateway to build Semantic Layer Views for Apify.
-
Use the CData SSIS Components to Insert New or Update Existing Stripe Records from SQL Server
Easily push SQL Server data to Stripe using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Stripe or update existing records with data from a SQL Server database.
-
How to connect and process SFTP from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SFTP.
-
Deploy the ADO.NET Provider for Hacker News on an SSRS Report Server
Connect to Hacker News 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.
-
Integrate Real-Time Access to Salesloft in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Salesloft in real time.
-
How to import Productboard Data into Apache Solr
Use the CData Software JDBC Driver for Productboard in Data Import Handler and create an automated import of Productboard to Apache Solr Enterprise Search platform.
-
Integrate Power BI XMLA with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Power BI XMLA with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Power BI XMLA.
-
Connect to Klipfolio Data in RapidMiner
Integrate Klipfolio with standard components and data source configuration wizards in RapidMiner Studio.
-
Analyze Sage 200 Data in Cognos Analytics
Use CData Connect AI to connect to Sage 200 Data from Cognos Analytics and analyze live Sage 200.
-
How to Access Live Rootly Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Rootly from the Cline extension in Visual Studio Code.
-
DataBind xBase Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for xBase with the DevExpress Windows Forms and Web controls to provide xBase to a chart.
-
Connecting Mastra with Google Spanner Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Google Spanner, no replication required.
-
Access DB2 Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live IBM DB2 from HeidiSQL.
-
Integrate Cline with Live SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP Netweaver Gateway from within your IDE.
-
Replicate Multiple Retently Accounts via the CData Sync CLI
Replicate multiple Retently accounts to one or many databases.
-
Access Live Redshift Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Amazon Redshift from your Excel spreadsheets.
-
Build a Simple VCL Application for Zoho CRM Data
How to build a simple VCL Application to view Zoho CRM in RAD Studio using the CData ODBC Driver for Zoho CRM.
-
Natively Connect to SpaceX Data in PHP
The CData ODBC driver for SpaceX enables you to create PHP applications with connectivity to SpaceX. Leverage the native support for ODBC in PHP.
-
Analyze Live Blackbaud FE NXT Data in SAS Viya
Use CData Connect AI to connect to Blackbaud FE NXT from SAS Viya and deploy self-service analytics using live Blackbaud FE NXT.
-
Replicate SparkPost Data to Multiple Databases
Replicate SparkPost to disparate databases with a point-and-click configuration.
-
How to connect PolyBase to HubSpot
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live HubSpot.
-
Automated Mailgun Data Replication to Teradata
Use CData Sync to Customize and automate Mailgun replication to Teradata.
-
A PostgreSQL Interface for SAP Ariba Procurement Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP Ariba Procurement JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live Cvent Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Cvent.
-
Build Data Flows from PayPal to SQL Server using SSIS
Easily back up PayPal to SQL Server using the SSIS components for PayPal.
-
Freshteam Reporting in OBIEE with the Freshteam JDBC Driver
Deploy the Freshteam JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Reports from ADP Data in Looker Studio
Use CData Connect AI to gain access to live ADP and create custom reports in Looker Studio.
-
Connect to Calendly Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Calendly using standard SQL.
-
How to connect and process Active Directory from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Active Directory.
-
How to load Flowlu data into Elasticsearch via Logstash
Introducing a simple method to load Flowlu data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Google Ads from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Ads, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Model, Search, and Visualize Live Sybase IQ Data in ThoughtSpot
Use CData Connect AI to connect to live Sybase IQ for modeling, searching, and visualizing.
-
How to Easily Query Keap Data in OpenOffice Base
Connect to Keap data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build Agents in Relevance AI with Access to Live SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SurveyMonkey within intelligent agent workflows.
-
Integrating LangChain with GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on GitHub within automated workflows.
-
Integrate SAP Hybris C4C Data in the Pentaho Report Designer
Publish reports based on SAP Hybris C4C in the Pentaho BI tool.
-
How to connect to ServiceDesk Plus Data in DBVisualizer
Integrate ServiceDesk Plus with visual data analysis tools and data connection wizards in DBVisualizer
-
Enable the Google Search JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Search.
-
Connect to ChargeOver Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ChargeOver using standard SQL.
-
Sync Google Contacts with QuickBooks
The CData ADO.NET Providers offer an easy way to integrate with different data sources. This article walks through the downloadable, fully functional application that can be used to synchronize contacts between Google and QuickBooks.
-
Visualize Live DB2 Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live IBM DB2 into custom reports in Power BI.
-
Visualize PivotalTracker Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to PivotalTracker.
-
Video: Connecting with MongoDB Data from Microsoft Excel
This video shows how to use the CData ODBC Driver for MongoDB to connect to MongoDB. You will create a DSN and then use the Data Connection Wizard in Excel to retrieve MongoDB data.
-
Manage Codat Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Codat.
-
Getting Started with the CData SSIS Components for iContact
Complete guide to installing, licensing, and connecting with the CData SSIS Components for iContact.
-
Import Real-Time Splunk Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Splunk in ColdFusion.
-
Viewing Instantly Data in RAD Studio Data Explorer
How to view Instantly in RAD Studio Data Explorer using the CData ODBC Driver for Instantly.
-
How to Connect Sage Intacct Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Sage Intacct data in real time using natural language.
-
Build a PostgreSQL Interface for SendPulse Data using the CData JDBC Driver
Use the Remoting features of the SendPulse JDBC Driver to create a PostgreSQL entry-point for data access.
-
A PostgreSQL Interface for Excel Data using the CData ODBC Driver
Use the SQL Gateway and Excel ODBC Driver to create a PostgreSQL entry-point for data access.
-
Import Zoho Books Data Using Azure Data Factory
Use CData Connect AI to connect to Zoho Books Data from Azure Data Factory and import live Zoho Books.
-
Connect to and Query Apollo Data in QlikView over ODBC
Create data visualizations with Apollo in QlikView.
-
Access Live Notion Data in Coginiti Pro
Connect to and query live Notion from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Replicate Multiple SharePoint Accounts
Replicate multiple SharePoint accounts to one or many databases.
-
Use the CData Software JDBC Driver for Azure Table in MicroStrategy
Connect to Azure Table Storage in MicroStrategy Developer using the CData Software JDBC Driver for Azure Table.
-
How to Create Power BI Visual Reports with Real-Time Azure Table Data
Use CData Power BI Connectors to visualize Azure Table Storage in Power BI.
-
Integrate with Azure DevOps Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Azure DevOps in SnapLogic.
-
Access Freshdesk Data from MySQL in Amazon QuickSight
Connect to Freshdesk and build visualizations of Freshdesk using a MySQL Connection in Amazon QuickSight.
-
Visualize Live Oracle Data in the Power BI Service
Use CData Connect AI to connect to live Oracle Database and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Open WebUI with Live SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP Business ByDesign from within the chat interface.
-
DataBind Controls to Toggl Data in Delphi
DataBind to Toggl in Delphi with standard data access components and controls.
-
Object-Relational Mapping (ORM) with QuickBooks Online Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to QuickBooks Online into a Java-based ORM framework, Hibernate.
-
Connect to Gong Data in HULFT Integrate
Connect to Gong as a JDBC data source in HULFT Integrate
-
Create Freshdesk-Connected Business Apps in AppSheet
Connect to Freshdesk Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Freshdesk.
-
Connect to Real-Time Aha! Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Aha! in Power Apps.