CData Software - Knowledge Base
Recent Articles
-
Connect to Live MariaDB in MicroStrategy through CData Connect AI
Create a live connection to MariaDB in CData Connect AI and connect to your MariaDB from MicroStrategy.
-
Access Live SurveyMonkey in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SurveyMonkey into the statistical analysis tools available in SAS JMP. This article shows how to use SurveyMonkey in the Graph Builder and Query Builder.
-
How to connect to Epicor Kinetic from Spring Boot
Connect to Epicor Kinetic in a Spring Boot Application using CData JDBC Epicor Kinetic Driver
-
Connect to Snapchat Ads in Aqua Data Studio
Access Snapchat Ads from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate CSV in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live CSV/TSV Files from Informatica Cloud.
-
Visualize Live PostgreSQL in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live PostgreSQL.
-
Operational Reporting on Amazon Marketplace from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Amazon Marketplace.
-
Use the CData Software ODBC Driver for Impala in MicroStrategy
Connect to Apache Impala in MicroStrategy Developer using the CData Software ODBC Driver for Impala.
-
How to create Marketo federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Marketo in MySQL .
-
Rapidly Develop Parquet-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Connect to Hive from PowerBuilder via ADO.NET
This article demonstrates how to access Apache Hive from Appeon PowerBuilder using the CData ADO.NET Provider for Hive.
-
Integrating Dataiku with Sage Intacct via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Sage Intacct.
-
Natively Connect to Salesforce Marketing in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Salesforce Marketing Cloud. Leverage the native support for ODBC in PHP.
-
Connect to ActiveCampaign through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with ActiveCampaign using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Invoiced in Pentaho Data Integration
Build ETL pipelines based on Invoiced in the Pentaho Data Integration tool.
-
Connect to and Visualize Live Parquet in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apache Parquet.
-
Query Google Contacts using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Contacts entities in PHP by modeling them as objects.
-
DataBind Controls to Jira Service Management in C++Builder
DataBind to Atlassian Jira Service Management in C++Builder with standard components and controls.
-
How to connect SharePoint with QuickBooks Time through external lists
Provide QuickBooks Time to SharePoint users as an external list.
-
Visualize Power BI XMLA in Sisense
Create an ElastiCube in Sisense app with access to Power BI XMLA.
-
Build Sage 200-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Sage 200 and create custom apps in Bubble.
-
Operational Reporting on FHIR from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote FHIR.
-
Create PostgreSQL-Connected Applications in Appsmith
Connect to PostgreSQL via CData Connect AI in Appsmith and create custom business applications with real-time access to PostgreSQL.
-
Create SAP SuccessFactors Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect PolyBase to Reckon
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Reckon.
-
Automated Continuous Splunk Replication to Snowflake
Use CData Sync for automated, continuous, customizable Splunk replication to Snowflake.
-
Access Live MongoDB in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate MongoDB into the statistical analysis tools available in SAS JMP. This article shows how to use MongoDB in the Graph Builder and Query Builder.
-
Creating Sage Cloud Accounting-Connected Applications in Unqork
You can use CData Connect AI to feed Sage Business Cloud Accounting to Unqork and build custom business apps.
-
Add Google Sheets to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Sheets with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live Google Cloud Storage Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Google Cloud Storage data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build an OLAP Cube in SSAS from Dynamics 365
Establish a connection to Microsoft Dynamics 365 data from SQL Server Analysis Services, and use the Dynamics 365 Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Salesforce Pardot in Jaspersoft Studio
Execute SQL to remote Salesforce Pardot in Jaspersoft Studio.
-
How to Connect DBeaver to Elasticsearch via a JDBC Driver
Manage Elasticsearch with visual tools in DBeaver like the query browser.
-
Create SSAS Tabular Models from Certinia
How to build a SQL Server Analysis Service Tabular Model from Certinia using CData drivers.
-
Query SAP HANA from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP HANA and perform CRUD operations on SAP HANA from Node.js.
-
Use the CData Software ODBC Driver for SAP Business One in MicroStrategy Desktop
Connect to SAP Business One in MicroStrategy Desktop using the CData Software ODBC Driver for SAP Business One.
-
Connect to SAP Netweaver Gateway from Asprova with CData Software ODBC Driver for SAP Netweaver Gateway
This article shows how to connect faster to SAP Netweaver Gateway data from Asprova.
-
Automated Adobe Analytics Replication to Teradata
Use CData Sync to Customize and automate Adobe Analytics replication to Teradata.
-
Deploy the ADO.NET Provider for Elasticsearch on an SSRS Report Server
Connect to Elasticsearch from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Use the CData Software ODBC Driver for Greenhouse in MicroStrategy
Connect to Greenhouse in MicroStrategy Developer using the CData Software ODBC Driver for Greenhouse.
-
Replicate Excel Online to Multiple Databases
Replicate Microsoft Excel Online to disparate databases with a point-and-click configuration.
-
Connecting Agentforce with LinkedIn 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 LinkedIn for you.
-
How to create TaxJar federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for TaxJar in MySQL .
-
Import Real-Time SAS xpt via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAS XPORT in ColdFusion.
-
How to connect to Avalara AvaTax from Spring Boot
Connect to Avalara AvaTax in a Spring Boot Application using CData JDBC Avalara AvaTax Driver
-
Automated Continuous Jira Replication to SQL Server
Use CData Sync for automated, continuous, customizable Jira replication to SQL Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Microsoft Dataverse
Provide connectivity to Microsoft Dataverse (CDS) through an SAP BusinessObjects universe.
-
Connect to HarperDB as an External Source in Dremio
Use the CData JDBC Driver to connect to HarperDB as an External Source in Dremio.
-
Load HubSpot to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load HubSpot to a database.
-
Create Data Visualizations in Cognos BI with Exact Online
Access Exact Online as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Zoho Creator in CloverDX (formerly CloverETL)
Transfer Zoho Creator using the visual workflow in the CloverDX data integration tool.
-
Process & Analyze Trello in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Trello .
-
Connect to BambooHR from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for BambooHR to connect to BambooHR and execute queries in PowerBuilder.
-
Getting Started with the CData Power BI Connector for Salesforce
-