CData Software - Knowledge Base

Recent Articles

---

• «
• 124
• 125
• 126
• 127
• 128
• 129
• 130
• 131
• 132
• 133
• »

• Manage Teamwork Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Teamwork.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed Apache CouchDB to Power BI dashboards. Simply drag and drop Apache CouchDB into data visuals on the Power BI canvas.

• Create Informatica Mappings From/To a JDBC Data Source for Zoho Recruit

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

• Connect Demio to IBM WebSphere Using the CData JDBC Driver

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

• Connect to Live Oracle SCM Data in MicroStrategy through CData Connect AI

  Create a live connection to Oracle SCM Data in CData Connect AI and connect to your Oracle SCM from MicroStrategy.

• Replicate Oracle Eloqua Data to Multiple Databases via the CData Sync CLI

  Replicate Oracle Eloqua to disparate databases with a single configuration.

• Connect to Azure Synapse from Asprova with CData Software ODBC Driver for Azure Synapse

  This article shows how to connect faster to Azure Synapse data from Asprova.

• How to Connect to & Open Contentful Data in Microsoft Excel

  This article uses the CData ODBC driver for Contentful to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Connect to Zoom Data from PowerBuilder via JDBC

  This article demonstrates how to access Zoom from PowerBuilder using the Zoom JDBC Driver.

• Automate Vault CRM Data Replication to SAP HANA

  Use CData Sync to customize and automate Veeva Vault & Vault CRM replication to SAP HANA.

• Integrating GitHub Copilot CLI with Zoho Books 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.

• Access Live Apollo Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Apollo from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Connect MySQL Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your MySQL using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Use Dash to Build to Web Apps on IBM Cloud Object Storage Data

  Create Python applications that use pandas and Dash to build IBM Cloud Object Storage-connected web apps.

• How to Use a Microsoft Access Database to Update YouTube Analytics Data in Real Time

  Update YouTube Analytics data by creating a linked table in Microsoft Access with the CData YouTube Analytics ODBC Driver.

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

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

• Use the CData Software ODBC Driver for Testmonitor in MicroStrategy

  Connect to Testmonitor in MicroStrategy Developer using the CData Software ODBC Driver for Testmonitor.

• Automate Gorgias Data Replication to Couchbase

  Use CData Sync to Customize and automate Gorgias replication to Couchbase.

• Automated Continuous Marketo Replication to Google Cloud SQL

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

• Use ChatGPT to Talk to Your Act CRM Data via CData Connect AI

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

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

  Execute MySQL queries against MailerSend from Node.js.

• Natively Connect to Perigon Data in PHP

  The CData ODBC driver for Perigon enables you to create PHP applications with connectivity to Perigon. Leverage the native support for ODBC in PHP.

• Create Reports with NetSuite Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date NetSuite CRM & ERP.

• Connect to Smartsheet Data in DBArtisan

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

• Visualize Zoom Data in TIBCO Spotfire through ADO.NET

  Integrate Zoom into dashboards in TIBCO Spotfire.

• How to Create Power BI Visual Reports with Real-Time Mixpanel Data

  Use CData Power BI Connectors to visualize Mixpanel in Power BI.

• Getting Started with the CData SSIS Components for Coinbase

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for Coinbase.

• Visualize Sage Intacct Data in TIBCO Spotfire through OData

  Integrate Sage Intacct into dashboards in TIBCO Spotfire.

• Access Live Confluence Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live Confluence data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Automated Continuous Google Calendar Replication to Local Delimited Files

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

• Establish a Live Connection with Beeminder Data using Tableau Bridge

  The CData ODBC Driver for Beeminder enables you to integrate live Beeminder into Tableau Cloud dashboards using the Tableau Bridge.

• Build a Singer.io Tap for Amazon Marketplace With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Amazon Marketplace data using

• Connect to Live Basecamp Data in PostGresSQL Interface through CData Connect AI

  Create a live connection to Basecamp in CData Connect AI and connect to your Basecamp from PostgreSQL.

• Getting Started with the CData Excel Add-In for Grafana

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

• Getting Started with the CData ODBC Driver for Wistia

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Wistia.

• Migrating data from Rebilly to Databricks using CData SSIS Components.

  Easily push Rebilly to Databricks using the CData SSIS Tasks for Rebilly and Databricks.

• Consume Bullhorn CRM OData Feeds in PowerBuilder

  This article demonstrates how to consume Bullhorn CRM as OData feeds from PowerBuilder using the API Server.

• Prepare, Blend, and Analyze Exact Online Data in Alteryx Designer (ODBC)

  Build workflows to access live Exact Online for self-service data analytics.

• LINQ to Sybase 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 Sybase Data Provider.

• Edit and Search External Azure Table Objects in Salesforce Connect

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

• Build Azure Analysis Services-Powered Applications in Gemini Code Assist with CData MCP Server

  Use the CData MCP Server for Azure Analysis Services to explore live Azure Analysis Services Data in Gemini Code Assist to assist with building Azure Analysis Services-powered applications.

• Connect to and Visualize Live Cvent Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Cvent.

• Visualize ZohoDesk Data in TIBCO Spotfire through ADO.NET

  Integrate ZohoDesk into dashboards in TIBCO Spotfire.

• Connect Guru to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Guru using the CData Python MCP Server.

• Connect to Spotify Data in RapidMiner

  Integrate Spotify with standard components and data source configuration wizards in RapidMiner Studio.

• Analyze DB2 Data in Cognos Analytics

  Use CData Connect AI to connect to DB2 Data from Cognos Analytics and analyze live IBM DB2.

• Build Dashboards with Humanity Data in DBxtra

  Create dynamic dashboards and perform analytics based on Humanity in DBxtra.

• Publish Zuora-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Zuora.

• Build Charts with Redshift Data in Clear Analytics

  Create dynamic charts and perform analytics based on Amazon Redshift in Clear Analytics.

• Edit and Search Azure Table External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of Azure Table Storage to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Azure Table objects that you can access from apps and the dashboard.

• DataBind Controls to FHIR Data in C++Builder

  DataBind to FHIR in C++Builder with standard components and controls.

• Connect to SAP ByDesign Data in Jaspersoft Studio

  Execute SQL to remote SAP Business ByDesign in Jaspersoft Studio.

• Access MYOB AccountRight Data from MySQL in PHP

  Connect to MYOB AccountRight through the standard MySQL libraries in PHP.

• How to create an RPA flow for Confluence Data in UiPath Studio

  Use the Confluence ODBC Driver to create workflows that access real-time Atlassian Confluence without any coding.

• How to create an RPA flow for DB2 Data in UiPath Studio

  Use the DB2 ODBC Driver to create workflows that access real-time IBM DB2 without any coding.

• Visualize Live eBay Analytics Data of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live eBay Analytics using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Connect to SAP Ariba Source Data Using the Script Function in Claris FileMaker Pro

  Use the CData ODBC Driver for SAP Ariba Source and the Script function in FileMaker Pro to connect to SAP Ariba Source and work with SAP Ariba Source in your FileMaker application.

• How to connect Amazon QuickSight to JSON Services

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

• Use the CData Software JDBC Driver for Cosmos DB in MicroStrategy

  Connect to Azure Cosmos DB in MicroStrategy Developer using the CData Software JDBC Driver for Cosmos DB.

• Use the CData ODBC Driver for CockroachDB from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for CockroachDB to connect to CockroachDB from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring CockroachDB in Excel.

• Automated Continuous IBM Cloud Object Storage Replication to Snowflake

  Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Snowflake.

• Use Microsoft Copilot Studio to talk to your Microsoft Exchange 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 Microsoft Exchange for you.

• Back Up LinkedIn Ads to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for LinkedIn Ads. In this article, we will employ an SSIS workflow to populate a database with LinkedIn Ads data.

• Consume Freshservice OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Freshservice feeds that reflect any changes in SAP Lumira.

