update data integration script, first integration test