Pentaho Data Integration

Pentaho Data Integration (also called Kettle) is the component of Pentaho responsible for the Extract, Transform and Load (ETL) processes. It can be used for following purposes:

• Data Warehouse
• Migrating data between applications or databases
• Exporting data from databases to flat files
• Loading data massively into databases
• Data cleansing
• Integrating applications

Spoon:
Spoon is the graphical tool with which you design and test every PDI process.
In Spoon, you build Jobs and Transformations. PDI offers two methods to save them:
Database repository and Files
If you choose the repository method, the repository has to be created the first time you execute Spoon. If you choose the files method, the Jobs are saved in files with the kjb extension, and the Transformations are in files with the ktr extension.
Starting Spoon
Start Spoon by executing spoon.bat on Windows, or spoon.sh on Unix-like operating systems. As soon as Spoon starts, a dialog window appears asking for the repository connection data. Click the No Repository button.

TABLEAU Vs QLIKVIEW

TABLEAU Vs QLIKVIEW

1. Tableau offers much better modern GUI principles with no clutter than QlikView
2.3d charts and gauges available in QlikView but missing in Tableau.
3.  What you build in Tableau looks great instantly (colors, fonts, text size, margins etc.). When you build something in QlikView you need to invest time in formating the visualization, as the visual experience out of the box is questionable.
4.QlikView is a tool for an IT department looking to build reports to the business. Tableau on the other hand is also a tool for the business, enabling them to analyse and build report themselves.
5.Data transformation (Script engine) is a built in functionality in Qlik if you choose not to connect to a data warehouse. Secondly, QlikView performs poorly in reporting but excels in dashboards. Tableau on the other hand is superior in ad hoc analysis on top of well-structured and organized datasets

Encryption In QlikView

There is no documented encryption functions for QlikView but it is possible with Expressor or VB script macro.
Using a self contained JavaScript encryption implementation i.e CyrptoJS and a few helper functions in the macro module, it is possible to encrypt and decrypt values in QlikView.

Create an empty QVW and copy this into the macro module. Also, add the encrypt/decrypt helper functions below at the end of the macro module.

function encrypt(value, key) {
    return CryptoJS.AES.encrypt(value, key).toString();
}
function decrypt(value, key) {
    return CryptoJS.AES.decrypt(value, key).toString(CryptoJS.enc.Utf8);
}


Now QlikView can encrypt and decrypt values using a specified key.

// Setup the encryption key
Let vEncryptionKey = 'Your Encryption Key Goes Here!099';

// Example with variable
Let vName = 'Justin';
Let vEncryptedName = encrypt('$(vName)', '$(vEncryptionKey)');
Let vDecryptedName = decrypt('$(vEncryptedName)', '$(vEncryptionKey)');

// Example with LOAD
ExampleWithLOAD:
Load
    Name,
    EncryptedName,
    decrypt(EncryptedName, '$(vEncryptionKey)') as DecryptedName
;
Load
    Name,
    encrypt(Name, '$(vEncryptionKey)') as EncryptedName
;
Load
    'Justin' as Name
AutoGenerate 5;