CData Software - Knowledge Base

Recent Articles

---

• «
• 971
• 972
• 973
• 974
• 975
• 976
• 977
• 978
• 979
• 980
• »

• Build AlloyDB Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live Google AlloyDB and build visualizations in Tableau Cloud.

• Process & Analyze Apollo Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Apollo Data.

• Access Paymo Data from MySQL in PHP

  Connect to Paymo through the standard MySQL libraries in PHP.

• Automate SAP BusinessObjects BI Data Replication to Azure Data Lake

  Use CData Sync to customize and automate SAP BusinessObjects BI replication to Azure Data Lake.

• Use Biml to Build SSIS Tasks to Replicate Okta Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Okta to SQL Server.

• Configure the CData JDBC Driver for Asana in a Connection Pool in Tomcat

  Connect to Asana from a connection pool in Tomcat.

• Analyze Highrise Data in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of Highrise CRM and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.

• Automate AdRoll Data Replication to Azure Data Lake

  Use CData Sync to customize and automate AdRoll replication to Azure Data Lake.

• Integrate Live Productboard Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live Productboard to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.

• Analyze GraphQL Data in Cognos Analytics

  Use CData Connect AI to connect to GraphQL Data from Cognos Analytics and analyze live GraphQL.

• Design BIRT Reports on Certinia Data

  Provide current Certinia to your embedded analytics.

• Connect to Oracle Financials Cloud Data in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Oracle Financials Cloud in the Denodo Virtual DataPort Administrator.

• Connect to SAP Business One Data in RazorSQL

  Connect to SAP Business One from wizards and query SAP Business One from the GUI in the RazorSQL database management tool.

• Import Box Data Using Azure Data Factory

  Use CData Connect AI to connect to Box Data from Azure Data Factory and import live Box.

• Process & Analyze GitLab Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live GitLab Data.

• Create Apollo-Connected Nintex Workflows

  Use CData Connect AI to connect to Apollo Data from Nintex Workflow Cloud and build custom workflows using live Apollo.

• Choosing the Best Method to Connect MailerSend to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use MailerSend from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Process & Analyze Jira Assets Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Jira Assets Data.

• Build AI/ML Models with Live Google Analytics Data using Dataiku

  Connect Google Analytics Data with Dataiku using the CData JDBC Driver for Google Analytics.

• How to create Freshsales federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Freshsales in MySQL .

• Integrating Kiro CLI with Couchbase Data via CData CLI

  CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.

• Getting Started with the CData Tableau Connector for SAP Netweaver Gateway

  Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP Netweaver Gateway.

• Automated Continuous Stack Exchange Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Stack Exchange replication to MongoDB.

• Publish Reports with Azure Data Catalog Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Azure Data Catalog.

• Explore Geographical Relationships in Google Cloud Storage Data with Power Map

  Create data visualizations with Google Cloud Storage in Power Map.

• A PostgreSQL Interface for Avro Data using the CData ODBC Driver

  Use the SQL Gateway and Avro ODBC Driver to create a PostgreSQL entry-point for data access.

• How to Seamlessly Import Brex Data into IBM SPSS Modeler

  Integrate Brex data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Work with Parquet Data in FoxPro

  Load Apache Parquet into a FoxPro database. This article includes full code and a walk-through of the process.

• A PostgreSQL Interface for Mixpanel Data using the CData ODBC Driver

  Use the SQL Gateway and Mixpanel ODBC Driver to create a PostgreSQL entry-point for data access.

• Connect to SAP HANA Data from Crystal Reports

  Use CData Connect AI to connect to and report on live SAP HANA from Crystal Reports.

• Use the CData Software JDBC Driver for Outreach.io in MicroStrategy Web

  Connect to Outreach.io in MicroStrategy Web using the CData Software JDBC Driver for Outreach.io.

• Access Live ScrapingBee Data in AWS Lambda

  Connect to live ScrapingBee in AWS Lambda using the CData JDBC Driver.

• Feed Confluence Data into FineReport

  How to set Atlassian Confluence as a JDBC data source in FineReport.

