CData Software - Knowledge Base

Recent Articles

• «
• 480
• 481
• 482
• 483
• 484
• 485
• 486
• 487
• 488
• 489
• »

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

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

• Integrate Bitbucket with External Services using SnapLogic

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

• Build Zoho Creator-Connected Apps in Bubble

  Use CData Connect Cloud to create an OData feed for Zoho Creator and create custom apps in Bubble.

• Connect to Pipedrive from PowerBuilder via ODBC

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

• Extend Google Sheets with Unbounce

  Make calls to the API Server from Google Apps Script.

• Load Greenplum to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Pivotal GreenPlum to a database.

• How to connect to ServiceNow with Squirrel SQL client

  Connect to ServiceNow and execute queries in the Squirrel SQL Client.

• How to connect to Active Directory from Spring Boot

  Connect to Active Directory in a Spring Boot Application using CData JDBC Active Directory Driver

• Build PCA Sales-Connected Apps in Choreo

  Use CData Connect Cloud to connect to PCA Sales from Choreo and build custom apps using live PCA Sales.

• Access Live Blackbaud FE NXT in Excel (Desktop) via Connect Cloud

  Use CData Connect Cloud to gain access to live Blackbaud FE NXT from your Excel spreadsheets.

• Create Power BI Reports on Real-Time Highrise

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

• Build a Singer.io Tap for ADP With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live ADP data using

• Build Salesforce Pardot-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Salesforce Pardot from Choreo and build custom apps using live Salesforce Pardot.

• Use the CData Software JDBC Driver for SuiteCRM in MicroStrategy

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

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

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

• Automate Google Cloud Storage Integration Tasks from PowerShell

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

• Connect to Slack in CloverDX (formerly CloverETL)

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

• Build CockroachDB Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live CockroachDB and build visualizations in Tableau.

• Connect to and Query Oracle Service Cloud in QlikView over ODBC

  Create data visualizations with Oracle Service Cloud in QlikView.

• Connect to SharePoint Excel Services in HULFT Integrate

  Connect to SharePoint Excel Services as a JDBC data source in HULFT Integrate

• How to connect PolyBase to Square

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

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

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

• Analyze TaxJar in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze TaxJar in Microsoft R Open.

• Integrate with YouTube Analytics in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live YouTube Analytics in SnapLogic.

• How to connect and process Shippo from Azure Databricks

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

• Automate Wave Financial Integration Tasks from PowerShell

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

• How to pipe Greenplum to CSV in PowerShell

  Use standard PowerShell cmdlets to access Greenplum tables.

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

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

• Query Calendly in ColdFusion

  Write standard ColdFusion data access code to connect to Calendly.

• How to Seamlessly Import Oracle Sales Data into IBM SPSS Modeler

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

• Create Cassandra-Connected Nintex Workflows

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

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

  Use CData ODBC drivers to import and use Zoho CRM in ColdFusion.

• Integrate with Live Paylocity in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Paylocity from the MuleSoft Anypoint Platform to integrate live Paylocity into custom reports and dashboards.

• Query Authorize.Net through ODBC in Node.js

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

• How to create Visio diagrams from AlloyDB

  Automatically update Google AlloyDB with the changes you make to Visio master shapes.

• A PostgreSQL Interface for Microsoft Dataverse (MySQL Remoting via JDBC)

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

• Design BIRT Reports on PingOne

  Provide current PingOne to your embedded analytics.

• Automated Continuous Freshdesk Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Freshdesk replication to Apache Cassandra.

• Creating SAP ByDesign-Connected Applications in Unqork

  You can use CData Connect Cloud to feed SAP Business ByDesign to Unqork and build custom business apps.

• Create Instagram-Connected Applications in Appsmith

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

• How to create Pipedrive federated tables in MySQL

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

• Manage Salesforce in DBArtisan as a JDBC Source

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

• Automated Continuous Pinterest Replication to Oracle

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

• Use the CData Software ODBC Driver for SAP HANA XS Advanced in SAS for Real-Time Reporting and Analytics

  Connect to real-time SAP HANA XS Advanced in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP HANA XS Advanced.

• Create QuickBooks Online-Connected Applications in Appsmith

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

• Create Stripe-Connected Visualizations in Klipfolio

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

• Write a Simple Go Application to work with Square on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Square.

• Automated Continuous Salesforce Replication to IBM DB2

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

• Create Square-Connected Nintex Workflows

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

