CData Software - Knowledge Base

Recent Articles

---

• «
• 505
• 506
• 507
• 508
• 509
• 510
• 511
• 512
• 513
• 514
• »

• How to connect Amazon QuickSight to Jira Assets Data

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

• Load Freshservice Data to a Database Using Embulk

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

• How to connect to Teamwork Data with Squirrel SQL client

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

• Build Semantic Layer Views for Bullhorn CRM Data in APOS Live Data Gateway

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

• Visualize Act-On Data in TIBCO Spotfire through OData

  Integrate Act-On into dashboards in TIBCO Spotfire.

• How to connect to Spotify Data with Squirrel SQL client

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

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

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

• Build Spotify-Connected ETL Processes in Google Data Fusion

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

• Create Power BI Reports on Real-Time Attio Data

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

• Build LinkedIn-Connected ETL Processes in Google Data Fusion

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

• Building Dynamic Web Pages with Avro Data Using AngularJS

  Create single-page applications with live connectivity to Avro using the CData API Server.

• Connect to Cloudant Data in Airbyte ELT Pipelines

  Use CData Connect AI to build ELT pipelines for IBM Cloudant in Airbyte.

• Excel Spreadsheet Automation on SpaceX Data with the QUERY Formula

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

• Connect to Contentful Data as an External Source in Dremio

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

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

  Create a simple Workflow for Salesforce & Force.com in Informatica PowerCenter.

• Automated Continuous Calendly Replication to Oracle

  Use CData Sync for automated, continuous, customizable Calendly replication to Oracle.

• Connect to Workday Data from Crystal Reports

  Use CData Connect AI to connect to and report on live Workday from Crystal Reports.

• Connect to MySQL Data from Filemaker Pro (Mac)

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

• Connect to Hive Data in DBeaver

  Use the CData ODBC Driver to connect to Apache Hive in DBeaver.

• How to connect PolyBase to Recurly

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

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

  Use Connect Spreadsheets by CData to gain access to live Microsoft Dataverse (CDS) from your Google Sheets.

• How to Query Exa Data in MySQL Workbench

  Execute MySQL queries against live Exa from MySQL Workbench.

• How to work with PDFMonkey Data in Apache Spark using SQL

  Access and process PDFMonkey Data in Apache Spark using the CData Software JDBC Driver.

• Automated Continuous WooCommerce Replication to IBM DB2

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

• Work with Freshteam Data in FoxPro

  Load Freshteam into a FoxPro database. This article includes full code and a walk-through of the process.

• Build Semantic Layer Views for Salesforce Data 360 Data in APOS Live Data Gateway

  Use the CData Connector for Salesforce Data 360 in APOS Live Data Gateway to build Semantic Layer Views for Salesforce Data 360.

• Connect to Invoiced from a Connection Pool in WebLogic

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

• Build Access-Powered Applications in Cursor with CData MCP Server

  Use the CData MCP Server for Access to explore live Access Data in Cursor to assist with building Access-powered applications.

• Build a Simple VCL Application for Landbot Data

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

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

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

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

• Build Charts with LinkedIn Data in Clear Analytics

  Create dynamic charts and perform analytics based on LinkedIn in Clear Analytics.

• Use the CData Software ODBC Driver for Quickbase in SAS for Real-Time Reporting and Analytics

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

• Create Dynamic Short.io Grids Using the Infragistics XamDataGrid

  Learn how you can connect Short.io to Infragistics XamDataGrid to build dynamic grids.

• How to Design PostgreSQL Power Apps with Database-Like Connectivity

  Gain real-time, database-like connectivity to PostgreSQL from mobile and tablet Power Apps.

• Visualize Live SurveyMonkey Data in the Power BI Service

  Use CData Connect AI to connect to live SurveyMonkey and create custom reports in the Power BI Service through the On-Premises Gateway.

• Operational Reporting on Mixpanel Data from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Mixpanel.

• Integrate with ZohoDesk Data using Apache Camel2

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

• Getting Started with the CData SSIS Components for OData

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

• Import BigQuery Data into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Google BigQuery. In this article, you will use the OData format to import Google BigQuery into Microsoft Power Query.

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

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

• Analyze Aweber Data in R via JDBC

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

• Explore Geographical Relationships in Anaplan Data with Power Map

  Create data visualizations with Anaplan in Power Map.

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

• Gumroad Reporting and Star Schemas in OBIEE

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

• Integrate Marketo Data into Automated Tasks with Power Automate

  Use CData Connect AI to connect to Marketo and integrate live Marketo into your Power Automate tasks.

• Integrate with Google Sheets Data in JReport Designer

  Create charts and reports based on Google Sheets in JReport Designer.

