CData Software - Knowledge Base

Recent Articles

---

• «
• 303
• 304
• 305
• 306
• 307
• 308
• 309
• 310
• 311
• 312
• »

• Automated Continuous SAP HANA XS Advanced Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Google BigQuery.

• Model Adobe Analytics Data Using Azure Analysis Services

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

• Automate MessageBird Integration Tasks from PowerShell

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

• Connect SAP BusinessObjects BI Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your SAP BusinessObjects BI using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Build Dashboards with Helpscout Data in Dundas BI

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

• Use the CData SSIS Components to Insert New or Update Existing Kintone Records from SQL Server

  Easily push SQL Server data to Kintone using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Kintone or update existing records with data from a SQL Server database.

• Getting Started with the CData Python Connector for Zoho Creator

  Learn to install and license the CData Python Connector

• How to Connect to Live CSV Data in Mistral AI Workflows

  Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live CSV/TSV Files without replication.

• Add AdRoll Data to Informatica Enterprise Data Catalog

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

• Automated Continuous Email Replication to SQLite

  Use CData Sync for automated, continuous, customizable Email replication to SQLite.

• How to Work with Sybase IQ Data in AWS Glue Jobs Using JDBC

  Connect to Sybase IQ from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Build Sage Intacct Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live Sage Intacct and build visualizations in Tableau.

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

• Use CData Connect AI to Access SAP BusinessObjects BI Data in Microsoft Power Pivot

  Use CData Connect AI to connect to live SAP BusinessObjects BI in the Power Pivot business intelligence tool.

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

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

• Build Visualizations of Delighted Data in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Delighted in Birst.

• A PostgreSQL Interface for Microsoft OneDrive Data using the CData ODBC Driver

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

• Use the CData SSIS Components to Insert New or Update Existing REST Records from SQL Server

  Easily push SQL Server data to REST using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into REST or update existing records with data from a SQL Server database.

• Integrating Codex CLI with Bannerbear 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 SAS xpt-Connected Business Apps in AppSheet

  Connect to SAS xpt Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAS XPORT.

• Build Data Flows from Cohere to SQL Server using SSIS

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

• Create Reports with Beeminder Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Beeminder.

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

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

• How to integrate Metabase with Azure DevOps Data

  Use CData Connect AI to connect to live Azure DevOps and create an interactive dashboard in Metabase from Azure DevOps.

• Visualize Live Deel Data of Power BI Report Builder in Power BI Service

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

• Integrating Dataiku with Adobe Analytics Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Adobe Analytics.

• Integrate JSON Services in Pentaho Data Integration

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

• Rapidly Develop Perigon-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 Perigon.

• Connect to Authorize.Net Data from a Connection Pool in JBoss

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

• Analyze Asana Data in R via JDBC

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

• Create Workable Dataflows on PowerBI.com

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

• Analyze Microsoft Exchange Data in Infragistics Reveal

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

• How to Easily Query ClickTime Data in OpenOffice Base

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

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

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

• How to Connect DBeaver to Azure Table via a JDBC Driver

  Manage Azure Table Storage with visual tools in DBeaver like the query browser.

• Access Live Oracle SCM Data in TIBCO Data Virtualization

  Use the Oracle SCM Tibco DV Adapter to create a Oracle SCM data source in TIBCO Data Virtualization Studio and gain access to live Oracle SCM from your TDV Server.

• Process & Analyze Apify Data in Databricks (AWS)

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

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

  Provide connectivity to Google Translate through an SAP BusinessObjects universe.

• Integrate with ADP Data using Apache Camel2

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

• Getting Started with the CData JDBC Driver for MySQL

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

• Migrating data from Gong to Snowflake using CData SSIS Components.

  Easily push Gong to Snowflake using the CData SSIS Tasks for Gong and Snowflake.

• Integrate Theia IDE with Live Blackbaud FE NXT Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Theia IDE

• Connect to PolarTeamPro in SpagoBI

  Create reports featuring live PolarTeamPro in SpagoBI Studio. Host PolarTeamPro reports on SpagoBI Server.

• Connecting Mastra with Oracle Data via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Oracle Database, no replication required.

• How to Connect DBeaver to SAP Concur via a JDBC Driver

  Manage SAP Concur with visual tools in DBeaver like the query browser.

• Connect to CloudConvert Data in Claris FileMaker Pro

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

• How to Access Testmonitor Data Using Entity Framework

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

• Getting Started with the CData Connect AI Python SDK for Microsoft Dataverse

  Install the CData Connect AI Python SDK to read and write live Microsoft Dataverse (CDS) with standard DB-API 2.0 Python code.

