DocumentCode :
1878142
Title :
Automating ETL process with scripting technology
Author :
Radhakrishna, V. ; SravanKiran, V. ; Ravikiran, K.
Author_Institution :
Dept. of IT, VNR VJIET Autonomous, Hyderabad, India
fYear :
2012
fDate :
6-8 Dec. 2012
Firstpage :
1
Lastpage :
4
Abstract :
Improving ETL process system data flows can provide better return on your Business investment. An enterprise level scheduling solution that is easy to use and handles heterogeneous environments may just do what you need. In the past, the focus was mainly on business process design, modeling. Recently, enterprises have realized that they can benefit tremendously from automating the ETL process with the objective of optimizing or improving them. In our research, we address the problem of warehousing, show how to automate the ETL process for pulling data from source to target environment. Typically, the source data consists of event streams that indicate changes in the business process state i.e progression of the process. The idea is to automate ETL process using scripting technologies. This paper is written to give scope in future for coming up with effective ETL tools that support command based automation or script based automation. We throw light on the need for usage of scripting technologies to automate ETL tools processing end to end process which reduce manual headache of running ETL process handling and also lead to development of ETL tools in future that support command based interface.
Keywords :
authoring languages; business data processing; data warehouses; investment; ETL process improvement; ETL process optimization; automatic ETL process system data flows Improving; business investment; business process state; command-based interface; enterprise level scheduling solution; event streams; heterogeneous environments; process progression; scripting technology; source data; source environment; target environment; Extract; Load; Scripting; Transform;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Engineering (NUiCONE), 2012 Nirma University International Conference on
Conference_Location :
Ahmedabad
Print_ISBN :
978-1-4673-1720-7
Type :
conf
DOI :
10.1109/NUICONE.2012.6493217
Filename :
6493217
Link To Document :
بازگشت