CData Software - Knowledge Base

Recent Articles

---

• «
• 491
• 492
• 493
• 494
• 495
• 496
• 497
• 498
• 499
• 500
• »

• Create SSAS Tabular Models from ZeroBounce Data

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

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

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

• How to Easily Query Facebook Ads Data in OpenOffice Base

  Connect to Facebook Ads data in OpenOffice Base using the CData ODBC Driver for Facebook Ads and generate reports with live data insights.

• Using the CData Software ODBC Driver for Google Spanner in PyCharm

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

• Access Miro Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Miro from HeidiSQL.

• How to Import Data from Outreach.io into Google Sheets

  Import Outreach.io into a Google spreadsheet that is automatically refreshed.

• Publish JobNimbus-Connected Dashboards in Tableau Server

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

• Access Salesforce Data 360 Data from MySQL in PHP

  Connect to Salesforce Data 360 through the standard MySQL libraries in PHP.

• Integrate Live Jira Assets Data into Amazon SageMaker Canvas with RDS

  Use CData Connect AI to connect to Jira Assets from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Jira Assets.

• Automated Continuous Box Replication to Databricks

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

• Replicate LDAP Objects from PowerShell

  Write a quick PowerShell script to query LDAP. Use connectivity to the live data to replicate LDAP to SQL Server.

• Automate Paymo Data Replication to Azure Synapse

  Use CData Sync to customize and automate Paymo replication to Azure Synapse.

• Connect to RabbitMQ Data in Google Apps Script via SQL Gateway

  Use the ODBC Driver for RabbitMQ and the SQL Gateway to access RabbitMQ from Google Apps Script.

• Validate ADP Data with QuerySurge

  Access and validate ADP in QuerySurge using the CData JDBC Driver.

• Create Data Visualizations in Cognos BI with Auth0 Data

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

• Use the CData SSIS Components to Insert New or Update Existing Excel Records from SQL Server

  Easily push SQL Server data to Excel using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Excel or update existing records with data from a SQL Server database.

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

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

• How to Connect to Live FreshBooks Data from crewAI Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your FreshBooks for you.

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

  Create a simple Workflow for FormSite in Informatica PowerCenter.

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

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

• How to publish and share Marketo Data dashboards with Tableau Server

  The CData ODBC driver for Marketo enables you integrate Marketo into Tableau dashboards.

• Access Live Microsoft Teams Data in Google Sheets through Connect Spreadsheets

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

• How to Easily Query LaunchDarkly Data in OpenOffice Base

  Connect to LaunchDarkly data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.

• Visualize Paymo Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Paymo.

• Analyze Google Cloud Storage Data in SAP Analytics Cloud

  Use CData Connect AI to create an OData API on top of Google Cloud Storage and visualize Google Cloud Storage in SAP Analytics Cloud.

• Create Data Visualizations in Cognos BI with Salesforce Data

  This article describes how to use the CData ODBC Driver for Salesforce in Cognos BI.

• Choosing the Best Method to Connect Microsoft OneDrive to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Microsoft OneDrive from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Access Live Slack Data in Emergent via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Slack through MCP integration.

• Natively Connect to QuickBooks Data in PHP

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

• Create Vimeo Dataflows on PowerBI.com

  Connect to the CData Power BI Connector for Vimeo from PowerBI.com to create Power BI Dataflows with real-time data.

• Visualize Anaplan Data in Tableau

  The CData ODBC driver for Anaplan enables you integrate Anaplan into Tableau dashboards.

• Publish MailerSend-Connected Dashboards in Tableau Server

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

• Using the CData Software ODBC Driver for Browserless in PyCharm

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

• Connect to Oracle Sales Data from a Connection Pool in JBoss

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

• Build Semantic Layer Views for EnterpriseDB Data in APOS Live Data Gateway

  Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for EnterpriseDB.

• Integrating Claude Code CLI with LaunchDarkly 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.

• Query Microsoft Ads Data from Node.js

  Use the OData endpoint of the CData API Server to connect to your Microsoft Ads and perform CRUD operations on Microsoft Ads from Node.js.

• Load SAP Data to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP ERP/NetWeaver to a database.

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

  Execute MySQL queries against Elasticsearch from Node.js.

• How to Query Live FHIR Data in Claude Desktop

  Connect to and query live FHIR Data in Claude Desktop using CData MCP Server.

• Replicate HBase Data to Multiple Databases

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

• Connect to DocuSign Data through External Services in Salesforce

  Use CData Connect AI to securely connect Salesforce External Services with DocuSign Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Query WooCommerce Data using the OData SDK for PHP

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

• Replicate Oracle Service Cloud Data in Heroku for Use in Salesforce Connect

  Replicate Oracle Service Cloud to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Build an OLAP Cube in SSAS from Strava Data

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

• Import Google Sheets Data Using Azure Data Factory

  Use CData Connect AI to connect to Google Sheets Data from Azure Data Factory and import live Google Sheets.

• Use the CData Software JDBC Driver for Typeform in MicroStrategy

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

• Build Dashboards with FreeAgent Data in DBxtra

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

• Build Snowflake-Connected Apps in Mendix

  Use CData Connect AI to create an OData feed for Snowflake Data and create custom apps in Mendix.

• How to Connect the Power BI Service to Adobe Commerce: Complete Guide

  Connect to the CData Software Power BI Connector for Adobe Commerce from PowerBI.com to provide real-time Adobe Commerce across the organization.

