CData Software - Knowledge Base
Recent Articles
-
Automated Azure Synapse Replication to Teradata
Use CData Sync to Customize and automate Azure Synapse replication to Teradata.
-
Automated Continuous Amazon Athena Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Amazon Redshift.
-
Bridge MongoDB Connectivity with Apache NiFi
Access and process MongoDB in Apache NiFi using the CData JDBC Driver.
-
Stream Greenplum into Apache Kafka Topics
Access and stream Pivotal GreenPlum in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Explore Geographical Relationships in SharePoint Excel Services with Power Map
Create data visualizations with SharePoint Excel Services in Power Map.
-
Integrate SharePoint Excel Services with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SharePoint Excel Services with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SharePoint Excel Services.
-
Access ClickUp from MySQL in PHP
Connect to ClickUp through the standard MySQL libraries in PHP.
-
Integrate Box with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Box with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Box.
-
Create Airtable-Connected Nintex Workflows
Use CData Connect AI to connect to Airtable from Nintex Workflow Cloud and build custom workflows using live Airtable.
-
How to create Highrise federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Highrise CRM in MySQL .
-
Create Power BI Reports on Real-Time Google Ad Manager
Use the CData ODBC Driver for Google Ad Manager to visualize Google Ad Manager in Power BI Desktop.
-
Create Zoho Inventory-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Zoho Inventory from OutSystems and build custom enterprise apps using live Zoho Inventory.
-
Connect to ShipStation from HeidiSQL
Use CData Connect AI to connect to and query live ShipStation from HeidiSQL.
-
Connecting Moonlit Workflow with Trello via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Trello in real time.
-
Connect to Live Epicor Kinetic in MicroStrategy through CData Connect AI
Create a live connection to Epicor Kinetic in CData Connect AI and connect to your Epicor Kinetic from MicroStrategy.
-
Using the CData Software ODBC Driver for Sage Intacct in PyCharm
Connect to Sage Intacct as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sage Intacct.
-
Connect to Live Sage Cloud Accounting in PostGresSQL Interface through CData Connect AI
Create a live connection to Sage Cloud Accounting in CData Connect AI and connect to your Sage Business Cloud Accounting from PostgreSQL.
-
Create Dashboards and Visualize Live Google Campaign Manager 360 in Geckoboard
Use CData Connect AI to connect to live Google Campaign Manager 360 and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live API within intelligent workflows.
-
Connect to Xero in Google Apps Script via Connect AI
Use CData Connect AI to access Xero Accounting in Google Apps Script.
-
Enable the Office 365 JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Office 365.
-
Analyze Live CockroachDB in SAS Viya
Use CData Connect AI to connect to CockroachDB from SAS Viya and deploy self-service analytics using live CockroachDB.
-
Migrating data from Salesloft to Snowflake using CData SSIS Components.
Easily push Salesloft to Snowflake using the CData SSIS Tasks for Salesloft and Snowflake.
-
Stream Confluence into Apache Kafka Topics
Access and stream Atlassian Confluence in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Publish Reports with FHIR in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date FHIR.
-
Build Automated Workflows with Live Act-On in Workato
Use CData Connect AI to connect to live Act-On and build automated workflows in Workato.
-
Connect to and Visualize Live Zoho Inventory in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Zoho Inventory.
-
Trigger Freshdesk IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Publish Reports with Bing Ads in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bing Ads.
-
Automated Continuous Oracle Financials Cloud Replication to Vertica
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Vertica.
-
How to publish and share Spark dashboards with Tableau Server
The CData ODBC driver for Spark enables you integrate Apache Spark SQL into Tableau dashboards.
-
Import Pipedrive into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Pipedrive. In this article, you will use the OData format to import Pipedrive into Microsoft Power Query.
-
Automated Continuous Outreach.io Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Outreach.io replication to IBM DB2.
-
Analyze Live Odoo in SAS Viya
Use CData Connect AI to connect to Odoo ERP from SAS Viya and deploy self-service analytics using live Odoo ERP.
-
How to Query Live Pipedrive Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Pipedrive data in natural language using Python.
-
How to create an RPA flow for ClickUp in UiPath Studio
Use the ClickUp ODBC Driver to create workflows that access real-time ClickUp without any coding.
-
Configure the CData JDBC Driver for Aha in a Connection Pool in Tomcat
Connect to Aha! from a connection pool in Tomcat.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAS Data Sets
Provide connectivity to SAS Data Sets through an SAP BusinessObjects universe.
-
Integrating LangGraph with BigQuery via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google BigQuery within automated workflows.
-
Automate BambooHR Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live BambooHR and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Work with SQL Analysis Services in AWS Glue Jobs Using JDBC
Connect to SQL Analysis Services from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous HubSpot Replication to SQL Server
Use CData Sync for automated, continuous, customizable HubSpot replication to SQL Server.
-
Connect to Azure Analysis Services from Asprova with CData Software ODBC Driver for Azure Analysis Services
This article shows how to connect faster to Azure Analysis Services data from Asprova.
-
Automated Continuous Oracle Sales Replication to MySQL
Use CData Sync for automated, continuous, customizable Oracle Sales replication to MySQL.
-
Connect to Paylocity in Google Apps Script via Connect AI
Use CData Connect AI to access Paylocity in Google Apps Script.
-
Connect to Spark from HeidiSQL
Use CData Connect AI to connect to and query live Apache Spark SQL from HeidiSQL.
-
Manage Quickbase in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Quickbase.
-
Build MySQL-Connected Apps in Choreo
Use CData Connect AI to connect to MySQL from Choreo and build custom apps using live MySQL.
-
Connect to and Visualize Live Oracle HCM Cloud in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Oracle HCM Cloud.
-
Work with Live Confluence in Power Query
Use CData Connect AI to connect to Atlassian Confluence and work with live Atlassian Confluence in Microsoft Power Query.
-
Migrating data from LinkedIn to Google BigQuery using CData SSIS Components.
Easily push LinkedIn to Google BigQuery using the CData SSIS Tasks for LinkedIn and Google BigQuery.
-
Build a Singer.io Tap for Jira Assets With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Jira Assets data using
-
Automated Continuous Shopify Replication to MongoDB
Use CData Sync for automated, continuous, customizable Shopify replication to MongoDB.
-
Connecting Mastra with Azure Table 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 data across 300+ enterprise sources no replication required.
-
Query Sybase IQ as a MySQL Database in Node.js
Execute MySQL queries against Sybase IQ from Node.js.
-
Connect to Act-On in JRuby
Create a simple JRuby app with access to live Act-On.
-
Object-Relational Mapping (ORM) with Adobe Commerce 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 Adobe Commerce into a Java-based ORM framework, Hibernate.
-
Connect to Amazon Marketplace in Jaspersoft Studio
Execute SQL to remote Amazon Marketplace in Jaspersoft Studio.
-
Object-Relational Mapping (ORM) with Phoenix 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 Apache Phoenix into a Java-based ORM framework, Hibernate.
-
Access Sage Cloud Accounting as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sage Business Cloud Accounting from your Oracle system.
-
Integrate GitHub in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live GitHub from Informatica Cloud.
-
Visualize Live Vault CRM in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Veeva Vault & Vault CRM.
-
Creating Google Spanner-Connected Applications in Unqork
You can use CData Connect AI to feed Google Spanner to Unqork and build custom business apps.
-
Build Automated Workflows with Live GraphQL in Workato
Use CData Connect AI to connect to live GraphQL and build automated workflows in Workato.
-
Enable the FHIR JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with FHIR.
-
How to connect SharePoint with Dynamics CRM through external lists
Provide Microsoft Dynamics CRM to SharePoint users as an external list.
-
Build Dashboards with Dynamics 365 Business Central in DBxtra
Create dynamic dashboards and perform analytics based on Dynamics 365 Business Central in DBxtra.
-
Query Redis using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Redis entities in PHP by modeling them as objects.
-
Automated Continuous Outreach.io Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Outreach.io replication to OneLake in Microsoft Fabric.
-
Automated Continuous Google Contacts Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Contacts replication to IBM DB2.
-
Query QuickBooks Online through ODBC in Node.js
Use node-odbc to execute SQL queries against QuickBooks Online from Node.js.
-
Analyze XML in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze XML Files in Microsoft R Open.
-
SurveyMonkey Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SurveyMonkey facts in real time.
-
Import Act CRM into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Act CRM. In this article, you will use the OData format to import Act CRM into Microsoft Power Query.
-
Create Dashboards and Visualize Live Sage 200 in Geckoboard
Use CData Connect AI to connect to live Sage 200 and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access Live JDBC-ODBC Bridge in TIBCO Data Virtualization
-