CData Software - Knowledge Base
Recent Articles
-
Access Live Aha! in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Aha! into the statistical analysis tools available in SAS JMP. This article shows how to use Aha! in the Graph Builder and Query Builder.
-
Build Semantic Layer Views for Oracle HCM Cloud in APOS Live Data Gateway
Use the CData Connector for Oracle HCM Cloud in APOS Live Data Gateway to build Semantic Layer Views for Oracle HCM Cloud.
-
Create Dashboards and Visualize Live WordPress in Geckoboard
Use CData Connect AI to connect to live WordPress and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use the CData Software JDBC Driver for Microsoft Dataverse in MicroStrategy
Connect to Microsoft Dataverse (CDS) in MicroStrategy Developer using the CData Software JDBC Driver for Microsoft Dataverse.
-
Analyze Zoho Projects with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zoho Projects from Power Pivot. You will use the Table Import Wizard to load Zoho Projects. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData Software JDBC Driver for HarperDB in MicroStrategy Desktop
Connect to HarperDB in MicroStrategy Desktop using the CData Software JDBC Driver for HarperDB.
-
Access Dynamics CRM from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Dynamics CRM from HeidiSQL.
-
Use Claude to Talk to Your Lakebase via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Lakebase for you.
-
Build Cloudant-Connected Apps in Choreo
Use CData Connect AI to connect to Cloudant from Choreo and build custom apps using live IBM Cloudant.
-
Access Live Gmail in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Gmail from your Excel spreadsheets.
-
DataBind Controls to Google Calendar in C++Builder
DataBind to Google Calendar in C++Builder with standard components and controls.
-
Build Box-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Box and build web apps with connectivity to live Box.
-
Import Freshdesk into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Freshdesk. In this article, you will use the OData format to import Freshdesk into Microsoft Power Query.
-
How to Connect to & Open Zendesk in Microsoft Excel
This article uses the CData ODBC driver for Zendesk to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Feed Vault CRM into FineReport
How to set Veeva Vault & Vault CRM as a JDBC data source in FineReport.
-
How to use SQLAlchemy ORM to access Twilio in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Twilio.
-
Connect to SendGrid from PowerBuilder via ADO.NET
This article demonstrates how to access SendGrid from Appeon PowerBuilder using the CData ADO.NET Provider for SendGrid.
-
Connect to SAP HANA as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP HANA as an External Source in Dremio.
-
Consume Twilio OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Twilio feeds that reflect any changes in SAP Lumira.
-
Create ADP-Connected Dashboards in Grafana
Connect to ADP via CData Connect AI in Grafana and create custom business dashboards with real-time access to ADP.
-
Visualize Live SAP ByDesign in the Power BI Service
Use CData Connect AI to connect to live SAP Business ByDesign and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Xero from a Connection Pool in WebLogic
Use the CData JDBC Driver for Xero to connect to Xero Accounting from Web applications running on WebLogic.
-
ETL Stripe in Oracle Data Integrator
This article shows how to transfer Stripe into a data warehouse using Oracle Data Integrator.
-
Create Google Campaign Manager 360-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Google Campaign Manager 360 from Klipfolio and build custom visualizations using live Google Campaign Manager 360.
-
How to connect to Pipedrive from IntelliJ
Integrate connectivity to Pipedrive with wizards in IntelliJ.
-
Integrate Real-Time Access to Vault CRM in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Veeva Vault & Vault CRM in real time.
-
How to Seamlessly Import Jira Data into IBM SPSS Modeler
Integrate Jira data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize Act CRM from Tableau
Use the Tableau Desktop business intelligence tool to connect to Act CRM.
-
Feed Box into FineReport
How to set Box as a JDBC data source in FineReport.
-
Add Slack to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Slack with the Informatica Enterprise Data Catalog to classify and organize data.
-
Visualize Dynamics CRM in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Microsoft Dynamics CRM into TIBCO Spotfire.
-
How to publish and share Zendesk dashboards with Tableau Server
The CData ODBC driver for Zendesk enables you integrate Zendesk into Tableau dashboards.
-
How to create Visio diagrams from HubSpot
Automatically update HubSpot with the changes you make to Visio master shapes.
-
Automate GitHub Replication to SAP HANA
Use CData Sync to customize and automate GitHub replication to SAP HANA.
-
Build Visualizations of MySQL in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of MySQL in Birst.
-
How to Connect to Highrise in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Highrise CRM. Leverage the pyodbc module for ODBC in Python.
-
Natively Connect to Amazon DynamoDB in PHP
The CData ODBC driver for Amazon DynamoDB enables you to create PHP applications with connectivity to Amazon DynamoDB. Leverage the native support for ODBC in PHP.
-
Connect to Sugar CRM as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Sugar CRM.
-
How to create MongoDB federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for MongoDB in MySQL .
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Microsoft OneDrive
Provide connectivity to Microsoft OneDrive through an SAP BusinessObjects universe.
-
Integrate Live Drift into Blue Prism for Intelligent Robotic Process Automation (RPA)
-