CData Software - Knowledge Base

Recent Articles

• «
• 358
• 359
• 360
• 361
• 362
• 363
• 364
• 365
• 366
• 367
• »

• Back Up Smartsheet to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Smartsheet. In this article, we will employ an SSIS workflow to populate a database with Smartsheet data.

• Connect Reckon Accounts Hosted to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Reckon Accounts Hosted using the CData Python MCP Server.

• Automated Continuous MarkLogic Replication to PostgreSQL

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

• Connect to Microsoft Exchange from Blazor Apps

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

• Import and Visualize Splunk in Power View

  Create data visualizations based on Splunk in Excel.

• Automated Continuous TaxJar Replication to MongoDB

  Use CData Sync for automated, continuous, customizable TaxJar replication to MongoDB.

• Connect Jira Assets to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

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

• Connect to SAP HANA in SpagoBI

  Create reports featuring live SAP HANA in SpagoBI Studio. Host SAP HANA reports on SpagoBI Server.

• Import and Visualize Monday.com in Power View

  Create data visualizations based on Monday.com in Excel.

• How to connect SharePoint with SAP BusinessObjects BI through external lists

  Provide SAP BusinessObjects BI to SharePoint users as an external list.

• Extend Google Sheets with Azure Data Lake Storage

  Make calls to the API Server from Google Apps Script.

• How to update Adobe Commerce from Excel

  This article explains how to transfer data from Excel to Adobe Commerce using the Excel Add-In for Adobe Commerce.

• Use the CData Software ODBC Driver for HubDB in MicroStrategy

  Connect to HubDB in MicroStrategy Developer using the CData Software ODBC Driver for HubDB.

• Build Dashboards with Cassandra in DBxtra

  Create dynamic dashboards and perform analytics based on Apache Cassandra in DBxtra.

• Model, Search, and Visualize Live Sage Intacct in ThoughtSpot

  Use CData Connect Cloud to connect to live Sage Intacct for modeling, searching, and visualizing.

• Query Quickbase from Node.js

  Use the OData endpoint of the CData API Server to connect to your Quickbase and perform CRUD operations on Quickbase from Node.js.

• Automate Pipedrive Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Pipedrive and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Bind Live Certinia Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Certinia data

• Use the CData Software ODBC Driver for Adobe Commerce in MicroStrategy Desktop

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

• Automated Continuous Google Ad Manager Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Apache Cassandra.

• Query HubDB in ColdFusion

  Write standard ColdFusion data access code to connect to HubDB.

• Bind Live Neo4J Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Neo4J data

• Connect to Basecamp from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Basecamp to connect to Basecamp and execute queries in PowerBuilder.

• Access Live Todoist in Coginiti Pro

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

• Extend Google Sheets with Cosmos DB

  Make calls to the API Server from Google Apps Script.

• Query NetSuite as a MySQL Database in Node.js

  Execute MySQL queries against NetSuite CRM & ERP from Node.js.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for SendGrid

  Provide connectivity to SendGrid through an SAP BusinessObjects universe.

• How to Connect to SurveyMonkey in Using Python: 6 Steps

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

• Extract, Transform, and Load Splunk in Informatica PowerCenter

  Create a simple Workflow for Splunk in Informatica PowerCenter.

• Analyze Office 365 in Cognos Analytics

  Use CData Connect Cloud to connect to Office 365 from Cognos Analytics and analyze live Microsoft Office 365.

• Object-Relational Mapping (ORM) with Zendesk Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Zendesk into a Java-based ORM framework, Hibernate.

• Automate ActiveCampaign Replication to Azure Synapse

  Use CData Sync to customize and automate ActiveCampaign replication to Azure Synapse.

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

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

• How to Build an ETL App for Oracle Service Cloud in Python with CData

  Create ETL applications and real-time data pipelines for Oracle Service Cloud in Python with petl.

• Connect to Zoho Creator in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Zoho Creator in the Denodo Virtual DataPort Administrator.

• Connect to Kintone in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Kintone in Google Apps Script.

• Build Azure DevOps-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Azure DevOps from Zoho Analytics and import live Azure DevOps.

• Use the CData Software JDBC Driver for Aha in MicroStrategy

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

• Back Up Bing Ads to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Bing Ads. In this article, we will employ an SSIS workflow to populate a database with Bing Ads data.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP Concur

  Provide connectivity to SAP Concur through an SAP BusinessObjects universe.

• Create Dashboards and Visualize Live SAP BusinessObjects BI in Geckoboard

  Use CData Connect Cloud to connect to live SAP BusinessObjects BI and create dashboards for real-time monitoring and visualization in Geckoboard.

• DataBind Oracle Eloqua to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Oracle Eloqua with the DevExpress Windows Forms and Web controls to provide Oracle Eloqua to a chart.

• Import ClickUp into Microsoft Power Query

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

• Build Data Flows from Sage 50 UK to SQL Server using SSIS

  Easily back up Sage 50 UK to SQL Server using the SSIS components for Sage 50 UK.

• Query TaxJar from Node.js

  Use the OData endpoint of the CData API Server to connect to your TaxJar and perform CRUD operations on TaxJar from Node.js.

• Automated Continuous SAP Netweaver Gateway Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to Google BigQuery.

• Analyze GitHub in Looker

  Use CData Connect Cloud to connect to GitHub from Looker and build custom apps using live GitHub.

• How to Work with Typeform in AWS Glue Jobs Using JDBC

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

• Access Live Google Analytics in Google Sheets through Connect Spreadsheets

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

• How to Connect to & Open SAP ByDesign in Microsoft Excel

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

• Automated Continuous Google Campaign Manager 360 Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to OneLake in Microsoft Fabric.

• Import Couchbase into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Couchbase and provide access to live Couchbase for custom reports in the Power BI Service.

• Visualize Live Pipedrive in Tableau

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

• Access Live Dynamics CRM in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Microsoft Dynamics CRM from your Google Sheets.

• Automated Continuous Microsoft Project Replication to PostgreSQL

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

• Build a Simple VCL Application for Gmail

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

• Integrate GraphQL into Power Automate Desktop using CData Connect

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

• Query Trello as a SQL Server Database in Node.js

  Execute SQL Server queries against Trello from Node.js.

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

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

• DataBind Charts to Authorize.Net

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Authorize.Net 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.

• Connect to Smartsheet from Blazor Apps

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

• Query Authorize.Net in DataGrip

  Create a Data Source for Authorize.Net in DataGrip and use SQL to query live Authorize.Net.

• Automate Tasks in Power Automate Using the CData API Server

  Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.

• Import Real-Time Cvent via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Cvent in ColdFusion.

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

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

• Extend Google Sheets with Google Contacts

  Make calls to the API Server from Google Apps Script.

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

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

• Add JotForm to Informatica Enterprise Data Catalog

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

• How to Connect to Live Splunk in n8n Workflows and Agents (via CData Connect Cloud)

  Leverage the CData Connect Cloud Remote MCP Server to enable n8n to securely read and take actions on your Splunk for you.

• Create GMO MakeShop-Connected Nintex Workflows

  Use CData Connect Cloud to connect to GMO MakeShop from Nintex Workflow Cloud and build custom workflows using live GMO MakeShop.

• Stream Office 365 into Apache Kafka Topics

  Access and stream Microsoft Office 365 in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Create Snowflake-Connected Nintex Workflows

  Use CData Connect Cloud to connect to Snowflake from Nintex Workflow Cloud and build custom workflows using live Snowflake.

• Extract, Transform, and Load PingOne in Informatica PowerCenter

  Create a simple Workflow for PingOne in Informatica PowerCenter.

• Enable the AlloyDB JDBC Driver in KNIME

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

• Connect to Zoho Inventory in Claris FileMaker Pro

• «
• 358
• 359
• 360
• 361
• 362
• 363
• 364
• 365
• 366
• 367
• »