Import Smartsheet Data into SQL Server using SSISEasily back up Smartsheet data to SQL Server using the SSIS components for Smartsheet. Using SQL Server as a backup for critical business data provides an essential safety net against loss. Backing up data to SQL Server enables business users to more...Oct 21, 2020 · 2 min readjerodj-cdata.hashnode.dev
Using Microsoft Query in Excel to Connect to SAPThis article uses the CData ODBC driver for SAP to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query. The CData ODBC driver for SAP uses the standard ODBC interface to link SAP data w...Oct 20, 2020 · 3 min readjerodj-cdata.hashnode.dev
Connect to Salesforce Data in AWS Glue Jobs Using JDBCConnect to Salesforce from AWS Glue jobs using the CData JDBC Driver hosted in Amazon S3. AWS Glue is an ETL service from Amazon that allows you to easily prepare and load your data for storage and analytics. Using the PySpark module along with AWS G...Oct 20, 2020 · 5 min readjerodj-cdata.hashnode.dev
Visualize Sage Intacct Data in TableauThe CData ODBC driver for Sage Intacct enables you integrate Sage Intacct data into Tableau dashboards. The CData ODBC Driver for Sage Intacct enables you to access live Sage Intacct data in business intelligence tools like Tableau. In this article, ...Oct 20, 2020 · 4 min readjerodj-cdata.hashnode.dev
Using Microsoft Query in Excel to Connect to QuickBooks OnlineThis article uses the CData ODBC driver for QuickBooks Online to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query. The CData ODBC driver for QuickBooks Online uses the standard ODBC ...Oct 20, 2020 · 3 min readjerodj-cdata.hashnode.dev