• Access Live Microsoft Exchange Data in Emergent via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Microsoft Exchange through MCP integration.

• Enable the REST JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with REST.

• Access YouTube Analytics Data from MySQL in PHP

  Connect to YouTube Analytics through the standard MySQL libraries in PHP.

• Connect to ActiveCampaign Data from HeidiSQL

  Use CData Connect AI to connect to and query live ActiveCampaign from HeidiSQL.

• Automated Continuous Yelp Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Yelp replication to Amazon S3.

• Analyze Scrapfly Data in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Scrapfly with the CData JDBC Driver for Scrapfly.

• Visualize Confluence Data in Tableau

  The CData ODBC driver for Confluence enables you integrate Atlassian Confluence into Tableau dashboards.

• How to load Act-On data into Elasticsearch via Logstash

  Introducing a simple method to load Act-On data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Automate Parquet Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Apache Parquet and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• How to import LightSpeedRetail Data into Apache Solr

  Use the CData Software JDBC Driver for LightSpeedRetail in Data Import Handler and create an automated import of LightSpeedRetail to Apache Solr Enterprise Search platform.

• Automated Continuous HelloSign Replication to Vertica

  Use CData Sync for automated, continuous, customizable HelloSign replication to Vertica.

• Publish Microsoft Entra ID-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Microsoft Entra ID.

• How to work with Codat Data in Apache Spark using SQL

  Access and process Codat Data in Apache Spark using the CData Software JDBC Driver.

• Access Live BambooHR Data in Excel 365 Online (Excel for the web)

  Connect to BambooHR from Excel 365 Online (Excel for the web) with CData Connect AI.

• How to create Visio diagrams from NetSuite Data

  Automatically update NetSuite CRM & ERP with the changes you make to Visio master shapes.

• Getting Started with the CData ADO.NET Provider for Basecamp

  Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Basecamp.

• Replicate Drip Data in Heroku for Use in Salesforce Connect

  Replicate Drip to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• How to create Visio diagrams from QuickBooks Data

  Automatically update QuickBooks Desktop with the changes you make to Visio master shapes.

• Deploy the ADO.NET Provider for ScrapingBee on an SSRS Report Server

  Connect to ScrapingBee 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.

• How to Connect to Live LinkedIn 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 LinkedIn for you.

• How to Work with Rootly Data in AWS Glue Jobs Using JDBC

  Connect to Rootly from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Integrate Open WebUI with Live Microsoft OneDrive Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft OneDrive from within the chat interface.

• How to connect and process ZohoPeople from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live ZohoPeople.

• Create Datasets from Active Directory in Domo Workbench and Build Visualizations of Active Directory Data in Domo

  Use the CData Software ODBC Driver for Active Directory to create datasets from Active Directory in Domo Workbench and then build visualizations in the Domo service.

• Use Grok to Talk to Your Microsoft Teams Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Microsoft Teams for you.

• Connect to Databricks Data in DBeaver

  Use the CData ODBC Driver to connect to Databricks in DBeaver.

• How to Query SQL Analysis Services Data in MySQL Workbench

  Execute MySQL queries against live SQL Analysis Services from MySQL Workbench.

• Build MVC Applications with Connectivity to Marketo Data

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Marketo from an ASP.NET MVC application.

• Integrate Open WebUI with Live Freshdesk Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Freshdesk from within the chat interface.

• Import and Visualize FTP Data in Power View

  Create data visualizations based on FTP Servers in Excel.

• Integrating Claude Code CLI with Harvest Data via CData CLI

  CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata - all without leaving the terminal.

• Bridge Airtable Connectivity with Apache NiFi

  Access and process Airtable in Apache NiFi using the CData JDBC Driver.

• Connect to Testmonitor Data in Ruby

  Connect to Testmonitor in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Build Microsoft Exchange-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Microsoft Exchange and build web apps with connectivity to live Microsoft Exchange.

• Manage Freshdesk Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Freshdesk.

• Access Live Gorgias Data in AWS Lambda (with IntelliJ IDEA)

  Connect to live Gorgias in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Connect to Lakebase in SpagoBI

  Create reports featuring live Lakebase in SpagoBI Studio. Host Lakebase reports on SpagoBI Server.

