CData Software - Knowledge Base
Recent Articles
-
Access MariaDB Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live MariaDB from HeidiSQL.
-
Design BIRT Reports on Neo4J Data
Provide current Neo4J to your embedded analytics.
-
Import and Visualize QuickBooks Time Data in Power View
Create data visualizations based on QuickBooks Time in Excel.
-
Query Clio Data as a MySQL Database in Node.js
Execute MySQL queries against Clio from Node.js.
-
Query Teamgate Data in ColdFusion
Write standard ColdFusion data access code to connect to Teamgate.
-
How to load Intercom data into Elasticsearch via Logstash
Introducing a simple method to load Intercom data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query Amplitude Data as a MySQL Database in Node.js
Execute MySQL queries against Amplitude from Node.js.
-
Connect to AdRoll Data from PowerBuilder via ADO.NET
This article demonstrates how to access AdRoll from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to JSON Services in NetBeans
Connect to JSON in NetBeans with the data source configuration wizard.
-
Connect to Klaviyo Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Klaviyo.
-
Configure the CData JDBC Driver for HubSpot in a Connection Pool in Tomcat
Connect to HubSpot from a connection pool in Tomcat.
-
How to Connect the Power BI Service to Printful: Complete Guide
Connect to the CData Software Power BI Connector for Printful from PowerBI.com to provide real-time Printful across the organization.
-
Integrating Dataiku with Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Elasticsearch.
-
Bridge OData Connectivity with Apache NiFi
Access and process OData in Apache NiFi using the CData JDBC Driver.
-
Build Apps with Live MySQL in Adalo using CData Connect AI
Use CData Connect AI to integrate live MySQL into the Adalo platform and build custom mobile and web applications with real-time MySQL.
-
Use the CData Software ODBC Driver for GitHub in MicroStrategy Desktop
Connect to GitHub in MicroStrategy Desktop using the CData Software ODBC Driver for GitHub.
-
Build SAP Business One-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP Business One Data and create custom apps in Bubble.
-
Connect to Oracle HCM Cloud from a Connection Pool in WebLogic
Use the CData JDBC Driver for Oracle HCM Cloud to connect to Oracle HCM Cloud from Web applications running on WebLogic.
-
LINQ to SendInBlue 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 SendInBlue Data Provider.
-
Build AI/ML Models with Live Google Forms Data using Dataiku
Connect Google Forms Data with Dataiku using the CData API Driver for JDBC.
-
Integrating Gumloop with Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Atlassian Confluence within automated workflows.
-
Visualize Reckon Accounts Hosted 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 Reckon Accounts Hosted into TIBCO Spotfire.
-
Connect to Grafana Data in Aqua Data Studio
Access Grafana from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Visualizations of Aha! Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Aha! in Birst.
-
How to Access MessageBird Data Using Entity Framework
This article shows how to access MessageBird using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Deploy the ADO.NET Provider for Zoho Projects on an SSRS Report Server
Connect to Zoho Projects 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 Instagram Data in PHP
The CData ODBC driver for Instagram enables you to create PHP applications with connectivity to Instagram. Leverage the native support for ODBC in PHP.
-
Integrate Confluence Data into Power Automate Desktop using CData Connect
CData Connect for Confluence Data enables you to integrate Atlassian Confluence into workflows built using Microsoft Power Automate Desktop.
-
Using the CData Software ODBC Driver for Confluence in PyCharm
Connect to Confluence as an ODBC data source in PyCharm using the CData Software ODBC Driver for Confluence.
-
Automated Continuous SAP Concur Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP Concur replication to SQL Server.
-
Integrate FTP Data into Power Automate Desktop using CData Connect
CData Connect for FTP Data enables you to integrate FTP Servers into workflows built using Microsoft Power Automate Desktop.
-
Visualize SharePoint 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 Microsoft SharePoint into TIBCO Spotfire.
-
Integrate with Supabase Data in JReport Designer
Create charts and reports based on Supabase in JReport Designer.
-
Integrate Real-Time Access to Exact Online in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Exact Online in real time.
-
Edit and Search LinkedIn Ads External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of LinkedIn Ads to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create LinkedIn Ads objects that you can access from apps and the dashboard.
-
Use Biml to Build SSIS Tasks to Replicate Bugsnag Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Bugsnag to SQL Server.
-
How to Easily Query Power BI XMLA Data in OpenOffice Base
Connect to Power BI XMLA data in OpenOffice Base using the CData ODBC Driver for Power BI XMLA and generate reports with live data insights.
-
How to Connect the Power BI Service to Everhour: Complete Guide
Connect to the CData Software Power BI Connector for Everhour from PowerBI.com to provide real-time Everhour across the organization.
-
How to Access Live Gumroad Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Gumroad enables you to integrate Gumroad into workflows built using Microsoft Power Automate Desktop.
-
Integrate Testmonitor with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Testmonitor with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Testmonitor.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Microsoft Teams actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Build Semantic Layer Views for Salesloft Data in APOS Live Data Gateway
Use the CData Connector for Salesloft in APOS Live Data Gateway to build Semantic Layer Views for Salesloft.
-
LINQ to DB2 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 DB2 Data Provider.
-
Excel Spreadsheet Automation on Paylocity Data with the QUERY Formula
Pull data from Paylocity, automate spreadsheets, and more with the QUERY formula.
-
Build Apps with Live Qualaroo Data Using the Low-Code Development Platform of Mendix
Connect Qualaroo with Mendix to build apps using the CData API Driver for JDBC.
-
Replicate Multiple Zuora Accounts
Replicate multiple Zuora accounts to one or many databases.
-
Connect to Aha! from Asprova with CData Software ODBC Driver for Aha!
This article shows how to connect faster to Aha! data from Asprova.
-
Create Power BI Reports on Real-Time Microsoft Dataverse Data
Use the CData ODBC Driver for Microsoft Dataverse to visualize Microsoft Dataverse (CDS) in Power BI Desktop.
-
Analyze Bright Data Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Bright Data from Power Pivot. You will use the Table Import Wizard to load Bright Data. You can visually build the import query or use any SQL supported by the driver.
-
Publish Access-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Access.
-
Connecting Pipedream with Zoho Books Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Zoho Books data in real time.
-
Query Jira Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Jira entities in PHP by modeling them as objects.
-
How to connect to Shortcut Data with Squirrel SQL client
Connect to Shortcut and execute queries in the Squirrel SQL Client.
-
LINQ to BambooHR 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 BambooHR Data Provider.
-
Integrating Testmonitor Data in Talend Cloud Data Management Platform
Connect Testmonitor Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Visualize Greenhouse Data in Sisense
Create an ElastiCube in Sisense app with access to Greenhouse.
-
Create Oracle Sales-Connected Applications in Appsmith
Connect to Oracle Sales Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Oracle Sales.
-
Use Claude to Talk to Your JSON Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your JSON for you.
-
Working with Wistia Data in LINQPad
Execute LINQ queries to Wistia in LINQPad.
-
Getting Started with the CData JDBC Driver for Landbot
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Landbot.
-
Connect to TaxJar Data in Ruby
Connect to TaxJar in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect DBeaver to NetSuite via a JDBC Driver
Manage NetSuite CRM & ERP with visual tools in DBeaver like the query browser.
-
Load Xero Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Xero Accounting to a database.
-
How to Connect to Live Airtable 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 Airtable for you.
-
Integrate with Codat Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Codat to a JSON file on disk.
-
Create Data Visualizations in Cognos BI with Hubstaff Data
Access Hubstaff as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Facebook API: Invalid Appsecret_Proof Provided in the API Argument
In this entry you will find the steps to resolve the Facebook API "Invalid appsecret_proof" error.
-
Query Email Data in ColdFusion
Write standard ColdFusion data access code to connect to Email.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Epicor Kinetic
Provide connectivity to Epicor Kinetic through an SAP BusinessObjects universe.
-
Create Datasets from Act-On in Domo Workbench and Build Visualizations of Act-On Data in Domo
Use the CData Software ODBC Driver for Act-On to create datasets from Act-On in Domo Workbench and then build visualizations in the Domo service.
-
How to Connect to Clockify Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Clockify. Leverage the pyodbc module for ODBC in Python.
-
Working with Bitly Data in LINQPad
Execute LINQ queries to Bitly in LINQPad.
-
Replicate Avro Data to Multiple Databases via the CData Sync CLI
Replicate Apache Avro to disparate databases with a single configuration.
-
How to integrate Clari with Apache Airflow
Access and process Clari in Apache Airflow using the CData JDBC Driver.
-
Integrating Dataiku with Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Facebook.
-
Choosing the Best Method to Connect Zoho Inventory to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Zoho Inventory from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google Spanner within intelligent workflows.
-
Provide OData Services of Copper Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Copper by developing a WCF Service Application.
-
Connect to NetSuite Data in JRuby
Create a simple JRuby app with access to live NetSuite CRM & ERP.
-
Visualize Omnisend 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 Omnisend into TIBCO Spotfire.
-
Automate Invoiced Data Replication to Azure Data Lake
Use CData Sync to customize and automate Invoiced replication to Azure Data Lake.
-
Connect to Optimizely Data in Jaspersoft Studio
Execute SQL to remote Optimizely in Jaspersoft Studio.
-
Connect to Ontraport Data from a Connection Pool in JBoss
Integrate Ontraport into Java servlets: Use the Management Console in JBoss to install the Ontraport JDBC Driver.
-
Analyze CouchDB Data in Cognos Analytics
Use CData Connect AI to connect to CouchDB Data from Cognos Analytics and analyze live Apache CouchDB.
-
Build Reckon Accounts Hosted-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Reckon Accounts Hosted.
-
Replicate Multiple REST Accounts
Replicate multiple REST accounts to one or many databases.
-
How to Query Hive Data in MySQL Workbench
Execute MySQL queries against live Apache Hive from MySQL Workbench.
-
How to Build an ETL App for Power BI XMLA Data in Python with CData
Create ETL applications and real-time data pipelines for Power BI XMLA in Python with petl.
-
Access Live Paymo Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Paymo in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Live LinkedIn Ads Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate LinkedIn Ads into the statistical analysis tools available in SAS JMP. This article shows how to use LinkedIn Ads in the Graph Builder and Query Builder.
-
Access Live SAP HANA Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP HANA from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Validate Keap Data with QuerySurge
Access and validate Keap in QuerySurge using the CData JDBC Driver.
-
Connect to Samanage Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Samanage and work with Samanage in your FileMaker applications.
-
Build Agents in Relevance AI with Access to Live Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Ad Manager within intelligent agent workflows.
-
Use Microsoft Copilot Studio to talk to your BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your BigCommerce for you.
-
Connect to and Visualize Live Omnisend Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Omnisend.
-
Use Claude to Talk to Your Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Neo4J for you.
-
How to connect to Superchat Data in DBVisualizer
Integrate Superchat with visual data analysis tools and data connection wizards in DBVisualizer
-
Extract, Transform, and Load JotForm Data in Informatica PowerCenter
Create a simple Workflow for JotForm in Informatica PowerCenter.
-
How to connect to Opsgenie Data from Spring Boot
Connect to Opsgenie in a Spring Boot Application using the CData API Driver for JDBC