To setup this project install the following softwares
Talend Real-Time Data Platform 7.1 SQL Server Developer Edition Microsoft SQL server Management Studio Tableau Microsoft PowerBI
- Run the following scripts in SSMS to setup the staging database
The Number - stage tables.sql stg imdb tables - core tables.sql stg imdb tables expanded part 2.sql stg_ml_tables.sql
-
Open Talend and setup your database connections and input file connections
-
When the connections are successfull run the final job (Runtime 75 mins)