CData Software - Knowledge Base

Recent Articles

---

• «
• 703
• 704
• 705
• 706
• 707
• 708
• 709
• 710
• 711
• 712
• »

• Connect to Salesforce Pardot Data in Aqua Data Studio

  Access Salesforce Pardot from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Visualize CouchDB Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Apache CouchDB.

• Explore Geographical Relationships in Deel Data with Power Map

  Create data visualizations with Deel in Power Map.

• Create QuickBooks Online-Connected Business Apps in AppSheet

  Connect to QuickBooks Online Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to QuickBooks Online.

• DataBind Charts to Dynamics NAV Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Dynamics NAV from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Connect to PhantomBuster Data from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for PhantomBuster to connect to PhantomBuster and execute queries in PowerBuilder.

• Create Apps from Act-On Data in Qlik Sense Cloud

  Use CData Connect AI to connect to Act-On Data and build apps from live Act-On in Qlik Sense Cloud.

• Import Real-Time Strava Data via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Strava in ColdFusion.

• Connect to Zoho Books Data in RazorSQL

  Connect to Zoho Books from wizards and query Zoho Books from the GUI in the RazorSQL database management tool.

• Process & Analyze Azure Synapse Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Azure Synapse Data.

• Query Auth0 Data in DataGrip

  Create a Data Source for Auth0 in DataGrip and use SQL to query live Auth0.

• Query Okta Data using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Okta entities in PHP by modeling them as objects.

• Automated Continuous NetSuite SuiteAnalytics Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to PostgreSQL.

• How to use SQLAlchemy ORM to access Greenplum Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Pivotal GreenPlum.

• Connect to Procore Data from a Connection Pool in Jetty

  The Procore JDBC Driver supports connection pooling: This article shows how to connect faster to Procore from Web apps in Jetty.

• Query, Visualize, and Share live MYOB AccountRight Data in Redash

  Use CData Connect AI to connect to live MYOB AccountRight in Redash for querying, visualizing, and sharing.

• Create FreshBooks-Connected Enterprise Applications in OutSystems

  Use CData Connect AI to connect to FreshBooks Data from OutSystems and build custom enterprise apps using live FreshBooks.

• Create Informatica Mappings From/To a JDBC Data Source for Bullhorn CRM

  Create Bullhorn CRM data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Connect to Shortcut Data from PowerBuilder via ADO.NET

  This article demonstrates how to access Shortcut from Appeon PowerBuilder using the CData API Driver for ADO.NET.

• Connecting Moonlit Workflow with Vault CRM Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Veeva Vault & Vault CRM in real time.

• How to Query Instagram Data in MySQL Workbench

  Execute MySQL queries against live Instagram from MySQL Workbench.

• PivotalTracker Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on PivotalTracker facts in real time.

• Object-Relational Mapping (ORM) with IBM Informix 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 IBM Informix into a Java-based ORM framework, Hibernate.

• Using the CData Software ODBC Driver for BenchmarkEmail in PyCharm

  Connect to BenchmarkEmail as an ODBC data source in PyCharm using the CData Software ODBC Driver for BenchmarkEmail.

• How to Access ClickTime Data Using Entity Framework

  This article shows how to access ClickTime using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Automated Continuous Exact Online Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Exact Online replication to AlloyDB.

• Create Data Visualizations in Cognos BI with Cloudant Data

  Access IBM Cloudant as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Connect to ADP Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Analyze SAP BusinessObjects BI Data with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for SAP BusinessObjects BI from Power Pivot. You will use the Table Import Wizard to load SAP BusinessObjects BI. You can visually build the import query or use any SQL supported by the driver.

• How to update SAP Hybris C4C from Excel

  This article explains how to transfer data from Excel to SAP Hybris C4C using the Excel Add-In for SAP Hybris C4C.

• Build a Simple VCL Application for Oracle Data

  How to build a simple VCL Application to view Oracle Database in RAD Studio using the CData ODBC Driver for Oracle.

• Connect to Phoenix Data in Jaspersoft Studio

  Execute SQL to remote Apache Phoenix in Jaspersoft Studio.

• Create Informatica Mappings From/To an ODBC Data Source for Codat

  Create an ODBC connection to Codat in Informatica and browse and transfer Codat.

• Work with Freshsales Data in FoxPro

  Load Freshsales into a FoxPro database. This article includes full code and a walk-through of the process.

