Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Techniques for data transfer

Go down

Techniques for data transfer Empty Techniques for data transfer

Post  DBADS Sun Aug 22, 2010 10:42 am

Are there any automated ways to transfer data from source to target knowing that there is no access to the source?
I know flat/csv files extraction can be an option but it doesn't seem to be an automated way...
Is there another way that is more automated?

DBADS

Posts : 7
Join date : 2010-08-22

Back to top Go down

Techniques for data transfer Empty Re: Techniques for data transfer

Post  ngalemmo Mon Aug 23, 2010 11:35 am

Having the source system produce an extract is a relatively common way to handle it if direct access isn't permitted. Such processes are easily (and always) automated using scheduling tools. Why would you think otherwise?
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Techniques for data transfer Empty Re: Techniques for data transfer

Post  DBADS Tue Aug 24, 2010 2:51 am

Thanks for the answer

I assume by scheduling tools, you don't mean ETL techniques, do you?
Would you kindly elaborate on "scheduling tools"?

DBADS

Posts : 7
Join date : 2010-08-22

Back to top Go down

Techniques for data transfer Empty Re: Techniques for data transfer

Post  ngalemmo Tue Aug 24, 2010 11:57 am

Job schedulers... Google the term. There are a lot of commercial and open source job scheduling products. Basically they allow you to schedule jobs to run in batch. They allow you to set up dependancies, alerts when things fail and so on...
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Techniques for data transfer Empty Re: Techniques for data transfer

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum