CData Software - Knowledge Base

Recent Articles

• «
• 252
• 253
• 254
• 255
• 256
• 257
• 258
• 259
• 260
• 261
• »

• Import WooCommerce into Microsoft Power Query

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

• Replicate Bing Ads to Multiple Databases

  Replicate Bing Ads to disparate databases with a point-and-click configuration.

• Bridge Azure Analysis Services Connectivity with Apache NiFi

  Access and process Azure Analysis Services in Apache NiFi using the CData JDBC Driver.

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

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

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

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

• Create Informatica Mappings From/To a JDBC Data Source for BigCommerce

  Create BigCommerce data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Connect to Sage 50 UK in Jaspersoft Studio

  Execute SQL to remote Sage 50 UK in Jaspersoft Studio.

• Connect to MarkLogic from Blazor Apps

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

• ETL Gmail in Oracle Data Integrator

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

• Query ClickUp through ODBC in Node.js

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

• Automate QuickBooks Online Integration Tasks from PowerShell

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

• How to Work with Teradata in ETL Validator JDBC

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

• Automated Continuous Box Replication to MySQL

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

• Edit and Search Act CRM External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of Act CRM to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Act CRM objects that you can access from apps and the dashboard.

• How to connect and process Apache HBase from Azure Databricks

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

• Connect to SQL Analysis Services from PowerBuilder via ADO.NET

  This article demonstrates how to access SQL Analysis Services from Appeon PowerBuilder using the CData ADO.NET Provider for SQL Analysis Services.

• Create Sansan-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Sansan from OutSystems and build custom enterprise apps using live Sansan.

• Connect to Azure Data Catalog in Jaspersoft Studio

  Execute SQL to remote Azure Data Catalog in Jaspersoft Studio.

• Connect to PostgreSQL in Google Apps Script via Connect Cloud

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

• Integrate Cosmos DB in the Pentaho Report Designer

  Publish reports based on Azure Cosmos DB in the Pentaho BI tool.

• Query ServiceNow in DataGrip

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

• Create Apps from Microsoft Dataverse in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Microsoft Dataverse and build apps from live Microsoft Dataverse (CDS) in Qlik Sense Cloud.

• Integrate Real-Time Access to Oracle SCM in SAPUI5 MVC Apps

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

• Build Data Flows from SuiteCRM to SQL Server using SSIS

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

• Build a Simple VCL Application for Pinterest

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

• Create Zoho Creator-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Zoho Creator from OutSystems and build custom enterprise apps using live Zoho Creator.

• How to load Epicor Kinetic data into Elasticsearch via Logstash

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

• Connect to ShipStation in CloverDX (formerly CloverETL)

  Transfer ShipStation using the visual workflow in the CloverDX data integration tool.

• Automated Continuous Printful Replication to AlloyDB

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

• Automated Continuous Sugar CRM Replication to Google BigQuery

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

• How to Query FHIR in MySQL Workbench

  Execute MySQL queries against live FHIR from MySQL Workbench.

• Create Exact Online-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Exact Online from Klipfolio and build custom visualizations using live Exact Online.

• Bridge Phoenix Connectivity with Apache NiFi

  Access and process Apache Phoenix in Apache NiFi using the CData JDBC Driver.

• Integrate Live Instagram into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Instagram and integrate live Instagram into apps built in Microsoft Power Apps.

• How to Import Data from Excel into Google Sheets

  Import Microsoft Excel into a Google spreadsheet that is automatically refreshed.

• How to connect Amazon QuickSight to ActiveCampaign

  Create a connection to ActiveCampaign in CData Connect Cloud and insert ActiveCampaign into Amazon QuickSight SPICE to build interactive dashboards.

• Create Google Contacts-Connected Applications in Appsmith

  Connect to Google Contacts via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Google Contacts.

• Access Live Salesforce Marketing in Excel 365 Online (Excel for the web)

  Connect to Salesforce Marketing Cloud from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Build Dashboards with Act-On in Dundas BI

  Create dynamic dashboards and perform analytics based on Act-On in Dundas BI.

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

  This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.

• How to connect and process Shopify from Azure Databricks

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

• Integrate with live Zendesk in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Zendesk in Jitterbit.

• Connect and Visualize Live BigCommerce Data in Databricks Lakehouse Federation with CData Connect Cloud

  Use CData Connect Cloud to integrate live BigCommerce into the Databricks platform and create visualization dashboards with real-time BigCommerce.

• Provide OData Services of SAS Data Sets from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for SAS Data Sets by developing a WCF Service Application.

• Excel Spreadsheet Automation on Sybase IQ with the QUERY Formula

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

• Visualize Google Campaign Manager 360 from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Google Campaign Manager 360.

• Access SuiteCRM from MySQL in PHP

  Connect to SuiteCRM through the standard MySQL libraries in PHP.

• Enable the Google Calendar JDBC Driver in KNIME

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

• Connect to Google Campaign Manager 360 in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Google Campaign Manager 360 in Google Apps Script.

• Connect to ADP in Ruby

  Connect to ADP in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Process & Analyze Instagram in Databricks (AWS)

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

