October 14, 2016 at 9:48 am
We have server running access etl. It generally gets the data using LANSA queries and access and SQL queries. What are the steps I need to follow to rewrite the whole ETL process to SQL ETL . Basically ssis
October 14, 2016 at 10:07 am
karthiknfr_1991 (10/14/2016)
We have server running access etl. It generally gets the data using LANSA queries and access and SQL queries.
bit difficult to say much without more specific details...can you please expand and explain.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 14, 2016 at 4:09 pm
We have access etl running on server A and B. We are going to decommission server A . There is another as400 server where we run lansa queries to fetch the data for etl and load it in to database. Now everything starting from lansa to access have to be rewritten in sql server
October 15, 2016 at 2:45 am
karthiknfr_1991 (10/14/2016)
We have access etl running on server A and B. We are going to decommission server A . There is another as400 server where we run lansa queries to fetch the data for etl and load it in to database. Now everything starting from lansa to access have to be rewritten in sql server
First step is to document those processes and any logic within those such as transformations, lookups etc.. Next is to map each logical unit to the best fit destination within the new architecture, i.e. sorting and lookup on SQL Server, file manipulation within SSIS etc. and after that is done then first do you start designing and PoC coding the new processes.
😎
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply