CData Software - Knowledge Base
Recent Articles
-
How to Query Live Shopify Data in Claude Desktop
Connect to and query live Shopify Data in Claude Desktop using CData MCP Server.
-
Import Real-Time Printful Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Printful in ColdFusion.
-
Automated Continuous Monday.com Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Monday.com replication to Google BigQuery.
-
Build OpenWeatherMap-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live OpenWeatherMap.
-
Extend Google Sheets with Printify Data
Make calls to Printify from Google Apps Script via the API Server.
-
Use Agno to Talk to Your Outreach.io 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 Outreach.io for you.
-
Query Aha! Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Aha! from Node.js.
-
Integrate Cline with Live Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Apollo from within your IDE.
-
ETL Sendwithus in Oracle Data Integrator
This article shows how to transfer Sendwithus into a data warehouse using Oracle Data Integrator.
-
How to load Amplitude data into Elasticsearch via Logstash
Introducing a simple method to load Amplitude data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Visualize Live Mode Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Mode using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Prepare, Blend, and Analyze Reckon Accounts Hosted Data in Alteryx Designer (ODBC)
Build workflows to access live Reckon Accounts Hosted for self-service data analytics.
-
Extract, Transform, and Load Zoho CRM Data in Informatica PowerCenter
Create a simple Workflow for Zoho CRM in Informatica PowerCenter.
-
Create Datasets from ZendeskSell in Domo Workbench and Build Visualizations of ZendeskSell Data in Domo
Use the CData Software ODBC Driver for ZendeskSell to create datasets from ZendeskSell in Domo Workbench and then build visualizations in the Domo service.
-
Create Data Visualizations in Cognos BI with Acumatica Data
Access Acumatica ERP as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated DocuSign Data Replication to Teradata
Use CData Sync to Customize and automate DocuSign replication to Teradata.
-
A PostgreSQL Interface for Oracle Service Cloud Data (MySQL Remoting via JDBC)
Use the Remoting features of the Oracle Service Cloud JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Microsoft Ads Data in Cognos Analytics
Use CData Connect AI to connect to Microsoft Ads Data from Cognos Analytics and analyze live Microsoft Ads.
-
Getting Started with the CData Excel Add-In for PagerDuty
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for PagerDuty.
-
Visualize Live Sybase IQ Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Sybase IQ using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Visualize ConvertAPI Data in Python with pandas
Use pandas and other modules to analyze and visualize live ConvertAPI in Python.
-
Integrate Live SAP Ariba Procurement Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP Ariba Procurement from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Ariba Procurement.
-
Import SAP Fieldglass Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAP Fieldglass. In this article, you will use the OData format to import SAP Fieldglass into Microsoft Power Query.
-
Confluence Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Atlassian Confluence through CData Connect AI using different applications and tools.
-
Connect to Hive from a Connection Pool in WebLogic
Use the CData JDBC Driver for Hive to connect to Apache Hive from Web applications running on WebLogic.
-
Migrating data from Beeminder to Google BigQuery using CData SSIS Components.
Easily push Beeminder to Google BigQuery using the CData SSIS Tasks for Beeminder and Google BigQuery.
-
Connect to Google Directory Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Directory.
-
Visualize ChartMogul 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 ChartMogul into TIBCO Spotfire.
-
Establish a Live Connection with Omnisend Data using Tableau Bridge
The CData ODBC Driver for Omnisend enables you to integrate live Omnisend into Tableau Cloud dashboards using the Tableau Bridge.
-
Use CData Connect AI to Access Act CRM Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Act CRM in the Power Pivot business intelligence tool.
-
How to Access Live Marketo Data in Visual Studio Code via Cline
Run CData MCP Server for Marketo on Windows Subsytem for Linux (WSL) and connect to live Marketo from the Cline extension in Visual Studio Code.
-
Use Microsoft Copilot Studio to talk to your Microsoft Teams 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 Microsoft Teams for you.
-
Connect to Shortcut Data in Ruby
Connect to Shortcut in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect to Zoho Books Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Zoho Books. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Drift Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Drift replication to Apache Cassandra.
-
Create a Data Access Object for Salesforce CRM Analytics Data using JDBI
A brief overview of creating a SQL Object API for Salesforce CRM Analytics in JDBI.
-
Visualize Live Sybase IQ Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Sybase IQ.
-
Object-Relational Mapping (ORM) with ClickUp Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to ClickUp into a Java-based ORM framework, Hibernate.
-
How to Easily Query ShipEngine Data in OpenOffice Base
Connect to ShipEngine data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrating Antigravity CLI with Klipfolio via CData CLI
Connect Klipfolio to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize Live Flowlu Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Flowlu.
-
Integrate with ADP Data in SnapLogic
Use CData Connect AI to connect to and integrate with live ADP in SnapLogic.
-
Visualize DocuSign Data in TIBCO Spotfire through OData
Integrate DocuSign into dashboards in TIBCO Spotfire.
-
How to Create Power BI Visual Reports with Real-Time Dropbox Data
Use CData Power BI Connectors to visualize Dropbox in Power BI.
-
Connect to Zendesk Data in Ruby
Connect to Zendesk in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate Basecamp Data to Multiple Databases via the CData Sync CLI
Replicate Basecamp to disparate databases with a single configuration.
-
Connect to Rootly Data in CloverDX (formerly CloverETL)
Transfer Rootly using the visual workflow in the CloverDX data integration tool.
-
How to Build an ETL App for Oracle HCM Cloud Data in Python with CData
Create ETL applications and real-time data pipelines for Oracle HCM Cloud in Python with petl.
-
Create Power BI Reports on Real-Time ZohoExpense Data
Use the CData ODBC Driver for ZohoExpense to visualize ZohoExpense in Power BI Desktop.
-
Connect to Azure Synapse from a Connection Pool in WebLogic
Use the CData JDBC Driver for Azure Synapse to connect to Azure Synapse from Web applications running on WebLogic.
-
Replicate Insightly Data in Heroku for Use in Salesforce Connect
Replicate Insightly to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to import ShipStation Data into Apache Solr
Use the CData Software JDBC Driver for ShipStation in Data Import Handler and create an automated import of ShipStation to Apache Solr Enterprise Search platform.
-
Connect to Printful Data in HULFT Integrate
Connect to Printful as a JDBC data source in HULFT Integrate
-
How to Seamlessly Import Quaderno Data into IBM SPSS Modeler
Integrate Quaderno data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Process & Analyze AdRoll Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live AdRoll Data.
-
Publish Dotmailer-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Dotmailer.
-
Visualize Grafana Data in TIBCO Spotfire through OData
Integrate Grafana into dashboards in TIBCO Spotfire.
-
Replicate Zoho CRM Data to Multiple Databases via the CData Sync CLI
Replicate Zoho CRM to disparate databases with a single configuration.
-
Analyze Cassandra Data in Looker
Use CData Connect AI to connect to Cassandra Data from Looker and build custom apps using live Apache Cassandra.
-
How to import Foursquare Data into Apache Solr
Use the CData Software JDBC Driver for Foursquare in Data Import Handler and create an automated import of Foursquare to Apache Solr Enterprise Search platform.
-
Connect to and Visualize Live BigQuery Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google BigQuery.
-
How to Query Live Salesforce Marketing Data in Perplexity MacOS Desktop
Connect to and query live Salesforce Marketing Data in Perplexity Desktop using CData MCP Server.
-
Choosing the Best Method to Connect Drift to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Drift from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous FreeAgent Replication to AlloyDB
Use CData Sync for automated, continuous, customizable FreeAgent replication to AlloyDB.
-
How to Connect the Power BI Service to RSS: Complete Guide
Connect to the CData Software Power BI Connector for RSS from PowerBI.com to provide real-time RSS Feeds across the organization.
-
Back Up SAP HANA XS Advanced to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP HANA XS Advanced. In this article, we will employ an SSIS workflow to populate a database with SAP HANA XS Advanced data.
-
Create Clari Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Clari from PowerBI.com to create Power BI Dataflows with real-time data.
-
Import SAP Ariba Procurement Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP Ariba Procurement Data and provide access to live SAP Ariba Procurement for custom reports in the Power BI Service.
-
Establish a Live Connection with Pinecone Data using Tableau Bridge
The CData ODBC Driver for Pinecone enables you to integrate live Pinecone into Tableau Cloud dashboards using the Tableau Bridge.
-
A PostgreSQL Interface for Supabase Data (MySQL Remoting via JDBC)
Use the Remoting features of the Supabase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate GetResponse Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live GetResponse and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Analyze Aha! Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Aha! and visualize live Aha! in Infragistics Reveal.
-
Connect to and Query Clockify Data in QlikView over ODBC
Create data visualizations with Clockify in QlikView.
-
Natively Connect to Oracle SCM Data in PHP
The CData ODBC driver for Oracle SCM enables you to create PHP applications with connectivity to Oracle SCM. Leverage the native support for ODBC in PHP.
-
Build Visualizations of Sybase Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Sybase in Birst.
-
Build Dashboards with Act CRM Data in Dundas BI
Create dynamic dashboards and perform analytics based on Act CRM in Dundas BI.
-
Connect to Microsoft Ads from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Ads, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create SSAS Tabular Models from Codat Data
How to build a SQL Server Analysis Service Tabular Model from Codat using CData drivers.
-
Automated Continuous FreeAgent Replication to Oracle
Use CData Sync for automated, continuous, customizable FreeAgent replication to Oracle.
-
Automated Continuous Azure Blob Storage Replication to SQLite
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to SQLite.
-
Connect to Acumatica Data from PowerBuilder via JDBC
This article demonstrates how to access Acumatica ERP from PowerBuilder using the Acumatica JDBC Driver.
-
Build Neo4J-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Neo4J to explore live Neo4J Data in GitHub Copilot to assist with building Neo4J-powered applications.
-
Create Informatica Mappings From/To a JDBC Data Source for Everhour
Create Everhour data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Klaviyo Data in HULFT Integrate
Connect to Klaviyo as a JDBC data source in HULFT Integrate
-
Migrating data from PagerDuty to Databricks using CData SSIS Components.
Easily push PagerDuty to Databricks using the CData SSIS Tasks for PagerDuty and Databricks.
-
Use the CData Software JDBC Driver for Paymo in MicroStrategy Web
Connect to Paymo in MicroStrategy Web using the CData Software JDBC Driver for Paymo.
-
Consume Microsoft OneDrive OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft OneDrive as OData feeds from PowerBuilder using the API Server.
-
Import Real-Time Sage Intacct Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Sage Intacct in ColdFusion.
-
Access Live Perigon Data in AWS Lambda
Connect to live Perigon in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for SurveyMonkey in MicroStrategy
Connect to SurveyMonkey in MicroStrategy Developer using the CData Software JDBC Driver for SurveyMonkey.
-
How to Connect to Tally Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Tally ERP. Leverage the pyodbc module for ODBC in Python.
-
Migrating data from MongoDB to Databricks using CData SSIS Components.
Easily push MongoDB to Databricks using the CData SSIS Tasks for MongoDB and Databricks.
-
Access Hacker News Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Hacker News from HeidiSQL.
-
Automated Continuous eBay Replication to Oracle
Use CData Sync for automated, continuous, customizable eBay replication to Oracle.
-
Connect to Snowflake Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Snowflake and the Script function in FileMaker Pro to connect to Snowflake and work with Snowflake in your FileMaker application.
-
Visualize DocuSign 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 DocuSign into TIBCO Spotfire.
-
Automated Continuous Jodoo Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Jodoo replication to Google BigQuery.
-
Automated Continuous ZohoMarketingHub Replication to SingleStore
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to SingleStore.
-
How to connect and process PhantomBuster from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live PhantomBuster.
-
Replicate Multiple Front Accounts
Replicate multiple Front accounts to one or many databases.