CData Software - Knowledge Base
Recent Articles
-
Access Codat Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Codat data from your Oracle system.
-
Connect to Real-Time Hugging Face Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Hugging Face data in Power Apps.
-
Getting Started with the CData Excel Add-In for Apollo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Apollo.
-
How to connect to Scrapfly Data from IntelliJ
Integrate connectivity to Scrapfly data with wizards in IntelliJ.
-
Replicate Multiple QuickBooks Time Accounts
Replicate multiple QuickBooks Time accounts to one or many databases.
-
Excel Spreadsheet Automation on Salesforce CRM Analytics Data with the QUERY Formula
Pull data from Salesforce CRM Analytics, automate spreadsheets, and more with the QUERY formula.
-
Integrate Live Sybase IQ Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Sybase IQ from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Sybase IQ data.
-
Connect to BigQuery Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for BigQuery and the SQL Gateway to access BigQuery data from Google Apps Script.
-
Import Real-Time Attio Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Attio data in ColdFusion.
-
Use Databricks Agent Bricks to Talk to Your SAP Ariba Procurement Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP Ariba Procurement data for you.
-
How to connect to Zoho Recruit Data with Squirrel SQL client
Connect to Zoho Recruit data and execute queries in the Squirrel SQL Client.
-
LINQ to Recurly Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Recurly Data Provider.
-
Use the CData Software ODBC Driver for ScrapingBee in MicroStrategy
Connect to ScrapingBee data in MicroStrategy Developer using the CData Software ODBC Driver for ScrapingBee.
-
Integrate Oracle Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Oracle data from Informatica Cloud.
-
Integrate Theia IDE with Live CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live CSV data from within the development environment.
-
A PostgreSQL Interface for Square Data (MySQL Remoting via JDBC)
Use the Remoting features of the Square JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Databricks Agent Bricks to Talk to Your QuickBooks Time Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your QuickBooks Time data for you.
-
Automated Continuous Opsgenie Replication to Oracle
Use CData Sync for automated, continuous, customizable Opsgenie replication to Oracle.
-
Access Live Monday.com Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Monday.com data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Building Dynamic Web Pages with Trello Data Using AngularJS
Create single-page applications with live connectivity to Trello using the CData API Server.
-
Automated Continuous Google Analytics Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Analytics replication to IBM DB2.
-
Build Automated Workflows with Live Jira Data in Workato
Use CData Connect AI to connect to live Jira data and build automated workflows in Workato.
-
Automated Continuous Quickbase Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Quickbase replication to Apache Kafka.
-
Migrating data from Hubstaff to Databricks using CData SSIS Components.
Easily push Hubstaff data to Databricks using the CData SSIS Tasks for Hubstaff and Databricks.
-
How to connect PolyBase to AfterShip
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live AfterShip data.
-
Getting Started with the CData JDBC Driver for Monday.com
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Monday.com.
-
Connect to HubDB Data in Jaspersoft Studio
Execute SQL to remote HubDB data in Jaspersoft Studio.
-
Connect to SAP Fieldglass Data in Ruby
Connect to SAP Fieldglass data 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 data from Web applications running on WebLogic.
-
Automate Marketo Data Replication to Azure Synapse
Use CData Sync to customize and automate Marketo data replication to Azure Synapse.
-
Analyze Figshare Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Figshare data and visualize Figshare data in SAP Analytics Cloud.
-
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 data in real time.
-
Getting Started with the CData Python Connector for PayPal
Learn to install and license the CData Python Connector and configure a connection to live PayPal data.
-
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 data 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 data.
-
Connect to QuickBooks Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for QuickBooks and the SQL Gateway to access QuickBooks data 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 data 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.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Clari
Provide connectivity to Clari data through an SAP BusinessObjects universe.
-
Automate PDFMonkey Data Replication to Azure Synapse
Use CData Sync to customize and automate PDFMonkey data replication to Azure Synapse.
-
Search External Microsoft OneDrive Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft OneDrive data 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.
-
Analyze Suadeo Data in Looker
Use CData Connect AI to connect to Suadeo Data from Looker and build custom apps using live Suadeo data.
-
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 data from within the editor.
-
Integrate Dify with Live Samanage Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Samanage data.
-
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 data from PostgreSQL.
-
How to connect and process IBM Informix data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live IBM Informix data.
-
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 Kafka data.
-
Feed Google Drive Data into FineReport
How to set Google Drive data 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.
-
Build LDAP Visualizations in Tableau Cloud
Use CData Connect AI to connect to live LDAP objects and build visualizations in Tableau Cloud.
-
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 data in QuerySurge using the CData JDBC Driver.
-
Integrate Dify with Live Vault CRM Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Vault CRM data.
-
Access Live MYOB AccountRight Data in AWS Lambda
Connect to live MYOB AccountRight data in AWS Lambda using the CData JDBC Driver.
-
Visualize Outlook Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Outlook data.
-
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 data.
-
Query Live Zoho Books Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Zoho Books data through a conversational interface.
-
Bridge Gorgias Connectivity with Apache NiFi
Access and process Gorgias data 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 data 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 data 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 data 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 CouchDB data to SQL Server.
-
Build Data Flows from QuickBooks Time to SQL Server using SSIS
Easily back up QuickBooks Time data 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 data.
-
How to use SQLAlchemy ORM to access Nuclia Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Nuclia data.
-
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 data in Redash for querying, visualizing, and sharing.
-
Replicate Simplesat Data to Multiple Databases
Replicate Simplesat data to disparate databases with a point-and-click configuration.
-
Connect to Nethunt Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Nethunt to connect to Nethunt data 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 data 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 data.
-
Integrate with live Paymo Data in Jitterbit
Use CData Connect AI to connect to and integrate live Paymo data in Jitterbit.
-
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 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 data.
-
Automated Continuous Webflow Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Webflow replication to Azure SQL Database.
-
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 data in Power Apps.
-
Validate Tavily Data with QuerySurge
Access and validate Tavily data 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 data 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 data 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 data in Jaspersoft Studio.
-
Connect to NASA Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time NASA data using standard SQL.
-
Visualize TaxJar Data in Sisense
Create an ElastiCube in Sisense app with access to TaxJar data.
-
Create Informatica Mappings From/To an ODBC Data Source for Testmonitor
Create an ODBC connection to Testmonitor in Informatica and browse and transfer Testmonitor data.
-
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 data 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 data across the organization.
-
Analyze Email Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Email data and visualize Email data 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 data. 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