CData Software - Knowledge Base
Recent Articles
-
Work with Hive in FoxPro
Load Apache Hive into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to publish and share SingleStore dashboards with Tableau Server
The CData ODBC driver for SingleStore enables you integrate SingleStore into Tableau dashboards.
-
Model, Search, and Visualize Live MongoDB in ThoughtSpot
Use CData Connect AI to connect to live MongoDB for modeling, searching, and visualizing.
-
Replicate Multiple Presto Accounts
Replicate multiple Presto accounts to one or many databases.
-
Automated Continuous Oracle Sales Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Oracle Sales replication to PostgreSQL.
-
How to connect PolyBase to Sybase
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Sybase.
-
How to connect Amazon QuickSight to Microsoft Exchange
Create a connection to Microsoft Exchange in CData Connect AI and insert Microsoft Exchange into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Query Live Redis in Claude Desktop
Connect to and query live Redis in Claude Desktop using the CData MCP Server.
-
Connect to Oracle Sales in NetBeans
Connect to Oracle Sales in NetBeans with the data source configuration wizard.
-
Create Dynamic Aha Grids Using the Infragistics XamDataGrid
Learn how you can connect Aha to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Salesforce Marketing Replication to Databricks
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Databricks.
-
DataBind Controls to Redshift in C++Builder
DataBind to Amazon Redshift in C++Builder with standard components and controls.
-
How to connect PolyBase to Lakebase
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Lakebase.
-
Integrating Boomi Agentstudio with Oracle Financials Cloud via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Oracle Financials Cloud, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
View Reports on Real-Time Reckon Accounts Hosted in Power BI Report Server
Use the CData ODBC Driver for Reckon Accounts Hosted to visualize Reckon Accounts Hosted in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize EnterpriseDB in Tableau
The CData ODBC driver for EnterpriseDB enables you integrate EnterpriseDB into Tableau dashboards.
-
Access Oracle Eloqua Reporting from MySQL in PHP
Connect to Oracle Eloqua Reporting through the standard MySQL libraries in PHP.
-
Analyze IBM Informix in Infragistics Reveal
Use the CData API Server to create an OData API on top of IBM Informix and visualize live IBM Informix in Infragistics Reveal.
-
Build Office 365-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Office 365.
-
Integrate Workday in Pentaho Data Integration
Build ETL pipelines based on Workday in the Pentaho Data Integration tool.
-
How to Query Live Odoo in Claude Desktop
Connect to and query live Odoo in Claude Desktop using the CData MCP Server.
-
How to connect to JSON Services from IntelliJ
Integrate connectivity to JSON with wizards in IntelliJ.
-
Connect to and Query Azure Data Catalog in QlikView over ODBC
Create data visualizations with Azure Data Catalog in QlikView.
-
Connect to Twilio from PowerBuilder via ADO.NET
This article demonstrates how to access Twilio from Appeon PowerBuilder using the CData ADO.NET Provider for Twilio.
-
Add Invoiced to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Invoiced with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create Freshdesk-Connected Applications in Appsmith
Connect to Freshdesk via CData Connect AI in Appsmith and create custom business applications with real-time access to Freshdesk.
-
Connect to Jira Service Management in ACL Analytics
Connect to Atlassian Jira Service Management via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Atlassian Jira Service Management.
-
Create Informatica Mappings From/To an ODBC Data Source for Microsoft Exchange
Create an ODBC connection to Microsoft Exchange in Informatica and browse and transfer Microsoft Exchange.
-
Access Live PingOne in AWS Lambda
Connect to live PingOne in AWS Lambda using the CData JDBC Driver.
-
Integrate BigCommerce with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate BigCommerce with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to BigCommerce.
-
How to Access Zoom Using Entity Framework
This article shows how to access Zoom using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Dashboards with Microsoft Dataverse in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft Dataverse (CDS) in DBxtra.
-
How to Design Presto Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
How to Visualize HubSpot Data in Python with pandas
Use pandas and other modules to analyze and visualize live HubSpot in Python.
-
Natively Connect to Exact Online in PHP
The CData ODBC driver for Exact Online enables you to create PHP applications with connectivity to Exact Online. Leverage the native support for ODBC in PHP.
-
Analyze Bitbucket with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Bitbucket from Power Pivot. You will use the Table Import Wizard to load Bitbucket. You can visually build the import query or use any SQL supported by the driver.
-
Seamlessly Bring Dynamics 365 into Retool Using CData Connect AI
Integrate Dynamics 365 data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous Wave Financial Replication to MongoDB
Use CData Sync for automated, continuous, customizable Wave Financial replication to MongoDB.
-
Connect to Adobe Analytics in RapidMiner
Integrate Adobe Analytics with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate with Reckon using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Reckon to a JSON file on disk.
-
Integrate Live Salesforce Marketing into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Salesforce Marketing from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Salesforce Marketing Cloud.
-
DataBind Controls to RSS Feeds in Delphi
DataBind to RSS Feeds in Delphi with standard data access components and controls.
-
Automate Zoho Books Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Zoho Books from PowerShell? This article demonstrates how to utilize the Zoho Books Cmdlets for tasks like connecting to Zoho Books, automating operations, downloading data, and more.
-
How to Query Live Basecamp in Claude Desktop
Connect to and query live Basecamp in Claude Desktop using the CData MCP Server.
-
Integrate with live Google Campaign Manager 360 in Jitterbit
Use CData Connect AI to connect to and integrate live Google Campaign Manager 360 in Jitterbit.
-
Use CData Connect AI to Access Jira Service Management in Microsoft Power Pivot
Use CData Connect AI to connect to live Atlassian Jira Service Management in the Power Pivot business intelligence tool.
-
Connect to Live Exact Online in MicroStrategy through CData Connect AI
Create a live connection to Exact Online in CData Connect AI and connect to your Exact Online from MicroStrategy.
-
Visualize Live SAP HANA XS Advanced of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP HANA XS Advanced using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to LinkedIn Ads in RazorSQL
Connect to LinkedIn Ads from wizards and query LinkedIn Ads from the GUI in the RazorSQL database management tool.
-
Create Kintone-Connected Dashboards in Grafana
Connect to Kintone via CData Connect AI in Grafana and create custom business dashboards with real-time access to Kintone.
-
Automated Continuous Shopify Replication to SQL Server
Use CData Sync for automated, continuous, customizable Shopify replication to SQL Server.
-
Write a Simple Go Application to work with Dynamics CRM on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Dynamics CRM.
-
Create Oracle HCM Cloud-Connected Business Apps in AppSheet
Connect to Oracle HCM Cloud via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Oracle HCM Cloud.
-
Automated Continuous Microsoft OneLake Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to delimited files (CSV/TSV).
-
Create Redis Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate with Odoo in SnapLogic
Use CData Connect AI to connect to and integrate with live Odoo ERP in SnapLogic.
-
Connect to Bullhorn CRM in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Bullhorn CRM and connect to Bullhorn CRM in Akorbi Digital RunMyProcess.
-
How to connect Amazon QuickSight to Redis
Create a connection to Redis in CData Connect AI and insert Redis into Amazon QuickSight SPICE to build interactive dashboards.
-
Use the CData Software ODBC Driver for HubDB in SAS for Real-Time Reporting and Analytics
Connect to real-time HubDB in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for HubDB.
-
Getting Started with the CData ODBC Driver for Gmail
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Gmail.
-
Object-Relational Mapping (ORM) with Bing Ads 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 Bing Ads into a Java-based ORM framework, Hibernate.
-
ETL Amazon Athena in Oracle Data Integrator
This article shows how to transfer Amazon Athena into a data warehouse using Oracle Data Integrator.
-
How to connect to ShipStation from IntelliJ
Integrate connectivity to ShipStation with wizards in IntelliJ.
-
Analyze PostgreSQL in Infragistics Reveal
Use CData Connect AI to create on OData API on top of PostgreSQL and visualize live PostgreSQL in Infragistics Reveal.
-
Natively Connect to Odoo in PHP
The CData ODBC driver for Odoo enables you to create PHP applications with connectivity to Odoo ERP. Leverage the native support for ODBC in PHP.
-
Bind Live Redshift Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Redshift data
-
Integrate with Tableau CRM Analytics in SnapLogic
Use CData Connect AI to connect to and integrate with live Tableau CRM Analytics in SnapLogic.
-
Analyze Azure Data Catalog with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Azure Data Catalog from Power Pivot. You will use the Table Import Wizard to load Azure Data Catalog. You can visually build the import query or use any SQL supported by the driver.
-
A PostgreSQL Interface for Google Analytics using the CData ODBC Driver
Use the SQL Gateway and Google Analytics ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Certinia in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Certinia into TIBCO Spotfire.
-
Edit and Search External API Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of API to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create API objects that you can access from apps and the dashboard.
-
Use the CData Software JDBC Driver for Google Data Catalog in MicroStrategy Desktop
Connect to Google Data Catalog in MicroStrategy Desktop using the CData Software JDBC Driver for Google Data Catalog.
-
How to connect to Google Ad Manager from Spring Boot
Connect to Google Ad Manager in a Spring Boot Application using CData JDBC Google Ad Manager Driver
-
Automated Continuous CouchDB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable CouchDB replication to IBM DB2.
-
How to connect to FTP in DBVisualizer
Integrate FTP Servers with visual data analysis tools and data connection wizards in DBVisualizer
-
Validate CouchDB with QuerySurge
Access and validate Apache CouchDB in QuerySurge using the CData JDBC Driver.
-
Automated Continuous MariaDB Replication to SQL Server
Use CData Sync for automated, continuous, customizable MariaDB replication to SQL Server.
-
Connect to Real-Time Harvest Data in Power Apps Using Dataflows to Build Custom Applications
-