• Create Dynamic Sage Cloud Accounting Grids Using the Infragistics XamDataGrid

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

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

  Connect to Google AlloyDB in MicroStrategy Web using the CData Software JDBC Driver for AlloyDB.

• Perform Batch Operations with Microsoft Project in Apache NiFi

  Connect to Microsoft Project and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Automated Continuous Printful Replication to IBM DB2

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

• Build Blackbaud FE NXT-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Blackbaud FE NXT from Zoho Analytics and import live Blackbaud FE NXT.

• Build Oracle HCM Cloud-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Oracle HCM Cloud from Choreo and build custom apps using live Oracle HCM Cloud.

• Analyze GraphQL in R via JDBC

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

• Connect to xBase in HULFT Integrate

  Connect to xBase as a JDBC data source in HULFT Integrate

• Connect to Oracle HCM Cloud from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Oracle HCM Cloud to connect to Oracle HCM Cloud from Web applications running on WebLogic.

• Build Pinterest-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Pinterest and build web apps with connectivity to live Pinterest.

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

  Easily push BambooHR to Google BigQuery using the CData SSIS Tasks for BambooHR and Google BigQuery.

• How to create an RPA flow for SAP Concur in UiPath Studio

  Use the SAP Concur ODBC Driver to create workflows that access real-time SAP Concur without any coding.

• Sync Google Contacts with QuickBooks

  The CData ADO.NET Providers offer an easy way to integrate with different data sources. This article walks through the downloadable, fully functional application that can be used to synchronize contacts between Google and QuickBooks.

• Excel Spreadsheet Automation on Exact Online with the QUERY Formula

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

• Access Live Cassandra in Coginiti Pro

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

• Easily Integrate SAP Ariba Source in Lazarus Pascal IDE

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

• Use the CData ODBC Driver for Hive in Microsoft Power Query

  You can use the CData Hive ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Apache Hive into Microsoft Power Query.

• Connect to Amazon Marketplace as an External Source in Dremio

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

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

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

• How to connect to Google Search Results from IntelliJ

  Integrate connectivity to Google Search with wizards in IntelliJ.

• Access JSON Services as a Remote Oracle Database

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

• Replicate Multiple SAP Concur Accounts via the CData Sync CLI

  Replicate multiple SAP Concur accounts to one or many databases.

• Work with Blackbaud FE NXT in FoxPro

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

• How to publish and share Amazon Athena dashboards with Tableau Server

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

• Use the CData Software ODBC Driver for SAP Hybris C4C in MicroStrategy

  Connect to SAP Hybris C4C in MicroStrategy Developer using the CData Software ODBC Driver for SAP Hybris C4C.

• Import Office 365 Using Azure Data Factory

  Use CData Connect Cloud to connect to Office 365 from Azure Data Factory and import live Microsoft Office 365.

• Create Oracle Financials Cloud Dataflows on PowerBI.com

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

• How to Build an ETL App for GitHub in Python with CData

  Create ETL applications and real-time data pipelines for GitHub in Python with petl.

• How to publish and share Sage 300 dashboards with Tableau Server

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

• Establish a Live Connection with Authorize.Net using Tableau Bridge

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

• How to create an RPA flow for Printify in UiPath Studio

  Use the Printify ODBC Driver to create workflows that access real-time Printify without any coding.

• Building Dynamic Web Pages with Microsoft OneDrive Using AngularJS

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

• Automate SAS xpt Tasks in Power Automate Using CData API Server

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

• How to Access Sybase IQ Using Entity Framework

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

• Query Twilio through ODBC in Node.js

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

• How to Access Live Basecamp in Visual Studio Code via Cline

  Run the CData MCP Server for Basecamp on Windows Subsytem for Linux (WSL) and connect to live Basecamp from the Cline extension in Visual Studio Code.

• Connect to SAP SuccessFactors as an External Source in Dremio

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

• Prepare, Blend, and Analyze Google Sheets in Alteryx Designer (Connect Cloud)

  Build workflows to access live Google Sheets for self-service data analytics.

• Stream HubSpot into Apache Kafka Topics

  Access and stream HubSpot in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Operational Reporting on GraphQL from Spotfire Server

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

• Automated Continuous Excel Online Replication to MongoDB

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

• Use the CData Software ODBC Driver for MYOB AccountRight in MicroStrategy

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

• Edit and Search External Microsoft Dataverse Objects in Salesforce Connect

  Use CData Connect Cloud to securely provide OData feeds of Microsoft Dataverse (CDS) to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Microsoft Dataverse objects that you can access from apps and the dashboard.

• Query CouchDB in DataGrip

  Create a Data Source for CouchDB in DataGrip and use SQL to query live Apache CouchDB.

• Automated Continuous HDFS Replication to AlloyDB

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

• DataBind Controls to DocuSign in C++Builder

  DataBind to DocuSign in C++Builder with standard components and controls.

• Analyze ShipStation in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of ShipStation and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

• Connect to BigCommerce from PowerBuilder via ODBC

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

• Connect to Real-Time Unbounce Data in Power Apps Using Dataflows to Build Custom Applications

• «
• 252
• 253
• 254
• 255
• 256
• 257
• 258
• 259
• 260
• 261
• »