CData Software - Knowledge Base
Recent Articles
-
Easily Integrate Copper Data in Lazarus Pascal IDE
Learn how to easily integrate live Copper data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
DataBind Controls to Sendwithus Data in C++Builder
DataBind to Sendwithus data in C++Builder with standard components and controls.
-
Getting Started with the CData JDBC Driver for Avalara AvaTax
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Avalara AvaTax.
-
Access Copper Data from MySQL in PHP
Connect to Copper through the standard MySQL libraries in PHP.
-
Rapidly Develop Bright Data-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 Bright Data.
-
Visualize Microsoft OneDrive Data in TIBCO Spotfire through ADO.NET
Integrate Microsoft OneDrive data into dashboards in TIBCO Spotfire.
-
How to load JDBC-ODBC Bridge data into Elasticsearch via Logstash
Introducing a simple method to load JDBC-ODBC Bridge data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect to ZohoInvoice Data with Squirrel SQL client
Connect to ZohoInvoice data and execute queries in the Squirrel SQL Client.
-
Configure the CData JDBC Driver for IBM Cloud Object Storage in a Connection Pool in Tomcat
Connect to IBM Cloud Object Storage data from a connection pool in Tomcat.
-
Create Dashboards and Visualize Live Typeform Data in Geckoboard
Use CData Connect AI to connect to live Typeform data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect Zoho Recruit to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Zoho Recruit data using the CData Python MCP Server.
-
Automate Google Analytics Data Replication to SAP HANA
Use CData Sync to customize and automate Google Analytics data replication to SAP HANA.
-
Connect to Insightly Data in JRuby
Create a simple JRuby app with access to live Insightly data.
-
Operational Reporting on Square Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Square data.
-
Create ClickUp-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to ClickUp Data from OutSystems and build custom enterprise apps using live ClickUp data.
-
Connect to Helpscout Data in Ruby
Connect to Helpscout data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate Opsgenie Data to Multiple Databases
Replicate Opsgenie data to disparate databases with a point-and-click configuration.
-
Connecting Mastra with Splunk Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Splunk data, no replication required.
-
Connect to IBM Cloud Object Storage in SpagoBI
Create reports featuring live IBM Cloud Object Storage data in SpagoBI Studio. Host IBM Cloud Object Storage reports on SpagoBI Server.
-
Provide OData Services of Google Ad Manager Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Ad Manager data by developing a WCF Service Application.
-
How to Query Asana Data in MySQL Workbench
Execute MySQL queries against live Asana data from MySQL Workbench.
-
Migrating data from Productboard to Snowflake using CData SSIS Components.
Easily push Productboard data to Snowflake using the CData SSIS Tasks for Productboard and Snowflake.
-
How to use SQLAlchemy ORM to access Pushbullet Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Pushbullet data.
-
Visualize Live BigQuery Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live BigQuery data.
-
Create Informatica Mappings From/To a JDBC Data Source for Basecamp
Create Basecamp data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Couchbase Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Couchbase data.
-
Integrate Open WebUI with Live SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SurveyMonkey data from within the chat interface.
-
Import and Visualize Coinbase Data in Power View
Create data visualizations based on Coinbase data in Excel.
-
Build a PostgreSQL Interface for Adobe Target Data using the CData JDBC Driver
Use the Remoting features of the Adobe Target JDBC Driver to create a PostgreSQL entry-point for data access.
-
Provide OData Services of Stripe Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Stripe data by developing a WCF Service Application.
-
Automated Browserless Data Replication to Teradata
Use CData Sync to Customize and automate Browserless data replication to Teradata.
-
ETL Gmail in Oracle Data Integrator
This article shows how to transfer Gmail data into a data warehouse using Oracle Data Integrator.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for BigQuery
Provide connectivity to BigQuery data through an SAP BusinessObjects universe.
-
Connect JotForm Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your JotForm data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect to Sugar CRM Data from IntelliJ
Integrate connectivity to Sugar CRM data with wizards in IntelliJ.
-
Edit and Search External BigQuery Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of BigQuery data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create BigQuery Data objects that you can access from apps and the dashboard.
-
Use the CData Software ODBC Driver for Webex in MicroStrategy Desktop
Connect to Webex data in MicroStrategy Desktop using the CData Software ODBC Driver for Webex.
-
Migrating data from Testmonitor to Snowflake using CData SSIS Components.
Easily push Testmonitor data to Snowflake using the CData SSIS Tasks for Testmonitor and Snowflake.
-
Connect CloudConvert to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live CloudConvert data using the CData Python MCP Server.
-
Use the CData Software ODBC Driver for Qualaroo in MicroStrategy
Connect to Qualaroo data in MicroStrategy Developer using the CData Software ODBC Driver for Qualaroo.
-
Integrate with Live Oracle Sales Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Oracle Sales from the MuleSoft Anypoint Platform to integrate live Oracle Sales data into custom reports and dashboards.
-
Back Up Facebook Ads data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Facebook Ads. In this article, we will employ an SSIS workflow to populate a database with Facebook Ads data data.
-
Automated Continuous Rebilly Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Rebilly replication to Apache Kafka.
-
How to Connect the Power BI Service to Excel: Complete Guide
Connect to the CData Software Power BI Connector for Excel from PowerBI.com to provide real-time Excel data across the organization.
-
Publish LaunchDarkly-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live LaunchDarkly data.
-
Build a PostgreSQL Interface for Adobe Commerce Data using the CData JDBC Driver
Use the Remoting features of the Adobe Commerce JDBC Driver to create a PostgreSQL entry-point for data access.
-
Prepare, Blend, and Analyze Planio Data in Alteryx Designer (ODBC)
Build workflows to access live Planio data for self-service data analytics.
-
Analyze Freshteam Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Freshteam data in Microsoft R Open.
-
How to connect and process Google Forms data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Forms data.
-
Work with ZohoInvoice Data in FoxPro
Load ZohoInvoice data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Seamlessly Bring HubSpot Data into Retool Using CData Connect AI
Integrate HubSpot data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Easily Query Facebook Data in OpenOffice Base
Connect to Facebook data in OpenOffice Base using the CData ODBC Driver for Facebook and generate reports with live data insights.
-
Visualize Planio Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Planio data.
-
Manage Spark Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Spark.
-
Add SAP Hybris C4C Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP Hybris C4C with the Informatica Enterprise Data Catalog to classify and organize data.
-
Process & Analyze xBase Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live xBase Data.
-
Build OneNote Visualizations in Tableau Desktop
Use CData Connect AI to connect to live OneNote data and build visualizations in Tableau.
-
Working with Jira Assets Data in LINQPad
Execute LINQ queries to Jira Assets data in LINQPad.
-
Query Google Search Results using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Search entities in PHP by modeling them as objects.
-
Integrating Gumloop with Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Salesforce Pardot data within automated workflows.
-
Query WooCommerce Data as a SQL Server Database in Node.js
Execute SQL Server queries against WooCommerce data from Node.js.
-
Use the CData ODBC Driver for Auth0 in Microsoft Power Query
You can use the CData Auth0 ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Auth0 data into Microsoft Power Query.
-
Query, Visualize, and Share live Oracle Financials Cloud Data in Redash
Use CData Connect AI to connect to live Oracle Financials Cloud data in Redash for querying, visualizing, and sharing.
-
Connect to Zoho Projects in SpagoBI
Create reports featuring live Zoho Projects data in SpagoBI Studio. Host Zoho Projects reports on SpagoBI Server.
-
How to Easily Query ServiceDesk Plus Data in OpenOffice Base
Connect to ServiceDesk Plus data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Getting Started with the CData ODBC Driver for Anaplan
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Anaplan.
-
Automated Continuous NASA Replication to Vertica
Use CData Sync for automated, continuous, customizable NASA replication to Vertica.
-
Natively Connect to Factorial Data in PHP
The CData ODBC driver for Factorial enables you to create PHP applications with connectivity to Factorial data. Leverage the native support for ODBC in PHP.
-
How to Connect the Power BI Service to Google Spanner: Complete Guide
Connect to the CData Software Power BI Connector for Google Spanner from PowerBI.com to provide real-time Google Spanner data across the organization.
-
Visualize Elorus Data in Sisense
Create an ElastiCube in Sisense app with access to Elorus data.
-
Provide OData Services of Databricks Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Databricks data by developing a WCF Service Application.
-
DataBind Strava Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Strava data to a chart.
-
Build Semantic Layer Views for Parquet Data in APOS Live Data Gateway
Use the CData Connector for Parquet in APOS Live Data Gateway to build Semantic Layer Views for Parquet data.
-
Access Live VWO Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live VWO data from your Google Sheets.
-
Integrating LangChain with Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Basecamp data within automated workflows.
-
Connect to FTP Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time FTP data using standard SQL.
-
How to Build an ETL App for Samanage Data in Python with CData Connect AI
Extract and transform live Samanage data in Python with petl and the CData Connect AI Python SDK.
-
NASA Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on NASA facts in real time.
-
Integrate Devin with Live Twilio Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Twilio data.
-
Analyze Sybase Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sybase from Power Pivot. You will use the Table Import Wizard to load Sybase data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to PabblySubscriptions Data in DBeaver
Use the CData ODBC Driver to connect to PabblySubscriptions data in DBeaver.
-
Interact with Live SQL Server Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SQL Server data.
-
Automated Continuous Databricks Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Databricks replication to delimited files (CSV/TSV).
-
Use Databricks Agent Bricks to Talk to Your Amazon DynamoDB Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Amazon DynamoDB data for you.
-
Connect to Sendwithus Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Sendwithus and work with Sendwithus data in your FileMaker applications.
-
Build AI Agents with Supabase 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 Supabase data through CData Connect AI.
-
Write a Simple Go Application to work with Stripe Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Stripe data.
-
Use Manus AI to Talk to Your Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Sage 200 data.
-
Query PayPal Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume PayPal entities in PHP by modeling them as objects.
-
Access HubSpot Data from MySQL in PHP
Connect to HubSpot through the standard MySQL libraries in PHP.
-
Integrate Live Authorize.Net Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Authorize.Net data to Blue Prism using the CData ODBC Driver for Authorize.Net to create automated workflows for repetitive business tasks.
-
Load Acumatica Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Acumatica data to a database.
-
Connect ZohoSubscriptions to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ZohoSubscriptions with IBM WebSphere for seamless data integration and connectivity.
-
Create Data Visualizations in Cognos BI with Invoiced Data
Access Invoiced data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Jira Assets Data into Power Automate Desktop using CData Connect
CData Connect for Jira Assets Data enables you to integrate Jira Assets data into workflows built using Microsoft Power Automate Desktop.
-
Easily Integrate MongoDB Data in Lazarus Pascal IDE
Learn how to easily integrate live MongoDB data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Dashboards with ZohoInvoice Data in DBxtra
Create dynamic dashboards and perform analytics based on ZohoInvoice data in DBxtra.
-
How to Visualize Omnisend Data in Python with pandas
Use pandas and other modules to analyze and visualize live Omnisend data in Python.
-
Query Rootly Data as a MySQL Database in Node.js
Execute MySQL queries against Rootly data from Node.js.
-
Getting Started with the CData ADO.NET Provider for Rootly
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.