CData Software - Knowledge Base

Recent Articles

---

• «
• 408
• 409
• 410
• 411
• 412
• 413
• 414
• 415
• 416
• 417
• »

• Connect to Accelo Data Using the Script Function in Claris FileMaker Pro

  Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Accelo and work with Accelo in your FileMaker application.

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

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

• Integrate with ZarMoney Data using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ZarMoney to a JSON file on disk.

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

  Use the CData Power BI Connector and CData Connect AI to integrate live Salesforce Marketing Cloud into custom reports in Power BI.

• Build an OLAP Cube in SSAS from Simplesat Data

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

• How to connect to MailerLite Data with Squirrel SQL client

  Connect to MailerLite and execute queries in the Squirrel SQL Client.

• Integrating Kiro CLI with ServiceNow 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.

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

• Add Notion Data to Informatica Enterprise Data Catalog

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

• Query MongoDB Data using the OData SDK for PHP

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

• Automate Stack Exchange Data Replication to Azure Synapse

  Use CData Sync to customize and automate Stack Exchange replication to Azure Synapse.

• Query ZohoDesk Data in ColdFusion

  Write standard ColdFusion data access code to connect to ZohoDesk.

• Access Live Google Drive Data in Roo Code via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Google Drive through MCP integration.

• Access Live Google Ads Data in Roo Code via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Google Ads through MCP integration.

• Analyze Zoho Creator Data in Looker

  Use CData Connect AI to connect to Zoho Creator Data from Looker and build custom apps using live Zoho Creator.

• Automate Klaviyo Data Replication to SAP HANA

  Use CData Sync to customize and automate Klaviyo replication to SAP HANA.

• Easily Integrate Monday.com Data in Lazarus Pascal IDE

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

• Connect to Testmonitor Data as an External Source in Dremio

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

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

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

• How to Query Printify Data in MySQL Workbench

  Execute MySQL queries against live Printify from MySQL Workbench.

• Use the CData Software ODBC Driver for Google Campaign Manager 360 in SAS for Real-Time Reporting and Analytics

  Connect to real-time Google Campaign Manager 360 in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Campaign Manager 360.

• Replicate Multiple Timely Accounts

  Replicate multiple Timely accounts to one or many databases.

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

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

• Use the CData Software ODBC Driver for Parquet in MicroStrategy Desktop

  Connect to Apache Parquet in MicroStrategy Desktop using the CData Software ODBC Driver for Parquet.

• Build Dashboards with CircleCI Data in DBxtra

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

• Excel Spreadsheet Automation on Close Data with the QUERY Formula

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

• How to connect SharePoint with MySQL Data through external lists

  Provide MySQL to SharePoint users as an external list.

• Build Freshteam-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Freshteam.

• Create Oracle Sales Dataflows on PowerBI.com

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

• Access Live EnterpriseDB Data in Excel 365 Online (Excel for the web)

  Connect to EnterpriseDB from Excel 365 Online (Excel for the web) with CData Connect AI.

• Automated Continuous Confluence Replication to AlloyDB

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

• Connect to Phoenix Data in RazorSQL

  Connect to Phoenix from wizards and query Apache Phoenix from the GUI in the RazorSQL database management tool.

• How to load Paylocity data into Elasticsearch via Logstash

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

• Analyze Microsoft Ads Data in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Microsoft Ads with the CData JDBC Driver for Microsoft Ads.

• How to import Testmonitor Data into Apache Solr

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

• Getting Started with the CData Python Connector for HelloSign

  Learn to install and license the CData Python Connector

• Automated Continuous Wistia Replication to Google BigQuery

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

• How to connect and process Oracle Eloqua from Azure Databricks

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

• Replicate Multiple MariaDB Accounts via the CData Sync CLI

  Replicate multiple MariaDB accounts to one or many databases.

• Connect to Parallel Data in CloverDX (formerly CloverETL)

  Transfer Parallel using the visual workflow in the CloverDX data integration tool.

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

  Replicate PagerDuty to disparate databases with a single configuration.

• Getting Started with the CData Tableau Connector for ADP

  Complete guide to installing, licensing, and connecting with the CData Tableau Connector for ADP.

• Consume Couchbase OData Feeds in SAP Lumira

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

• Build an OLAP Cube in SSAS from CapsuleCRM Data

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

• How to connect and process Hacker News from Azure Databricks

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

• Create Quaderno Reports on JasperReports Server

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

