How to load Tableau server repository data to SQL Server using SSIS

This post describes how to load a set of tables from the Tableau server repository. Tableau server repository uses PostgreSQL. You might need to install the PostgreSQL database drivers. You can download drivers from www.tableau.com/support/drivers.

Create a SSIS ODBC connection

Use ODBC connection in SSIS

Some useful tables are:

Cheers!
Uma

How to give read only permission to the Public and Private keys for SFTP in Windows 10

In Linux command, chmod 400 file is used to protect a file against accidental overwriting. 

In windows you can use icacls command

https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/icacls

In this case, let see how to give read only permission to .pub file

C:\WINDOWS\system32>cd c:\Keys

c:\Keys>icacls.exe id_rsa.pub /reset

processed file: id_rsa.pub

Successfully processed 1 files; Failed processing 0 files

c:\Keys>icacls.exe id_rsa.pub /grant:r "%Username%":"(R)"

processed file: id_rsa.pub

Successfully processed 1 files; Failed processing 0 files

c:\Keys>icacls.exe id_rsa.pub /inheritance:r

processed file: id_rsa.pub

Successfully processed 1 files; Failed processing 0 files

You can do the same for Private key and share the Public key and your IP address to get permission from the SFTP host. Once the permission is granted check the connection.

c:\Keys>sftp -i id_rsa <SFTP username>@<SFTP Host IP>

c:\Keys>exit

Cheers!
Uma

How to pass parameter to PowerShell script in SSIS

How to run PowerShell script in SSIS using Execute Process Task

Cheers!
Uma

How to get SSH key in WinSCP

Once you connect to the SFTP server, go to session and click on Server/Protocol Information

Cheers!
Uma

Wine Quality data analytics using Databricks

Data can be downloaded from here

https://archive.ics.uci.edu/ml/datasets/wine+quality

In the preview data, use “First row is header” to identify the column name & “ Infer Schema” to automatically identify the data types.

The table will be created in Default database

Let’s crate a new database and load data into the table

Create a SQL Notebook and Import that downloaded data.

Some sample useful SQL commands

You can change to plot view

Using Python Notebook

Create a data frame and load the data from the table

Some common useful Python commands

Save the results as another table

Cleaning Data

Handling NULL value

Remove extreme values or outliers

Machine Learning

Create multiple charts and dashboards

Cheers!
Uma