CData Software - Knowledge Base

Recent Articles

• «
• 332
• 333
• 334
• 335
• 336
• 337
• 338
• 339
• 340
• 341
• »

• How to Query ShipStation in MySQL Workbench

  Execute MySQL queries against live ShipStation from MySQL Workbench.

• Visualize Zoho Projects in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Zoho Projects into TIBCO Spotfire.

• Connect to Dynamics GP in RunMyProcess through Connect Server

  Use CData Connect Server to create an OData API for Dynamics GP and connect to Microsoft Dynamics GP in Akorbi Digital RunMyProcess.

• Import and Visualize Sage Cloud Accounting in Power View

  Create data visualizations based on Sage Business Cloud Accounting in Excel.

• Publish Reports with Dynamics 365 Business Central in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Dynamics 365 Business Central.

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

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

• A PostgreSQL Interface for Cloudant using the CData ODBC Driver

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

• Visualize Live Sage Cloud Accounting in the Power BI Service

  Use CData Connect Cloud to connect to live Sage Business Cloud Accounting and create custom reports in the Power BI Service through the On-Premises Gateway.

• Integrate QuickBooks Time in Your Informatica Cloud Instance

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

• Operational Reporting on Zenefits from Spotfire Server

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

• Publish BigQuery-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Google BigQuery.

• Automated Continuous AlloyDB Replication to OneLake in Microsoft Fabric

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

• Connect to Spark as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Apache Spark SQL.

• Automated Continuous Dynamics GP Replication to MySQL

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

• Load ActiveCampaign to a Database Using Embulk

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

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

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

• Connect to Office 365 in JRuby

  Create a simple JRuby app with access to live Microsoft Office 365.

• Automated Continuous Wave Financial Replication to Oracle

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

• Automated SurveyMonkey Replication to Teradata

  Use CData Sync to Customize and automate SurveyMonkey replication to Teradata.

• Query, Visualize, and Share live SAP BusinessObjects BI in Redash

  Use CData Connect Cloud to connect to live SAP BusinessObjects BI in Redash for querying, visualizing, and sharing.

• Build Facebook Visualizations in Tableau Desktop

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

• Build Semantic Layer Views for Twilio in APOS Live Data Gateway

  Use the CData Connector for Twilio in APOS Live Data Gateway to build Semantic Layer Views for Twilio.

• Create Apps from Stripe in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Stripe and build apps from live Stripe in Qlik Sense Cloud.

• Connect to Excel Online from a Connection Pool in JBoss

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

• Automated Continuous Avro Replication to SQLite

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

• Automated Continuous MarkLogic Replication to OneLake in Microsoft Fabric

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

• Create Data Visualizations in Cognos BI with Todoist

  Access Todoist as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Publish Reports with CouchDB in SAP Crystal Reports

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

• Visualize Klaviyo in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for Klaviyo in CData Software Connect (or Connect Server) and build visualizations from live Klaviyo in Tableau Desktop.

• Connect to Couchbase in the Denodo Platform

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

• Publish Crystal Reports on SAP HANA

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP HANA.

• Automated Continuous Pipedrive Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Pipedrive replication to Amazon Redshift.

• Create Azure DevOps-Connected Nintex Workflows

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

• Build Semantic Layer Views for Cosmos DB in APOS Live Data Gateway

  Use the CData Connector for Cosmos DB in APOS Live Data Gateway to build Semantic Layer Views for Azure Cosmos DB.

• Build LinkedIn Ads-Connected ETL Processes in Google Data Fusion

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

• Visualize Act-On in TIBCO Spotfire through ADO.NET

  Integrate Act-On into dashboards in TIBCO Spotfire.

• Build Semantic Layer Views for ServiceNow in APOS Live Data Gateway

  Use the CData Connector for ServiceNow in APOS Live Data Gateway to build Semantic Layer Views for ServiceNow.

• Connect to Xero from PowerBuilder via ODBC

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

• Connect to Trello as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Trello.

• Automated Continuous Active Directory Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Active Directory replication to Snowflake.

• Establish a Live Connection with SAP HANA XS Advanced using Tableau Bridge

  The CData ODBC Driver for SAP HANA XS Advanced enables you to integrate live SAP HANA XS Advanced into Tableau Cloud dashboards using the Tableau Bridge.

• How to update FTP from Excel

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

• Access Live Google Campaign Manager 360 in SAS JMP via ODBC

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

• Connect to SAP SuccessFactors in Google Apps Script via SQL Gateway

  Use the ODBC Driver for SAP SuccessFactors and the SQL Gateway to access SAP SuccessFactors from Google Apps Script.

• Object-Relational Mapping (ORM) with Procore 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 Procore into a Java-based ORM framework, Hibernate.

• Import and Visualize SAS Data Sets in Power View

  Create data visualizations based on SAS Data Sets in Excel.

• Build a Simple VCL Application for Wave Financial

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

• Integrate with Bullhorn CRM in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Bullhorn CRM in SnapLogic.

