CData Software - Knowledge Base
Recent Articles
-
Automate Twitter Ads Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Twitter Ads data from PowerShell? This article demonstrates how to utilize the Twitter Ads Cmdlets for tasks like connecting to Twitter Ads data, automating operations, downloading data, and more.
-
Connect to Procore Data in Ruby
Connect to Procore data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData SSIS Components to Insert New or Update Existing Oracle Eloqua Records from SQL Server
Easily push SQL Server data to Oracle Eloqua using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Oracle Eloqua or update existing records with data from a SQL Server database.
-
Automate Wrike Data Replication to Azure Synapse
Use CData Sync to customize and automate Wrike data replication to Azure Synapse.
-
Access Live Zoho Projects 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 Zoho Projects data through MCP integration.
-
Connect to Oracle Financials Cloud Data from PowerBuilder via ADO.NET
This article demonstrates how to access Oracle Financials Cloud data from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle Financials Cloud.
-
Automated Continuous CockroachDB Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable CockroachDB replication to Amazon Redshift.
-
Create SSAS Tabular Models from Redshift Data
How to build a SQL Server Analysis Service Tabular Model from Redshift data using CData drivers.
-
Operational Reporting on Zoho Creator Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Zoho Creator data.
-
How to Visualize Jira Assets Data in Python with pandas
Use pandas and other modules to analyze and visualize live Jira Assets data in Python.
-
Bidirectional Access to QuickBooks Online Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate QuickBooks Online data in Filemaker Pro for Mac or Windows.
-
DataBind Controls to Jira Assets Data in C++Builder
DataBind to Jira Assets data in C++Builder with standard components and controls.
-
Create Act-On-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Act-On Data from OutSystems and build custom enterprise apps using live Act-On data.
-
How to Connect to Live ClickUp Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live ClickUp data securely in real time.
-
Link Miro with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Miro data in Filemaker Pro for Mac or Windows.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Spark
Provide connectivity to Spark data through an SAP BusinessObjects universe.
-
Write a Simple Go Application to work with Presto Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Presto data.
-
Deploy the ADO.NET Provider for Webex on an SSRS Report Server
Connect to Webex 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.
-
Back Up Sugar CRM data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sugar CRM. In this article, we will employ an SSIS workflow to populate a database with Sugar CRM data data.
-
Integrate PDFMonkey Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live PDFMonkey data from Informatica Cloud.
-
Connect to Zoho Creator Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Zoho Creator Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Live OData Services into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to OData services and integrate live OData services into apps built in Microsoft Power Apps.
-
Create Data Visualizations in Cognos BI with Salesforce Marketing Data
Access Salesforce Marketing data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Choosing the Best Method to Connect CouchDB to SQL Server: 5 Options Explained
Discover multiple ways to connect and use CouchDB data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Analyze Live Smartsheet Data in SAS Viya
Use CData Connect AI to connect to Smartsheet data from SAS Viya and deploy self-service analytics using live Smartsheet data.
-
Automated Continuous Parquet Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Parquet replication to Azure SQL Database.
-
Publish Reports with IBM Cloud Object Storage Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date IBM Cloud Object Storage data.
-
Visualize Live Landbot Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Landbot data.
-
Use ChatGPT to Talk to Your ZohoDesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your ZohoDesk data for you.
-
Use the CData Software ODBC Driver for Stripe in MicroStrategy
Connect to Stripe data in MicroStrategy Developer using the CData Software ODBC Driver for Stripe.
-
Access Live Autopilot Data in AWS Lambda
Connect to live Autopilot data in AWS Lambda using the CData JDBC Driver.
-
How to Connect the Power BI Service to Flowlu: Complete Guide
Connect to the CData Software Power BI Connector for Flowlu from PowerBI.com to provide real-time Flowlu data across the organization.
-
Use Agno to Talk to Your Twitter Ads 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 Twitter Ads data for you.
-
Query Live MarkLogic Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live MarkLogic data directly from the development environment.
-
Integrate with OpenWeatherMap Data in JReport Designer
Create charts and reports based on OpenWeatherMap data in JReport Designer.
-
Query Exa Data in ColdFusion
Write standard ColdFusion data access code to connect to Exa data.
-
Publish Crystal Reports on ShipEngine Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ShipEngine data.
-
Integrate Google Ad Manager Data in the Pentaho Report Designer
Publish reports based on Google Ad Manager data in the Pentaho BI tool.
-
Consume TaxJar OData Feeds in SAP Lumira
Use the API Server to create data visualizations on TaxJar feeds that reflect any changes in SAP Lumira.
-
Automated Continuous Sage 300 Replication to MySQL
Use CData Sync for automated, continuous, customizable Sage 300 replication to MySQL.
-
Connect to Front in SpagoBI
Create reports featuring live Front data in SpagoBI Studio. Host Front reports on SpagoBI Server.
-
Getting Started with the CData ADO.NET Provider for Coda
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Publish SageHR-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SageHR data.
-
Deploy the ADO.NET Provider for Facebook on an SSRS Report Server
Connect to Facebook 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.
-
Build Mode-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Mode Data and create custom apps in Mendix.
-
Integrate Cursor with Live EnterpriseDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live EnterpriseDB data from within the editor.
-
How to Create Power BI Visual Reports with Real-Time ADP Data
Use CData Power BI Connectors to visualize ADP data in Power BI.
-
How to Query Highrise Data in MySQL Workbench
Execute MySQL queries against live Highrise data from MySQL Workbench.
-
Automated Continuous API Replication to SQLite
Use CData Sync for automated, continuous, customizable API replication to SQLite.
-
Import Spark Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Spark Data and provide access to live Spark data for custom reports in the Power BI Service.
-
Integrating Codex with ConvertKit 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.
-
Getting Started with the CData ADO.NET Provider for Stripe
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Stripe.
-
Connect to Bannerbear Data in CloverDX (formerly CloverETL)
Transfer Bannerbear data using the visual workflow in the CloverDX data integration tool.
-
Query Live Google Sheets Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Google Sheets data through a conversational interface.
-
Connect to Google Drive Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Drive data in Airbyte.
-
How to connect to Strava Data with Squirrel SQL client
Connect to Strava data and execute queries in the Squirrel SQL Client.
-
Query Hubstaff Data as a MySQL Database in Node.js
Execute MySQL queries against Hubstaff data from Node.js.
-
Create NetSuite SuiteAnalytics-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to NetSuite SuiteAnalytics Data from OutSystems and build custom enterprise apps using live NetSuite SuiteAnalytics data.
-
Create Reports with Suadeo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Suadeo data.
-
Create Dropbox Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Dropbox from PowerBI.com to create Power BI Dataflows with real-time data.
-
Import Sugar CRM Data Using Azure Data Factory
Use CData Connect AI to connect to Sugar CRM Data from Azure Data Factory and import live Sugar CRM data.
-
Connect to BigCommerce Data in HULFT Integrate
Connect to BigCommerce as a JDBC data source in HULFT Integrate
-
Build Visualizations of OpenWeatherMap Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of OpenWeatherMap data in Birst.
-
DataBind Charts to Email Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Email 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.
-
Integrate Hugging Face Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Hugging Face data from Informatica Cloud.
-
Integrate Simplesat with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Simplesat with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Simplesat data.
-
Connect and Visualize Live Discord Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Discord data into the Databricks platform and create visualization dashboards with real-time Discord data.
-
How to use SQLAlchemy ORM to access JotForm Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of JotForm data.
-
Automated Continuous Brex Replication to SQLite
Use CData Sync for automated, continuous, customizable Brex replication to SQLite.
-
Build AI/ML Models with Live Zendesk Data using Dataiku
Connect Zendesk Data with Dataiku using the CData JDBC Driver for Zendesk.
-
Connect to Redshift Data in NetBeans
Connect to Redshift data in NetBeans with the data source configuration wizard.
-
How to Access Live Azure Analysis Services Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Azure Analysis Services enables you to integrate Azure Analysis Services data into workflows built using Microsoft Power Automate Desktop.
-
Bridge Coinbase Connectivity with Apache NiFi
Access and process Coinbase data in Apache NiFi using the CData JDBC Driver.
-
Connect Google Cloud Storage to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Cloud Storage data using the CData Python MCP Server.
-
Automated Continuous Cosmos DB Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Cosmos DB data replication to OneLake in Microsoft Fabric.
-
Connect to Reply.io Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Reply.io data in the Denodo Virtual DataPort Administrator.
-
Connect and Query Live Greenplum Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Greenplum data into Databricks and enable direct, live querying and analysis without replication.
-
Using the CData Software ODBC Driver for Onfleet in PyCharm
Connect to Onfleet as an ODBC data source in PyCharm using the CData Software ODBC Driver for Onfleet.
-
Validate Google Directory Data with QuerySurge
Access and validate Google Directory data in QuerySurge using the CData JDBC Driver.
-
Access Highrise Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Highrise data.
-
Connect to SuiteCRM Data in DBeaver
Use the CData ODBC Driver to connect to SuiteCRM data in DBeaver.
-
Connect to Productboard Data in NetBeans
Connect to Productboard data in NetBeans with the data source configuration wizard.
-
Build Agents in Relevance AI with Access to Live Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Confluence data within intelligent agent workflows.
-
Connect to Supabase Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Supabase Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Teradata Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Teradata.
-
How to connect PolyBase to Amazon Athena
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Amazon Athena data.
-
A PostgreSQL Interface for SAP ByDesign Data using the CData ODBC Driver
Use the SQL Gateway and SAP ByDesign ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Salesforce Marketing Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Salesforce Marketing data from HeidiSQL.
-
Connect to Azure DevOps Data in ACL Analytics
Connect to Azure DevOps data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Azure DevOps data.
-
Connect to Snowflake Data in Jaspersoft Studio
Execute SQL to remote Snowflake data in Jaspersoft Studio.
-
Configure the CData JDBC Driver for eBay Analytics in a Connection Pool in Tomcat
Connect to eBay Analytics data from a connection pool in Tomcat.
-
Automated Continuous Paddle Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Paddle replication to Azure SQL Database.
-
How to connect PolyBase to Impala
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Impala data.
-
Query Azure DevOps Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Azure DevOps entities in PHP by modeling them as objects.
-
Integrate Paddle with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Paddle with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Paddle data.
-
ETL MarkLogic in Oracle Data Integrator
This article shows how to transfer MarkLogic data into a data warehouse using Oracle Data Integrator.
-
Connect to Shortcut Data in JRuby
Create a simple JRuby app with access to live Shortcut data.
-
Build AI/ML Models with Live Aweber Data using Dataiku
Connect Aweber Data with Dataiku using the CData API Driver for JDBC.
-
How to Access Live Google Ad Manager Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Ad Manager enables you to integrate Google Ad Manager data into workflows built using Microsoft Power Automate Desktop.
-
Using the CData Software ODBC Driver for CapsuleCRM in PyCharm
Connect to CapsuleCRM as an ODBC data source in PyCharm using the CData Software ODBC Driver for CapsuleCRM.