• ETL SAP ByDesign in Oracle Data Integrator

  This article shows how to transfer SAP Business ByDesign into a data warehouse using Oracle Data Integrator.

• Automated Continuous HubSpot Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable HubSpot replication to Amazon S3.

• Replicate Multiple Microsoft Dataverse Accounts

  Replicate multiple Microsoft Dataverse accounts to one or many databases.

• Automated Continuous Zoho Books Replication to SQL Server

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

• Design BIRT Reports on Printify

  Provide current Printify to your embedded analytics.

• Connect to Excel from a Connection Pool in JBoss

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

• Automated Continuous AlloyDB Replication to Amazon S3

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

• How to connect to Email from IntelliJ

  Integrate connectivity to Email with wizards in IntelliJ.

• Automated Continuous Amazon S3 Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Amazon S3 replication to OneLake in Microsoft Fabric.

• How to Connect to & Open Google Contacts in Microsoft Excel

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

• Create Informatica Mappings From/To an ODBC Data Source for Google Campaign Manager 360

  Create an ODBC connection to Google Campaign Manager 360 in Informatica and browse and transfer Google Campaign Manager 360.

• Work with Box in FoxPro

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

• Build Azure Data Catalog-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Azure Data Catalog and build web apps with connectivity to live Azure Data Catalog.

• PowerShell Scripting to Replicate SFTP to MySQL

  Write a simple PowerShell script to replicate SFTP to a MySQL database.

• Use the CData ODBC Driver for SAP HANA XS Advanced from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for SAP HANA XS Advanced to connect to SAP HANA XS Advanced from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP HANA XS Advanced in Excel.

• Automated Continuous Oracle HCM Cloud Replication to PostgreSQL

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

• Connect to Live AlloyDB in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to AlloyDB in CData Connect Cloud and connect to your Google AlloyDB from PostgreSQL.

• Visualize Google Data Catalog in Tableau

  The CData ODBC driver for Google Data Catalog enables you integrate Google Data Catalog into Tableau dashboards.

• Build an OLAP Cube in SSAS from Authorize.Net

  Establish a connection to Authorize.Net data from SQL Server Analysis Services, and use the Authorize.Net Data Provider to build OLAP cubes for use in analytics and reporting.

• Integrate Microsoft Planner into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Microsoft Planner and integrate live Microsoft Planner into your Power Automate tasks.

• How to connect to Oracle HCM Cloud in DBVisualizer

  Integrate Oracle HCM Cloud with visual data analysis tools and data connection wizards in DBVisualizer

• Create Dynamic Zoho Inventory Grids Using the Infragistics XamDataGrid

  Learn how you can connect Zoho Inventory to Infragistics XamDataGrid to build dynamic grids.

• Integrate Live Jira Service Management into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Jira Service Management from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Atlassian Jira Service Management.

• Build Freshdesk-Connected ETL Processes in Google Data Fusion

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

• Analyze Google Data Catalog in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Google Data Catalog and visualize live Google Data Catalog in Ingragistics Reveal.

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

  Connect to Monday.com 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.

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

  Connect to ClickUp 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.

• How to update Exact Online from Excel

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

• Connect to Slack from Asprova with CData Software ODBC Driver for Slack

  This article shows how to connect faster to Slack data from Asprova.

• Natively Connect to ConstantContact in PHP via ODBC (Linux)

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

• Query Google Data Catalog using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Google Data Catalog entities in PHP by modeling them as objects.

• Access Smartsheet from MySQL in HeidiSQL

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

• Create Datasets from Oracle SCM in Domo Workbench and Build Visualizations of Oracle SCM in Domo

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

• Connect to SharePoint from PowerBuilder via ODBC

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

• Automated Continuous Freshdesk Replication to SingleStore

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

• Connect to Typeform in CloverDX (formerly CloverETL)

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

• Visualize Excel Online in Sisense

  Create an ElastiCube in Sisense app with access to Microsoft Excel Online.

• DataBind Charts to Bullhorn CRM

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

• Integrate Real-Time Access to Salesforce Marketing in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Salesforce Marketing Cloud in real time.

• How to Connect to & Open JSON Services in Microsoft Excel

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

• Connect to Act CRM in CloverDX (formerly CloverETL)

  Transfer Act CRM using the visual workflow in the CloverDX data integration tool.

• Integrating SFTP in Talend Cloud Data Management Platform

• «
• 480
• 481
• 482
• 483
• 484
• 485
• 486
• 487
• 488
• 489
• »