CData Software - Knowledge Base
Recent Articles
-
Connect to SAP Fieldglass Data in Ruby
Connect to SAP Fieldglass in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Oracle Eloqua from a Connection Pool in WebLogic
Use the CData JDBC Driver for Oracle Eloqua to connect to Oracle Eloqua from Web applications running on WebLogic.
-
Automate Marketo Data Replication to Azure Synapse
Use CData Sync to customize and automate Marketo replication to Azure Synapse.
-
Integrating LlamaIndex with Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Facebook in real time.
-
Getting Started with the CData Python Connector for PayPal
Learn to install and license the CData Python Connector
-
Query Salesforce from Node.js
Execute CRUD queries to live Salesforce data in Node.js.
-
Choosing the Best Method to Connect Salesforce Pardot to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Salesforce Pardot from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Publish Crystal Reports on SAP BusinessObjects BI Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP BusinessObjects BI.
-
Connect to QuickBooks Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for QuickBooks and the SQL Gateway to access QuickBooks Desktop from Google Apps Script.
-
Integrating LangGraph with Slack Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Slack within automated workflows.
-
Add Nethunt Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Nethunt with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automate SAP SuccessFactors LMS Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP SuccessFactors LMS and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Clari
Provide connectivity to Clari through an SAP BusinessObjects universe.
-
Edit and Search External Microsoft OneDrive Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft OneDrive to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Microsoft OneDrive Data objects that you can access from apps and the dashboard.
-
Integrate Cursor with Live Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Paylocity from within the editor.
-
Connect to Live WordPress Data in PostGresSQL Interface through CData Connect AI
Create a live connection to WordPress in CData Connect AI and connect to your WordPress from PostgreSQL.
-
How to connect and process IBM Informix from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live IBM Informix.
-
Automate Kintone Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Kintone and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build Semantic Layer Views for Kafka Data in APOS Live Data Gateway
Use the CData Connector for Kafka in APOS Live Data Gateway to build Semantic Layer Views for Apache Kafka.
-
Feed Google Drive Data into FineReport
How to set Google Drive as a JDBC data source in FineReport.
-
Access Contentful Data from MySQL in PHP
Connect to Contentful through the standard MySQL libraries in PHP.
-
Connect JotForm to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect JotForm with IBM WebSphere for seamless data integration and connectivity.
-
Extend Google Sheets with Instagram Data
Make calls to Instagram from Google Apps Script via the API Server.
-
How to Work with Trello Data in AWS Glue Jobs Using JDBC
Connect to Trello from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Validate ZohoMarketingHub Data with QuerySurge
Access and validate ZohoMarketingHub in QuerySurge using the CData JDBC Driver.
-
Access Live MYOB AccountRight Data in AWS Lambda
Connect to live MYOB AccountRight in AWS Lambda using the CData JDBC Driver.
-
Visualize Outlook Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Outlook.
-
Connect to ScrapingBee Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ScrapingBee.
-
Bridge Gorgias Connectivity with Apache NiFi
Access and process Gorgias in Apache NiFi using the CData JDBC Driver.
-
Visualize Live Cvent Data in the Power BI Service
Use CData Connect AI to connect to live Cvent and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live Amazon Athena Data in Excel 365 Online (Excel for the web)
Connect to Amazon Athena from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Zuora
Provide connectivity to Zuora through an SAP BusinessObjects universe.
-
Connect to Qualaroo Data in HULFT Integrate
Connect to Qualaroo as a JDBC data source in HULFT Integrate
-
Use Biml to Build SSIS Tasks to Replicate CouchDB Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Apache CouchDB to SQL Server.
-
Build Data Flows from QuickBooks Time to SQL Server using SSIS
Easily back up QuickBooks Time to SQL Server using the SSIS components for QuickBooks Time.
-
How to Seamlessly Import Pinecone Data into IBM SPSS Modeler
Integrate Pinecone data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to connect to Wrike Data from Spring Boot
Connect to Wrike in a Spring Boot Application using the CData API Driver for JDBC
-
Use JayDeBeApi to access Coda Data in Python
Use standard Python scripting and the development environment of your choice to access live Coda.
-
How to use SQLAlchemy ORM to access Nuclia Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Nuclia.
-
How to connect to Freshsales Data from Spring Boot
Connect to Freshsales in a Spring Boot Application using the CData API Driver for JDBC
-
Query, Visualize, and Share live Workday Data in Redash
Use CData Connect AI to connect to live Workday in Redash for querying, visualizing, and sharing.
-
Connect to Nethunt Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Nethunt to connect to Nethunt and execute queries in PowerBuilder.
-
How to Connect the Power BI Service to SAP HANA XS Advanced: Complete Guide
Connect to the CData Software Power BI Connector for SAP HANA XS Advanced from PowerBI.com to provide real-time SAP HANA XS Advanced across the organization.
-
Publish Reports with ActiveCampaign Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ActiveCampaign.
-
Building Dynamic Web Pages with SAP Netweaver Gateway Data Using AngularJS
Create single-page applications with live connectivity to SAP Netweaver Gateway using the CData API Server.
-
Getting Started with the CData Tableau Connector for Exact Online
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Exact Online.
-
Add Kintone Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Kintone with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Phoenix Replication to Vertica
Use CData Sync for automated, continuous, customizable Phoenix replication to Vertica.
-
How to Query Live CircleCI Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live CircleCI data in natural language using Python.
-
Write a Simple Go Application to work with Demio Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Demio.
-
Connect to Real-Time Close Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Close in Power Apps.
-
Validate Tavily Data with QuerySurge
Access and validate Tavily in QuerySurge using the CData JDBC Driver.
-
How to Connect to Live Gmail Data 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 Gmail through natural language.
-
Bidirectional Access to JDBC-ODBC Bridge Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate JDBC-ODBC Bridge in Filemaker Pro for Mac or Windows.
-
Automated Continuous Google Analytics Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Analytics replication to delimited files (CSV/TSV).
-
Connect to Gorgias Data in Jaspersoft Studio
Execute SQL to remote Gorgias in Jaspersoft Studio.
-
Connect to NASA Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time NASA using standard SQL.
-
Visualize TaxJar Data in Sisense
Create an ElastiCube in Sisense app with access to TaxJar.
-
Create Informatica Mappings From/To an ODBC Data Source for Testmonitor
Create an ODBC connection to Testmonitor in Informatica and browse and transfer Testmonitor.
-
Build Data Flows from SQL Server to Google Drive through SSIS
Easily push SQL Server data to Google Drive using the CData SSIS Tasks for Google Drive.
-
Connect to AgileCRM Data in Jaspersoft Studio
Execute SQL to remote AgileCRM in Jaspersoft Studio.
-
Automated Continuous Facebook Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Facebook replication to Apache Kafka.
-
How to Connect the Power BI Service to Spotify: Complete Guide
Connect to the CData Software Power BI Connector for Spotify from PowerBI.com to provide real-time Spotify across the organization.
-
Analyze Email Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Email and visualize Email in SAP Analytics Cloud.
-
How to Connect to ConstantContact Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ConstantContact. Leverage the pyodbc module for ODBC in Python.
-
How to connect to CockroachDB Data from Spring Boot
Connect to CockroachDB in a Spring Boot Application using the CData JDBC Driver for CockroachDB
-
Bridge Bitly Connectivity with Apache NiFi
Access and process Bitly in Apache NiFi using the CData JDBC Driver.
-
A PostgreSQL Interface for SAS Data Sets Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAS Data Sets JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Redis Data from PowerBuilder via ADO.NET
This article demonstrates how to access Redis from Appeon PowerBuilder using the CData ADO.NET Provider for Redis.
-
Connect to Act-On Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Object-Relational Mapping (ORM) with ZohoDesk Data 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 ZohoDesk into a Java-based ORM framework, Hibernate.
-
Configure the CData JDBC Driver for Square in a Connection Pool in Tomcat
Connect to Square from a connection pool in Tomcat.
-
Connect to Google Calendar Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Calendar.
-
Add Kafka Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Kafka with the Informatica Enterprise Data Catalog to classify and organize data.
-
Publish Dynamics 365-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Dynamics 365.
-
How to create eBay Analytics federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for eBay Analytics in MySQL .
-
Bidirectional Access to YouTube Analytics Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate YouTube Analytics in Filemaker Pro for Mac or Windows.
-
How to integrate Metabase with QuickBooks Online Data
Use CData Connect AI to connect to live QuickBooks Online and create an interactive dashboard in Metabase from QuickBooks Online.
-
Getting Started with the CData Power BI Connector for SAS xpt
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAS xpt.
-
Connect to OpenWeatherMap Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for OpenWeatherMap.
-
How to Connect to Live QuickBooks Online Data 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 QuickBooks Online for you.
-
Natively Connect to SQL Analysis Services Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SQL Analysis Services. Leverage the native support for ODBC in PHP.
-
Quaderno Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Quaderno facts in real time.
-
How to integrate Google Analytics with Apache Airflow
Access and process Google Analytics in Apache Airflow using the CData JDBC Driver.
-
Query Splunk Data in ColdFusion
Write standard ColdFusion data access code to connect to Splunk.
-
Connect Wrike to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Wrike with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Asana Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Asana and the Script function in FileMaker Pro to connect to Asana and work with Asana in your FileMaker application.
-
Analyze Presto Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Presto and visualize live Presto in Infragistics Reveal.
-
How to Connect the Power BI Service to Mocean: Complete Guide
Connect to the CData Software Power BI Connector for Mocean from PowerBI.com to provide real-time Mocean across the organization.
-
Connect to WordPress Data in RazorSQL
Connect to WordPress from wizards and query WordPress from the GUI in the RazorSQL database management tool.
-
Connect to Bannerbear Data in NetBeans
Connect to Bannerbear in NetBeans with the data source configuration wizard.
-
Build AI Agents with Cosmos DB Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Azure Cosmos DB through CData Connect AI.
-
Replicate Multiple Delighted Accounts
Replicate multiple Delighted accounts to one or many databases.
-
How to Query Live RSS Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live RSS Feeds data in natural language using Python.
-
Create a Data Access Object for Cohere Data using JDBI
A brief overview of creating a SQL Object API for Cohere in JDBI.
-
Quickbase Reporting in OBIEE with the Quickbase JDBC Driver
Deploy the Quickbase JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use Microsoft Copilot Studio to talk to your Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Shopify for you.
-
How to Connect Okta Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Okta data in real time using natural language.
-
How to Query Live GraphQL Data in Claude Desktop
Connect to and query live GraphQL Data in Claude Desktop using CData MCP Server.
-
Create Informatica Mappings From/To an ODBC Data Source for Reckon
Create an ODBC connection to Reckon in Informatica and browse and transfer Reckon.