Techniques for data transfer
2 posters
Page 1 of 1
Techniques for data transfer
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?
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
Re: Techniques for data transfer
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?
Re: Techniques for data transfer
Thanks for the answer
I assume by scheduling tools, you don't mean ETL techniques, do you?
Would you kindly elaborate on "scheduling tools"?
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
Re: Techniques for data transfer
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...
Similar topics
» Ebook The Data Warehouse Lifecycle Toolkit, 2nd Edition: Practical Techniques for Building Data Warehouse and Business Intelligence Systems
» Transfer Courses Fact/Dimensions Design
» Techniques for Updating existing fact records
» Looking for a Data Architect/Data Modeler for NYC Big Data Startup
» difference between data mart and data warehouse at logical/physical level
» Transfer Courses Fact/Dimensions Design
» Techniques for Updating existing fact records
» Looking for a Data Architect/Data Modeler for NYC Big Data Startup
» difference between data mart and data warehouse at logical/physical level
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum