CData Software - Knowledge Base
Recent Articles
-
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 data 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 SharePoint data into TIBCO Spotfire.
-
Integrate with Supabase Data in JReport Designer
Create charts and reports based on Supabase data 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 data in real time.
-
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 data 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 data across the organization.
-
How to Connect to Live Azure Data Catalog Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Azure Data Catalog data for you.
-
How to Access Live Gumroad Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Gumroad enables you to integrate Gumroad data 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 data.
-
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 data.
-
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.
-
Interact with Live LinkedIn Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live LinkedIn data.
-
Build Apps with Live Qualaroo Data Using the Low-Code Development Platform of Mendix
Connect Qualaroo data 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 data 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 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 Access data.
-
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 data 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 data.
-
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 data.
-
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 services for you.
-
Working with Wistia Data in LINQPad
Execute LINQ queries to Wistia data 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 data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect DBeaver to NetSuite via a JDBC Driver
Manage NetSuite data 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 data to a database.
-
Automate Rootly Data Replication to Azure Data Lake
Use CData Sync to customize and automate Rootly data replication to Azure Data Lake.
-
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 data 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 data to a JSON file on disk.
-
Create Data Visualizations in Cognos BI with Hubstaff Data
Access Hubstaff data 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 data.
-
Replicate Outlook Data in Heroku for Use in Salesforce Connect
Replicate Outlook data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Epicor Kinetic
Provide connectivity to Epicor Kinetic data 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 data 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 data. Leverage the pyodbc module for ODBC in Python.
-
Working with Bitly Data in LINQPad
Execute LINQ queries to Bitly data in LINQPad.
-
Replicate Avro Data to Multiple Databases via the CData Sync CLI
Replicate Avro data to disparate databases with a single configuration.
-
How to integrate Clari with Apache Airflow
Access and process Clari data 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 data.
-
Choosing the Best Method to Connect Zoho Inventory to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Zoho Inventory data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Google's Vertex AI Agent with Live Google Spanner 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 Google Spanner data 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 data by developing a WCF Service Application.
-
Connect to NetSuite Data in JRuby
Create a simple JRuby app with access to live NetSuite data.
-
Connecting Moonlit Workflow with Reckon 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 Reckon data in real time.
-
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 data into TIBCO Spotfire.
-
Automate Invoiced Data Replication to Azure Data Lake
Use CData Sync to customize and automate Invoiced data replication to Azure Data Lake.
-
Connect to Optimizely Data in Jaspersoft Studio
Execute SQL to remote Optimizely data in Jaspersoft Studio.
-
Integrate Goose with Live Toggl Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Toggl data from within the local AI agent.
-
Connect to Ontraport Data from a Connection Pool in JBoss
Integrate Ontraport data 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 CouchDB data.
-
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 data.
-
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 Hive data 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 data in Python with petl.
-
Access Live Paymo Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Paymo data 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 data into the statistical analysis tools available in SAS JMP. This article shows how to use LinkedIn Ads data 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 data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Validate Keap Data with QuerySurge
Access and validate Keap data 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 data 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 data 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 data for you.
-
Connect to and Visualize Live Omnisend Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Omnisend data.
-
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 data for you.
-
How to connect to Superchat Data in DBVisualizer
Integrate Superchat data 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 data 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
-
Replicate LightSpeedRetail Data to Multiple Databases
Replicate LightSpeedRetail data 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.
-
Design BIRT Reports on Kintone Data
Provide current Kintone data to your embedded analytics.
-
How to integrate Onfleet with Apache Airflow
Access and process Onfleet data in Apache Airflow using the CData JDBC Driver.
-
How to create Visio diagrams from Adobe Commerce Data
Automatically update Adobe Commerce data with the changes you make to Visio master shapes.
-
Connect to JobNimbus Data in Jaspersoft Studio
Execute SQL to remote JobNimbus data in Jaspersoft Studio.
-
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 data.
-
Integrating Cursor with Airtable 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 JDBC Driver for Twitter Ads in MicroStrategy Desktop
Connect to Twitter Ads data in MicroStrategy Desktop using the CData Software JDBC Driver for Twitter Ads.
-
Build Charts with MessageBird Data in Clear Analytics
Create dynamic charts and perform analytics based on MessageBird data in Clear Analytics.
-
How to Connect to Live ZohoMarketingHub 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 ZohoMarketingHub data for you.
-
Automate EnterpriseDB Data Replication to Couchbase
Use CData Sync to Customize and automate EnterpriseDB data replication to Couchbase.
-
Explore Geographical Relationships in Teamgate Data with Power Map
Create data visualizations with Teamgate data in Power Map.
-
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 data for you.
-
Getting Started with the CData ODBC Driver for Google Analytics
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Analytics.
-
Natively Connect to Pipedrive Data in PHP
The CData ODBC driver for Pipedrive enables you to create PHP applications with connectivity to Pipedrive data. Leverage the native support for ODBC in PHP.
-
Build SageHR Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SageHR data and build visualizations in Tableau Cloud.
-
Build Automated Workflows with Live Bullhorn CRM Data in Workato
Use CData Connect AI to connect to live Bullhorn CRM data and build automated workflows in Workato.
-
Automated Continuous Short.io Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Short.io replication to Azure SQL Database.
-
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 data.
-
Connect to Google Forms Data in NetBeans
Connect to Google Forms data in NetBeans with the data source configuration wizard.
-
Build Data Flows from WooCommerce to SQL Server using SSIS
Easily back up WooCommerce data to SQL Server using the SSIS components for WooCommerce.
-
Connect to Blackbaud FE NXT Data from a Connection Pool in JBoss
Integrate Blackbaud FE NXT data into Java servlets: Use the Management Console in JBoss to install the Blackbaud FE NXT JDBC Driver.
-
How to Connect to Live Wave Financial 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 Wave Financial data for you.