CData Software - Knowledge Base

Recent Articles

---

• «
• 920
• 921
• 922
• 923
• 924
• 925
• 926
• 927
• 928
• 929
• »

• How to Connect to Live YouTube Analytics Data in n8n Workflows and Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your YouTube Analytics for you.

• A PostgreSQL Interface for SingleStore Data (MySQL Remoting via JDBC)

  Use the Remoting features of the SingleStore JDBC Driver to create a PostgreSQL entry-point for data access.

• Feed Marketo Data into FineReport

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

• Replicate Superchat Data from PowerShell

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

• Automated Continuous SAP BusinessObjects BI Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Azure SQL Database.

• Use JayDeBeApi to access DB2 Data in Python

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

• How to connect Amazon QuickSight to Cloudant Data

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

• How to create Pushbullet federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Pushbullet in MySQL .

• Query Live Dynamics 365 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 Microsoft Dynamics 365 directly from the development environment.

• Easily Integrate Marketo Data in Lazarus Pascal IDE

  Learn how to easily integrate live Marketo in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Use the CData Software JDBC Driver for Certinia in MicroStrategy Web

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

• Access Live Moosend Data in AWS Lambda (with IntelliJ IDEA)

  Connect to live Moosend in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

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

• SSIS Components: Source Output ColumnName Does Not Match the Data Type "System.String" of the Source Column

  In this entry, you will find the steps to resolve the SSIS Source output data type mismatch error.

• Query Marketo Data in DataGrip

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

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

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

• Publish Adobe Commerce-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Adobe Commerce.

• Automated Continuous Chargebee Replication to Vertica

  Use CData Sync for automated, continuous, customizable Chargebee replication to Vertica.

• DataBind Controls to ClickTime Data in Delphi

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

• Automated Continuous SendPulse Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable SendPulse replication to IBM DB2.

• Migrating data from Sage Cloud Accounting to Google BigQuery using CData SSIS Components.

  Easily push Sage Business Cloud Accounting to Google BigQuery using the CData SSIS Tasks for Sage Cloud Accounting and Google BigQuery.

• How to Query SendPulse Data in MySQL Workbench

  Execute MySQL queries against live SendPulse from MySQL Workbench.

• Replicate Jumpseller Data from PowerShell

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

• Automate Power BI XMLA Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Power BI XMLA and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Visualize ClickUp Data in Tableau

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

• Connect to Webflow Data in JRuby

  Create a simple JRuby app with access to live Webflow.

• Integrating Antigravity CLI with Azure Table Storage via CData CLI

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

• How to Seamlessly Import Rebilly Data into IBM SPSS Modeler

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

• Create SAP SuccessFactors Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP SuccessFactors data access from reports, embedded analytics, and more.

• Integrating Kiro CLI with Raisers Edge NXT 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.

• View Reports on Real-Time Xero Data in Power BI Report Server

  Use the CData ODBC Driver for Xero to visualize Xero Accounting in Power BI Desktop and then publish them to Power BI Report Server.

• Create Attio Dataflows on PowerBI.com

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

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

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

• How to Visualize Klipfolio Data in Python with pandas

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

• Build Dashboards with Cosmos DB Data in DBxtra

  Create dynamic dashboards and perform analytics based on Azure Cosmos DB in DBxtra.

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

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

• Use Databricks Agent Bricks to Talk to Your BambooHR Data via CData Connect AI

  Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your BambooHR for you.

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

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

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

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

• Visualize Square 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 Square into TIBCO Spotfire.

• Build Visualizations of Pipeliner CRM Data in Birst

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

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

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

• LinkedIn Ads Reporting and Star Schemas in OBIEE

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

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

• Create Amazon DynamoDB Dataflows on PowerBI.com

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

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

  Learn how to give AI assistants like Claude direct access to live Salesforce & Force.com using the CData Python MCP Server.

• Connect to GitHub Data in JRuby

  Create a simple JRuby app with access to live GitHub.

• Build Phoenix Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live Apache Phoenix and build visualizations in Tableau.

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

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

• How to connect and process PolarTeamPro from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live PolarTeamPro.

• Analyze Miro Data with Power Pivot

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

• Easily Integrate Flowlu Data in Lazarus Pascal IDE

  Learn how to easily integrate live Flowlu in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• ETL Spotify in Oracle Data Integrator

  This article shows how to transfer Spotify into a data warehouse using Oracle Data Integrator.

• Provide OData Services of PhantomBuster Data from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for PhantomBuster by developing a WCF Service Application.

• How to Connect to & Open Adobe Analytics Data in Microsoft Excel

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

• Automated Continuous DocuSign Replication to MySQL

  Use CData Sync for automated, continuous, customizable DocuSign replication to MySQL.

