CData Software - Knowledge Base
Recent Articles
-
Access Live Instagram Data in TIBCO Data Virtualization
Use the Instagram Tibco DV Adapter to create a Instagram data data source in TIBCO Data Virtualization Studio and gain access to live Instagram data from your TDV Server.
-
How to connect Amazon QuickSight to HCL Domino Data
Create a connection to HCL Domino data in CData Connect AI and insert HCL Domino data into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous Clio Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Clio replication to Apache Kafka.
-
Trigger Microsoft Ads IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Microsoft Ads with standard wizards in Logic Apps.
-
How to Create Power BI Visual Reports with Real-Time BigQuery Data
Use CData Power BI Connectors to visualize BigQuery data in Power BI.
-
Connect to Reckon Data from Crystal Reports
Use CData Connect AI to connect to and report on live Reckon data from Crystal Reports.
-
Connect to and Query Hive Data in QlikView over ODBC
Create data visualizations with Hive data in QlikView.
-
Connect to Real-Time Azure DevOps Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Azure DevOps and Dataflow to import and use Azure DevOps data in Power Apps.
-
Visualize Live Office 365 Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Office 365 data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Omnisend
Provide connectivity to Omnisend data through an SAP BusinessObjects universe.
-
Create Informatica Mappings From/To an ODBC Data Source for SAS xpt
Create an ODBC connection to SAS xpt in Informatica and browse and transfer SAS xpt data.
-
How to use SQLAlchemy ORM to access Google Tasks Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Tasks data.
-
How to connect SharePoint with SQL Analysis Services Data through external lists
Provide SQL Analysis Services data to SharePoint users as an external list.
-
Integrate IBM Informix with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate IBM Informix with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to IBM Informix data.
-
Create Wave Financial Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Wave Financial from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Snapchat Ads Data in RazorSQL
Connect to Snapchat Ads from wizards and query Snapchat Ads data from the GUI in the RazorSQL database management tool.
-
Bridge AgileCRM Connectivity with Apache NiFi
Access and process AgileCRM data in Apache NiFi using the CData JDBC Driver.
-
Migrating data from HDFS to Databricks using CData SSIS Components.
Easily push HDFS data to Databricks using the CData SSIS Tasks for HDFS and Databricks.
-
Connect to BigQuery Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for BigQuery data in Airbyte.
-
Integrating Kiro with Scrapfly 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.
-
A PostgreSQL Interface for Telegram Data using the CData ODBC Driver
Use the SQL Gateway and Telegram ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use JayDeBeApi to access Moosend Data in Python
Use standard Python scripting and the development environment of your choice to access live Moosend data.
-
Integrating OpenCode 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.
-
How to load Sage 300 data into Elasticsearch via Logstash
Introducing a simple method to load Sage 300 data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Cloudant Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Cloudant data from your Excel spreadsheets.
-
How to publish and share Bright Data Data dashboards with Tableau Server
The CData ODBC driver for Bright Data enables you integrate Bright Data data into Tableau dashboards.
-
DataBind Controls to Box Data in C++Builder
DataBind to Box data in C++Builder with standard components and controls.
-
Integrate Devin with Live Avro 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 Avro data.
-
Use JayDeBeApi to access Wrike Data in Python
Use standard Python scripting and the development environment of your choice to access live Wrike data.
-
Automate Factorial Data Replication to SAP HANA
Use CData Sync to customize and automate Factorial data replication to SAP HANA.
-
Integrating LlamaIndex with GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on GitHub data in real time.
-
A PostgreSQL Interface for Active Directory Data (MySQL Remoting via JDBC)
Use the Remoting features of the Active Directory JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to EnterpriseDB from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from EnterpriseDB data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Agents in Relevance AI with Access to Live NetSuite SuiteAnalytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on NetSuite SuiteAnalytics data within intelligent agent workflows.
-
Create SFTP-Connected Business Apps in AppSheet
Connect to SFTP Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SFTP data.
-
Automated Continuous LinkedIn Replication to Snowflake
Use CData Sync for automated, continuous, customizable LinkedIn replication to Snowflake.
-
Connect to Chargebee Data from a Connection Pool in Jetty
The Chargebee JDBC Driver supports connection pooling: This article shows how to connect faster to Chargebee data from Web apps in Jetty.
-
How to work with Omnisend Data in Apache Spark using SQL
Access and process Omnisend Data in Apache Spark using the CData Software JDBC Driver.
-
Easily Integrate Chargebee Data in Lazarus Pascal IDE
Learn how to easily integrate live Chargebee data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData ODBC Driver for Avaza in Microsoft Power Query
You can use the CData Avaza ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Avaza data into Microsoft Power Query.
-
Integrating Antigravity CLI with MongoDB data via CData CLI
Connect MongoDB data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Simplesat from a Connection Pool in WebLogic
Use the CData JDBC Driver for Simplesat to connect to Simplesat data from Web applications running on WebLogic.
-
DataBind Controls to Salesloft Data in C++Builder
DataBind to Salesloft data in C++Builder with standard components and controls.
-
Automated Continuous Kafka Replication to SQLite
Use CData Sync for automated, continuous, customizable Kafka replication to SQLite.
-
Replicate Multiple Wistia Accounts via the CData Sync CLI
Replicate multiple Wistia accounts to one or many databases.
-
Connect to Insightly Data in CloverDX (formerly CloverETL)
Transfer Insightly data using the visual workflow in the CloverDX data integration tool.
-
Connecting GenSpark with PingOne Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to PingOne data without any replication or custom integration required.
-
How to Connect to Bitbucket Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Bitbucket data. Leverage the pyodbc module for ODBC in Python.
-
How to publish and share CapsuleCRM Data dashboards with Tableau Server
The CData ODBC driver for CapsuleCRM enables you integrate CapsuleCRM data into Tableau dashboards.
-
Query Jira Assets Data as a MySQL Database in Node.js
Execute MySQL queries against Jira Assets data from Node.js.
-
How to Work with Hive Data in AWS Glue Jobs Using JDBC
Connect to Hive from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Build an ETL App for HubDB Data in Python with CData Connect AI
Build ETL pipelines that read and write live HubDB data in Python with petl and the CData Connect AI Python SDK.
-
Integrating Zendesk Data in Talend Cloud Data Management Platform
Connect Zendesk Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Zendesk.
-
Build YouTube Analytics Visualizations in Tableau Desktop
Use CData Connect AI to connect to live YouTube Analytics data and build visualizations in Tableau.
-
Build Charts with BambooHR Data in Clear Analytics
Create dynamic charts and perform analytics based on BambooHR data in Clear Analytics.
-
Automated Continuous Zoho Inventory Replication to SQLite
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to SQLite.
-
How to Easily Query Azure Data Catalog Data in OpenOffice Base
Connect to Azure Data Catalog data in OpenOffice Base using the CData ODBC Driver for Azure Data Catalog and generate reports with live data insights.
-
How to load eBay Analytics data into Elasticsearch via Logstash
Introducing a simple method to load eBay Analytics data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Query Live Aweber Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Aweber data data in natural language using Python.
-
Connect to Discord Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Discord Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use the CData Software ODBC Driver for MariaDB in MicroStrategy Desktop
Connect to MariaDB data in MicroStrategy Desktop using the CData Software ODBC Driver for MariaDB.
-
Use the CData Software ODBC Driver for Asana in MicroStrategy Web
Connect to Asana data in MicroStrategy Web using the CData Software ODBC Driver for Asana.
-
Interact with Live Okta Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Okta data.
-
How to connect to Greenplum Data from Spring Boot
Connect to Greenplum in a Spring Boot Application using the CData JDBC Driver for Greenplum
-
Excel Spreadsheet Automation on PostgreSQL Data with the QUERY Formula
Pull data from PostgreSQL, automate spreadsheets, and more with the QUERY formula.
-
Query Live PayPal 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 PayPal data directly from the development environment.
-
Connect to Azure Data Lake Storage Data in ACL Analytics
Connect to Azure Data Lake Storage data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Azure Data Lake Storage data.
-
Connecting Agentforce with Email Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Email data for you.
-
Create Power BI Reports on Real-Time Todoist Data
Use the CData ODBC Driver for Todoist to visualize Todoist data in Power BI Desktop.
-
Connecting GenSpark with GitLab Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to GitLab data without any replication or custom integration required.
-
Connect and Query Live Oracle Service Cloud Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Oracle Service Cloud data into Databricks and enable direct, live querying and analysis without replication.
-
Use the CData ODBC Driver for Amazon Athena from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Amazon Athena to connect to Amazon Athena data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Amazon Athena data in Excel.
-
Connect to OData Services in ACL Analytics
Connect to OData services via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to OData services.
-
DataBind Controls to Vimeo Data in C++Builder
DataBind to Vimeo data in C++Builder with standard components and controls.
-
Create Datasets from SAP Ariba Source in Domo Workbench and Build Visualizations of SAP Ariba Source Data in Domo
Use the CData Software ODBC Driver for SAP Ariba Source to create datasets from SAP Ariba Source data in Domo Workbench and then build visualizations in the Domo service.
-
How to Query Live Rebilly Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Rebilly data data in natural language using Python.
-
Create Reports with Webex Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Webex data.
-
Migrating data from Impala to Databricks using CData SSIS Components.
Easily push Impala data to Databricks using the CData SSIS Tasks for Impala and Databricks.
-
Automate Spark Data Replication to Couchbase
Use CData Sync to Customize and automate Spark data replication to Couchbase.
-
How to Connect the Power BI Service to Avro: Complete Guide
Connect to the CData Software Power BI Connector for Avro from PowerBI.com to provide real-time Avro data across the organization.
-
Analyze Live DocuSign Data in SAS Viya
Use CData Connect AI to connect to DocuSign data from SAS Viya and deploy self-service analytics using live DocuSign data.
-
A PostgreSQL Interface for Microsoft Dataverse Data using the CData ODBC Driver
Use the SQL Gateway and Microsoft Dataverse ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live Facebook Data in the Power BI Service
Use CData Connect AI to connect to live Facebook data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Freshdesk Data in Jaspersoft Studio
Execute SQL to remote Freshdesk data in Jaspersoft Studio.
-
Create Informatica Mappings From/To a JDBC Data Source for Miro
Create Miro data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to load Helpscout data into Elasticsearch via Logstash
Introducing a simple method to load Helpscout data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Establish a Live Connection with eBay Data using Tableau Bridge
The CData ODBC Driver for eBay enables you to integrate live eBay data into Tableau Cloud dashboards using the Tableau Bridge.
-
Replicate Highrise Data from PowerShell
Write a quick PowerShell script to query Highrise data. Use connectivity to the live data to replicate Highrise data to SQL Server.
-
Connect to Azure Table Data from HeidiSQL
Use CData Connect AI to connect to and query live Azure Table data from HeidiSQL.
-
Use Biml to Build SSIS Tasks to Replicate Mouseflow Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Mouseflow data to SQL Server.
-
How to Connect to Live ZohoDesk Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your ZohoDesk data through natural language.
-
Automated Continuous Microsoft OneLake Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to Azure SQL Database.
-
Build Apps with Live Salesloft data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Salesloft data into the Adalo platform and build custom mobile and web applications with real-time Salesloft data.
-
DataBind Charts to PabblySubscriptions Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to PabblySubscriptions 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.
-
Connect to Live Paylocity Data in MicroStrategy through CData Connect AI
Create a live connection to Paylocity Data in CData Connect AI and connect to your Paylocity data from MicroStrategy.
-
How to integrate Metabase with Salesforce Pardot Data
Use CData Connect AI to connect to live Salesforce Pardot data and create an interactive dashboard in Metabase from Salesforce Pardot data.
-
Build Dashboards with Workable Data in DBxtra
Create dynamic dashboards and perform analytics based on Workable data in DBxtra.
-
Provide OData Services of Okta Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Okta data by developing a WCF Service Application.
-
Access Live Shippo Data in Coginiti Pro
Connect to and query live Shippo data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Reports with Pingdom Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pingdom data.