CData Software - Knowledge Base

Recent Articles

---

• «
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• »

• Access PhantomBuster Data from MySQL in Amazon QuickSight

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

• View Reports on Real-Time SFTP Data in Power BI Report Server

  Use the CData ODBC Driver for SFTP to visualize SFTP in Power BI Desktop and then publish them to Power BI Report Server.

• Integrate Kafka with External Services using SnapLogic

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

• How to connect SharePoint with DB2 Data through external lists

  Provide IBM DB2 to SharePoint users as an external list.

• Build a PostgreSQL Interface for ChartMogul Data using the CData JDBC Driver

  Use the Remoting features of the ChartMogul JDBC Driver to create a PostgreSQL entry-point for data access.

• How to create Quaderno federated tables in MySQL

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

• Use CData Connect AI to Access SingleStore Data in Microsoft Power Pivot

  Use CData Connect AI to connect to live SingleStore in the Power Pivot business intelligence tool.

• Build Agents in Relevance AI with Access to Live Facebook Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Facebook within intelligent agent workflows.

• How to Connect to Kintone Data in Using Python: 6 Steps

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

• How to work with Avalara AvaTax Data in Apache Spark using SQL

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

• Trigger Box IFTTT Flows in Azure App Service

  Automate IFTTT (if-this-then-that) workflows for Box with standard wizards in Logic Apps.

• Use the CData Software ODBC Driver for Dynamics 365 in MicroStrategy Desktop

  Connect to Microsoft Dynamics 365 in MicroStrategy Desktop using the CData Software ODBC Driver for Dynamics 365.

• Build a Simple VCL Application for Zuora Data

  How to build a simple VCL Application to view Zuora in RAD Studio using the CData ODBC Driver for Zuora.

• Build an OLAP Cube in SSAS from Blackbaud FE NXT Data

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

• DataBind Controls to MySQL Data in Delphi

  DataBind to MySQL in Delphi with standard data access components and controls.

• How to Connect to Instantly Data in Using Python: 6 Steps

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

• Analyze Couchbase Data in Looker

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

• Object-Relational Mapping (ORM) with Tickspot 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 Tickspot into a Java-based ORM framework, Hibernate.

• How to connect to Sage Intacct Data with Squirrel SQL client

  Connect to Sage Intacct and execute queries in the Squirrel SQL Client.

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

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

• Automated Continuous BenchmarkEmail Replication to PostgreSQL

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

• Integrating Gumloop with Oracle Eloqua Data via CData Connect AI

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

• Replicate Marketo Data to Multiple Databases

  Replicate Marketo to disparate databases with a point-and-click configuration.

• Automate Invoiced Data Replication to Azure Synapse

  Use CData Sync to customize and automate Invoiced replication to Azure Synapse.

• How to Easily Query Klaviyo Data in OpenOffice Base

  Connect to Klaviyo data in OpenOffice Base using the CData ODBC Driver for Klaviyo and generate reports with live data insights.

• How to Query Live Delighted Data in Claude Desktop

  Connect to and query live Delighted Data in Claude Desktop using CData MCP Server.

• Migrating data from RSS to Google BigQuery using CData SSIS Components.

  Easily push RSS Feeds to Google BigQuery using the CData SSIS Tasks for RSS and Google BigQuery.

• Access CloudConvert Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access CloudConvert from your Oracle system.

• Automated Continuous API Replication to SingleStore

  Use CData Sync for automated, continuous, customizable API replication to SingleStore.

• How to load Hugging Face data into Elasticsearch via Logstash

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

• Use the CData ODBC Driver for PagerDuty from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for PagerDuty to connect to PagerDuty from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring PagerDuty in Excel.

• Publish Reports with CircleCI Data in SAP Crystal Reports

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

• Access Live Kintone Data in AWS Lambda

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

• Connect to Insightly Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Analyze Azure Analysis Services Data in Infragistics Reveal

  Use CData Connect AI to create on OData API on top of Azure Analysis Services and visualize live Azure Analysis Services in Infragistics Reveal.

• Use the CData Software JDBC Driver for Highrise in MicroStrategy

  Connect to Highrise CRM in MicroStrategy Developer using the CData Software JDBC Driver for Highrise.

• Integrating Codex CLI with Discourse 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.

• Integrate Microsoft Planner Data in Pentaho Data Integration

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

• Connect and Visualize Live Twitter Ads Data in Databricks Lakehouse Federation with CData Connect AI

  Use CData Connect AI to integrate live Twitter Ads into the Databricks platform and create visualization dashboards with real-time Twitter Ads.

• Build Pipelines with Live QuickBooks Time Data in Google Cloud Data Fusion (via CData Connect AI)

  Use CData Connect AI to connect to QuickBooks Time from Google Cloud Data Fusion, enabling the integration of live QuickBooks Time into the building and management of effective data pipelines.

• Enable the Azure Synapse JDBC Driver in KNIME

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

• Back Up Veeva Vault & Vault CRM to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Vault CRM. In this article, we will employ an SSIS workflow to populate a database with Veeva Vault & Vault CRM data.

• Connect to Freshservice Data in Aqua Data Studio

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

• Publish Reports with Cosmos DB Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Azure Cosmos DB.

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

• Build Apps with Live Oracle Eloqua Data Using the Low-Code Development Platform of Mendix

  Connect Oracle Eloqua with Mendix to build apps using the CData JDBC Driver for Eloqua.

• Creating Stripe-Connected Applications in Unqork

  You can use CData Connect AI to feed Stripe to Unqork and build custom business apps.

• How to Query Live Drift Data in Perplexity MacOS Desktop

  Connect to and query live Drift Data in Perplexity Desktop using CData MCP Server.