• Write a Simple Go Application to work with Google Campaign Manager 360 Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Campaign Manager 360.

• Access Live Salesforce CRM Analytics Data in Emergent via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Salesforce CRM Analytics through MCP integration.

• Access Live Twilio Data in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Twilio into the statistical analysis tools available in SAS JMP. This article shows how to use Twilio in the Graph Builder and Query Builder.

• Excel Spreadsheet Automation on OneNote Data with the QUERY Formula

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

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

  Use LlamaIndex to query live Microsoft Dataverse (CDS) data in natural language using Python.

• Connect to Autopilot Data as an External Source in Dremio

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

• How to connect and process Couchbase from Azure Databricks

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

• ETL Parquet in Oracle Data Integrator

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

• Access Gong Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Gong from your Oracle system.

• Access Live Snowflake Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Snowflake from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Build Power BI XMLA-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live Power BI XMLA.

• Integrate Everhour Data in Your Informatica Cloud Instance

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

• DataBind Controls to Beeminder Data in Delphi

  DataBind to Beeminder in Delphi with standard data access components and controls.

• Integrating OpenCode Terminal with SendInBlue 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 Power BI Reports on Real-Time Act CRM Data

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

• Automated Continuous Zendesk Replication to PostgreSQL

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

• How to Work with Teradata Data in ETL Validator JDBC

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

• Build a PostgreSQL Interface for Cassandra Data using the CData JDBC Driver

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

• Integrate Dynamics 365 Business Central Data in Pentaho Data Integration

  Build ETL pipelines based on Dynamics 365 Business Central in the Pentaho Data Integration tool.

• Use the CData Software ODBC Driver for Wave Financial in MicroStrategy Desktop

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

• Build MVC Applications with Connectivity to Miro Data

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

• Use JayDeBeApi to access Quickbase Data in Python

  Use standard Python scripting and the development environment of your choice to access live Quickbase.

• Access Live Dynamics 365 Data in AWS Lambda (with IntelliJ IDEA)

  Connect to live Microsoft Dynamics 365 in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• How to Connect to Live Dynamics CRM Data from crewAI Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Microsoft Dynamics CRM for you.

• Access Live Brex Data in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Brex into the statistical analysis tools available in SAS JMP. This article shows how to use Brex in the Graph Builder and Query Builder.

• Manage Campaigner Data in DBArtisan as a JDBC Source

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

• Connect to Adobe Analytics in SpagoBI

  Create reports featuring live Adobe Analytics in SpagoBI Studio. Host Adobe Analytics reports on SpagoBI Server.

• How to Work with TigerGraph Data in ETL Validator JDBC

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

• Connect to CircleCI Data from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time CircleCI using standard SQL.

• Use the CData Software ODBC Driver for Microsoft Dataverse in MicroStrategy Web

  Connect to Microsoft Dataverse (CDS) in MicroStrategy Web using the CData Software ODBC Driver for Microsoft Dataverse.

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

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

• Visualize ZohoMarketingHub Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to ZohoMarketingHub.

• Create Harvest Dataflows on PowerBI.com

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

• Visualize Live Planio Data in Tableau

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

• Analyze Vertica Data in Looker

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

• Replicate Bitly Data from PowerShell

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

• Connect Google Spanner Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Google Spanner using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Automated Continuous Reckon Accounts Hosted Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to SingleStore.

• Deploy the ADO.NET Provider for Factorial on an SSRS Report Server

  Connect to Factorial from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Integrate Cline with Live Google Drive Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Drive from within your IDE.

• Connect AdRoll to IBM WebSphere Using the CData JDBC Driver

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

• Create DB2-Connected Nintex Workflows

  Use CData Connect AI to connect to DB2 Data from Nintex Workflow Cloud and build custom workflows using live IBM DB2.

• How to Seamlessly Import Apify Data into IBM SPSS Modeler

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

• Getting Started with the CData Tableau Connector for Moosend

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

• Integrating Codex CLI with Clio 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 Customer.io in SpagoBI

  Create reports featuring live Customer.io in SpagoBI Studio. Host Customer.io reports on SpagoBI Server.

• Integrate Facebook with External Services using SnapLogic

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

• How to load Google Spanner data into Elasticsearch via Logstash

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

• Seamlessly Bring Sybase IQ Data into Retool Using CData Connect AI

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

• Build DB2-Connected Apps in Mendix

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

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

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

• Build Data Flows from Google Forms to SQL Server using SSIS

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

• «
• 303
• 304
• 305
• 306
• 307
• 308
• 309
• 310
• 311
• 312
• »