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

How to create data warehouse

4 posters

Go down

How to create data warehouse  Empty How to create data warehouse

Post  adeelahmad 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

Back to top Go down

How to create data warehouse  Empty Re: How to create data warehouse

Post  BoxesAndLines 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!
BoxesAndLines
BoxesAndLines

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

Back to top Go down

How to create data warehouse  Empty Re: How to create data warehouse

Post  asadn711 Mon Apr 13, 2015 12:00 am

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

asadn711

Posts : 1
Join date : 2015-04-12

Back to top Go down

How to create data warehouse  Empty Re: How to create data warehouse

Post  ron.dunn Mon Apr 13, 2015 4:29 am

Buy this:

http://www.kimballgroup.com/data-warehouse-business-intelligence-resources/books/microsoft-data-warehouse-dw-toolkit/

Read.

ron.dunn

Posts : 55
Join date : 2015-01-06
Location : Australia

http://ajilius.com

Back to top Go down

How to create data warehouse  Empty Re: How to create data warehouse

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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