add etl pull capabilities