• Import Microsoft OneDrive Data into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft OneDrive. In this article, you will use the OData format to import Microsoft OneDrive into Microsoft Power Query.

• Analyze Quickbase Data in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of Quickbase and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.

• Integrate with live FHIR Data in Jitterbit

  Use CData Connect AI to connect to and integrate live FHIR in Jitterbit.

• Access Telegram Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Telegram from your Oracle system.

• Connect to Oracle SCM Data in Google Apps Script via Connect AI

  Use CData Connect AI to access Oracle SCM in Google Apps Script.

• Connect to Kafka Data in HULFT Integrate

  Connect to Kafka as a JDBC data source in HULFT Integrate

• Connect to Quickbase Data in Jaspersoft Studio

  Execute SQL to remote Quickbase in Jaspersoft Studio.

• Automated Continuous Sage Intacct Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Sage Intacct replication to Google Cloud SQL.

• Connect to Couchbase Data as a SQL Server Linked Server

  Use CData Connect AI to create a linked server for live Couchbase.

• Analyze Klaviyo Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Klaviyo and visualize live Klaviyo in Infragistics Reveal.

• Natively Connect to IBM Cloud Object Storage Data in PHP

  The CData ODBC driver for IBM Cloud Object Storage enables you to create PHP applications with connectivity to IBM Cloud Object Storage. Leverage the native support for ODBC in PHP.

• Create SSAS Tabular Models from QuickBooks Time Data

  How to build a SQL Server Analysis Service Tabular Model from QuickBooks Time using CData drivers.

• How to Query Live Grafana Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Grafana data in natural language using Python.

• Process & Analyze Google Campaign Manager 360 Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Google Campaign Manager 360 Data.

• Build Semantic Layer Views for Zoho Creator Data in APOS Live Data Gateway

  Use the CData Connector for Zoho Creator in APOS Live Data Gateway to build Semantic Layer Views for Zoho Creator.

• Automate DB2 for i Data Replication to Azure Synapse

  Use CData Sync to customize and automate DB2 for i replication to Azure Synapse.

• How to import Salesforce CRM Analytics Data into Apache Solr

  Use the CData Software JDBC Driver for Salesforce CRM Analytics in Data Import Handler and create an automated import of Salesforce CRM Analytics to Apache Solr Enterprise Search platform.

• Analyze Drift Data with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Drift from Power Pivot. You will use the Table Import Wizard to load Drift. You can visually build the import query or use any SQL supported by the driver.

• Bridge Freshdesk Connectivity with Apache NiFi

  Access and process Freshdesk in Apache NiFi using the CData JDBC Driver.

• How to connect PolyBase to Dropbox

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Dropbox.

• Bidirectional Access to Presto Data from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Presto in Filemaker Pro for Mac or Windows.

• Edit and Search External CouchDB Objects in Salesforce Connect

  Use CData Connect AI to securely provide OData feeds of Apache CouchDB to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create CouchDB Data objects that you can access from apps and the dashboard.

• Build Dashboards with Salesforce CRM Analytics Data in DBxtra

  Create dynamic dashboards and perform analytics based on Salesforce CRM Analytics in DBxtra.

• Integrate Cline with Live Oracle SCM Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Oracle SCM from within your IDE.

• Connect to Google Ad Manager Data in CloverDX (formerly CloverETL)

  Transfer Google Ad Manager using the visual workflow in the CloverDX data integration tool.

• Query AgileCRM Data as a MySQL Database in Node.js

  Execute MySQL queries against AgileCRM from Node.js.

• Connect to PDFMonkey from Asprova with CData Software ODBC Driver for PDFMonkey

  This article shows how to connect faster to PDFMonkey data from Asprova.

• Connecting Agentforce with SAS Data Sets Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your SAS Data Sets for you.

• Integrating Codex CLI with Act CRM via CData CLI

  CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.

• Replicate Everhour Data to Multiple Databases

  Replicate Everhour to disparate databases with a point-and-click configuration.

• How to Work with Azure Table Data in AWS Glue Jobs Using JDBC

  Connect to Azure Table from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Getting Started with the CData Power BI Connector for WooCommerce

  Complete guide to installing, licensing, and connecting with the CData Power BI Connector for WooCommerce.

