CData Software - Knowledge Base

Recent Articles

---

• «
• 1459
• 1460
• 1461
• 1462
• 1463
• 1464
• 1465
• 1466
• 1467
• 1468
• »

• Excel Spreadsheet Automation on Google Calendar Data with the QUERY Formula

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

• Create SSAS Tabular Models from Attio Data

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

• Create SSAS Tabular Models from Aweber Data

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

• Integrating OpenCode with FHIR 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.

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

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

• Access Avaza Data from MySQL in HeidiSQL

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

• Process & Analyze Freshteam Data in Databricks (AWS)

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

• How to use SQLAlchemy ORM to access Clockify Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Clockify data.

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

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

• Feed SAP HANA Data into FineReport

  How to set SAP HANA data as a JDBC data source in FineReport.

• Use ChatGPT to Talk to Your Bitly Data via CData Connect AI

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

• Connect to Google Campaign Manager 360 Data in Aqua Data Studio

  Access Google Campaign Manager 360 data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Integrate with LDAP Objects in SnapLogic

  Use CData Connect AI to connect to and integrate with live LDAP objects in SnapLogic.

• Work with Wrike Data in FoxPro

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

• How to Seamlessly Import Snapchat Ads Data into IBM SPSS Modeler

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

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

  Use the CData Power BI Connector and CData Connect AI to integrate live QuickBooks Online data into custom reports in Power BI.

• Access Egnyte Data from MySQL in Amazon QuickSight

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

• Integrating Codex with Pinecone 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 Oracle HCM Cloud Data in JRuby

  Create a simple JRuby app with access to live Oracle HCM Cloud data.

• Automated Continuous Presto Replication to MySQL

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

• Migrating data from FreeAgent to Databricks using CData SSIS Components.

  Easily push FreeAgent data to Databricks using the CData SSIS Tasks for FreeAgent and Databricks.

• Connect ConvertAPI to IBM WebSphere Using the CData JDBC Driver

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

• Connect to Humanity Data in DBeaver

  Use the CData ODBC Driver to connect to Humanity data in DBeaver.

• Automated Continuous Stripe Replication to Google Cloud SQL

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

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

  Connect SFTP Data with Dataiku using the CData JDBC Driver for SFTP.

• Know Your LLM (Series): ChatGPT

  Comprehensive guide to ChatGPT models for enterprise AI. Learn integration patterns with CData Connect AI, model selection criteria, security compliance, and industry use cases for natural-language-to-SQL generation.

• Automated Continuous Slack Replication to AlloyDB

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

• Query Live PolarTeamPro Data in Perplexity Desktop via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live PolarTeamPro data through a conversational interface.

• Automated Continuous Miro Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Miro replication to Snowflake.

• Connect to PostgreSQL Data as an External Source in Dremio

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

• Automated Continuous Strava Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Strava replication to SingleStore.

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

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

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

• Connect to Sendwithus Data in RazorSQL

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

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

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

• Prepare, Blend, and Analyze Zoho CRM Data in Alteryx Designer (ODBC)

  Build workflows to access live Zoho CRM data for self-service data analytics.

• Validate Figshare Data with QuerySurge

  Access and validate Figshare data in QuerySurge using the CData JDBC Driver.

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

• Natively Connect to SAP Business Warehouse Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to SAP Business Warehouse data. Leverage the native support for ODBC in PHP.

• Migrating data from ConvertKit to Databricks using CData SSIS Components.

  Easily push ConvertKit data to Databricks using the CData SSIS Tasks for ConvertKit and Databricks.

• Visualize Live OData Services of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live OData services using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

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

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

• Enable the Billsby JDBC Driver in KNIME

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

• Import and Visualize Google Cloud Storage Data in Power View

  Create data visualizations based on Google Cloud Storage data in Excel.

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

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

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

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

• Manage Postmark Data in DBArtisan as a JDBC Source

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

• Integrating Antigravity CLI with IBM Informix data via CData CLI

  Connect IBM Informix data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.

• Automated Continuous Aircall Replication to Local Delimited Files

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

• Connect to QuickBooks Online Data in Airbyte ELT Pipelines

  Use CData Connect AI to build ELT pipelines for QuickBooks Online data in Airbyte.

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for SQL Analysis Services

  Provide connectivity to SQL Analysis Services data through an SAP BusinessObjects universe.

• Connect to Gmail Data from Filemaker Pro (Mac)

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