• Create a Data Access Object for Strava Data using JDBI

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

• Analyze Pingdom Data in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Pingdom in Microsoft R Open.

• Automated Continuous Salesforce CRM Analytics Replication to Vertica

  Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Vertica.

• Analyze OData Services in Looker

  Use CData Connect AI to connect to OData Services from Looker and build custom apps using live OData.

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

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

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

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

• Query Moosend Data in DataGrip

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

• Establish a Live Connection with Quickbase Data using Tableau Bridge

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

• Viewing Zoho Recruit Data in RAD Studio Data Explorer

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

• Integrate Live ChargeOver Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live ChargeOver to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.

• Use the CData Software ODBC Driver for SageHR in MicroStrategy Desktop

  Connect to SageHR in MicroStrategy Desktop using the CData Software ODBC Driver for SageHR.

• Automated Continuous SageHR Replication to Databricks

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

• Integrate Oracle Sales with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Oracle Sales with External Services.

• Analyze Miro Data in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Miro in Microsoft R Open.

• Integrate Aha! Data in Pentaho Data Integration

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

• Use Dash to Build Web Apps on Sage 200 Data via CData Connect AI

  Build interactive Dash web apps on live Sage 200 using pandas and the CData Connect AI Python SDK.

• Build Dashboards with Shopify Data in Dundas BI

  Create dynamic dashboards and perform analytics based on Shopify in Dundas BI.

• Using the CData Software ODBC Driver for Intercom in PyCharm

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

• Analyze ZohoMarketingHub Data in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze ZohoMarketingHub in Microsoft R Open.

• Connect to and Visualize Live Todoist Data in Tableau Prep

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

• Automated Continuous FreshBooks Replication to Vertica

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

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

  Replicate Smartsheet to disparate databases with a single configuration.

• Analyze ZohoInvoice Data with Power Pivot

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

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

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Perigon

  Provide connectivity to Perigon through an SAP BusinessObjects universe.

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for LDAP

  Provide connectivity to LDAP through an SAP BusinessObjects universe.

• Build Automated Workflows with Live Zuora Data in Workato

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

• Visualize Basecamp Data in Tableau

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

• Analyze Azure Synapse Data in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Azure Synapse in Microsoft R Open.

• Access Live Zoho Inventory Data in Excel 365 Online (Excel for the web)

  Connect to Zoho Inventory from Excel 365 Online (Excel for the web) with CData Connect AI.

• How to Query Live Sage 200 Data in Perplexity MacOS Desktop

  Connect to and query live Sage 200 Data in Perplexity Desktop using CData MCP Server.

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

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

• Build Data Flows from RabbitMQ to SQL Server using SSIS

  Easily back up RabbitMQ to SQL Server using the SSIS components for RabbitMQ.

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

• Connect to Salesloft Data in RazorSQL

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

• Automated Continuous LionDesk Replication to Google BigQuery

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

• Use the CData ODBC Driver for SAS xpt from SharePoint Excel Services

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

• How to Visualize Email Data in Python with pandas

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

• Connect to Printify Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

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

  Provide connectivity to Telegram through an SAP BusinessObjects universe.

• Bridge Reply.io Connectivity with Apache NiFi

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

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

  Execute SQL Server queries against FTP Servers from Node.js.

• Rapidly Develop Webflow-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Webflow.

• Create IBM Informix-Connected Enterprise Applications in OutSystems

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

• Use the CData Software JDBC Driver for Oracle HCM Cloud in MicroStrategy Web

  Connect to Oracle HCM Cloud in MicroStrategy Web using the CData Software JDBC Driver for Oracle HCM Cloud.

• Integrate Box Data into Power Automate Desktop using CData Connect

  CData Connect for Box Data enables you to integrate Box into workflows built using Microsoft Power Automate Desktop.

• Excel Spreadsheet Automation on SAP Business Warehouse Data with the QUERY Formula

  Pull data from SAP Business Warehouse, automate spreadsheets, and more with the QUERY formula.

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

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

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

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

• Visualize Live LaunchDarkly Data in Tableau

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

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

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

• Integrate with SendInBlue Data in JReport Designer

  Create charts and reports based on SendInBlue in JReport Designer.

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

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

• Load Accelo Data to a Database Using Embulk

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

• «
• 408
• 409
• 410
• 411
• 412
• 413
• 414
• 415
• 416
• 417
• »