CData Software - Knowledge Base

Recent Articles

---

• «
• 62
• 63
• 64
• 65
• 66
• 67
• 68
• 69
• 70
• 71
• »

• Import Impala Data Using Azure Data Factory

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

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed Printful to Power BI dashboards. Simply drag and drop Printful into data visuals on the Power BI canvas.

• Getting Started with the CData Tableau Connector for ChargeOver

  Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.

• Visualize Cvent Data in TIBCO Spotfire through OData

  Integrate Cvent into dashboards in TIBCO Spotfire.

• Create a Data Access Object for eBay Analytics Data using JDBI

  A brief overview of creating a SQL Object API for eBay Analytics in JDBI.

• Create Informatica Mappings From/To an ODBC Data Source for MailChimp

  Create an ODBC connection to MailChimp in Informatica and browse and transfer MailChimp.

• Create Redshift Dataflows on PowerBI.com

  Connect to the CData Power BI Connector for Redshift from PowerBI.com to create Power BI Dataflows with real-time data.

• Manage XML Data in DBArtisan as a JDBC Source

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

• Moving Data from Helpscout to SQL Server Using Toad Data Point and CData ODBC Driver

  Query, export, and automate live Helpscout data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.

• Connect to and Query Harvest Data in QlikView over ODBC

  Create data visualizations with Harvest in QlikView.

• How to connect SharePoint with WordPress Data through external lists

  Provide WordPress to SharePoint users as an external list.

• Build an OLAP Cube in SSAS from ZeroBounce Data

  Establish a connection to ZeroBounce data from SQL Server Analysis Services, and use the ZeroBounce Data Provider to build OLAP cubes for use in analytics and reporting.

• Access Live JSON Services in Roo Code via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live JSON through MCP integration.

• Query Epicor Kinetic Data as a SQL Server Database in Node.js

  Execute SQL Server queries against Epicor Kinetic from Node.js.

• How to connect and process Klipfolio from Azure Databricks

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

• Automated Continuous CampaignMonitor Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Google BigQuery.

• How to load Microsoft OneDrive data into Elasticsearch via Logstash

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

• Connect to Lakebase Data from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Lakebase using standard SQL.

• Process & Analyze Landbot Data in Databricks (AWS)

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

• Integrate SQL Server Data in the Pentaho Report Designer

  Publish reports based on Microsoft SQL Server in the Pentaho BI tool.

• Automated Continuous Cassandra Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Cassandra replication to Apache Kafka.

• Use the CData Software ODBC Driver for ShipEngine in SAS for Real-Time Reporting and Analytics

  Connect to real-time ShipEngine in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ShipEngine.

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

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

• Connect to SageHR Data in NetBeans

  Connect to SageHR in NetBeans with the data source configuration wizard.

• Automated Continuous Outreach.io Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Outreach.io replication to PostgreSQL.

• Integrating Claude Code CLI with Ontraport 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 ODBC Driver for Cvent in MicroStrategy

  Connect to Cvent in MicroStrategy Developer using the CData Software ODBC Driver for Cvent.

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

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

• Use the CData Software ODBC Driver for SAP Netweaver Gateway in MicroStrategy

  Connect to SAP Netweaver Gateway in MicroStrategy Developer using the CData Software ODBC Driver for SAP Netweaver Gateway.

• Integrate Webex Data in Pentaho Data Integration

  Build ETL pipelines based on Webex in the Pentaho Data Integration tool.

• Build QuickBooks Online-Powered Applications in Cursor with CData MCP Server

  Use the CData MCP Server for QuickBooks Online to explore live QuickBooks Online Data in Cursor to assist with building QuickBooks Online-powered applications.

• Getting Started with the CData Power BI Connector for ClickTime

  Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.

• Automated Continuous Stack Exchange Replication to Apache Kafka

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

• A PostgreSQL Interface for Azure Data Lake Storage Data (MySQL Remoting via JDBC)

  Use the Remoting features of the Azure Data Lake Storage JDBC Driver to create a PostgreSQL entry-point for data access.

• Visualize Pipeliner CRM 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 Pipeliner CRM into TIBCO Spotfire.

• Automate Freshteam Data Replication to Azure Data Lake

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

• Connect to Freshsales Data Using the Script Function in Claris FileMaker Pro

  Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Freshsales and work with Freshsales in your FileMaker application.

• Connect to Dropbox Data from Filemaker Pro (Mac)

  Use CData Connect AI to connect to and query live Dropbox from Filemaker Pro on Mac.

• Build Dynamics 365-Connected Apps in Mendix

  Use CData Connect AI to create an OData feed for Dynamics 365 Data and create custom apps in Mendix.

• How to Design Greenplum Power Apps with Database-Like Connectivity

  Gain real-time, database-like connectivity to Greenplum from mobile and tablet Power Apps.

• Analyze Ontraport Data in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Ontraport in Microsoft R Open.

• Build Airtable-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Airtable.

• Create Informatica Mappings From/To an ODBC Data Source for HubDB

  Create an ODBC connection to HubDB in Informatica and browse and transfer HubDB.

• Connect to Outreach.io Data in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Outreach.io in the Denodo Virtual DataPort Administrator.

• Automated Continuous Sendwithus Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Sendwithus replication to Azure SQL Database.

• Integrate Google Ads with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Google Ads with External Services.

• Connect to Spotify Data in NetBeans

  Connect to Spotify in NetBeans with the data source configuration wizard.

• Create Data Visualizations Based On Instagram Data in Mode

  Use CData Connect AI to connect to Instagram Data from Mode and build visualizations using live

• Build Email-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live Email.

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

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

