How to create data warehouse

View previous topic View next topic Go down

How to create data warehouse

Post  adeelahmad on Mon Aug 18, 2014 3:13 am

I want to create data warehouse , it includes 4 types of databases (sqlserver,oracle,mysql,access) & i have already store data in these databases but how can i create datawarehouse using sql server??? plzzzz help me.......

adeelahmad

Posts : 1
Join date : 2014-08-18

View user profile

Back to top Go down

Re: How to create data warehouse

Post  BoxesAndLines on Mon Aug 18, 2014 11:10 am

Create a new database in SQL Server, call it EDW. Extract (E) all the data from your source datababases, transform (T) it to the new enterprise data model in the EDW database, and load (L) it based on user requirements. Most folks using SQL Server like to use SSIS for their ETL tool although I'm not sure how well it connects to non-Microsoft third party databases. You may find you need to hire a couple of people to help in this process. Project managers, data analysts, data modelers, ETL developers, and reporting people are a few of the more common roles. Hopefully your question didn't imply that someone expects you to do the job of five people minimum. Good luck!
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: How to create data warehouse

Post  asadn711 on Mon Apr 13, 2015 12:00 am

but how can i create datawarehouse using sql server??? ???

asadn711

Posts : 1
Join date : 2015-04-12

View user profile

Back to top Go down

Re: How to create data warehouse

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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