CData Software - Knowledge Base
Recent Articles
-
Connect to Live Zoho Creator Data in MicroStrategy through CData Connect AI
Create a live connection to Zoho Creator Data in CData Connect AI and connect to your Zoho Creator from MicroStrategy.
-
DataBind Controls to Quickbase Data in C++Builder
DataBind to Quickbase in C++Builder with standard components and controls.
-
Migrating data from Microsoft Entra ID to Google BigQuery using CData SSIS Components.
Easily push Microsoft Entra ID to Google BigQuery using the CData SSIS Tasks for Microsoft Entra ID and Google BigQuery.
-
Connect to and Query Eventbrite Data in QlikView over ODBC
Create data visualizations with Eventbrite in QlikView.
-
Configure the CData JDBC Driver for Rebilly in a Connection Pool in Tomcat
Connect to Rebilly from a connection pool in Tomcat.
-
Automate Oracle Eloqua Reporting Data Replication to Couchbase
Use CData Sync to Customize and automate Oracle Eloqua Reporting replication to Couchbase.
-
Query Jira Data in ColdFusion
Write standard ColdFusion data access code to connect to Atlassian Jira.
-
Edit and Search TaxJar External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of TaxJar to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create TaxJar objects that you can access from apps and the dashboard.
-
Create SAP Fieldglass Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP Fieldglass data access from reports, embedded analytics, and more.
-
Connect to and Query Avalara AvaTax Data in QlikView over ODBC
Create data visualizations with Avalara AvaTax in QlikView.
-
Connect to Zoho Projects Data in Aqua Data Studio
Access Zoho Projects from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connecting Agentforce with Google Contacts 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 Google Contacts for you.
-
How to connect to Discourse Data with Squirrel SQL client
Connect to Discourse and execute queries in the Squirrel SQL Client.
-
Validate Amplitude Data with QuerySurge
Access and validate Amplitude in QuerySurge using the CData JDBC Driver.
-
DataBind Flowlu Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Flowlu to a chart.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live HCL Domino within intelligent workflows.
-
Design BIRT Reports on Google Tasks Data
Provide current Google Tasks to your embedded analytics.
-
Use Microsoft Copilot Studio to talk to your Email 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 Email for you.
-
Use the CData ODBC Driver for Superchat from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Superchat to connect to Superchat from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Superchat in Excel.
-
Automated Continuous ClickUp Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ClickUp replication to Apache Cassandra.
-
How to connect to Unbounce Data from Spring Boot
Connect to Unbounce in a Spring Boot Application using the CData API Driver for JDBC
-
ETL Wrike in Oracle Data Integrator
This article shows how to transfer Wrike into a data warehouse using Oracle Data Integrator.
-
Visualize PabblySubscriptions Data in Sisense
Create an ElastiCube in Sisense app with access to PabblySubscriptions.
-
DataBind Impala Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Impala with the DevExpress Windows Forms and Web controls to provide Apache Impala to a chart.
-
Validate SharePoint Excel Services Data with QuerySurge
Access and validate SharePoint Excel Services in QuerySurge using the CData JDBC Driver.
-
How to Query Live ServiceNow Data in Claude Desktop
Connect to and query live ServiceNow Data in Claude Desktop using CData MCP Server.
-
How to connect to Pinterest Data from IntelliJ
Integrate connectivity to Pinterest with wizards in IntelliJ.
-
Integrate Amazon S3 with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Amazon S3 with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Amazon S3.
-
Use JayDeBeApi to access Spark Data in Python
Use standard Python scripting and the development environment of your choice to access live Apache Spark SQL.
-
Build AI/ML Models with Live Webex Data using Dataiku
Connect Webex Data with Dataiku using the CData API Driver for JDBC.
-
Prepare, Blend, and Analyze Couchbase Data in Alteryx Designer (Connect AI)
Build workflows to access live Couchbase for self-service data analytics.
-
Integrate Real-Time Access to SAS xpt in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAS XPORT in real time.
-
Build MVC Applications with Connectivity to SAP Netweaver Gateway Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP Netweaver Gateway from an ASP.NET MVC application.
-
Integrating Codex CLI with SAP Business Warehouse 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 Microsoft Copilot Studio to talk to your Marketo 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 Marketo for you.
-
Integrating Kiro CLI with ChargeOver 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 Biml to Build SSIS Tasks to Replicate Amplitude Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Amplitude to SQL Server.
-
Bridge Redshift Connectivity with Apache NiFi
Access and process Amazon Redshift in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous ChargeOver Replication to SQLite
Use CData Sync for automated, continuous, customizable ChargeOver replication to SQLite.
-
How to connect to HDFS Data from Spring Boot
Connect to HDFS in a Spring Boot Application using the CData JDBC Driver for HDFS
-
Build AI/ML Models with Live Oracle Eloqua Reporting Data using Dataiku
Connect Oracle Eloqua Reporting Data with Dataiku using the CData JDBC Driver for Oracle Eloqua Reporting.
-
Build Automated Workflows with Live Azure Table Data in Workato
Use CData Connect AI to connect to live Azure Table Storage and build automated workflows in Workato.
-
Connecting Mastra with Zoho Inventory 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 Zoho Inventory, no replication required.
-
How to create Parallel federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Parallel in MySQL .
-
Create Dashboards and Visualize Live FTP Data in Geckoboard
Use CData Connect AI to connect to live FTP Servers and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Work with Pingdom Data in AWS Glue Jobs Using JDBC
Connect to Pingdom from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Data Flows from SQL Server to Facebook Ads through SSIS
Easily push SQL Server data to Facebook Ads using the CData SSIS Tasks for Facebook Ads.
-
Getting Started with the CData Tableau Connector for Google Sheets
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Sheets.
-
Connect to PivotalTracker Data in DBeaver
Use the CData ODBC Driver to connect to PivotalTracker in DBeaver.
-
How to connect to SendPulse Data from Spring Boot
Connect to SendPulse in a Spring Boot Application using the CData API Driver for JDBC
-
Getting Started with the CData Connect AI Python SDK for Act CRM
Install the CData Connect AI Python SDK to read and write live Act CRM with standard DB-API 2.0 Python code.
-
Visualize Live Kintone Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Kintone into custom reports in Power BI.
-
Create Data Visualizations in Cognos BI with Postmark Data
Access Postmark as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Okta-Connected Applications in Appsmith
Connect to Okta Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Okta.
-
Bidirectional Access to SQL Analysis Services Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SQL Analysis Services in Filemaker Pro for Mac or Windows.
-
Write a Simple Go Application to work with SAP BusinessObjects BI Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP BusinessObjects BI.
-
Integrating Cursor CLI with ClickTime 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.
-
Integrating Kiro CLI with Azure Table 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.
-
Feed ServiceNow Data into FineReport
How to set ServiceNow as a JDBC data source in FineReport.
-
Query SAP Business One Data as a MySQL Database in Node.js
Execute MySQL queries against SAP Business One from Node.js.
-
How to load Guru data into Elasticsearch via Logstash
Introducing a simple method to load Guru data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live SAP Netweaver Gateway Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live SAP Netweaver Gateway through MCP integration.
-
Query Helpscout Data in DataGrip
Create a Data Source for Helpscout in DataGrip and use SQL to query live Helpscout.
-
Automated Continuous WooCommerce Replication to Amazon S3
Use CData Sync for automated, continuous, customizable WooCommerce replication to Amazon S3.
-
A PostgreSQL Interface for Email Data using the CData ODBC Driver
Use the SQL Gateway and Email ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live CSV Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live CSV/TSV Files securely in real time.
-
Build a Singer.io Tap for Snowflake using CData Python Connector
Integrate Singer.io with Snowflake using CData to access live Snowflake data, streamline ETL workflows, and optimize performance.
-
Build a Simple VCL Application for WordPress Data
How to build a simple VCL Application to view WordPress in RAD Studio using the CData ODBC Driver for WordPress.
-
Automate Zoho Creator Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Zoho Creator from PowerShell? This article demonstrates how to utilize the Zoho Creator Cmdlets for tasks like connecting to Zoho Creator, automating operations, downloading data, and more.
-
Getting Started with the CData Power BI Connector for Deel
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create a Data Access Object for Postmark Data using JDBI
A brief overview of creating a SQL Object API for Postmark in JDBI.
-
How to connect to Customer.io Data from IntelliJ
Integrate connectivity to Customer.io with wizards in IntelliJ.
-
Model, Search, and Visualize Live IBM Cloud Object Storage Data in ThoughtSpot
Use CData Connect AI to connect to live IBM Cloud Object Storage for modeling, searching, and visualizing.
-
Build Sage 200-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Sage 200 and build Sage 200-connected web apps with Axios.
-
Build Agents in Relevance AI with Access to Live SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft SQL Server within intelligent agent workflows.
-
How to work with Cohere Data in Apache Spark using SQL
Access and process Cohere Data in Apache Spark using the CData Software JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Templated Data
Use CData Power BI Connectors to visualize Templated in Power BI.
-
Build an OLAP Cube in SSAS from Keap Data
Establish a connection to Keap data from SQL Server Analysis Services, and use the Keap Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Bitly Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Bitly and work with Bitly in your FileMaker applications.
-
How to publish and share Workday Data dashboards with Tableau Server
The CData ODBC driver for Workday enables you integrate Workday into Tableau dashboards.
-
Connect to IBM Informix from Asprova with CData Software ODBC Driver for IBM Informix
This article shows how to connect faster to IBM Informix data from Asprova.
-
Build an OLAP Cube in SSAS from Mocean Data
Establish a connection to Mocean data from SQL Server Analysis Services, and use the Mocean Data Provider to build OLAP cubes for use in analytics and reporting.
-
Choosing the Best Method to Connect Short.io to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Short.io from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Avalara AvaTax 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 Avalara AvaTax.
-
Prepare, Blend, and Analyze EnterpriseDB Data in Alteryx Designer (ODBC)
Build workflows to access live EnterpriseDB for self-service data analytics.
-
How to Query Live Front Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Front data in natural language using Python.
-
Integrate Cline with Live Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Apache Hive from within your IDE.
-
Automated Continuous Salesloft Replication to SQLite
Use CData Sync for automated, continuous, customizable Salesloft replication to SQLite.
-
Connect to and Query PagerDuty Data in QlikView over ODBC
Create data visualizations with PagerDuty in QlikView.
-
Connect to and Query SAP Ariba Source Data in QlikView over ODBC
Create data visualizations with SAP Ariba Source in QlikView.
-
Connect to ZohoMarketingHub Data in Ruby
Connect to ZohoMarketingHub in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automate DocuSign Integration Tasks from PowerShell
Are you in search of a quick and easy way to access DocuSign from PowerShell? This article demonstrates how to utilize the DocuSign Cmdlets for tasks like connecting to DocuSign, automating operations, downloading data, and more.
-
Connect LDAP Objects to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your LDAP using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to and Visualize Live ServiceDesk Plus Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ServiceDesk Plus.
-
Use the CData SSIS Components to Insert New or Update Existing SAP Netweaver Gateway Records from SQL Server
Easily push SQL Server data to SAP Netweaver Gateway using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SAP Netweaver Gateway or update existing records with data from a SQL Server database.
-
Use the CData ODBC Driver for Gumroad from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Gumroad to connect to Gumroad from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Gumroad in Excel.
-
Connect to and Visualize Live Tickspot Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Tickspot.
-
Access Live Drip Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Drip in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Migrating data from HCL Domino to Snowflake using CData SSIS Components.
Easily push HCL Domino to Snowflake using the CData SSIS Tasks for HCL Domino and Snowflake.
-
Integrate Theia IDE with Live Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE