CData Software - Knowledge Base

Recent Articles

---

• «
• 532
• 533
• 534
• 535
• 536
• 537
• 538
• 539
• 540
• 541
• »

• Connect to BambooHR Data as an External Data Source using PolyBase

  Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live BambooHR.

• Create Pingdom Dataflows on PowerBI.com

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

• Create Power BI Reports on Real-Time Workable Data

  Use the CData ODBC Driver for Workable to visualize Workable in Power BI Desktop.

• A PostgreSQL Interface for xBase Data using the CData ODBC Driver

  Use the SQL Gateway and xBase ODBC Driver to create a PostgreSQL entry-point for data access.

• ETL PivotalTracker in Oracle Data Integrator

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

• Build Dashboards with Dotmailer Data in Dundas BI

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

• Use the CData Software JDBC Driver for Microsoft Teams in MicroStrategy Desktop

  Connect to Microsoft Teams in MicroStrategy Desktop using the CData Software JDBC Driver for Microsoft Teams.

• Automated Continuous Azure DevOps Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Azure DevOps replication to Apache Cassandra.

• Use the CData Software ODBC Driver for Delighted in MicroStrategy Web

  Connect to Delighted in MicroStrategy Web using the CData Software ODBC Driver for Delighted.

• Replicate Multiple Freshteam Accounts via the CData Sync CLI

  Replicate multiple Freshteam accounts to one or many databases.

• Establish a Live Connection with SAP HANA Data using Tableau Bridge

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

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

  Create an ODBC connection to Mouseflow in Informatica and browse and transfer Mouseflow.

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

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

• Automated Continuous Wistia Replication to Azure SQL Database

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

• How to Connect to Azure Synapse Data in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Azure Synapse. Leverage the pyodbc module for ODBC in Python.

• Import Sage 200 Data into the Power BI Service for Visualizations

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

• Analyze Oracle SCM Data in R via ODBC

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

• Bridge Kintone Connectivity with Apache NiFi

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

• Automated Continuous MariaDB Replication to Google BigQuery

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

• How to publish and share Bullhorn CRM Data dashboards with Tableau Server

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

• Access Live Google Search Results in AWS Lambda (with IntelliJ IDEA)

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

• Automated Facebook Ads Data Replication to Teradata

  Use CData Sync to Customize and automate Facebook Ads replication to Teradata.

• How to Work with Google Forms Data in ETL Validator JDBC

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

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

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

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

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

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

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

• A PostgreSQL Interface for Customer.io Data using the CData ODBC Driver

  Use the SQL Gateway and Customer.io ODBC Driver to create a PostgreSQL entry-point for data access.

• How to Connect to Vault CRM Data in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Veeva Vault & Vault CRM. Leverage the pyodbc module for ODBC in Python.

• Build Dashboards with QuickBooks Time Data in DBxtra

  Create dynamic dashboards and perform analytics based on QuickBooks Time in DBxtra.

• Integrate Amazon S3 Data into Power Automate Desktop using CData Connect

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

• Load Paymo Data to a Database Using Embulk

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

• Connect to Printify Data in RapidMiner

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

• Create Apps from Odoo Data in Qlik Sense Cloud

  Use CData Connect AI to connect to Odoo Data and build apps from live Odoo ERP in Qlik Sense Cloud.

• Use the CData ODBC Driver for Zoho Books from SharePoint Excel Services

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

• Create Phoenix-Connected Dashboards in Grafana

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

• Connect and Visualize Live Jira Assets Data in Databricks Lakehouse Federation with CData Connect AI

  Use CData Connect AI to integrate live Jira Assets into the Databricks platform and create visualization dashboards with real-time Jira Assets.

• Getting Started with the CData ADO.NET Provider for SpaceX

  Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.

• Create Dashboards and Visualize Live Okta Data in Geckoboard

  Use CData Connect AI to connect to live Okta and create dashboards for real-time monitoring and visualization in Geckoboard.

• Access Cvent Data from MySQL in Amazon QuickSight

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

• Use Dash to Build to Web Apps on Shortcut Data

  Create Python applications that use pandas and Dash to build Shortcut-connected web apps.

• How to Connect Freshdesk Data to Gemini Enterprise via CData Connect AI

  Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Freshdesk data in real time using natural language.

• Use the CData Software ODBC Driver for Bullhorn CRM in MicroStrategy Desktop

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

• Build Monday.com-Connected Apps in Mendix

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

• Automated Continuous ZarMoney Replication to Amazon S3

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

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

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

• Connect to Paddle Data in HULFT Integrate

  Connect to Paddle as a JDBC data source in HULFT Integrate

• How to connect PolyBase to Paylocity

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

• Publish Crystal Reports on FreshBooks Data

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

• Query SAP Ariba Source Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against SAP Ariba Source from Node.js.

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

  Execute MySQL queries against Humanity from Node.js.

• Create Autopilot Dataflows on PowerBI.com

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

• Visualize Perplexity Data in Tableau

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

• DataBind Google Campaign Manager 360 Data to the DevExpress Data Grid

  Use the CData ADO.NET Provider for Google Campaign Manager 360 with the DevExpress Windows Forms and Web controls to provide Google Campaign Manager 360 to a chart.

• Manage Zoho Creator Data in DBArtisan as a JDBC Source

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

• Analyze Google Ads Data in Cognos Analytics

  Use CData Connect AI to connect to Google Ads Data from Cognos Analytics and analyze live Google Ads.

• How to create Visio diagrams from Zoho Creator Data

  Automatically update Zoho Creator with the changes you make to Visio master shapes.

• Create Epicor Kinetic-Connected Enterprise Applications in OutSystems

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

• Connect to Suadeo Data as an External Source in Dremio

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

• How to Seamlessly Import Salesforce Pardot Data into IBM SPSS Modeler

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

• Load SAP SuccessFactors Data to a Database Using Embulk

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

• Connect to LightSpeedRetail Data in Aqua Data Studio

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

• Analyze Google Contacts Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Google Contacts and visualize live Google Contacts in Infragistics Reveal.

• Use the CData Software JDBC Driver for PagerDuty in MicroStrategy Desktop

  Connect to PagerDuty in MicroStrategy Desktop using the CData Software JDBC Driver for PagerDuty.

• Use the CData Software JDBC Driver for EnterpriseDB in MicroStrategy Desktop

  Connect to EnterpriseDB in MicroStrategy Desktop using the CData Software JDBC Driver for EnterpriseDB.

• Getting Started with the CData JDBC Driver for ActiveCampaign

  Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ActiveCampaign.

• Access Live Auth0 Data in AWS Lambda

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

• Avalara AvaTax Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Avalara AvaTax facts in real time.

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

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

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

• Perform Batch Operations with WordPress Data in Apache NiFi

  Connect to WordPress and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Build Data Flows from SQL Server to Presto through SSIS

  Easily push SQL Server data to Presto using the CData SSIS Tasks for Presto.

• Create Oracle Financials Cloud-Connected Dashboards in Grafana

  Connect to Oracle Financials Cloud Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Oracle Financials Cloud.

• Create SSAS Tabular Models from Basecamp Data

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

• Integrate with WordPress Data in JReport Designer

  Create charts and reports based on WordPress in JReport Designer.

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

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

• Enable the Teamwork JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Teamwork.

• Access Live PivotalTracker Data in Coginiti Pro

  Connect to and query live PivotalTracker from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Connect to Workday Data in Claris FileMaker Pro

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

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

  Create an ODBC connection to Trello in Informatica and browse and transfer Trello.

• Build Data Flows from SQL Server to Teradata through SSIS

  Easily push SQL Server data to Teradata using the CData SSIS Tasks for Teradata.

• Connect to HBase Data through External Services in Salesforce

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

• Access Live Certinia Data in Google Sheets through Connect Spreadsheets

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

• How to Connect Flowise AI Agents to Live MailChimp Data via CData Connect AI

  Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live MailChimp without replication.

• ETL Sage 300 in Oracle Data Integrator

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

• Build an OLAP Cube in SSAS from Confluence Data

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

• Build Dashboards with Apollo Data in Dundas BI

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

• Easily Integrate Everhour Data in Lazarus Pascal IDE

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

• Connect to SQL Analysis Services Data in CloverDX (formerly CloverETL)

  Transfer SQL Analysis Services using the visual workflow in the CloverDX data integration tool.

• Build a Simple VCL Application for Trello Data

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

• How to Build an ETL App for IBM Informix Data in Python with CData

  Create ETL applications and real-time data pipelines for IBM Informix in Python with petl.

• How to Use a Microsoft Access Database to Update Oracle Service Cloud Data in Real Time

  Update Oracle Service Cloud data by creating a linked table in Microsoft Access with the CData Oracle Service Cloud ODBC Driver.

• How to load Scrapfly data into Elasticsearch via Logstash

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

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

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

• How to Import Data from CockroachDB into Google Sheets

  Import CockroachDB into a Google spreadsheet that is automatically refreshed.

• Build Voice Agents in ElevenLabs with access to Live Microsoft Dataverse Data

  Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft Dataverse (CDS).

• Create Power BI Reports on Real-Time Bright Data Data

  Use the CData ODBC Driver for Bright Data to visualize Bright Data in Power BI Desktop.

• Feed Salesforce CRM Analytics Data into FineReport

  How to set Salesforce CRM Analytics as a JDBC data source in FineReport.

• Replicate GitHub Data from PowerShell

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

• Automated Vertica Data Replication to Teradata

  Use CData Sync to Customize and automate Vertica replication to Teradata.

• «
• 532
• 533
• 534
• 535
• 536
• 537
• 538
• 539
• 540
• 541
• »