CData Software - Knowledge Base
Recent Articles
-
Object-Relational Mapping (ORM) with Redshift 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 Redshift into a Java-based ORM framework, Hibernate.
-
Connect Adobe Target to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Adobe Target with IBM WebSphere for seamless data integration and connectivity.
-
How to Seamlessly Import Salesloft Data into IBM SPSS Modeler
Integrate Salesloft data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate with Xero in SnapLogic
Use CData Connect AI to connect to and integrate with live Xero Accounting in SnapLogic.
-
Access Live Tally in AWS Lambda (with IntelliJ IDEA)
Connect to live Tally ERP in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to YouTube Analytics from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for YouTube Analytics to connect to YouTube Analytics and execute queries in PowerBuilder.
-
Replicate Sybase to Multiple Databases via the CData Sync CLI
Replicate Sybase to disparate databases with a single configuration.
-
Create Informatica Mappings From/To a JDBC Data Source for Microsoft Project
Create Microsoft Project data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Query Live SAP Fieldglass Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP Fieldglass data in natural language using Python.
-
How to Connect DBeaver to Teradata via a JDBC Driver
Manage Teradata with visual tools in DBeaver like the query browser.
-
How to use SQLAlchemy ORM to access Office 365 in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Office 365.
-
Access Live FTP Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live FTP data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Design Zoho Projects Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Use JayDeBeApi to access Google Ads in Python
Use standard Python scripting and the development environment of your choice to access live Google Ads.
-
Connect Drip to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Drip with IBM WebSphere for seamless data integration and connectivity.
-
Import Real-Time Bullhorn CRM via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Bullhorn CRM in ColdFusion.
-
Enable the Oracle HCM Cloud JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Oracle HCM Cloud.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Apache Impala to Power BI dashboards. Simply drag and drop Apache Impala into data visuals on the Power BI canvas.
-
How to Query Live Google Analytics in Claude Desktop
Connect to and query live Google Analytics in Claude Desktop using CData Code Assist MCP.
-
How to Visualize Dropbox Data in Python with pandas
Use pandas and other modules to analyze and visualize live Dropbox in Python.
-
Migrating data from Phoenix to Google BigQuery using CData SSIS Components.
Easily push Apache Phoenix to Google BigQuery using the CData SSIS Tasks for Phoenix and Google BigQuery.
-
How to work with Amazon DynamoDB in Apache Spark using SQL
Access and process Amazon DynamoDB in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to Live AlloyDB from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Google AlloyDB for you.
-
Connect to Epicor Kinetic in CloverDX (formerly CloverETL)
Transfer Epicor Kinetic using the visual workflow in the CloverDX data integration tool.
-
Build Semantic Layer Views for Drift in APOS Live Data Gateway
Use the CData Connector for Drift in APOS Live Data Gateway to build Semantic Layer Views for Drift.
-
How to Seamlessly Import Unbounce Data into IBM SPSS Modeler
Integrate Unbounce data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Natively Connect to SAP Fieldglass in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAP Fieldglass. Leverage the native support for ODBC in PHP.
-
Excel Spreadsheet Automation on LinkedIn Ads with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
How to connect to MongoDB in DBVisualizer
Integrate MongoDB with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Reports from Dynamics CRM in Looker Studio
Use CData Connect AI to gain access to live Microsoft Dynamics CRM and create custom reports in Looker Studio.
-
DataBind Controls to SuiteCRM in Delphi
DataBind to SuiteCRM in Delphi with standard data access components and controls.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Pipedrive
Provide connectivity to Pipedrive through an SAP BusinessObjects universe.
-
How to Connect to Live Paylocity from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Paylocity through natural language.
-
Build a PostgreSQL Interface for HubSpot using the CData JDBC Driver
Use the Remoting features of the HubSpot JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect PolyBase to SAP Netweaver Gateway
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP Netweaver Gateway.
-
Connect to Zoho Inventory from Asprova with CData Software ODBC Driver for Zoho Inventory
This article shows how to connect faster to Zoho Inventory data from Asprova.
-
Analyze IBM Informix in R via JDBC
Use standard R functions and the development environment of your choice to analyze IBM Informix with the CData JDBC Driver for IBM Informix.
-
Create Microsoft Dataverse-Connected Business Apps in AppSheet
Connect to Microsoft Dataverse via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft Dataverse (CDS).
-
Build Apps with Live Excel Using the Low-Code Development Platform of Mendix
-