CData Software - Knowledge Base

Recent Articles

---

• «
• 601
• 602
• 603
• 604
• 605
• 606
• 607
• 608
• 609
• 610
• »

• How to connect PolyBase to Campaigner

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

• Replicate Zoho Recruit Data to Multiple Databases via the CData Sync CLI

  Replicate Zoho Recruit data to disparate databases with a single configuration.

• Connect to SageHR from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SageHR data, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Feed Avaza Data into FineReport

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

• Automated Continuous Oracle HCM Cloud Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Amazon S3.

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

  Learn how to easily build a Singer.io Tap for live Perplexity data using the CData Python Connector.

• Visualize Live Rootly Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Rootly data.

• Access Sybase IQ Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Sybase IQ data from HeidiSQL.

• Write a Simple Go Application to work with Gumroad Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Gumroad data.

• Integrate Devin with Live AgileCRM Data Using CData Connect AI

  Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live AgileCRM data.

• Build a PostgreSQL Interface for Perplexity Data using the CData JDBC Driver

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

• Connect to Elasticsearch Data as an External Source in Dremio

  Use the CData JDBC Driver to connect to Elasticsearch as an External Source in Dremio.

• Manage Bright Data Data in DBArtisan as a JDBC Source

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

• Access Live Klaviyo Data in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Klaviyo data into the statistical analysis tools available in SAS JMP. This article shows how to use Klaviyo data in the Graph Builder and Query Builder.

• Create Tally-Connected Nintex Workflows

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

• Integrate Real-Time Access to SAP Ariba Source in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP Ariba Source data in real time.

• Integrate Devin with Live FreshBooks Data Using CData Connect AI

  Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live FreshBooks data.

• Manage Oracle SCM Data in DBArtisan as a JDBC Source

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

• Visualize Live Short.io Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Short.io data.

• How to create Zoho Creator federated tables in MySQL

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

• Use Dash to Build Web Apps on Vault CRM Data via CData Connect AI

  Build interactive Dash web apps on live Vault CRM data using pandas and the CData Connect AI Python SDK.

• Connect to Azure Data Catalog Data from PowerBuilder via ADO.NET

  This article demonstrates how to access Azure Data Catalog data from Appeon PowerBuilder using the CData ADO.NET Provider for Azure Data Catalog.

• Integrate Nuclia Data in Pentaho Data Integration

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

• Create a Data Access Object for SAP HANA Data using JDBI

  A brief overview of creating a SQL Object API for SAP HANA data in JDBI.

• Use the CData Software JDBC Driver for Sage 300 in MicroStrategy

  Connect to Sage 300 data in MicroStrategy Developer using the CData Software JDBC Driver for Sage 300.

• Connect to HubDB Data as an External Source in Dremio

  Use the CData JDBC Driver to connect to HubDB as an External Source in Dremio.

• Automated Continuous SendInBlue Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable SendInBlue replication to Apache Kafka.

• Query AlloyDB Data in ColdFusion

  Write standard ColdFusion data access code to connect to AlloyDB data.

• Automate Workday Data Replication to Couchbase

  Use CData Sync to Customize and automate Workday data replication to Couchbase.

• Connect to Helpscout Data from PowerBuilder via ADO.NET

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

• Analyze Sage 200 Data in SAP Analytics Cloud

  Use CData Connect AI to create an OData API on top of Sage 200 data and visualize Sage 200 data in SAP Analytics Cloud.

• Analyze PostgreSQL Data in Cognos Analytics

  Use CData Connect AI to connect to PostgreSQL Data from Cognos Analytics and analyze live PostgreSQL data.

• Query QuickBooks Online Data as a SQL Server Database in Node.js

  Execute SQL Server queries against QuickBooks Online data from Node.js.

• Working with Foursquare Data in LINQPad

  Execute LINQ queries to Foursquare data in LINQPad.

• Create SSAS Tabular Models from Microsoft Entra ID Data

  How to build a SQL Server Analysis Service Tabular Model from Microsoft Entra ID data using CData drivers.

• Seamlessly Bring Wave Financial Data into Retool Using CData Connect AI

  Integrate Wave Financial data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.

• Connect to Live Jira Assets Data in PostGresSQL Interface through CData Connect AI

  Create a live connection to Jira Assets in CData Connect AI and connect to your Jira Assets data from PostgreSQL.

• How to Build an ETL App for Google Ad Manager Data in Python with CData Connect AI

  Build ETL pipelines that read and write live Google Ad Manager data in Python with petl and the CData Connect AI Python SDK.

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

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

• Automated Continuous Chargebee Replication to Google Cloud SQL

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

• How to Visualize SageHR Data in Python with pandas

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

• Automated Continuous Clari Replication to Google BigQuery

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

• Create SAS xpt Reports on JasperReports Server

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

• Connect to IBM Cloud Object Storage Data in RazorSQL

  Connect to IBM Cloud Object Storage from wizards and query IBM Cloud Object Storage data from the GUI in the RazorSQL database management tool.

• Build Cloudant-Connected Applications in Kiro with CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Cloudant data without replication.

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

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

• Automated Continuous Yelp Replication to Local Delimited Files

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

• Automated Continuous Google Directory Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Google Directory replication to PostgreSQL.