• Integrate with Close Data using Apache Camel2

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

• How to Build an ETL App for Microsoft Entra ID Data in Python with CData

  Create ETL applications and real-time data pipelines for Microsoft Entra ID data in Python with petl.

• Build ConstantContact Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live ConstantContact data and build visualizations in Tableau.

• Build Voice Agents in ElevenLabs with access to Live Campaigner Data

  Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Campaigner data.

• Connect to Adobe Commerce Data in DBArtisan

  Use wizards in DBArtisan to configure Adobe Commerce data as a data source.

• Connect to Toggl from a Connection Pool in WebLogic

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

• Automated Continuous Certinia Replication to Vertica

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

• Create Reports from ZohoExpense Data in Looker Studio

  Use CData Connect AI to gain access to live ZohoExpense data and create custom reports in Looker Studio.

• Query YouTube Analytics Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against YouTube Analytics data from Node.js.

• ETL Guru in Oracle Data Integrator

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

• How to create Cosmos DB federated tables in MySQL

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

• Connect to and Query ActiveCampaign Data in QlikView over ODBC

  Create data visualizations with ActiveCampaign data in QlikView.

• Build Apps with Live Jira Data Using the Low-Code Development Platform of Mendix

  Connect Jira data with Mendix to build apps using the CData JDBC Driver for Jira.

• Establish a Live Connection with Amplitude Data using Tableau Bridge

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

• Getting Started with the CData Tableau Connector for SAP Business One

  Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP Business One.

• Automated Continuous Sentry Replication to Azure SQL Database

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

• How to connect to BigCommerce Data from IntelliJ

  Integrate connectivity to BigCommerce data with wizards in IntelliJ.

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

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

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

• Access Vimeo Data from MySQL in Amazon QuickSight

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

• Use ChatGPT to Talk to Your SendPulse Data via CData Connect AI

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

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

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

• Using the CData Software ODBC Driver for Amazon Athena in PyCharm

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

• Excel Spreadsheet Automation on Elorus Data with the QUERY Formula

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

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

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

• Build Dashboards with Salesloft Data in Dundas BI

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

• Model, Search, and Visualize Live Basecamp Data in ThoughtSpot

  Use CData Connect AI to connect to live Basecamp data for modeling, searching, and visualizing.

• Automate Klaviyo Data Replication to Couchbase

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

• How to Connect Flowise AI Agents to Live VWO 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 VWO data without replication.

• Replicate Aha! Data to Multiple Databases via the CData Sync CLI

  Replicate Aha! data to disparate databases with a single configuration.

• Build Raisers Edge NXT-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live Raisers Edge NXT data.

• How to connect PolyBase to LightSpeedRetail

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

• Automated Continuous MariaDB Replication to AlloyDB

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

• Build MySQL-Connected Apps in Choreo

  Use CData Connect AI to connect to MySQL Data from Choreo and build custom apps using live MySQL data.

• Use the CData ODBC Driver for SAP HANA XS Advanced in Microsoft Power Query

  You can use the CData SAP HANA XS Advanced ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP HANA XS Advanced data into Microsoft Power Query.

• Automate SQL Server Data Replication to Couchbase

  Use CData Sync to Customize and automate SQL Server data replication to Couchbase.

• How to Work with Pipeline CRM Data in ETL Validator JDBC

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

• Model Shopify Data Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and Shopify, enabling the direct import of real-time Shopify data.

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

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

• Operational Reporting on Workday Data from Spotfire Server

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

• Interact with Live SendGrid Data in Meta Muse via CData Connect AI

  Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SendGrid data.

• Use the CData Software JDBC Driver for Hubstaff in MicroStrategy

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

• Integrating OpenCode with Clari 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.

• Build a Simple VCL Application for Mistral AI Data

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

• Suadeo Reporting and Star Schemas in OBIEE

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

• Create Adobe Target-Connected Enterprise Applications in OutSystems

  Use CData Connect AI to connect to Adobe Target Data from OutSystems and build custom enterprise apps using live Adobe Target data.

• How to create Demio federated tables in MySQL

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

• Automate PolarTeamPro Data Replication to SAP HANA

  Use CData Sync to customize and automate PolarTeamPro data replication to SAP HANA.

• «
• 1459
• 1460
• 1461
• 1462
• 1463
• 1464
• 1465
• 1466
• 1467
• 1468
• »