CData Software - Knowledge Base
Recent Articles
-
Migrating data from Hugging Face to Snowflake using CData SSIS Components.
Easily push Hugging Face to Snowflake using the CData SSIS Tasks for Hugging Face and Snowflake.
-
Connect to Avalara AvaTax Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Avalara AvaTax.
-
Design BIRT Reports on Cloudant Data
Provide current IBM Cloudant to your embedded analytics.
-
Connecting Pipedream with Google Analytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Google Analytics data in real time.
-
Use Biml to Build SSIS Tasks to Replicate SAP HANA XS Advanced Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP HANA XS Advanced to SQL Server.
-
Choosing the Best Method to Connect Hive to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Apache Hive from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build CouchDB Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Apache CouchDB and build visualizations in Tableau Cloud.
-
Bidirectional Access to Clio Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Clio in Filemaker Pro for Mac or Windows.
-
Connect to JSON Services as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live JSON.
-
Getting Started with the CData Python Connector for Xero
Learn to install and license the CData Python Connector
-
Create Dynamic Intercom Grids Using the Infragistics XamDataGrid
Learn how you can connect Intercom to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData Software ODBC Driver for HubDB in MicroStrategy Desktop
Connect to HubDB in MicroStrategy Desktop using the CData Software ODBC Driver for HubDB.
-
How to Easily Query Dynamics CRM Data in OpenOffice Base
Connect to Dynamics CRM data in OpenOffice Base using the CData ODBC Driver for Dynamics CRM and generate reports with live data insights.
-
Getting Started with the CData Python Connector for Oracle SCM
Learn to install and license the CData Python Connector
-
Work with Live NetSuite Data in Power Query
Use CData Connect AI to connect to NetSuite CRM & ERP and work with live NetSuite CRM & ERP in Microsoft Power Query.
-
DataBind Controls to ZohoExpense Data in Delphi
DataBind to ZohoExpense in Delphi with standard data access components and controls.
-
DataBind RabbitMQ Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide RabbitMQ to a chart.
-
How to Query SQL Server Data in MySQL Workbench
Execute MySQL queries against live Microsoft SQL Server from MySQL Workbench.
-
Getting Started with the CData Tableau Connector for Tanda
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Getting Started with the CData SSIS Components for Sybase IQ
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Sybase IQ.
-
Integrate Unbounce Data in Pentaho Data Integration
Build ETL pipelines based on Unbounce in the Pentaho Data Integration tool.
-
How to Work with Adobe Commerce Data in ETL Validator JDBC
Connect to Adobe Commerce from ETL Validator jobs using the CData Software JDBC Driver.
-
Work with Live SAP Netweaver Gateway Data in Power Query
Use CData Connect AI to connect to SAP Netweaver Gateway and work with live SAP Netweaver Gateway in Microsoft Power Query.
-
How to Access Clari Data Using Entity Framework
This article shows how to access Clari using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Import PayPal Data Using Azure Data Factory
Use CData Connect AI to connect to PayPal Data from Azure Data Factory and import live PayPal.
-
Integrate Live Pipedrive Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Pipedrive and integrate live Pipedrive into apps built in Microsoft Power Apps.
-
Model, Search, and Visualize Live Oracle HCM Cloud Data in ThoughtSpot
Use CData Connect AI to connect to live Oracle HCM Cloud for modeling, searching, and visualizing.
-
How to create HubDB federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for HubDB in MySQL .
-
Connect to Active Directory Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Active Directory using standard SQL.
-
Connect to Gmail Data in Jaspersoft Studio
Execute SQL to remote Gmail in Jaspersoft Studio.
-
Create Adobe Analytics-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Adobe Analytics Data from OutSystems and build custom enterprise apps using live Adobe Analytics.
-
How to Query Live Paylocity Data in Claude Desktop
Connect to and query live Paylocity Data in Claude Desktop using CData MCP Server.
-
Automated Continuous Basecamp Replication to SQLite
Use CData Sync for automated, continuous, customizable Basecamp replication to SQLite.
-
How to connect to Salesforce Data 360 Data from IntelliJ
Integrate connectivity to Salesforce Data 360 with wizards in IntelliJ.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ZohoSubscriptions
Provide connectivity to ZohoSubscriptions through an SAP BusinessObjects universe.
-
Build Data Flows from LaunchDarkly to SQL Server using SSIS
Easily back up LaunchDarkly to SQL Server using the SSIS components for LaunchDarkly.
-
Automated Continuous Bullhorn CRM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to PostgreSQL.
-
A PostgreSQL Interface for QuickBooks Data using the CData ODBC Driver
Use the SQL Gateway and QuickBooks ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous LinkedIn Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable LinkedIn replication to delimited files (CSV/TSV).
-
Connect to Eventbrite Data in HULFT Integrate
Connect to Eventbrite as a JDBC data source in HULFT Integrate
-
How to load SendPulse data into Elasticsearch via Logstash
Introducing a simple method to load SendPulse data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Build an ETL App for Shortcut Data in Python with CData
Create ETL applications and real-time data pipelines for Shortcut in Python with petl.
-
Automate Monday.com Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Monday.com from PowerShell? This article demonstrates how to utilize the Monday.com Cmdlets for tasks like connecting to Monday.com, automating operations, downloading data, and more.
-
Object-Relational Mapping (ORM) with Teamgate 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 Teamgate into a Java-based ORM framework, Hibernate.
-
Build Automated SAS xpt-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAS XPORT and build automated workflows in Zapier.
-
Query Live SAP Ariba Source 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 SAP Ariba Source directly from the development environment.
-
Integrate Goose with Live NetSuite SuiteAnalytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live NetSuite SuiteAnalytics from within the local AI agent.
-
Connect to Avro Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Avro to connect to Apache Avro and execute queries in PowerBuilder.
-
Build a Singer.io Tap for Pipedrive With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Pipedrive data using
-
Explore Geographical Relationships in Google Forms Data with Power Map
Create data visualizations with Google Forms in Power Map.
-
Edit and Search External GraphQL Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of GraphQL to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create GraphQL Data objects that you can access from apps and the dashboard.
-
Manage SAP Netweaver Gateway Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP Netweaver Gateway.
-
Create Reports with Drip Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Drip.
-
Connecting Mastra with Azure Synapse 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 Azure Synapse, no replication required.
-
How to publish and share Gumroad Data dashboards with Tableau Server
The CData ODBC driver for Gumroad enables you integrate Gumroad into Tableau dashboards.
-
Visualize Live ScrapingBee Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ScrapingBee.
-
Use the CData Software ODBC Driver for FreshBooks in MicroStrategy Web
Connect to FreshBooks in MicroStrategy Web using the CData Software ODBC Driver for FreshBooks.
-
How to Query Calendly Data in MySQL Workbench
Execute MySQL queries against live Calendly from MySQL Workbench.
-
Replicate Multiple Freshservice Accounts via the CData Sync CLI
Replicate multiple Freshservice accounts to one or many databases.
-
Build IBM Informix-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live IBM Informix and build IBM Informix-connected web apps with Axios.
-
Connect to Microsoft Teams Data from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Teams from HeidiSQL.
-
Use ChatGPT to Talk to Your QuickBooks Time 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 QuickBooks Time for you.
-
Replicate Multiple Wave Financial Accounts
Replicate multiple Wave Financial accounts to one or many databases.
-
How to Easily Query Google Campaign Manager 360 Data in OpenOffice Base
Connect to Google Campaign Manager 360 data in OpenOffice Base using the CData ODBC Driver for Google Campaign Manager 360 and generate reports with live data insights.
-
Automated Continuous Yelp Replication to Vertica
Use CData Sync for automated, continuous, customizable Yelp replication to Vertica.
-
Load Azure DevOps Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Azure DevOps to a database.
-
Build eBay Analytics-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for eBay Analytics to explore live eBay Analytics Data in Cursor to assist with building eBay Analytics-powered applications.
-
How to Connect Flowise AI Agents to Live Freshservice Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Freshservice without replication.
-
How to Seamlessly Import LaunchDarkly Data into IBM SPSS Modeler
Integrate LaunchDarkly data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build AI/ML Models with Live IBM Informix Data using Dataiku
Connect IBM Informix Data with Dataiku using the CData JDBC Driver for IBM Informix.
-
Work with Live SingleStore Data in Power Query
Use CData Connect AI to connect to SingleStore and work with live SingleStore in Microsoft Power Query.
-
Build Automated Xero-Connected Workflows in Zapier
Use CData Connect AI to connect to live Xero Accounting and build automated workflows in Zapier.
-
Getting Started with the CData Power BI Connector for Stripe
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Stripe.
-
Connect to Microsoft Ads from a Connection Pool in WebLogic
Use the CData JDBC Driver for Microsoft Ads to connect to Microsoft Ads from Web applications running on WebLogic.
-
Bind Live Dynamics NAV Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Dynamics NAV data
-
Use the CData Software ODBC Driver for HBase in MicroStrategy Desktop
Connect to Apache HBase in MicroStrategy Desktop using the CData Software ODBC Driver for HBase.
-
Getting Started with the CData ADO.NET Provider for Omnisend
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Use Azure AI Foundry to Talk to Your Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Freshdesk for you.
-
DataBind Controls to Bitbucket Data in C++Builder
DataBind to Bitbucket in C++Builder with standard components and controls.
-
Connect to Datadog Data in Jaspersoft Studio
Execute SQL to remote Datadog in Jaspersoft Studio.
-
Build Visualizations of Sage 300 Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Sage 300 in Birst.
-
Working with SAP Fieldglass Data in LINQPad
Execute LINQ queries to SAP Fieldglass in LINQPad.
-
Integrating Freshteam Data in Talend Cloud Data Management Platform
Connect Freshteam Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build Redshift-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Redshift Data from Zoho Analytics and import live Amazon Redshift.
-
Oracle Financials Cloud Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Oracle Financials Cloud facts in real time.
-
Migrating data from SFTP to Databricks using CData SSIS Components.
Easily push SFTP to Databricks using the CData SSIS Tasks for SFTP and Databricks.
-
Connect to Zoho CRM Data in NetBeans
Connect to Zoho CRM in NetBeans with the data source configuration wizard.
-
Connecting Mastra with Greenhouse 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 Greenhouse, no replication required.
-
Use the CData Software ODBC Driver for Neo4J in MicroStrategy Web
Connect to Neo4J in MicroStrategy Web using the CData Software ODBC Driver for Neo4J.
-
Getting Started with the CData ADO.NET Provider for PagerDuty
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to publish and share Outreach.io Data dashboards with Tableau Server
The CData ODBC driver for Outreach.io enables you integrate Outreach.io into Tableau dashboards.
-
Access Live Shopify Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Shopify data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to WordPress Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live WordPress.
-
Integrate with PDFMonkey Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy PDFMonkey to a JSON file on disk.
-
Bridge SAP Fieldglass Connectivity with Apache NiFi
Access and process SAP Fieldglass in Apache NiFi using the CData JDBC Driver.
-
Connect to Mouseflow in SpagoBI
Create reports featuring live Mouseflow in SpagoBI Studio. Host Mouseflow reports on SpagoBI Server.
-
Visualize Live Pipeliner CRM Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Pipeliner CRM using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Create Power BI Visual Reports with Real-Time Splunk Data
Use CData Power BI Connectors to visualize Splunk in Power BI.
-
Connecting Pipedream with SAP SuccessFactors Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on SAP SuccessFactors data in real time.
-
Integrate Placid Data in Pentaho Data Integration
Build ETL pipelines based on Placid in the Pentaho Data Integration tool.