• How to Work with Testmonitor Data in ETL Validator JDBC

  Connect to Testmonitor from ETL Validator jobs using the CData Software JDBC Driver.

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

• Integrating Codex with Everhour 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.

• Connect to and Query Bannerbear Data in QlikView over ODBC

  Create data visualizations with Bannerbear data in QlikView.

• How to Query Instantly Data in MySQL Workbench

  Execute MySQL queries against live Instantly data from MySQL Workbench.

• How to create SQL Server federated tables in MySQL

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

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

  Use CData JDBC drivers to import and use Notion data in ColdFusion.

• Automated Continuous Printify Replication to PostgreSQL

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

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

  Provide connectivity to Figshare data through an SAP BusinessObjects universe.

• Create Optimizely-Connected Nintex Workflows

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

• Access Amazon S3 Data from MySQL in PHP

  Connect to Amazon S3 through the standard MySQL libraries in PHP.

• Integrating Boomi Agentstudio with MySQL Data via CData Connect AI

  Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to MySQL data, enabling AI agents to act on live enterprise data within your integration and automation workflows.

• Integrate with live AfterShip Data in Jitterbit

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

• Process & Analyze Demio Data in Databricks (AWS)

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

• How to Easily Query LinkedIn Ads Data in OpenOffice Base

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

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

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

• Migrating data from Gumroad to Google BigQuery using CData SSIS Components.

  Easily push Gumroad data to Google BigQuery using the CData SSIS Tasks for Gumroad and Google BigQuery.

• Connect to Amazon Athena Data from a Connection Pool in JBoss

  Integrate Amazon Athena data into Java servlets: Use the Management Console in JBoss to install the Amazon Athena JDBC Driver.

• Build Adobe Commerce-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live Adobe Commerce data.

• Automate ChartMogul Data Replication to Azure Synapse

  Use CData Sync to customize and automate ChartMogul data replication to Azure Synapse.

• How to Easily Query ActiveCampaign Data in OpenOffice Base

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

• Create Paymo-Connected Dashboards in Grafana

  Connect to Paymo Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Paymo data.

• Connect to WordPress Data from PowerBuilder via ODBC

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

• How to connect SharePoint with SAP ByDesign Data through external lists

  Provide SAP ByDesign data to SharePoint users as an external list.

• Integrate Cursor with Live Acumatica Data via CData Connect AI

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

• Automated Continuous Clio Replication to MySQL

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

• How to connect to BambooHR Data with Squirrel SQL client

  Connect to BambooHR data and execute queries in the Squirrel SQL Client.

• How to Connect the Power BI Service to Simplesat: Complete Guide

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

• Connect to Bannerbear Data as an External Source in Dremio

  Use the CData JDBC Driver to connect to Bannerbear as an External Source in Dremio.

• Getting Started with the CData Python Connector for SAP SuccessFactors

  Learn to install and license the CData Python Connector and configure a connection to live SAP SuccessFactors data.

• Integrate with Everhour Data in JReport Designer

  Create charts and reports based on Everhour data in JReport Designer.

• Integrate OpenCode with Live Lakebase Data via CData Connect AI

  Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Lakebase data from within your AI coding agent.

• Connect to CircleCI Data from PowerBuilder via ADO.NET

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

• Create Dynamic Dynamics NAV Grids Using the Infragistics XamDataGrid

  Learn how you can connect Dynamics NAV to Infragistics XamDataGrid to build dynamic grids.

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

• Automated Continuous Perigon Replication to Local Delimited Files

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

• Create a Data Access Object for ZarMoney Data using JDBI

  A brief overview of creating a SQL Object API for ZarMoney data in JDBI.

• Connect Telegram to IBM WebSphere Using the CData JDBC Driver

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

• Integrate Theia IDE with Live Microsoft Ads 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 Microsoft Ads data from within the development environment.

• Establish a Live Connection with Typeform Data using Tableau Bridge

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

• Working with JobNimbus Data in LINQPad

  Execute LINQ queries to JobNimbus data in LINQPad.

• Import Excel Online Data Using Azure Data Factory

  Use CData Connect AI to connect to Excel Online Data from Azure Data Factory and import live Excel Online data.

• Connect to Greenplum from a Connection Pool in WebLogic

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

• Use Claude to Talk to Your Anaplan Data via CData Connect AI

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

• Integrate Dify with Live BambooHR 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 BambooHR data.

• Getting Started with the CData Python Connector for Azure DevOps

  Learn to install and license the CData Python Connector and configure a connection to live Azure DevOps data.

• Access Opsgenie Data from MySQL in Amazon QuickSight

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

• Publish Crystal Reports on Basecamp Data

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

• Connect to Salesforce CRM Analytics Data from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Salesforce CRM Analytics data using standard SQL.

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

  Create an ODBC connection to Printify in Informatica and browse and transfer Printify data.

• Add SAP HANA Data to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for SAP HANA with the Informatica Enterprise Data Catalog to classify and organize data.

• Using the CData Software ODBC Driver for SFTP in PyCharm

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

• «
• 601
• 602
• 603
• 604
• 605
• 606
• 607
• 608
• 609
• 610
• »