CData Software - Knowledge Base

Recent Articles

---

• «
• 968
• 969
• 970
• 971
• 972
• 973
• 974
• 975
• 976
• 977
• »

• Automated Continuous API Replication to SQL Server

  Use CData Sync for automated, continuous, customizable API replication to SQL Server.

• Build Pipelines with Live Act-On Data in Google Cloud Data Fusion (via CData Connect AI)

  Use CData Connect AI to connect to Act-On from Google Cloud Data Fusion, enabling the integration of live Act-On into the building and management of effective data pipelines.

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live ShipStation using the Model Context Protocol.

• Build Charts with IBM Informix Data in Clear Analytics

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

• Integrating Kiro CLI with Paymo 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 Biml to Build SSIS Tasks to Replicate Azure Data Catalog Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Azure Data Catalog to SQL Server.

• Connect to Smartsheet Data in ACL Analytics

  Connect to Smartsheet via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Smartsheet.

• Getting Started with the CData SSIS Components for Retently

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

• Connect to Snapchat Ads Data in Jaspersoft Studio

  Execute SQL to remote Snapchat Ads in Jaspersoft Studio.

• Automated Continuous Aircall Replication to Oracle

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

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

  Execute MySQL queries against Apache CouchDB from Node.js.

• Automated Continuous Flowlu Replication to Google BigQuery

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

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

• Create Dashboards and Visualize Live Microsoft Entra ID Data in Geckoboard

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

• Create Power BI Reports on Real-Time Spark Data

  Use the CData ODBC Driver for Spark to visualize Apache Spark SQL in Power BI Desktop.

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

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

• Replicate Multiple Access Accounts

  Replicate multiple Access accounts to one or many databases.

• Automate Cosmos DB Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Azure Cosmos DB from PowerShell? This article demonstrates how to utilize the Cosmos DB Cmdlets for tasks like connecting to Azure Cosmos DB, automating operations, downloading data, and more.

• Analyze CSV Data in Cognos Analytics

  Use CData Connect AI to connect to CSV Data from Cognos Analytics and analyze live CSV/TSV Files.

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

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

• Build MVC Applications with Connectivity to SparkPost Data

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

• Connect to JobNimbus Data in RazorSQL

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

• Connect to SAS Data Sets Data in Jaspersoft Studio

  Execute SQL to remote SAS Data Sets in Jaspersoft Studio.

• How to connect PolyBase to FormSite

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

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

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

• How to Easily Query Attio Data in OpenOffice Base

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

• Integrate with Redis Data in SnapLogic

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

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

• Explore Geographical Relationships in Helpscout Data with Power Map

  Create data visualizations with Helpscout in Power Map.

• Design BIRT Reports on DocuSign Data

  Provide current DocuSign to your embedded analytics.

• Build MVC Applications with Connectivity to Rebilly Data

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

• Analyze SAP HANA XS Advanced Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of SAP HANA XS Advanced and visualize live SAP HANA XS Advanced in Infragistics Reveal.

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

• Paymo Reporting and Star Schemas in OBIEE

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

• Connect to and Visualize Live Google Forms Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Forms.

• Analyze Bugsnag Data with Power Pivot

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

• Integrate Live Google Sheets Data into Amazon SageMaker Canvas with RDS

  Use CData Connect AI to connect to Google Sheets from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Sheets.

• How to Query Live HBase Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Apache HBase data in natural language using Python.

• Build a Simple VCL Application for ChargeOver Data

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

• How to connect to Aircall Data from Spring Boot

  Connect to Aircall in a Spring Boot Application using the CData API Driver for JDBC

• Integrating GitHub Copilot CLI with Bullhorn CRM 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 ODBC Driver for Aircall in MicroStrategy Desktop

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

• Prepare, Blend, and Analyze Amazon S3 Data in Alteryx Designer (ODBC)

  Build workflows to access live Amazon S3 for self-service data analytics.

• DataBind Charts to PolarTeamPro Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to PolarTeamPro from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

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

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

• How to Easily Query Google Search Results in OpenOffice Base

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

• Integrate Email Data in the Pentaho Report Designer

  Publish reports based on Email in the Pentaho BI tool.

• Moving Data from SendPulse to SQL Server Using Toad Data Point and CData ODBC Driver

  Query, export, and automate live SendPulse data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.

• Seamlessly Bring SAS xpt Data into Retool Using CData Connect AI

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

• Replicate Multiple Wrike Accounts via the CData Sync CLI

  Replicate multiple Wrike accounts to one or many databases.

• Connect to Helpscout 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 Helpscout and work with Helpscout in your FileMaker application.

• Connecting GenSpark with SAP Ariba Source Data via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP Ariba Source without any replication or custom integration required.

• Easily Integrate MessageBird Data in Lazarus Pascal IDE

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

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

  Execute MySQL queries against ActiveCampaign from Node.js.

• Build a Simple VCL Application for Twitter Ads Data

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

• Integrating GitHub Copilot CLI with HubSpot 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 Connect to Live GitLab Data from OpenAI Python Applications (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your GitLab through natural language.

• Getting Started with the CData Power BI Connector for BigQuery

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

• Automated Continuous Microsoft Dataverse Replication to Oracle

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

• Automate Optimizely Data Replication to Azure Data Lake

  Use CData Sync to customize and automate Optimizely replication to Azure Data Lake.

• Getting Started with the CData Connect AI Python SDK for SingleStore

  Install the CData Connect AI Python SDK to read and write live SingleStore with standard DB-API 2.0 Python code.

• Build a Simple VCL Application for Zoho Books Data

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

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

• Automated Continuous Oracle HCM Cloud Replication to MySQL

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

• Replicate Multiple Reckon Accounts Hosted Accounts via the CData Sync CLI

  Replicate multiple Reckon Accounts Hosted accounts to one or many databases.

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

• Connect to ADP Data as a SQL Server Linked Server

  Use CData Connect AI to create a linked server for live ADP.

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

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

• How to connect to Airtable Data in DBVisualizer

  Integrate Airtable with visual data analysis tools and data connection wizards in DBVisualizer

• Automated Continuous AdRoll Replication to Google BigQuery

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

• Query Unbounce Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against Unbounce from Node.js.

• Error: Architecture Mismatch

  This entry describes a solution for Architecture Mismatch errors that may occur in various tools.

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

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

• How to Query TigerGraph Data in MySQL Workbench

  Execute MySQL queries against live TigerGraph from MySQL Workbench.

• Integrate Sage 200 Data in the Pentaho Report Designer

  Publish reports based on Sage 200 in the Pentaho BI tool.

• How to connect to Redshift Data from IntelliJ

  Integrate connectivity to Amazon Redshift with wizards in IntelliJ.

• How to connect to Google Campaign Manager 360 Data with Squirrel SQL client

  Connect to Google Campaign Manager 360 and execute queries in the Squirrel SQL Client.

• How to connect to ConstantContact Data from IntelliJ

  Integrate connectivity to ConstantContact with wizards in IntelliJ.

• Use Databricks Agent Bricks to Talk to Your Google Contacts Data via CData Connect AI

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

• Access Authorize.Net Data from MySQL in Amazon QuickSight

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

• Build Excel Online-Powered Applications in GitHub Copilot with CData MCP Server

  Use the CData MCP Server for Excel Online to explore live Excel Online Data in GitHub Copilot to assist with building Excel Online-powered applications.

• How to connect SharePoint with MongoDB Data through external lists

  Provide MongoDB to SharePoint users as an external list.

• How to Access Insightly Data Using Entity Framework

  This article shows how to access Insightly using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

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

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

• Automated Continuous JotForm Replication to Google BigQuery

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

• Use the CData Software JDBC Driver for Quaderno in MicroStrategy

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

• Connect to Azure Table Data in RazorSQL

  Connect to Azure Table from wizards and query Azure Table Storage from the GUI in the RazorSQL database management tool.

• Visualize Live Act-On Data in Power BI (via CData Connect AI)

  Use the CData Power BI Connector and CData Connect AI to integrate live Act-On into custom reports in Power BI.

• Getting Started with the CData JDBC Driver for WordPress

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

• Getting Started with the CData Connect AI Python SDK for MongoDB

  Install the CData Connect AI Python SDK to read and write live MongoDB with standard DB-API 2.0 Python code.

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

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

• How to Build an ETL App for Sybase IQ Data in Python with CData Connect AI

  Build ETL pipelines that read and write live Sybase IQ in Python with petl and the CData Connect AI Python SDK.

• Integrate Real-Time Access to MYOB AccountRight in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to MYOB AccountRight in real time.

• Build MVC Applications with Connectivity to Google Spanner Data

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

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

  Execute MySQL queries against Paddle from Node.js.

• Use CData Connect AI to Access ActiveCampaign Data in Microsoft Power Pivot

  Use CData Connect AI to connect to live ActiveCampaign in the Power Pivot business intelligence tool.

• Integrating GitHub Copilot CLI with SAP ERP/NetWeaver 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 Salesforce Pardot-Connected ETL Processes in Google Data Fusion

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

• Connect and Query Live Freshdesk Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live Freshdesk into Databricks

• Integrate SAP Fieldglass Data in Pentaho Data Integration

  Build ETL pipelines based on SAP Fieldglass in the Pentaho Data Integration tool.

• «
• 968
• 969
• 970
• 971
• 972
• 973
• 974
• 975
• 976
• 977
• »