{"id":1313,"date":"2016-03-03T11:17:11","date_gmt":"2016-03-03T10:17:11","guid":{"rendered":"http:\/\/www.venco.com.pl\/~cozy\/blog\/?p=1313"},"modified":"2016-03-03T11:17:11","modified_gmt":"2016-03-03T10:17:11","slug":"what-tools-are-needed-to-build-a-data-warehouse","status":"publish","type":"post","link":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/2016\/03\/03\/what-tools-are-needed-to-build-a-data-warehouse\/","title":{"rendered":"What tools are needed to Build a Data Warehouse in MS SQL Server?"},"content":{"rendered":"<p>Wg. podr\u0119cznika\u00a0z PJWST do tworzenia hurtowni potrzebne jest\u00a0<strong>SQL Business Intelligence Development Studio <\/strong>(BIDS). W wersjach p\u00f3\u017aniejszych zosta\u0142o ono zast\u0105pione przez <strong>SQL Server Data Tools<\/strong>.<\/p>\n<p>&#8222;Aby zbudowa\u0107 kostk\u0119 nale\u017cy otworzy\u0107 SQL Server Business Intelligence Development Studio (Start \u00ae Programy \u00ae Microsoft SQL Server 2008 R2 \u00ae SQL Server Business Intelligence Development Studio), a nast\u0119pnie stworzy\u0107 nowy projekt, korzystaj\u0105c z szablonu Analysis Services Project. W tym celu wybieramy opcj\u0119 File \u00ae New \u00ae Project\u2026:&#8221;<\/p>\n<p>Both SQL Server 2005 and SQL Server 2008 include three tools that are very helpful towards implementing a Data Warehouse. These three tools allow you to create an killer data warehouse.<\/p>\n<ul>\n<li>Analysis Services (SSAS)<\/li>\n<li>Integration Services (SSIS)<\/li>\n<li>Reporting Services (SSRS).<\/li>\n<\/ul>\n<p>We will go over these tools in great detail in future posts.\u00a0 For now, let\u2019s just think of SSAS as the tool that provides storage for the data used in cubes for your data warehouse. SSIS is the tool we will use to extract, transform and load (ETL) data into our data warehouse.\u00a0 SSRS is a tool used to view the data in our data warehouse.<\/p>\n<p>\u0179r\u00f3d\u0142o:\u00a0http:\/\/johnsterrett.com\/2009\/09\/29\/building-a-data-warehouse-with-sql-server\/<\/p>\n","protected":false},"excerpt":{"rendered":"<p class=\"excerpt\">Wg. podr\u0119cznika\u00a0z PJWST do tworzenia hurtowni potrzebne jest\u00a0SQL Business Intelligence Development Studio (BIDS). W wersjach p\u00f3\u017aniejszych zosta\u0142o ono zast\u0105pione przez SQL Server Data Tools. &#8222;Aby zbudowa\u0107 kostk\u0119 nale\u017cy otworzy\u0107 SQL Server Business Intelligence Development Studio (Start \u00ae Programy \u00ae Microsoft SQL Server 2008 R2 \u00ae SQL Server Business Intelligence Development Studio), a nast\u0119pnie stworzy\u0107 nowy&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/2016\/03\/03\/what-tools-are-needed-to-build-a-data-warehouse\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[37],"class_list":["post-1313","post","type-post","status-publish","format-standard","hentry","category-bez-kategorii","tag-bazy-danych"],"_links":{"self":[{"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/posts\/1313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/comments?post=1313"}],"version-history":[{"count":0,"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/posts\/1313\/revisions"}],"wp:attachment":[{"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/media?parent=1313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/categories?post=1313"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/tags?post=1313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}