Looking to implement a ETL solution using Pentaho Data Integration
The source Database is based on Advantage Database server Tables - OLTP from [url removed, login to view]
Open for suggestions about the target database Tables
The source tables are in 5 Locations on a VPN Windows OS – The job would run each night preparing the file for the next day reports.
Would also need to make some Guided Ad-hoc drill down reports and cubes based on the following :
Projected ‘In Stock’ at a future date - based on Info taken for sales trend on past season
Received in a given time frame
Amount to Purchase
Meters of raw materiel would be used
Size - Numeric _size, Size_attribute (S,M,L,X -42X)
Bu iş için 16 freelancer ortalamada $1194 teklif veriyor
Hello, I can definitely do this project, and I bring extensive experience with Access and ETL products. Please check your PM shortly for details. Thanks.