• Use Claude to Talk to Your Basecamp 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 Basecamp for you.

• Using the CData Software ODBC Driver for Google Campaign Manager 360 in PyCharm

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

• Automate Oracle HCM Cloud Data Replication to Azure Synapse

  Use CData Sync to customize and automate Oracle HCM Cloud replication to Azure Synapse.

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

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

• Create Dashboards and Visualize Live Oracle Sales Data in Geckoboard

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

• How to load FTP data into Elasticsearch via Logstash

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

• Connect to ClickTime Data in RazorSQL

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

• Connect to MessageBird Data from a Connection Pool in JBoss

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

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

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

• Getting Started with the CData Power BI Connector for SAP Ariba Source

  Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP Ariba Source.

• Use Azure AI Foundry to Talk to Your Google Ads Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Google Ads for you.

• Automated DB2 for i Data Replication to Teradata

  Use CData Sync to Customize and automate DB2 for i replication to Teradata.

• How to Use a Microsoft Access Database to Update Snowflake Data in Real Time

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

• Databricks: Option to Disable SELECT version() Execution

  Learn how to disable the execution of SELECT version() in Databricks to improve performance and avoid unnecessary queries.

• How to Access Live Square Data in Power Automate Desktop via ODBC

  The CData ODBC Driver for Square enables you to integrate Square into workflows built using Microsoft Power Automate Desktop.

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

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

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

• ETL Egnyte in Oracle Data Integrator

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

• Migrating data from Azure Data Lake Storage to Google BigQuery using CData SSIS Components.

  Easily push Azure Data Lake Storage to Google BigQuery using the CData SSIS Tasks for Azure Data Lake Storage and Google BigQuery.

• Load SharePoint Excel Services Data to a Database Using Embulk

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

• Build Quickbase-Connected ETL Processes in Google Data Fusion

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

• Build MVC Applications with Connectivity to Epicor Kinetic Data

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Epicor Kinetic from an ASP.NET MVC application.

• Create Dynamic Sage 200 Grids Using the Infragistics XamDataGrid

  Learn how you can connect Sage 200 to Infragistics XamDataGrid to build dynamic grids.

• Automated Continuous Clari Replication to PostgreSQL

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

• Integrating OpenCode Terminal with OData Services 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 the CData Software JDBC Driver for Postmark in MicroStrategy

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

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

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

• How to Easily Query FTP Data in OpenOffice Base

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

• How to Access Live Office 365 Data in Power Automate Desktop via ODBC

  The CData ODBC Driver for Office 365 enables you to integrate Microsoft Office 365 into workflows built using Microsoft Power Automate Desktop.

• Automate Confluence Data Replication to SAP HANA

  Use CData Sync to customize and automate Atlassian Confluence replication to SAP HANA.

• Connect to Adobe Experience Manager Data in NetBeans

  Connect to Adobe Experience Manager in NetBeans with the data source configuration wizard.

• Visualize SAP Ariba Procurement Data in TIBCO Spotfire through ADO.NET

  Integrate SAP Ariba Procurement into dashboards in TIBCO Spotfire.

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

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

• Visualize MYOB AccountRight Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to MYOB AccountRight.

• Getting Started with the CData Python Connector for Missive

  Learn to install and license the CData Python Connector

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

  Execute SQL Server queries against Box from Node.js.

• Build BigQuery Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live Google BigQuery and build visualizations in Tableau.

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

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

• Use Databricks Agent Bricks to Talk to Your Raisers Edge NXT Data via CData Connect AI

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

• Use Biml to Build SSIS Tasks to Replicate Twitter Ads Data to SQL Server

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

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

  Provide connectivity to Dotmailer through an SAP BusinessObjects universe.

• Natively Connect to WordPress Data in PHP

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

• Connect to Adobe Target Data as an External Source in Dremio

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

• Create Reports from Oracle HCM Cloud Data in Looker Studio

  Use CData Connect AI to gain access to live Oracle HCM Cloud and create custom reports in Looker Studio.

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

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

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

• Analyze Live Microsoft Teams Data in SAS Viya

  Use CData Connect AI to connect to Microsoft Teams from SAS Viya and deploy self-service analytics using live Microsoft Teams.

• Feed SFTP Data into FineReport

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

• Analyze SparkPost Data with Power Pivot

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

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

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

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

• Integrate ZohoMarketingHub Data in Your Informatica Cloud Instance

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

• Build AI/ML Models with Live Freshsales Data using Dataiku

  Connect Freshsales Data with Dataiku using the CData API Driver for JDBC.

• «
• 505
• 506
• 507
• 508
• 509
• 510
• 511
• 512
• 513
• 514
• »