• Connect to Drift from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Drift to connect to Drift from Web applications running on WebLogic.

• Access Live Grafana Data in AWS Lambda

  Connect to live Grafana in AWS Lambda using the CData JDBC Driver.

• Connect to Unbounce Data in Aqua Data Studio

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

• Access Instagram Data from MySQL in Amazon QuickSight

  Connect to Instagram and build visualizations of Instagram using a MySQL Connection in Amazon QuickSight.

• How to Seamlessly Import Opsgenie Data into IBM SPSS Modeler

  Integrate Opsgenie data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Prepare, Blend, and Analyze SendPulse Data in Alteryx Designer (ODBC)

  Build workflows to access live SendPulse for self-service data analytics.

• Connect to Cvent Data in Aqua Data Studio

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

• Bidirectional Access to Sendwithus Data from FileMaker Pro

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

• Use the CData API Server to Access Aircall Data in Microsoft PowerPivot

  Use the CData API Server to connect to live Aircall in the Power Pivot business intelligence tool.

• Access Pingdom Data from MySQL in Amazon QuickSight

  Connect to Pingdom and build visualizations of Pingdom using a MySQL Connection in Amazon QuickSight.

• Integrate Cline with Live HubSpot Data via CData Connect AI

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

• Connect to Asana Data in Google Apps Script via Connect AI

  Use CData Connect AI to access Asana in Google Apps Script.

• Visualize Live SAP Data of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live SAP ERP/NetWeaver using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Edit and Search Wrike External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of Wrike to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Wrike objects that you can access from apps and the dashboard.

• How to connect to SAS Data Sets Data with Squirrel SQL client

  Connect to SAS Data Sets and execute queries in the Squirrel SQL Client.

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

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

• Consume Smartsheet OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Smartsheet feeds that reflect any changes in SAP Lumira.

• Automated Continuous JSON Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable JSON replication to Google BigQuery.

• Moving Data from Deel to SQL Server Using Toad Data Point and CData ODBC Driver

  Query, export, and automate live Deel data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.

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

  Execute MySQL queries against Quickbase from Node.js.

• Replicate Eventbrite Data to Multiple Databases

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

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

  Create an ODBC connection to Salesforce Pardot in Informatica and browse and transfer Salesforce Pardot.

• Connect to Odoo Data from a Connection Pool in Jetty

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

• Import Google Ads Data into the Power BI Service for Visualizations

  Use CData Connect AI to connect to Google Ads Data and provide access to live Google Ads for custom reports in the Power BI Service.

• Bridge MariaDB Connectivity with Apache NiFi

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

• Use JayDeBeApi to access Beeminder Data in Python

  Use standard Python scripting and the development environment of your choice to access live Beeminder.

• Build a Simple VCL Application for Salesforce Pardot Data

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

• Natively Connect to Typeform Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Typeform. Leverage the native support for ODBC in PHP.

• Integrating Cursor CLI with PostgreSQL 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.

• Natively Connect to Gorgias Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Gorgias. Leverage the native support for ODBC in PHP.

• Consume Freshsales OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Freshsales feeds that reflect any changes in SAP Lumira.

• Connect to Real-Time SAP BusinessObjects BI Data in Power Apps Using Dataflows to Build Custom Applications

  Use CData Power BI Connector for SAP BusinessObjects BI and Dataflow to import and use SAP BusinessObjects BI in Power Apps.

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

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

• Build an OLAP Cube in SSAS from DB2 Data

  Establish a connection to IBM DB2 data from SQL Server Analysis Services, and use the DB2 Data Provider to build OLAP cubes for use in analytics and reporting.

• Connect Mistral AI Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Mistral AI using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Connect to Jira Data from a Connection Pool in JBoss

  Integrate Atlassian Jira into Java servlets: Use the Management Console in JBoss to install the Jira JDBC Driver.

• «
• 124
• 125
• 126
• 127
• 128
• 129
• 130
• 131
• 132
• 133
• »