• Validate Invoiced Data with QuerySurge

  Access and validate Invoiced in QuerySurge using the CData JDBC Driver.

• Connect to Hive from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Apache Hive, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• How to Access ZohoPeople Data Using Entity Framework

  This article shows how to access ZohoPeople using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Bidirectional Access to Hive Data from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Apache Hive in Filemaker Pro for Mac or Windows.

• Stream Salesforce Pardot Data into Apache Kafka Topics

  Access and stream Salesforce Pardot in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Automated Continuous ZohoPeople Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable ZohoPeople replication to AlloyDB.

• Prepare, Blend, and Analyze SQL Analysis Services Data in Alteryx Designer (Connect AI)

  Build workflows to access live SQL Analysis Services for self-service data analytics.

• Build AI Agents with Adobe Analytics Data in IBM watsonx Orchestrate using CData Connect AI

  Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Adobe Analytics through CData Connect AI.

• How to Connect to Live SingleStore Data from OpenAI Python Applications (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your SingleStore through natural language.

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

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

• Use the CData Software ODBC Driver for Google Drive in MicroStrategy

  Connect to Google Drive in MicroStrategy Developer using the CData Software ODBC Driver for Google Drive.

• How to connect to Oracle Eloqua Data in DBVisualizer

  Integrate Oracle Eloqua with visual data analysis tools and data connection wizards in DBVisualizer

• Build Dashboards with ChartMogul Data in Dundas BI

  Create dynamic dashboards and perform analytics based on ChartMogul in Dundas BI.

• Validate Google Search Results with QuerySurge

  Access and validate Google Search in QuerySurge using the CData JDBC Driver.

• Visualize Reckon Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Reckon.

• Build a Singer.io Tap for Sentry With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Sentry data using

• Automate PayPal Tasks in Power Automate Using CData API Server

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

• Extend Google Sheets with Zendesk Data

  Make calls to Zendesk from Google Apps Script via the API Server.

• Integrating Gumloop with Slack Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Slack within automated workflows.

• Create Informatica Mappings From/To an ODBC Data Source for Google Sheets

  Create an ODBC connection to Google Sheets in Informatica and browse and transfer Google Sheets.

• Build an OLAP Cube in SSAS from ZohoMarketingHub Data

  Establish a connection to ZohoMarketingHub data from SQL Server Analysis Services, and use the ZohoMarketingHub Data Provider to build OLAP cubes for use in analytics and reporting.

• Build Semantic Layer Views for Ontraport Data in APOS Live Data Gateway

  Use the CData Connector for Ontraport in APOS Live Data Gateway to build Semantic Layer Views for Ontraport.

• Use Dash to Build to Web Apps on Superchat Data

  Create Python applications that use pandas and Dash to build Superchat-connected web apps.

• Using the CData Software ODBC Driver for Apify in PyCharm

  Connect to Apify as an ODBC data source in PyCharm using the CData Software ODBC Driver for Apify.

• How to connect to Databricks Data in DBVisualizer

  Integrate Databricks with visual data analysis tools and data connection wizards in DBVisualizer

• Use the CData Software ODBC Driver for Drift in MicroStrategy Desktop

  Connect to Drift in MicroStrategy Desktop using the CData Software ODBC Driver for Drift.

• Work with Live Okta Data in Power Query

  Use CData Connect AI to connect to Okta and work with live Okta in Microsoft Power Query.

• Integrate Cline with Live Sage Intacct Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Sage Intacct from within your IDE.

• Query Jira Data as a MySQL Database in Node.js

  Execute MySQL queries against Atlassian Jira from Node.js.

• Integrate Freshdesk Data in Pentaho Data Integration

  Build ETL pipelines based on Freshdesk in the Pentaho Data Integration tool.

• Connect to Active Directory Data in Airbyte ELT Pipelines

  Use CData Connect AI to build ELT pipelines for Active Directory in Airbyte.

• Create Reports with Google Search Results in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Google Search.

• Integrating Cursor CLI with FTP 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.

• Create Reports with Scrapfly Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Scrapfly.

• Visualize Live Parallel Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Parallel.

• Validate SingleStore Data with QuerySurge

  Access and validate SingleStore in QuerySurge using the CData JDBC Driver.

• Connect to Klipfolio Data from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Klipfolio to connect to Klipfolio and execute queries in PowerBuilder.

• LINQ to XML Data

  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 XML Data Provider.

• Automated Continuous Salesforce CRM Analytics Replication to MySQL

  Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to MySQL.

• Connect to SingleStore Data in JRuby

  Create a simple JRuby app with access to live SingleStore.

• Access ZohoPeople Data from MySQL in Amazon QuickSight

  Connect to ZohoPeople and build visualizations of ZohoPeople using a MySQL Connection in Amazon QuickSight.

• Query Sugar CRM Data using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Sugar CRM entities in PHP by modeling them as objects.

• Automated Continuous Oracle Eloqua Reporting Replication to Databricks

  Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to Databricks.

• Integrate with Xero Data using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Xero Accounting to a JSON file on disk.

• Automated Continuous Bitbucket Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Bitbucket replication to AlloyDB.

• Integrating Klaviyo Data in Talend Cloud Data Management Platform

  Connect Klaviyo Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Klaviyo.

• Consume Azure Data Lake Storage OData Feeds in PowerBuilder

  This article demonstrates how to consume Azure Data Lake Storage as OData feeds from PowerBuilder using the API Server.

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

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

• Integrating GitHub Copilot CLI with ClickTime 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.

• Analyze Redis Data in Looker

  Use CData Connect AI to connect to Redis Data from Looker and build custom apps using live Redis.

• «
• 62
• 63
• 64
• 65
• 66
• 67
• 68
• 69
• 70
• 71
• »