• How to Seamlessly Import Yelp Data into IBM SPSS Modeler

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

• Integrating Antigravity CLI with Atlassian Confluence via CData CLI

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

• Excel Spreadsheet Automation on Anaplan Data with the QUERY Formula

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

• Use SQL Server Integration Services to Add HubSpot Contacts to MailChimp Lists

  A walkthrough of using CData SSIS Components to query for new HubSpot contacts and add them to an existing MailChimp list.

• How to load Moosend data into Elasticsearch via Logstash

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

• Connect to MYOB AccountRight Data in CloverDX (formerly CloverETL)

  Transfer MYOB AccountRight using the visual workflow in the CloverDX data integration tool.

• Connect to Google Analytics Data from Filemaker Pro (Mac)

  Use CData Connect AI to connect to and query live Google Analytics from Filemaker Pro on Mac.

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

  Execute MySQL queries against Pipedrive from Node.js.

• Access Live Hive Data in TIBCO Data Virtualization

  Use the Hive Tibco DV Adapter to create a Apache Hive data source in TIBCO Data Virtualization Studio and gain access to live Apache Hive from your TDV Server.

• Automated Continuous ShipEngine Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable ShipEngine replication to Amazon S3.

• Getting Started with the CData SSIS Components for Avro

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

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

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

• Integrate Tavily Data in Your Informatica Cloud Instance

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

• Query Tally Data from Node.js

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

• DataBind Charts to Procore Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Procore 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.

• Visualize Twitter Ads Data in TIBCO Spotfire through OData

  Integrate Twitter Ads into dashboards in TIBCO Spotfire.

• Access Live PayPal 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 PayPal through MCP integration.

• How to Seamlessly Import SAP Business One Data into IBM SPSS Modeler

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

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

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

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

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

• Automate Neo4J Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Neo4J and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• How to Query ZohoSubscriptions Data in MySQL Workbench

  Execute MySQL queries against live ZohoSubscriptions from MySQL Workbench.

• Import and Visualize Google Sheets Data in Power View

  Create data visualizations based on Google Sheets in Excel.

• Natively Connect to SageHR Data in PHP

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

• Integrate MYOB AccountRight with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate MYOB AccountRight with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to MYOB AccountRight.

• Create Phoenix-Connected Nintex Workflows

  Use CData Connect AI to connect to Phoenix Data from Nintex Workflow Cloud and build custom workflows using live Apache Phoenix.

• Integrating Dataiku with Confluence Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Atlassian Confluence.

• Connect to Oracle Eloqua Reporting Data in Claris FileMaker Pro

  Use the CData ODBC Driver for Oracle Eloqua Reporting in FileMaker Pro to connect to Oracle Eloqua Reporting and work with Oracle Eloqua Reporting in your FileMaker applications.

• Integrate with live WordPress Data in Jitterbit

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

• Automate Excel Online Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Microsoft Excel Online and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• ETL Klipfolio in Oracle Data Integrator

  This article shows how to transfer Klipfolio into a data warehouse using Oracle Data Integrator.

• Automated Continuous Neo4J Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Neo4J replication to IBM DB2.

• Automated Continuous Cvent Replication to SQLite

  Use CData Sync for automated, continuous, customizable Cvent replication to SQLite.

• Import Azure Synapse Data into the Power BI Service for Visualizations

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

• Viewing Simplesat Data in RAD Studio Data Explorer

  How to view Simplesat in RAD Studio Data Explorer using the CData ODBC Driver for Simplesat.

• Connect to OnePageCrm Data in DBArtisan

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

• How to Connect to Live Adobe Analytics 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 Adobe Analytics through natural language.

• Establish a Live Connection with PagerDuty Data using Tableau Bridge

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

• Visualize Live AlloyDB Data in Power BI (via CData Connect AI)

  Use the CData Power BI Connector and CData Connect AI to integrate live Google AlloyDB into custom reports in Power BI.

• Design BIRT Reports on Vimeo Data

  Provide current Vimeo to your embedded analytics.

• Automated Continuous Microsoft Exchange Data Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to OneLake in Microsoft Fabric.

• Connect to Zoho Books Data in Claris FileMaker Pro

  Use the CData ODBC Driver for Zoho Books in FileMaker Pro to connect to Zoho Books and work with Zoho Books in your FileMaker applications.

• Automated Continuous ConstantContact Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable ConstantContact replication to Azure SQL Database.

• Query FormSite Data in ColdFusion

  Write standard ColdFusion data access code to connect to FormSite.

• «
• 920
• 921
• 922
• 923
• 924
• 925
• 926
• 927
• 928
• 929
• »