CData Software - Knowledge Base
Recent Articles
-
How to connect to Opsgenie Data from Spring Boot
Connect to Opsgenie in a Spring Boot Application using the CData API Driver for JDBC
-
Build Semantic Layer Views for TaxJar Data in APOS Live Data Gateway
Use the CData Connector for TaxJar in APOS Live Data Gateway to build Semantic Layer Views for TaxJar.
-
Replicate LightSpeedRetail Data to Multiple Databases
Replicate LightSpeedRetail to disparate databases with a point-and-click configuration.
-
Rapidly Develop Airtable-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Airtable.
-
Operational Reporting on SAP Ariba Procurement Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP Ariba Procurement.
-
Object-Relational Mapping (ORM) with Box 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 Box into a Java-based ORM framework, Hibernate.
-
How to integrate Onfleet with Apache Airflow
Access and process Onfleet in Apache Airflow using the CData JDBC Driver.
-
Migrating data from OpenWeatherMap to Google BigQuery using CData SSIS Components.
Easily push OpenWeatherMap to Google BigQuery using the CData SSIS Tasks for OpenWeatherMap and Google BigQuery.
-
Use the CData Software ODBC Driver for Act-On in SAS for Real-Time Reporting and Analytics
Connect to real-time Act-On in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Act-On.
-
Integrate Real-Time Access to CircleCI in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to CircleCI in real time.
-
Integrate Live Zoho Projects Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Zoho Projects from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zoho Projects.
-
Bind Live WooCommerce Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live WooCommerce data
-
Build AI Agents with Greenplum 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 Pivotal GreenPlum through CData Connect AI.
-
Automate EnterpriseDB Data Replication to Couchbase
Use CData Sync to Customize and automate EnterpriseDB replication to Couchbase.
-
How to Query Live Mailgun Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Mailgun data in natural language using Python.
-
Integrate with MailerSend Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy MailerSend to a JSON file on disk.
-
How to Work with GitHub Data in ETL Validator JDBC
Connect to GitHub from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Datasets from SFTP in Domo Workbench and Build Visualizations of SFTP Data in Domo
Use the CData Software ODBC Driver for SFTP to create datasets from SFTP in Domo Workbench and then build visualizations in the Domo service.
-
Write a Simple Go Application to work with Adobe Analytics Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Adobe Analytics.
-
Azure Data Lake Storage Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Azure Data Lake Storage facts in real time.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Microsoft Exchange within intelligent workflows.
-
How to connect to Amazon Athena Data from Spring Boot
Connect to Amazon Athena in a Spring Boot Application using the CData JDBC Driver for Amazon Athena
-
How to Connect to Live LinkedIn Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your LinkedIn for you.
-
Getting Started with the CData Excel Add-In for CampaignMonitor
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for CampaignMonitor.
-
Visualize Live Pushbullet Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Pushbullet using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind Charts to Tally Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Tally ERP 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.
-
Object-Relational Mapping (ORM) with Klipfolio 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 Klipfolio into a Java-based ORM framework, Hibernate.
-
Connect to Greenplum Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Pivotal GreenPlum from Filemaker Pro on Mac.
-
Build Blackbaud FE NXT-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Blackbaud FE NXT Data from Zoho Analytics and import live Blackbaud FE NXT.
-
How to Seamlessly Import SAP Business Warehouse Data into IBM SPSS Modeler
Integrate SAP Business Warehouse data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create Highrise-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Highrise Data from Klipfolio and build custom visualizations using live Highrise CRM.
-
Connect to Google Forms Data in NetBeans
Connect to Google Forms in NetBeans with the data source configuration wizard.
-
Build Vault CRM Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Veeva Vault & Vault CRM and build visualizations in Tableau Cloud.
-
How to Connect the Power BI Service to Moosend: Complete Guide
Connect to the CData Software Power BI Connector for Moosend from PowerBI.com to provide real-time Moosend across the organization.
-
Connect to SAP BusinessObjects BI Data in NetBeans
Connect to SAP BusinessObjects BI in NetBeans with the data source configuration wizard.
-
Extend Google Sheets with Elasticsearch Data
Make calls to Elasticsearch from Google Apps Script via the API Server.
-
Access Live Reckon Accounts Hosted 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 Reckon Accounts Hosted through MCP integration.
-
Integrating Boomi Agentstudio with Snowflake Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Snowflake, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Dashboards with SAP Netweaver Gateway Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Netweaver Gateway in Dundas BI.
-
Migrating data from Basecamp to Snowflake using CData SSIS Components.
Easily push Basecamp to Snowflake using the CData SSIS Tasks for Basecamp and Snowflake.
-
Using the CData Software ODBC Driver for Reckon Accounts Hosted in PyCharm
Connect to Reckon Accounts Hosted as an ODBC data source in PyCharm using the CData Software ODBC Driver for Reckon Accounts Hosted.
-
Connect to SAS xpt Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAS XPORT in Airbyte.
-
Build Apps with Live CouchDB Data Using the Low-Code Development Platform of Mendix
Connect Apache CouchDB with Mendix to build apps using the CData JDBC Driver for CouchDB.
-
Build Odoo-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Odoo to explore live Odoo Data in Gemini Code Assist to assist with building Odoo-powered applications.
-
How to Work with ZohoExpense Data in AWS Glue Jobs Using JDBC
Connect to ZohoExpense from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Getting Started with the CData Power BI Connector for Webflow
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Explore Geographical Relationships in Microsoft Teams Data with Power Map
Create data visualizations with Microsoft Teams in Power Map.
-
Build Charts with Freshteam Data in Clear Analytics
Create dynamic charts and perform analytics based on Freshteam in Clear Analytics.
-
Access Live Elasticsearch Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Elasticsearch into the statistical analysis tools available in SAS JMP. This article shows how to use Elasticsearch in the Graph Builder and Query Builder.
-
Query Shortcut Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Shortcut and perform CRUD operations on Shortcut from Node.js.
-
Connect to Grafana Data from a Connection Pool in JBoss
Integrate Grafana into Java servlets: Use the Management Console in JBoss to install the Grafana JDBC Driver.
-
Visualize Azure DevOps Data in Sisense
Create an ElastiCube in Sisense app with access to Azure DevOps.
-
Connect to Sentry Data from PowerBuilder via JDBC
This article demonstrates how to access Sentry from PowerBuilder using the Sentry JDBC Driver.
-
Build Google Search-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Search Results from Zoho Analytics and import live Google Search.
-
How to create an RPA flow for Excel Online Data in UiPath Studio
Use the Excel Online ODBC Driver to create workflows that access real-time Microsoft Excel Online without any coding.
-
Use the CData Software ODBC Driver for Epicor Kinetic in MicroStrategy Web
Connect to Epicor Kinetic in MicroStrategy Web using the CData Software ODBC Driver for Epicor Kinetic.
-
Replicate Multiple Parquet Accounts
Replicate multiple Parquet accounts to one or many databases.
-
How to Query Live SAP SuccessFactors Data in Claude Desktop
Connect to and query live SAP SuccessFactors Data in Claude Desktop using CData MCP Server.
-
Build Data Flows from Phoenix to SQL Server using SSIS
Easily back up Apache Phoenix to SQL Server using the SSIS components for Phoenix.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Insightly to Power BI dashboards. Simply drag and drop Insightly into data visuals on the Power BI canvas.
-
Connect to Todoist Data in Ruby
Connect to Todoist in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Data Visualizations Based On Acumatica Data in Mode
Use CData Connect AI to connect to Acumatica Data from Mode and build visualizations using live
-
Integrate MailerLite with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate MailerLite with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to MailerLite.
-
DataBind Controls to Avro Data in C++Builder
DataBind to Apache Avro in C++Builder with standard components and controls.
-
Create Reports with Shopify Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Shopify.
-
Build Hacker News-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Hacker News and build web apps with connectivity to live Hacker News.
-
Write a Simple Go Application to work with RSS Feeds on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to RSS Feeds.
-
Automated XML Data Replication to Teradata
Use CData Sync to Customize and automate XML Files replication to Teradata.
-
Integrating LangGraph with ServiceNow Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on ServiceNow within automated workflows.
-
Build Semantic Layer Views for xBase Data in APOS Live Data Gateway
Use the CData Connector for xBase in APOS Live Data Gateway to build Semantic Layer Views for xBase.
-
Automated Continuous Amazon Marketplace Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to AlloyDB.
-
Visualize Live ChargeOver Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ChargeOver.
-
Connecting Moonlit Workflow with MarkLogic 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 MarkLogic in real time.
-
Replicate ConstantContact Data in Heroku for Use in Salesforce Connect
Replicate ConstantContact to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Getting Started with the CData Excel Add-In for Xero
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Xero.
-
A PostgreSQL Interface for Exa Data (MySQL Remoting via JDBC)
Use the Remoting features of the Exa JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData ODBC Driver for Google Cloud Storage from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Cloud Storage to connect to Google Cloud Storage from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Cloud Storage in Excel.
-
Connect to Acumatica Data in Google Apps Script via Connect AI
Use CData Connect AI to access Acumatica ERP in Google Apps Script.
-
Automated Continuous Azure Data Catalog Replication to Vertica
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Vertica.
-
Connect to NASA from Asprova with CData Software ODBC Driver for NASA
This article shows how to connect faster to NASA data from Asprova.
-
How to Query Sage 200 Data in MySQL Workbench
Execute MySQL queries against live Sage 200 from MySQL Workbench.
-
Integrating Claude Code with Sybase Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Sybase within assisted coding and automated development workflows.
-
Query Notion Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Notion and perform CRUD operations on Notion from Node.js.
-
How to connect to TigerGraph Data from IntelliJ
Integrate connectivity to TigerGraph with wizards in IntelliJ.
-
Create Power BI Reports on Real-Time Active Directory Data
Use the CData ODBC Driver for Active Directory to visualize Active Directory in Power BI Desktop.
-
Migrating data from ZeroBounce to Google BigQuery using CData SSIS Components.
Easily push ZeroBounce to Google BigQuery using the CData SSIS Tasks for ZeroBounce and Google BigQuery.
-
Explore Geographical Relationships in Postmark Data with Power Map
Create data visualizations with Postmark in Power Map.
-
Enable the Eventbrite JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Eventbrite.
-
Query Dynamics CRM Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Dynamics CRM entities in PHP by modeling them as objects.
-
Getting Started with the CData Excel Add-In for Productboard
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Productboard.
-
Using the CData Software ODBC Driver for Sybase IQ in PyCharm
Connect to Sybase IQ as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sybase IQ.
-
Use the CData Software JDBC Driver for Instagram in MicroStrategy Web
Connect to Instagram in MicroStrategy Web using the CData Software JDBC Driver for Instagram.
-
Using the CData Software ODBC Driver for Microsoft Entra ID in PyCharm
Connect to Microsoft Entra ID as an ODBC data source in PyCharm using the CData Software ODBC Driver for Microsoft Entra ID.
-
Analyze WooCommerce Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for WooCommerce from Power Pivot. You will use the Table Import Wizard to load WooCommerce. You can visually build the import query or use any SQL supported by the driver.
-
ETL Microsoft Planner in Oracle Data Integrator
This article shows how to transfer Microsoft Planner into a data warehouse using Oracle Data Integrator.
-
Migrating data from Mistral AI to Snowflake using CData SSIS Components.
Easily push Mistral AI to Snowflake using the CData SSIS Tasks for Mistral AI and Snowflake.
-
Publish Reply.io-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Reply.io.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Snowflake
Provide connectivity to Snowflake through an SAP BusinessObjects universe.
-
LINQ to Teamgate 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 Teamgate Data Provider.
-
Automated Continuous LinkedIn Ads Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to Amazon Redshift.