• Use Biml to Build SSIS Tasks to Replicate XML Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate XML Files to SQL Server.

• Use the CData Software JDBC Driver for Google Drive in MicroStrategy Web

  Connect to Google Drive in MicroStrategy Web using the CData Software JDBC Driver for Google Drive.

• Connect to Zoho Creator Data in DBeaver

  Use the CData ODBC Driver to connect to Zoho Creator in DBeaver.

• Build SuiteCRM-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to SuiteCRM and build web apps with connectivity to live SuiteCRM.

• How to Access Live HubDB Data in Visual Studio Code via Cline

  Run CData MCP Server for HubDB on Windows Subsytem for Linux (WSL) and connect to live HubDB from the Cline extension in Visual Studio Code.

• Bidirectional Access to Confluence Data from FileMaker Pro

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

• Replicate Teradata Data to Multiple Databases via the CData Sync CLI

  Replicate Teradata to disparate databases with a single configuration.

• How to Visualize NASA Data in Python with pandas

  Use pandas and other modules to analyze and visualize live NASA in Python.

• Create Reports with FTP Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date FTP Servers.

• Automate Avalara AvaTax Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Avalara AvaTax from PowerShell? This article demonstrates how to utilize the Avalara AvaTax Cmdlets for tasks like connecting to Avalara AvaTax, automating operations, downloading data, and more.

• Access Demio 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 Demio.

• Build Agents in Relevance AI with Access to Live Oracle SCM Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Oracle SCM within intelligent agent workflows.

• How to Access iContact Data Using Entity Framework

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

• Connect to LinkedIn Ads Data in RapidMiner

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

• Visualize LinkedIn Data in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load LinkedIn into TIBCO Spotfire.

• Extend Google Sheets with Freshdesk Data

  Make calls to Freshdesk from Google Apps Script via the API Server.

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

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

• How to Visualize CockroachDB Data in Python with pandas

  Use pandas and other modules to analyze and visualize live CockroachDB in Python.

• Build Automated Workflows with Live BigQuery Data in Workato

  Use CData Connect AI to connect to live Google BigQuery and build automated workflows in Workato.

• Integrate Stripe Data in Pentaho Data Integration

  Build ETL pipelines based on Stripe in the Pentaho Data Integration tool.

• How to Connect to Live Twitter Ads Data in Mistral AI Workflows

  Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Twitter Ads without replication.

• Access Snowflake 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 Snowflake.

• Bidirectional Access to Webflow Data from FileMaker Pro

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

• Access Nuclia Data from MySQL in PHP

  Connect to Nuclia through the standard MySQL libraries in PHP.

• Visualize Live Calendly Data in Tableau

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

• Publish Quickbase-Connected Dashboards in Tableau Server

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

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

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

• Query Live ActiveCampaign Data in Zed Editor via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live ActiveCampaign directly from the development environment.

• How to publish and share ScrapingBee Data dashboards with Tableau Server

  The CData ODBC driver for ScrapingBee enables you integrate ScrapingBee into Tableau dashboards.

• Access Live Oracle Sales Data in Excel (Desktop) via Connect AI

  Use CData Connect AI to gain access to live Oracle Sales from your Excel spreadsheets.

• Integrating Antigravity CLI with ClickTime via CData CLI

  Connect ClickTime to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.

• Build a Simple VCL Application for Dropbox Data

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

• Publish Crystal Reports on Azure DevOps Data

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Azure DevOps.

• Connect to Paylocity Data in NetBeans

  Connect to Paylocity in NetBeans with the data source configuration wizard.

• Integrate HubDB Data in Pentaho Data Integration

  Build ETL pipelines based on HubDB in the Pentaho Data Integration tool.

• How to Access Live Amazon DynamoDB Data in Visual Studio Code via Cline

  Run CData MCP Server for Amazon DynamoDB on Windows Subsytem for Linux (WSL) and connect to live Amazon DynamoDB from the Cline extension in Visual Studio Code.

• DataBind Controls to AfterShip Data in Delphi

  DataBind to AfterShip in Delphi with standard data access components and controls.

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

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

• How to Access Live Excel Online Data in Visual Studio Code via Cline

  Run CData MCP Server for Excel Online on Windows Subsytem for Linux (WSL) and connect to live Microsoft Excel Online from the Cline extension in Visual Studio Code.

• Establish a Live Connection with Pipedrive Data using Tableau Bridge

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

• Connect to Close Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Close.

• Connect Everhour to IBM WebSphere Using the CData JDBC Driver

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

• Edit and Search External Cvent Objects in Salesforce Connect

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

• Integrating OpenCode Terminal with PivotalTracker 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.

• Access Reckon Accounts Hosted 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 Reckon Accounts Hosted.

• Build Visualizations of Accelo Data in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Accelo in Birst.

• Migrating data from Bugsnag to Snowflake using CData SSIS Components.

  Easily push Bugsnag to Snowflake using the CData SSIS Tasks for Bugsnag and Snowflake.

• Connect to Salesforce Marketing Data in NetBeans

  Connect to Salesforce Marketing Cloud in NetBeans with the data source configuration wizard.

• Connect to and Visualize Live Klipfolio Data in Tableau Prep

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

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

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

• «
• 491
• 492
• 493
• 494
• 495
• 496
• 497
• 498
• 499
• 500
• »