CData Software - Knowledge Base
Recent Articles
-
Connect to Oracle Service Cloud in SpagoBI
Create reports featuring live Oracle Service Cloud in SpagoBI Studio. Host Oracle Service Cloud reports on SpagoBI Server.
-
ETL Printful in Oracle Data Integrator
This article shows how to transfer Printful into a data warehouse using Oracle Data Integrator.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live eBay within intelligent workflows.
-
Create a Data Access Object for HubDB using JDBI
A brief overview of creating a SQL Object API for HubDB in JDBI.
-
How to Connect Flowise AI Agents to Live Redshift via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
Connect to Microsoft Teams from PowerBuilder via JDBC
This article demonstrates how to access Microsoft Teams from PowerBuilder using the Microsoft Teams JDBC Driver.
-
Natively Connect to SAP Hybris C4C in PHP
The CData ODBC driver for SAP Hybris C4C enables you to create PHP applications with connectivity to SAP Hybris C4C. Leverage the native support for ODBC in PHP.
-
Connect to PingOne from Asprova with CData Software ODBC Driver for PingOne
This article shows how to connect faster to PingOne data from Asprova.
-
Query PingOne in ColdFusion
Write standard ColdFusion data access code to connect to PingOne.
-
Automate HDFS Replication to Azure Data Lake
Use CData Sync to customize and automate Apache HDFS replication to Azure Data Lake.
-
PostgreSQL Reporting in OBIEE with the PostgreSQL JDBC Driver
Deploy the PostgreSQL JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Live Workday in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Workday from your Google Sheets.
-
Migrating data from LDAP to Databricks using CData SSIS Components.
Easily push LDAP to Databricks using the CData SSIS Tasks for LDAP and Databricks.
-
How to use SQLAlchemy ORM to access Microsoft Project in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Project.
-
Connect to MailChimp as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for MailChimp.
-
How to Connect to TaxJar in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to TaxJar. Leverage the pyodbc module for ODBC in Python.
-
Visualize Printful in TIBCO Spotfire through OData
Integrate Printful into dashboards in TIBCO Spotfire.
-
Connect to Typeform from a Connection Pool in WebLogic
Use the CData JDBC Driver for Typeform to connect to Typeform from Web applications running on WebLogic.
-
Consume Google Directory OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Directory feeds that reflect any changes in SAP Lumira.
-
Visualize Klipfolio in Tableau
The CData ODBC driver for Klipfolio enables you integrate Klipfolio into Tableau dashboards.
-
How to connect to Oracle HCM Cloud with Squirrel SQL client
Connect to Oracle HCM Cloud and execute queries in the Squirrel SQL Client.
-
Publish Crystal Reports on Highrise
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Highrise CRM.
-
How to Connect DBeaver to Salesforce Data Cloud via a JDBC Driver
Manage Salesforce Data Cloud with visual tools in DBeaver like the query browser.
-
Create SSAS Tabular Models from Basecamp
How to build a SQL Server Analysis Service Tabular Model from Basecamp using CData drivers.
-
Import Real-Time Exact Online via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Exact Online in ColdFusion.
-
Natively Connect to Oracle in PHP
The CData ODBC driver for Oracle enables you to create PHP applications with connectivity to Oracle Database. Leverage the native support for ODBC in PHP.
-
Connect to eBay Analytics from a Connection Pool in Jetty
The eBay Analytics JDBC Driver supports connection pooling: This article shows how to connect faster to eBay Analytics from Web apps in Jetty.
-
How to Connect DBeaver to PingOne via a JDBC Driver
Manage PingOne with visual tools in DBeaver like the query browser.
-
Installation Guide: CData MCP Servers (Google Sheets)
Learn how to install a CData MCP Server (Google Sheets) and connect to live data from Claude.
-
Create SSAS Tabular Models from JotForm
How to build a SQL Server Analysis Service Tabular Model from JotForm using CData drivers.
-
How to Create Power BI Visual Reports with Real-Time Google Ad Manager
Use CData Power BI Connectors to visualize Google Ad Manager in Power BI.
-
Connect to and Visualize Live Twitter in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Twitter.
-
How to connect to Google Contacts from Spring Boot
Connect to Google Contacts in a Spring Boot Application using CData JDBC Google Contacts Driver
-
Visualize Live WordPress in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live WordPress.
-
Getting Started with the CData Excel Add-In for Invoiced
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Invoiced.
-
Object-Relational Mapping (ORM) with Salesforce 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 Salesforce & Force.com into a Java-based ORM framework, Hibernate.
-
Connect to ClickUp from PowerBuilder via JDBC
This article demonstrates how to access ClickUp from PowerBuilder using the ClickUp JDBC Driver.
-
Back Up FHIR to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for FHIR. In this article, we will employ an SSIS workflow to populate a database with FHIR data.
-
How to Seamlessly Import SAP Data into IBM SPSS Modeler
Integrate SAP data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Printful with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Printful with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Printful.
-
Connect to QuickBooks Time in the Denodo Platform
Use CData driver technologies to create a virtual data source for QuickBooks Time in the Denodo Virtual DataPort Administrator.
-
Build Semantic Layer Views for Unbounce in APOS Live Data Gateway
Use the CData Connector for Unbounce in APOS Live Data Gateway to build Semantic Layer Views for Unbounce.
-
How to Seamlessly Import Okta Data into IBM SPSS Modeler
Integrate Okta data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to and Query BigQuery in QlikView over ODBC
Create data visualizations with Google BigQuery in QlikView.
-
Create Data Visualizations in Cognos BI with Printful
Access Printful as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Live LinkedIn Ads in MicroStrategy through CData Connect AI
Create a live connection to LinkedIn Ads in CData Connect AI and connect to your LinkedIn Ads from MicroStrategy.
-
Access Live MongoDB in Coginiti Pro
Connect to and query live MongoDB from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to MailChimp from Asprova with CData Software ODBC Driver for MailChimp
This article shows how to connect faster to MailChimp data from Asprova.
-
Query Act-On from Node.js
Use the OData endpoint of the CData API Server to connect to your Act-On and perform CRUD operations on Act-On from Node.js.
-
Getting Started with the CData Excel Add-In for Sage 300
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Sage 300.
-
Integrate with Oracle SCM in SnapLogic
Use CData Connect AI to connect to and integrate with live Oracle SCM in SnapLogic.
-
How to Connect to Live Sage Cloud Accounting from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Sage Business Cloud Accounting for you.
-
Build Data Flows from SQL Server to Tableau CRM Analytics through SSIS
Easily push SQL Server data to Tableau CRM Analytics using the CData SSIS Tasks for Tableau CRM Analytics.
-
Automated Continuous Salesloft Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Salesloft replication to Azure SQL Database.
-
Build Apps with Live Microsoft Project in Adalo using CData Connect AI
Use CData Connect AI to integrate live Microsoft Project into the Adalo platform and build custom mobile and web applications with real-time Microsoft Project.
-
Connect to and Visualize Live Bullhorn CRM in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Bullhorn CRM.
-
Create Power BI Reports on Real-Time Quickbase
Use the CData ODBC Driver for Quickbase to visualize Quickbase in Power BI Desktop.
-
Build Pipelines with Live Oracle Financials Cloud in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Oracle Financials Cloud from Google Cloud Data Fusion, enabling the integration of live Oracle Financials Cloud into the building and management of effective data pipelines.
-
Automate Basecamp Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Basecamp and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Using the CData Software ODBC Driver for SAP Ariba Source in PyCharm
Connect to SAP Ariba Source as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP Ariba Source.
-
How to publish and share Clio dashboards with Tableau Server
The CData ODBC driver for Clio enables you integrate Clio into Tableau dashboards.
-
Connect to and Visualize Live Sage 50 UK in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sage 50 UK.
-
Automate Excel Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Excel replication to Couchbase.
-
How to Connect to Live Adobe Commerce Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Adobe Commerce securely in real time.
-
Work with Tableau CRM Analytics in FoxPro
Load Tableau CRM Analytics into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use Dash to Build to Web Apps on Dynamics NAV
Create Python applications that use pandas and Dash to build Dynamics NAV-connected web apps.
-
Bridge HCL Domino Connectivity with Apache NiFi
Access and process HCL Domino in Apache NiFi using the CData JDBC Driver.
-
Connect to Microsoft Exchange in DBArtisan
Use wizards in DBArtisan to configure Microsoft Exchange as a data source.
-
Work with Live MongoDB in Power Query
Use CData Connect AI to connect to MongoDB and work with live MongoDB in Microsoft Power Query.
-
How to pipe WordPress to CSV in PowerShell
Use standard PowerShell cmdlets to access WordPress tables.
-
How to connect to Facebook in DBVisualizer
Integrate Facebook with visual data analysis tools and data connection wizards in DBVisualizer
-
How to integrate SAP SuccessFactors with Apache Airflow
Access and process SAP SuccessFactors in Apache Airflow using the CData JDBC Driver.
-
Connect to TigerGraph in Aqua Data Studio
Access TigerGraph from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Visualize Facebook Ads in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Facebook Ads into TIBCO Spotfire.
-
Build Google Calendar-Connected Apps in Choreo
Use CData Connect AI to connect to Google Calendar from Choreo and build custom apps using live Google Calendar.
-
Automate Cosmos DB Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Azure Cosmos DB and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Create Power BI Visual Reports with Real-Time Active Directory
Use CData Power BI Connectors to visualize Active Directory in Power BI.
-
How to load Azure DevOps data into Elasticsearch via Logstash
Introducing a simple method to load Azure DevOps data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Certinia from a Connection Pool in Jetty
The Certinia JDBC Driver supports connection pooling: This article shows how to connect faster to Certinia from Web apps in Jetty.
-
Connect to SQL Analysis Services in DBeaver
Use the CData ODBC Driver to connect to SQL Analysis Services in DBeaver.
-
Consume Salesloft OData Feeds in PowerBuilder
This article demonstrates how to consume Salesloft as OData feeds from PowerBuilder using the API Server.
-
Bind Live Tally Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Tally data
-
Integrate Sage 200 in the Pentaho Report Designer
Publish reports based on Sage 200 in the Pentaho BI tool.
-
Integrating Pipedrive in Talend Cloud Data Management Platform
-