• Build AI Agents with Procore 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 Procore through CData Connect AI.

• Replicate QuickBooks Online Data from PowerShell

  Write a quick PowerShell script to query QuickBooks Online. Use connectivity to the live data to replicate QuickBooks Online to SQL Server.

• Automated Redis Data Replication to Teradata

  Use CData Sync to Customize and automate Redis replication to Teradata.

• Getting Started with the CData Python Connector for Wrike

  Learn to install and license the CData Python Connector

• Automated Continuous MarkLogic Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable MarkLogic replication to Amazon Redshift.

• Connect to Act CRM Data in HULFT Integrate

  Connect to Act CRM as a JDBC data source in HULFT Integrate

• Integrate with Pinecone Data using Apache Camel2

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

• Build SAP Fieldglass-Connected Dashboards Using Zoho Analytics

  Use CData Connect AI to connect to SAP Fieldglass Data from Zoho Analytics and import live SAP Fieldglass.

• How to Connect DBeaver to SingleStore via a JDBC Driver

  Manage SingleStore with visual tools in DBeaver like the query browser.

• Design BIRT Reports on SAP SuccessFactors Data

  Provide current SAP SuccessFactors to your embedded analytics.

• Connect to Mode Data in RapidMiner

  Integrate Mode with standard components and data source configuration wizards in RapidMiner Studio.

• How to connect to Dropbox Data with Squirrel SQL client

  Connect to Dropbox and execute queries in the Squirrel SQL Client.

• Build Visualizations of Billsby Data in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Billsby in Birst.

• Analyze WordPress Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of WordPress and visualize live WordPress in Infragistics Reveal.

• Visualize Box Data from Tableau

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

• How to Query Live Azure DevOps Data in Claude Desktop

  Connect to and query live Azure DevOps Data in Claude Desktop using CData MCP Server.

• Visualize Zoho Recruit Data in TIBCO Spotfire through ADO.NET

  Integrate Zoho Recruit into dashboards in TIBCO Spotfire.

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

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

• Build Onfleet-Powered Applications in Claude Code with CData MCP Server

  Use the CData API Driver for MCP Server to explore live Onfleet Data in Claude Code to assist with building Onfleet-powered applications.

• Extend Google Sheets with Dynamics 365 Business Central Data

  Make calls to Dynamics 365 Business Central from Google Apps Script via the API Server.

• How to Query Live Wave Financial Data in Claude Desktop

  Connect to and query live Wave Financial Data in Claude Desktop using CData MCP Server.

• Connecting Moonlit Workflow with Jira Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Atlassian Jira in real time.

• Connect to eBay Analytics Data in HULFT Integrate

  Connect to eBay Analytics as a JDBC data source in HULFT Integrate

• Build a PostgreSQL Interface for Nethunt Data using the CData JDBC Driver

  Use the Remoting features of the Nethunt JDBC Driver to create a PostgreSQL entry-point for data access.

• Work with Certinia Data in FoxPro

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

• Use the CData ODBC Driver for ShipStation from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for ShipStation to connect to ShipStation from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ShipStation in Excel.

• Publish Google Spanner-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Google Spanner.

• Work with Raisers Edge NXT Data in FoxPro

  Load Raisers Edge NXT into a FoxPro database. This article includes full code and a walk-through of the process.

• Connect to Kintone Data in JRuby

  Create a simple JRuby app with access to live Kintone.

• Build a Simple VCL Application for Kintone Data

  How to build a simple VCL Application to view Kintone in RAD Studio using the CData ODBC Driver for Kintone.

• Connect to Microsoft OneDrive Data from HeidiSQL

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

• Stream Oracle HCM Cloud Data into Apache Kafka Topics

  Access and stream Oracle HCM Cloud in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Use ChatGPT to Talk to Your Sage Cloud Accounting Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Sage Business Cloud Accounting for you.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Jira Assets

  Provide connectivity to Jira Assets through an SAP BusinessObjects universe.

• Migrating data from Chargebee to Databricks using CData SSIS Components.

  Easily push Chargebee to Databricks using the CData SSIS Tasks for Chargebee and Databricks.

• Work with Simplesat Data in FoxPro

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

• Enable the Oracle Eloqua JDBC Driver in KNIME

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

• Query Bannerbear Data from Node.js

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

• Access Live Tanda Data in AWS Lambda

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

• Integrate TaxJar Data in the Pentaho Report Designer

  Publish reports based on TaxJar in the Pentaho BI tool.

• Load Samanage Data to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Samanage to a database.

• Analyze Freshsales Data in Slingshot with CData API Server

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

• Connect to Hugging Face Data in Ruby

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

• Create SSAS Tabular Models from Aha! Data

  How to build a SQL Server Analysis Service Tabular Model from Aha! using CData drivers.

• Create SurveyMonkey Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time SurveyMonkey data access from reports, embedded analytics, and more.

• Create Power BI Reports on Real-Time PolarTeamPro Data

  Use the CData ODBC Driver for PolarTeamPro to visualize PolarTeamPro in Power BI Desktop.

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

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

• Build Moosend-Powered Applications in Claude Code with CData MCP Server

  Use the CData API Driver for MCP Server to explore live Moosend Data in Claude Code to assist with building Moosend-powered applications.

• Create Reports from Basecamp Data in Looker Studio

  Use CData Connect AI to gain access to live Basecamp and create custom reports in Looker Studio.

• Access Workday 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 Workday.

• How to Connect to Live Impala Data from Sourcegraph Amp (via CData Connect AI)

  Integrate Sourcegraph Amp with CData Connect AI to query and manage live Apache Impala securely in real time.

• Bind Live Teamwork Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Teamwork data

• «
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• »