CData Software - Knowledge Base
Recent Articles
-
Build PostgreSQL-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live PostgreSQL.
-
Visualize Spark in TIBCO Spotfire through OData
Integrate Apache Spark SQL into dashboards in TIBCO Spotfire.
-
Automated Continuous QuickBooks Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable QuickBooks replication to Azure SQL Database.
-
Load Excel to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Excel to a database.
-
Object-Relational Mapping (ORM) with Amazon DynamoDB 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 Amazon DynamoDB into a Java-based ORM framework, Hibernate.
-
Replicate Multiple Unbounce Accounts
Replicate multiple Unbounce accounts to one or many databases.
-
Use the CData Software ODBC Driver for PayPal in MicroStrategy
Connect to PayPal in MicroStrategy Developer using the CData Software ODBC Driver for PayPal.
-
Integrate Zuora in the Pentaho Report Designer
Publish reports based on Zuora in the Pentaho BI tool.
-
Design BIRT Reports on BigQuery
Provide current Google BigQuery to your embedded analytics.
-
Use CData Connect AI to Access Impala in Microsoft Power Pivot
Use CData Connect AI to connect to live Apache Impala in the Power Pivot business intelligence tool.
-
Build an OLAP Cube in SSAS from Azure Synapse
Establish a connection to Azure Synapse data from SQL Server Analysis Services, and use the Azure Synapse Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect SAP Ariba Source to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP Ariba Source using the CData Python MCP Server.
-
How to Query Live Odoo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Odoo ERP data in natural language using Python.
-
Build Dashboards with SAP ByDesign in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Business ByDesign in Dundas BI.
-
Stream PostgreSQL into Apache Kafka Topics
Access and stream PostgreSQL in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Setup Routines Could not be Loaded Error Code 126
This error signifies that certain Visual C++ runtimes are missing on your machine.
-
Connect to Epicor Kinetic from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Epicor Kinetic from Filemaker Pro on Mac.
-
Automated Continuous Salesforce Marketing Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Salesforce Marketing Cloud replication to OneLake in Microsoft Fabric.
-
Build Agents in Relevance AI with Access to Live HubSpot via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on HubSpot within intelligent agent workflows.
-
Access Live Oracle Service Cloud in Coginiti Pro
Connect to and query live Oracle Service Cloud from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect the Power BI Service to Quickbase: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Write a Simple Go Application to work with Parquet on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Apache Parquet.
-
Publish Epicor Kinetic-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Epicor Kinetic.
-
Choosing the Best Method to Connect Facebook Ads to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Facebook Ads from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Natively Connect to Sage Cloud Accounting in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Sage Business Cloud Accounting. Leverage the native support for ODBC in PHP.
-
Analyze Microsoft OneDrive in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft OneDrive with the CData JDBC Driver for Microsoft OneDrive.
-
Analyze Salesforce Marketing in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Salesforce Marketing Cloud and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Create a Data Access Object for Couchbase using JDBI
A brief overview of creating a SQL Object API for Couchbase in JDBI.
-
How to Query Live Shopify in Perplexity MacOS Desktop
Connect to and query live Shopify in Perplexity Desktop using CData Code Assist MCP.
-
Build Data Flows from eBay to SQL Server using SSIS
Easily back up eBay to SQL Server using the SSIS components for eBay.
-
Explore Geographical Relationships in Databricks with Power Map
Create data visualizations with Databricks in Power Map.
-
Use Microsoft Copilot Studio to talk to your eBay 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 eBay for you.
-
How to connect and process MySQL from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live MySQL.
-
How to create an RPA flow for Epicor Kinetic in UiPath Studio
Use the Epicor Kinetic ODBC Driver to create workflows that access real-time Epicor Kinetic without any coding.
-
Build Data Flows from PingOne to SQL Server using SSIS
Easily back up PingOne to SQL Server using the SSIS components for PingOne.
-
Automate Bullhorn CRM Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Bullhorn CRM and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Work with SAP Ariba Procurement in FoxPro
Load SAP Ariba Procurement into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData JDBC Driver for Sybase
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Sybase.
-
Connecting Agentforce with Oracle Service Cloud 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 Oracle Service Cloud for you.
-
Integrating LangGraph with Airtable via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Airtable within automated workflows.
-
Integrating Stripe in Talend Cloud Data Management Platform
-