• How to connect Amazon QuickSight to Azure DevOps Data

  Create a connection to Azure DevOps in CData Connect AI and insert Azure DevOps into Amazon QuickSight SPICE to build interactive dashboards.

• How to Connect DBeaver to Outreach.io via a JDBC Driver

  Manage Outreach.io with visual tools in DBeaver like the query browser.

• Automated Continuous GitHub Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable GitHub replication to delimited files (CSV/TSV).

• Automated Continuous Samanage Replication to Databricks

  Use CData Sync for automated, continuous, customizable Samanage replication to Databricks.

• Automated Continuous SAP Netweaver Gateway Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to Amazon Redshift.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Amazon Marketplace

  Provide connectivity to Amazon Marketplace through an SAP BusinessObjects universe.

• How to load SageHR data into Elasticsearch via Logstash

  Introducing a simple method to load SageHR data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Use the CData ODBC Driver for Dynamics CRM in Microsoft Power Query

  You can use the CData Dynamics CRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft Dynamics CRM into Microsoft Power Query.

• Excel Spreadsheet Automation on Bitly Data with the QUERY Formula

  Pull data from Bitly, automate spreadsheets, and more with the QUERY formula.

• Connect to Presto Data in DBArtisan

  Use wizards in DBArtisan to configure Presto as a data source.

• Integrate Cursor with Live Azure Table Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Azure Table Storage from within the editor.

• Integrate Live Slack Data in the Windsurf IDE via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Windsurf

• Connect GraphQL to IBM WebSphere Using the CData JDBC Driver

  Use the CData JDBC Driver to connect GraphQL with IBM WebSphere for seamless data integration and connectivity.

• Connect to PingOne Data from a Connection Pool in Jetty

  The PingOne JDBC Driver supports connection pooling: This article shows how to connect faster to PingOne from Web apps in Jetty.

• Access Pinecone Data in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Pinecone.

• Build Apps with Live Salesforce Marketing Data Using the Low-Code Development Platform of Mendix

  Connect Salesforce Marketing Cloud with Mendix to build apps using the CData JDBC Driver for Salesforce Marketing.

• Create SSAS Tabular Models from SpaceX Data

  How to build a SQL Server Analysis Service Tabular Model from SpaceX using CData drivers.

• Integrate Open WebUI with Live PostgreSQL Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live PostgreSQL from within the chat interface.

• Feed Certinia Data into FineReport

  How to set Certinia as a JDBC data source in FineReport.

• Extract, Transform, and Load Pingdom Data in Informatica PowerCenter

  Create a simple Workflow for Pingdom in Informatica PowerCenter.

• Integrating Cursor CLI with Delighted Data via CData CLI

  CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.

• How to Access Act-On Data Using Entity Framework

  This article shows how to access Act-On using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Create Datasets from Scrapfly in Domo Workbench and Build Visualizations of Scrapfly Data in Domo

  Use the CData Software ODBC Driver for Scrapfly to create datasets from Scrapfly in Domo Workbench and then build visualizations in the Domo service.

• Getting Started with the CData Excel Add-In for Reply.io

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Reply.io.

• Use the CData ODBC Driver for NASA in Microsoft Power Query

  You can use the CData NASA ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import NASA into Microsoft Power Query.

• Visualize Live Apollo Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Apollo.

• Access Live Quickbase Data in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Quickbase from your Google Sheets.

• How to use SQLAlchemy ORM to access Cloudflare Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Cloudflare.

• Use Grok to Talk to Your MongoDB Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your MongoDB for you.

• Visualize Live Salesforce Data in the Power BI Service

  Use CData Connect AI to connect to live Salesforce & Force.com and create custom reports in the Power BI Service through the On-Premises Gateway.

• Use the CData Software JDBC Driver for Airtable in MicroStrategy

  Connect to Airtable in MicroStrategy Developer using the CData Software JDBC Driver for Airtable.

• Integrate Salesloft Data in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Salesloft from Informatica Cloud.

• A PostgreSQL Interface for Square Data using the CData ODBC Driver

  Use the SQL Gateway and Square ODBC Driver to create a PostgreSQL entry-point for data access.

• How to Work with HubDB Data in AWS Glue Jobs Using JDBC

  Connect to HubDB from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• «
• 703
• 704
• 705
• 706
• 707
• 708
• 709
• 710
• 711
• 712
• »