• How to load Omnisend data into Elasticsearch via Logstash

  Introducing a simple method to load Omnisend data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Analyze Bullhorn CRM Data in Infragistics Reveal

  Use CData Connect AI to create on OData API on top of Bullhorn CRM and visualize live Bullhorn CRM in Infragistics Reveal.

• Replicate Blackbaud FE NXT Data to Multiple Databases

  Replicate Blackbaud FE NXT to disparate databases with a point-and-click configuration.

• Connect to Authorize.Net Data in Ruby

  Connect to Authorize.Net in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• DataBind Charts to Freshservice Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Freshservice 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.

• Query Zoho CRM Data from Node.js

  Use the OData endpoint of the CData API Server to connect to your Zoho CRM and perform CRUD operations on Zoho CRM from Node.js.

• Connect to Active Directory Data in Aqua Data Studio

  Access Active Directory from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Visualize Highrise Data in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Highrise CRM into TIBCO Spotfire.

• Access Oracle Eloqua Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Oracle Eloqua from HeidiSQL.

• Analyze Live Act-On Data in SAS Viya

  Use CData Connect AI to connect to Act-On from SAS Viya and deploy self-service analytics using live Act-On.

• Connect HDFS to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Apache HDFS using the CData Python MCP Server.

• Build Amazon S3-Powered Applications in GitHub Copilot with CData MCP Server

  Use the CData MCP Server for Amazon S3 to explore live Amazon S3 Data in GitHub Copilot to assist with building Amazon S3-powered applications.

• Integrate Goose with Live Dynamics 365 Business Central Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Dynamics 365 Business Central from within the local AI agent.

• Connect to Email Data through External Services in Salesforce

  Use CData Connect AI to securely connect Salesforce External Services with Email Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Use JayDeBeApi to access Avalara AvaTax Data in Python

  Use standard Python scripting and the development environment of your choice to access live Avalara AvaTax.

• Using IMAP with the Gmail Data Provider

  The CData Gmail Data Providers provide access to the full search capabilities of IMAP through a simple SQL interface. This article will demonstrate how to use the Gmail demo to query your Gmail account.

• Access Pipeliner CRM Data 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 Pipeliner CRM.

• How to Connect to Twitter Ads Data in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Twitter Ads. Leverage the pyodbc module for ODBC in Python.

• Query, Visualize, and Share live Google Cloud Storage Data in Redash

  Use CData Connect AI to connect to live Google Cloud Storage in Redash for querying, visualizing, and sharing.

• Integrating Cursor CLI with Avaza Data via CData CLI

  CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.

• Use the CData Software JDBC Driver for OnePageCrm in MicroStrategy Desktop

  Connect to OnePageCrm in MicroStrategy Desktop using the CData Software JDBC Driver for OnePageCrm.

• Integrate with Oracle Service Cloud Data in SnapLogic

  Use CData Connect AI to connect to and integrate with live Oracle Service Cloud in SnapLogic.

• Natively Connect to BigCommerce Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to BigCommerce. Leverage the native support for ODBC in PHP.

• Integrate Open WebUI with Live GitLab Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live GitLab from within the chat interface.

• Integrate with Placid Data in JReport Designer

  Create charts and reports based on Placid in JReport Designer.

• Visualize Tanda Data in Sisense

  Create an ElastiCube in Sisense app with access to Tanda.

• How to integrate PhantomBuster with Apache Airflow

  Access and process PhantomBuster in Apache Airflow using the CData JDBC Driver.

• How to load Jumpseller data into Elasticsearch via Logstash

  Introducing a simple method to load Jumpseller data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• How to Seamlessly Import Stripe Data into IBM SPSS Modeler

  Integrate Stripe data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• How to Connect to & Open LinkedIn Ads Data in Microsoft Excel

  This article uses the CData ODBC driver for LinkedIn Ads to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• «
• 971
• 972
• 973
• 974
• 975
• 976
• 977
• 978
• 979
• 980
• »