• Automate Tally Replication to SAP HANA

  Use CData Sync to customize and automate Tally ERP replication to SAP HANA.

• Integrate with QuickBooks Online in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live QuickBooks Online in SnapLogic.

• Bidirectional Access to Smartsheet from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Smartsheet in Filemaker Pro for Mac or Windows.

• Visualize Live Zoho Inventory of Power BI Report Builder in Power BI Service

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

• Create Facebook-Connected Business Apps in AppSheet

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

• Automate Snowflake Replication to Azure Synapse

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

• Import SAS Data Sets into Microsoft Power Query

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

• Connect to Google Campaign Manager 360 in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Google Campaign Manager 360 in Airbyte.

• Rapidly Develop Exact Online-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• Integrate Live Spark into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Spark from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Apache Spark SQL.

• Build Pipelines with Live Azure Table in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Azure Table from Google Cloud Data Fusion, enabling the integration of live Azure Table Storage into the building and management of effective data pipelines.

• Design BIRT Reports on Google Drive

  Provide current Google Drive to your embedded analytics.

• Import MailChimp into FileMaker Pro

  Create reports that integrate MailChimp in Filemaker Pro.

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

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

• Build a PostgreSQL Interface for Clio using the CData JDBC Driver

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

• Connect to Airtable in JRuby

  Create a simple JRuby app with access to live Airtable.

• Integrate Google Contacts in Pentaho Data Integration

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

• Visualize Live Cvent in Tableau

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

• Easily Integrate Google Spanner in Lazarus Pascal IDE

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

• Replicate SendGrid to Multiple Databases via the CData Sync CLI

  Replicate SendGrid to disparate databases with a single configuration.

• Visualize Tally in TIBCO Spotfire through OData

  Integrate Tally ERP into dashboards in TIBCO Spotfire.

• Automate Impala Replication to Azure Data Lake

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

• How to create an RPA flow for Microsoft OneDrive in UiPath Studio

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

• Automated AlloyDB Replication to Teradata

  Use CData Sync to Customize and automate Google AlloyDB replication to Teradata.

• Access Live ShipStation in AWS Lambda

  Connect to live ShipStation in AWS Lambda using the CData JDBC Driver.

• How to connect PolyBase to ActiveCampaign

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

• Automated Continuous Clio Replication to IBM DB2

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

• Integrate Twilio into Power Automate Desktop using CData Connect

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for eBay Analytics

  Provide connectivity to eBay Analytics through an SAP BusinessObjects universe.

• Connect to Odoo in CloverDX (formerly CloverETL)

  Transfer Odoo ERP using the visual workflow in the CloverDX data integration tool.

• Access Live Quickbase in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for Quickbase to create a Quickbase source in TIBCO Data Virtualization Studio and gain access to live Quickbase from your TDV Server.

• Query Email as a SQL Server in Node.js

  Execute SQL Server queries against Email from Node.js.

• Access Clio from MySQL in PHP

  Connect to Clio through the standard MySQL libraries in PHP.

• Import Real-Time LDAP Objects via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use LDAP in ColdFusion.

• How to Access Live IBM Informix in Power Automate Desktop via ODBC

  The CData ODBC Driver for IBM Informix enables you to integrate IBM Informix into workflows built using Microsoft Power Automate Desktop.

• Connect to Azure Data Catalog from PowerBuilder via ODBC

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

• Connect to Basecamp in the Denodo Platform

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

• How to Create Power BI Visual Reports with Real-Time DocuSign

  Use CData Power BI Connectors to visualize DocuSign in Power BI.

• Publish Crystal Reports on YouTube Analytics

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date YouTube Analytics.

• Connect to Zoho Projects as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Zoho Projects.

• Automated Continuous Shopify Replication to MySQL

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

• Automated Continuous Amazon S3 Replication to SQL Server

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

• Operational Reporting on Blackbaud FE NXT from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Blackbaud FE NXT.

• How to connect to SAP Ariba Procurement with Squirrel SQL client

  Connect to SAP Ariba Procurement and execute queries in the Squirrel SQL Client.

• Create Zoho CRM-Connected Applications in Appsmith

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

• Integrate with Adobe Commerce in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Adobe Commerce in SnapLogic.

• LINQ to Freshdesk

  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 Freshdesk Data Provider.

• Feed Microsoft Dataverse into FineReport

  How to set Microsoft Dataverse (CDS) as a JDBC data source in FineReport.

• Build Interactive Dashboards from TaxJar in Amazon QuickSight

  Create a virtual SQL Server database for TaxJar in CData Software Connect Server and import TaxJar into Amazon QuickSight SPICE to build interactive dashboards.

• How to connect PolyBase to Databricks

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

• How to Query SFTP in MySQL Workbench

  Execute MySQL queries against live SFTP from MySQL Workbench.

• Access Jira 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 Atlassian Jira.

• «
• 332
• 333
• 334
• 335
• 336
• 337
• 338
• 339
• 340
• 341
• »