CData Software - Knowledge Base
Recent Articles
-
Connect to Omnisend from a Connection Pool in WebLogic
Use the CData JDBC Driver for Omnisend to connect to Omnisend from Web applications running on WebLogic.
-
Automated Continuous Tickspot Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Tickspot replication to PostgreSQL.
-
Automated Continuous Bullhorn CRM Replication to MongoDB
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to MongoDB.
-
Visualize QuickBooks Time Data in TIBCO Spotfire through ADO.NET
Integrate QuickBooks Time into dashboards in TIBCO Spotfire.
-
Connect to Shopify Data in RazorSQL
Connect to Shopify from wizards and query Shopify from the GUI in the RazorSQL database management tool.
-
Access Live LinkedIn Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live LinkedIn data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Analyze Zoom Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Zoom and visualize live Zoom in Infragistics Reveal.
-
Connect to Landbot Data in JRuby
Create a simple JRuby app with access to live Landbot.
-
Connect SAP Ariba Procurement Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP Ariba Procurement using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrating Boomi Agentstudio with Workday Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Workday, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Getting Started with the CData SSIS Components for QuickBooks
Complete guide to installing, licensing, and connecting with the CData SSIS Components for QuickBooks.
-
A PostgreSQL Interface for Invoiced Data (MySQL Remoting via JDBC)
Use the Remoting features of the Invoiced JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build an OLAP Cube in SSAS from Float Data
Establish a connection to Float data from SQL Server Analysis Services, and use the Float Data Provider to build OLAP cubes for use in analytics and reporting.
-
Migrating data from Epicor Kinetic to Snowflake using CData SSIS Components.
Easily push Epicor Kinetic to Snowflake using the CData SSIS Tasks for Epicor Kinetic and Snowflake.
-
Analyze Live BigCommerce Data in SAS Viya
Use CData Connect AI to connect to BigCommerce from SAS Viya and deploy self-service analytics using live BigCommerce.
-
Query Rebilly Data in DataGrip
Create a Data Source for Rebilly in DataGrip and use SQL to query live Rebilly.
-
Rapidly Develop GitHub-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 GitHub.
-
How to connect PolyBase to Cosmos DB
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Azure Cosmos DB.
-
Integrate with Smartsheet Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Smartsheet in SnapLogic.
-
Analyze XML Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of XML Files and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate with Google Campaign Manager 360 Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Campaign Manager 360 in SnapLogic.
-
Build a Simple VCL Application for Stack Exchange Data
How to build a simple VCL Application to view Stack Exchange in RAD Studio using the CData ODBC Driver for Stack Exchange.
-
Publish Salesforce CRM Analytics-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Salesforce CRM Analytics.
-
Integrate with Cassandra Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Apache Cassandra to a JSON file on disk.
-
Integrating Antigravity CLI with FHIR via CData CLI
Connect FHIR to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Extract, Transform, and Load Dynamics NAV Data in Informatica PowerCenter
Create a simple Workflow for Microsoft Dynamics NAV in Informatica PowerCenter.
-
Connect to Omnisend Data from a Connection Pool in Jetty
The Omnisend JDBC Driver supports connection pooling: This article shows how to connect faster to Omnisend from Web apps in Jetty.
-
Access AdRoll Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live AdRoll from HeidiSQL.
-
Connect to Browserless Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Browserless and work with Browserless in your FileMaker applications.
-
Visualize Live Browserless Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Browserless using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Excel Spreadsheet Automation on Retently Data with the QUERY Formula
Pull data from Retently, automate spreadsheets, and more with the QUERY formula.
-
Natively Connect to HBase Data in PHP
The CData ODBC driver for HBase enables you to create PHP applications with connectivity to Apache HBase. Leverage the native support for ODBC in PHP.
-
Configure the CData JDBC Driver for Tickspot in a Connection Pool in Tomcat
Connect to Tickspot from a connection pool in Tomcat.
-
How to Access Coda Data Using Entity Framework
This article shows how to access Coda using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Add Apify Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Apify with the Informatica Enterprise Data Catalog to classify and organize data.
-
DataBind Controls to Gorgias Data in Delphi
DataBind to Gorgias in Delphi with standard data access components and controls.
-
Visualize Azure Data Catalog Data in TIBCO Spotfire through OData
Integrate Azure Data Catalog into dashboards in TIBCO Spotfire.
-
Connect to Live Google Calendar Data in MicroStrategy through CData Connect AI
Create a live connection to Google Calendar Data in CData Connect AI and connect to your Google Calendar from MicroStrategy.
-
Build AI/ML Models with Live SAS xpt Data using Dataiku
Connect SAS xpt Data with Dataiku using the CData JDBC Driver for SASxpt.
-
Create Informatica Mappings From/To an ODBC Data Source for MySQL
Create an ODBC connection to MySQL in Informatica and browse and transfer MySQL.
-
Create Reports from eBay Data in Looker Studio
Use CData Connect AI to gain access to live eBay and create custom reports in Looker Studio.
-
Build Charts with CapsuleCRM Data in Clear Analytics
Create dynamic charts and perform analytics based on CapsuleCRM in Clear Analytics.
-
Build MVC Applications with Connectivity to Opsgenie Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Opsgenie from an ASP.NET MVC application.
-
Integrate MongoDB with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate MongoDB with External Services.
-
Import Lakebase Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Lakebase Data and provide access to live Lakebase for custom reports in the Power BI Service.
-
Access Live XML Data in TIBCO Data Virtualization
Use the XML Tibco DV Adapter to create a XML Files data source in TIBCO Data Virtualization Studio and gain access to live XML Files from your TDV Server.
-
Visualize Insightly 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 Insightly into TIBCO Spotfire.
-
Build QuickBooks Online-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to QuickBooks Online Data from Zoho Analytics and import live QuickBooks Online.
-
Use the CData ODBC Driver for Missive from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Missive to connect to Missive from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Missive in Excel.
-
Getting Started with the CData SSIS Components for TaxJar
Complete guide to installing, licensing, and connecting with the CData SSIS Components for TaxJar.
-
Import eBay Analytics Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access eBay Analytics. In this article, you will use the OData format to import eBay Analytics into Microsoft Power Query.
-
Access Live RabbitMQ Data in AWS Lambda
Connect to live RabbitMQ in AWS Lambda using the CData JDBC Driver.
-
Model Azure DevOps Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Azure DevOps, enabling the direct import of real-time Azure DevOps.
-
Validate Typeform Data with QuerySurge
Access and validate Typeform in QuerySurge using the CData JDBC Driver.
-
Create Datasets from Microsoft Ads in Domo Workbench and Build Visualizations of Microsoft Ads Data in Domo
Use the CData Software ODBC Driver for Microsoft Ads to create datasets from Microsoft Ads in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to Greenplum Data from IntelliJ
Integrate connectivity to Pivotal GreenPlum with wizards in IntelliJ.
-
How to integrate Microsoft Ads with Apache Airflow
Access and process Microsoft Ads in Apache Airflow using the CData JDBC Driver.
-
How to Easily Query ConstantContact Data in OpenOffice Base
Connect to ConstantContact data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to load Acumatica data into Elasticsearch via Logstash
Introducing a simple method to load Acumatica data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Azure Data Catalog
Provide connectivity to Azure Data Catalog through an SAP BusinessObjects universe.
-
Build Semantic Layer Views for SAP BusinessObjects BI Data in APOS Live Data Gateway
Use the CData Connector for SAP BusinessObjects BI in APOS Live Data Gateway to build Semantic Layer Views for SAP BusinessObjects BI.
-
How to Visualize ConstantContact Data in Python with pandas
Use pandas and other modules to analyze and visualize live ConstantContact in Python.
-
Build Omnisend-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Omnisend Data in Cursor to assist with building Omnisend-powered applications.
-
Integrate ServiceNow Data in Pentaho Data Integration
Build ETL pipelines based on ServiceNow in the Pentaho Data Integration tool.
-
Build Semantic Layer Views for Azure DevOps Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Azure DevOps.
-
Connect SAP Business One to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP Business One using the CData Python MCP Server.
-
Connect to and Visualize Live LeadDesk Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live LeadDesk.
-
Sugar CRM Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Sugar CRM through CData Connect AI using different applications and tools.
-
Migrating data from Dynamics 365 Business Central to Snowflake using CData SSIS Components.
Easily push Dynamics 365 Business Central to Snowflake using the CData SSIS Tasks for Dynamics 365 Business Central and Snowflake.
-
Replicate Bugsnag Data from PowerShell
Write a quick PowerShell script to query Bugsnag. Use connectivity to the live data to replicate Bugsnag to SQL Server.
-
Publish Mocean-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Mocean.
-
How to Access Qualaroo Data Using Entity Framework
This article shows how to access Qualaroo using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Seamlessly Bring Act CRM Data into Retool Using CData Connect AI
Integrate Act CRM data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate Cursor with Live Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Amazon Athena from within the editor.
-
Create Dashboards and Visualize Live Google Ad Manager Data in Geckoboard
Use CData Connect AI to connect to live Google Ad Manager and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Provide OData Services of Clari Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Clari by developing a WCF Service Application.
-
Access Live Excel Online 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 Microsoft Excel Online through MCP integration.
-
Use Biml to Build SSIS Tasks to Replicate Jira Assets Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Jira Assets to SQL Server.
-
Automated Continuous Splunk Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Splunk replication to Amazon Redshift.
-
Create Coda Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Coda from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Data Visualizations in Cognos BI with Impala Data
Access Apache Impala as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Gong
Provide connectivity to Gong through an SAP BusinessObjects universe.
-
Import Microsoft Ads Data Using Azure Data Factory
Use CData Connect AI to connect to Microsoft Ads Data from Azure Data Factory and import live Microsoft Ads.
-
Analyze Epicor Kinetic Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Epicor Kinetic and visualize live Epicor Kinetic in Infragistics Reveal.
-
How to Seamlessly Import Cosmos DB Data into IBM SPSS Modeler
Integrate Cosmos DB data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Workday Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Workday from Filemaker Pro on Mac.
-
Access Live Dynamics 365 Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Dynamics 365 from your Excel spreadsheets.
-
Automated Continuous Basecamp Replication to MongoDB
Use CData Sync for automated, continuous, customizable Basecamp replication to MongoDB.
-
Build Semantic Layer Views for Marketo Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Marketo.
-
Automated Continuous Typeform Replication to SingleStore
Use CData Sync for automated, continuous, customizable Typeform replication to SingleStore.
-
Connecting GenSpark with Instagram Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Instagram without any replication or custom integration required.
-
Visualize Square Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Square.
-
How to Visualize Teradata Data in Python with pandas
Use pandas and other modules to analyze and visualize live Teradata in Python.
-
A PostgreSQL Interface for Phoenix Data (MySQL Remoting via JDBC)
Use the Remoting features of the Phoenix JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Gumloop with Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Azure Cosmos DB within automated workflows.
-
Integrate with Oracle SCM Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Oracle SCM in SnapLogic.
-
Getting Started with the CData Tableau Connector for IBM Informix
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for IBM Informix.
-
Connect to Helpscout Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Connect DBeaver to MarkLogic via a JDBC Driver
Manage MarkLogic with visual tools in DBeaver like the query browser.
-
Working with Accelo Data in LINQPad
Execute LINQ queries to Accelo in LINQPad.