Not sure if this is the most appropriate place, but here it goes.
I have to create an ETL from Lotus Notes to SQL server tables. The tables have been built and an intial load has been completed. The problem now, is that I have identified close to 60+ databases within Lotus that have to be pulled and pushed into the SQL tables. Each database refers to a specific region but contain the exact same tables. So I would need to pull from each one and dump them into the appropriate table.
I am looking for the best approach to handling this. I have downloaded the NotesSQL driver which allows me to create an ODBC connection, but usually this is done with one database, not with multiple...at least that has been my experience.
Please advise if there is a much better way to handle this....thanks!
I have to create an ETL from Lotus Notes to SQL server tables. The tables have been built and an intial load has been completed. The problem now, is that I have identified close to 60+ databases within Lotus that have to be pulled and pushed into the SQL tables. Each database refers to a specific region but contain the exact same tables. So I would need to pull from each one and dump them into the appropriate table.
I am looking for the best approach to handling this. I have downloaded the NotesSQL driver which allows me to create an ODBC connection, but usually this is done with one database, not with multiple...at least that has been my experience.
Please advise if there is a much better way to handle this....thanks!
