CData Software - Knowledge Base
Recent Articles
-
Connect to SAP SuccessFactors Data in Jaspersoft Studio
Execute SQL to remote SAP SuccessFactors data in Jaspersoft Studio.
-
Create Data Visualizations Based On Timely Data in Mode
Use CData Connect AI to connect to Timely Data from Mode and build visualizations using live Timely data.
-
Automated Continuous Foursquare Replication to SQLite
Use CData Sync for automated, continuous, customizable Foursquare replication to SQLite.
-
Deploy the ADO.NET Provider for Wistia on an SSRS Report Server
Connect to Wistia data 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.
-
Natively Connect to Tally Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Tally data. Leverage the native support for ODBC in PHP.
-
Building Dynamic Web Pages with SurveyMonkey Data Using AngularJS
Create single-page applications with live connectivity to SurveyMonkey using the CData API Server.
-
Integrating Dataiku with Certinia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Certinia data.
-
Connect to AfterShip Data in Jaspersoft Studio
Execute SQL to remote AfterShip data in Jaspersoft Studio.
-
Prepare, Blend, and Analyze Microsoft Ads Data in Alteryx Designer (ODBC)
Build workflows to access live Microsoft Ads data for self-service data analytics.
-
Connect to ConvertAPI Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ConvertAPI and the SQL Gateway to access ConvertAPI data from Google Apps Script.
-
Query NetSuite Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume NetSuite entities in PHP by modeling them as objects.
-
Connect to Exa Data in Aqua Data Studio
Access Exa data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Live Superchat Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Superchat data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Configure the CData JDBC Driver for Smartsheet in a Connection Pool in Tomcat
Connect to Smartsheet data from a connection pool in Tomcat.
-
Import and Visualize Sentry Data in Power View
Create data visualizations based on Sentry data in Excel.
-
Getting Started with the CData Tableau Connector for Dynamics NAV
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Dynamics NAV.
-
Build Typeform-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Typeform data without replication.
-
Use the CData SSIS Components to Insert New or Update Existing MarkLogic Records from SQL Server
Easily push SQL Server data to MarkLogic using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into MarkLogic or update existing records with data from a SQL Server database.
-
Create Invoiced Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Invoiced data access from reports, embedded analytics, and more.
-
Automated Continuous Retently Replication to SingleStore
Use CData Sync for automated, continuous, customizable Retently replication to SingleStore.
-
Integrating Kiro with Hacker News 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 Agno to Talk to Your Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Spark data for you.
-
Build Agents in Relevance AI with Access to Live Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft Planner data within intelligent agent workflows.
-
Integrating GitHub Copilot with Mouseflow 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 SSIS Components to Insert New or Update Existing Exact Online Records from SQL Server
Easily push SQL Server data to Exact Online using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Exact Online or update existing records with data from a SQL Server database.
-
Connect Excel Online to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Excel Online with IBM WebSphere for seamless data integration and connectivity.
-
Provide OData Services of Azure DevOps Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Azure DevOps data by developing a WCF Service Application.
-
Create SageHR-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SageHR Data from OutSystems and build custom enterprise apps using live SageHR data.
-
Connect Azure Data Lake Storage Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Azure Data Lake Storage data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Validate Outreach.io Data with QuerySurge
Access and validate Outreach.io data in QuerySurge using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Figshare in SAS for Real-Time Reporting and Analytics
Connect to real-time Figshare data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Figshare.
-
Connect to Google Drive Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Drive data using standard SQL.
-
How to Connect to & Open Vault CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Vault CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create DocuSign-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to DocuSign Data from OutSystems and build custom enterprise apps using live DocuSign data.
-
Build Jumpseller-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Jumpseller data.
-
Work with Live Square Data in Power Query
Use CData Connect AI to connect to Square data and work with live Square data in Microsoft Power Query.
-
Bind Live Parquet Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Parquet data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect to Real-Time SparkPost Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use SparkPost data in Power Apps.
-
Create Azure Data Lake Storage Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Azure Data Lake Storage data access from reports, embedded analytics, and more.
-
Seamlessly Bring Freshdesk Data into Retool Using CData Connect AI
Integrate Freshdesk data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Automated Freshdesk-Connected Workflows in Zapier
Use CData Connect AI to connect to live Freshdesk data and build automated workflows in Zapier.
-
How to Access Pinecone Data Using Entity Framework
This article shows how to access Pinecone data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access WooCommerce Data from MySQL in PHP
Connect to WooCommerce through the standard MySQL libraries in PHP.
-
Automate Box Data Replication to Azure Data Lake
Use CData Sync to customize and automate Box data replication to Azure Data Lake.
-
Create Dynamic SAP Ariba Source Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP Ariba Source to Infragistics XamDataGrid to build dynamic grids.
-
How to create an RPA flow for PingOne Data in UiPath Studio
Use the PingOne ODBC Driver to create workflows that access real-time PingOne data without any coding.
-
Build an OLAP Cube in SSAS from Bitbucket Data
Establish a connection to Bitbucket data data from SQL Server Analysis Services, and use the Bitbucket Data Provider to build OLAP cubes for use in analytics and reporting.
-
Design BIRT Reports on Teradata Data
Provide current Teradata data to your embedded analytics.
-
Create Power BI Reports on Real-Time CSV Data
Use the CData ODBC Driver for CSV to visualize CSV data in Power BI Desktop.
-
How to Query LDAP Objects in MySQL Workbench
Execute MySQL queries against live LDAP objects from MySQL Workbench.
-
Create Bannerbear-Connected Dashboards in Grafana
Connect to Bannerbear Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Bannerbear data.
-
Creating LinkedIn Ads-Connected Applications in Unqork
You can use CData Connect AI to feed LinkedIn Ads data to Unqork and build custom business apps.
-
Create Dashboards and Visualize Live Email Data in Geckoboard
Use CData Connect AI to connect to live Email data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Bitbucket Replication to MySQL
Use CData Sync for automated, continuous, customizable Bitbucket replication to MySQL.
-
Configure the CData JDBC Driver for Datadog in a Connection Pool in Tomcat
Connect to Datadog data from a connection pool in Tomcat.
-
How to Query PingOne Data in MySQL Workbench
Execute MySQL queries against live PingOne data from MySQL Workbench.
-
View Reports on Real-Time Salesloft Data in Power BI Report Server
Use the CData ODBC Driver for Salesloft to visualize Salesloft data in Power BI Desktop and then publish them to Power BI Report Server.
-
Enable the HubDB JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with HubDB data.
-
DataBind Charts to Oracle Eloqua Reporting Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Eloqua Reporting data 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.
-
How to connect to Beeminder Data from IntelliJ
Integrate connectivity to Beeminder data with wizards in IntelliJ.
-
Integrate Impala with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Impala with External Services.
-
Create a Data Access Object for SAP Fieldglass Data using JDBI
A brief overview of creating a SQL Object API for SAP Fieldglass data in JDBI.
-
Integrate Open WebUI with Live ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live ActiveCampaign data from within the chat interface.
-
Connect to Microsoft Dataverse Data from a Connection Pool in Jetty
The Microsoft Dataverse JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Dataverse data from Web apps in Jetty.
-
Integrate Redshift with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Redshift with External Services.
-
Manage Zoho Books Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Zoho Books.
-
Natively Connect to Accelo Data in PHP
The CData ODBC driver for Accelo enables you to create PHP applications with connectivity to Accelo data. Leverage the native support for ODBC in PHP.
-
Use Dash to Build Web Apps on Avalara AvaTax Data via CData Connect AI
Build interactive Dash web apps on live Avalara AvaTax data using pandas and the CData Connect AI Python SDK.
-
How to integrate Oracle with Apache Airflow
Access and process Oracle data in Apache Airflow using the CData JDBC Driver.
-
Create Apps from Oracle Service Cloud Data in Qlik Sense Cloud
Use CData Connect AI to connect to Oracle Service Cloud Data and build apps from live Oracle Service Cloud data in Qlik Sense Cloud.
-
Visualize Grafana Data in Sisense
Create an ElastiCube in Sisense app with access to Grafana data.
-
Automated Continuous Insightly Replication to SQLite
Use CData Sync for automated, continuous, customizable Insightly replication to SQLite.
-
Connect to SAP Concur Data in JRuby
Create a simple JRuby app with access to live SAP Concur data.
-
Create Dynamic Workday Grids Using the Infragistics XamDataGrid
Learn how you can connect Workday to Infragistics XamDataGrid to build dynamic grids.
-
How to Connect to Live JSON Services from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your JSON services for you.
-
How to work with AlloyDB Data in Apache Spark using SQL
Access and process AlloyDB Data in Apache Spark using the CData Software JDBC Driver.
-
Consume Sage Cloud Accounting OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Sage Cloud Accounting feeds that reflect any changes in SAP Lumira.
-
ETL Auth0 in Oracle Data Integrator
This article shows how to transfer Auth0 data into a data warehouse using Oracle Data Integrator.
-
How to load Strava data into Elasticsearch via Logstash
Introducing a simple method to load Strava data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Manage SAS xpt Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAS xpt.
-
Import Amazon Athena Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Amazon Athena Data and provide access to live Amazon Athena data for custom reports in the Power BI Service.
-
Automate SharePoint Data Replication to Couchbase
Use CData Sync to Customize and automate SharePoint data replication to Couchbase.
-
Use the CData Software JDBC Driver for MYOB AccountRight in MicroStrategy Desktop
Connect to MYOB AccountRight data in MicroStrategy Desktop using the CData Software JDBC Driver for MYOB AccountRight.
-
Build PostgreSQL-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live PostgreSQL data.
-
Integrate Google's Vertex AI Agent with Live Perplexity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Perplexity data within intelligent workflows.
-
Connect to Adobe Experience Manager Data from PowerBuilder via ADO.NET
This article demonstrates how to access Adobe Experience Manager data from Appeon PowerBuilder using the CData ADO.NET Provider for Adobe Experience Manager.
-
Prepare, Blend, and Analyze Google Campaign Manager 360 Data in Alteryx Designer (ODBC)
Build workflows to access live Google Campaign Manager 360 data for self-service data analytics.
-
Automated Continuous Reckon Accounts Hosted Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Apache Kafka.
-
Edit and Search External Amazon DynamoDB Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Amazon DynamoDB data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Amazon DynamoDB Data objects that you can access from apps and the dashboard.
-
Create Excel Online Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Excel Online from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData Software JDBC Driver for Salesforce CRM Analytics in MicroStrategy
Connect to Salesforce CRM Analytics data in MicroStrategy Developer using the CData Software JDBC Driver for Salesforce CRM Analytics.
-
DataBind Controls to Facebook Data in Delphi
DataBind to Facebook data in Delphi with standard data access components and controls.
-
ETL Zoho Creator in Oracle Data Integrator
This article shows how to transfer Zoho Creator data into a data warehouse using Oracle Data Integrator.
-
Build Dashboards with Zoho Inventory Data in Dundas BI
Create dynamic dashboards and perform analytics based on Zoho Inventory data in Dundas BI.
-
Query Salesforce Marketing Data in ColdFusion
Write standard ColdFusion data access code to connect to Salesforce Marketing data.
-
Connect to Live SAP HANA Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP HANA in CData Connect AI and connect to your SAP HANA data from PostgreSQL.
-
Access Live SAP Ariba Procurement Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Ariba Procurement data from your Excel spreadsheets.
-
Query Snapchat Ads Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Snapchat Ads entities in PHP by modeling them as objects.
-
Analyze Bugsnag Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Bugsnag data with the CData JDBC Driver for Bugsnag.
-
Import and Visualize Xero Data in Power View
Create data visualizations based on Xero data in Excel.