Integrating SSIS with C# to deliver very scalable Data-Driven Solution

August 14, 2009

نوضح في هذه المقاله استخدام ال SSIS  لبناء C# application to get very scalable data-driven solution  و كيفيه ارتباط ال C#  بالـ SSIS

ما هم ال SSIS  ؟؟ كيفيه الحصول عليه ؟؟ وماهي مميزاته؟؟ وفيما يستخدم اكثر؟؟

اولا SSIS  تعني SQL Server Integration Services  وهى احدى منتجات ميكروسوفت ويأتي مع جميع نسخ ال SQL Server  ما عدا ال Express  كان يسمى فيما سبق DTS  لكن SSIS  يعتبر منتج جديد وليس تحديثا من ال DTS

هي اداه قامت ميكروسوفت بتطويره و اخراجه للسوق عام 2007 وتهدف الى نقل البيانات من اكثر من Data Repository  الى Data Repository  اخر مثلا نقل البيانات من ملف نصي، ملف Excel  او قاعاده بيانات SQL or Access  الى جدول في قاعده بيانات في ال SQL Server  دون الحاجه لوجود SQL Server  ولا يجب مصدر البيانات او وصول البيانات SQL Server بأختصار يكمن استخدمها لنقل البيانات من ملف نصي الى قاعده بيانات Oracle تعتبر ال SSIS  اداه ETL (Extract, Transform, and Load)  اي انها تقوم بأخد البيانات من المصادر تحسين البيانات بشكل وتنظيمه وبعد هذا نقلها الى نقطه الوصول.
Read the rest of this entry »

Advertisements

SharePoint BI

July 23, 2009

I’m reading 6 posts on SharePoint Magazine about SharePoint BI. I like to share it with you

Part 1 – Getting to Know You – Intro to SharePoint BI
Part 2 – Sell! Sell! Sell! Why Build a Dashboard Anyway?
Part 3 – KPIs – Where do I Come From?
Part 4 – Dissecting Dashboards
Part 5 – We Really Need to Talk – Scorecards & Reports (Not published yet)
Part 6 – Beware the Bogeyman – Securing Dashboards (Not published yet)


SQL Server 2008 Training Kit

May 16, 2009

Banner

First to be honest I don’t remember who gave me this link or where I got it from, but once I remember I’ll update this post.
SQL Server 2008 Training Kit: http://download.microsoft.com/download/9/1/1/911EC8F9-4407-42F0-A7EE-335BA0E61F50/SQL2008TrainingKit.Setup.20090505.exe

What’s its goal:

The goal of the SQL Server 2008 Developer Training Kit is to provide information about new features in SQL Server 2008. Its primary audience is solution architects and developers already familiar with SQL Server who want to learn about new functionality available in this release. The content focuses on development aspects and illustrates how to design more effective database applications that take advantage of improved capabilities in SQL Server 2008.

The material is organized into several feature areas:

  • Spatial Support provides an overview of the new spatial data types that allow for the creation, comparison, analysis, and retrieval of spatial data.
  • FILESTREAM describes how SQL Server 2008 enables the storage of binary large object (BLOB) data as files on the file system in a manner that ensures transactional consistency with the database.
  • CLR introduces the common language runtime integration feature and describes new support for nullable types and additional .NET Framework libraries supported in SQL Server 2008.
  • Reporting Services highlights enhancements to SQL Server Reporting Services including the new Report Builder 2.0 authoring tool.
  • Date and Time introduces the new ANSI standard compatible data types that provide increased range and accuracy.
  • T-SQL shows several new language enhancements including table-valued parameters, row constructors, grouping sets, and the MERGE statement.

Within each feature area, you will find presentations, demo scripts, and hands-on labs that will help you understand important aspects of each feature.

In the training kit, you will find the AdventureWorks Racing Community application. This sample application highlights some of the new functionality introduced in SQL Server 2008.


Building ASP.NET Reporting OLAP-Based Application Part-3

April 20, 2009

In the previous two posts building the Cube and building the Report, we discovered how BIDS helps in developing BI applications in robust, managed and organized way. I believe if you have few BI concepts you can do this walkthrough in 10 minutes.
Let’s come to the last layer which I see it’s the presentation layer. One question may come to your mind why I build ASP.NET application over Reporting Service? Why I don’t give the end user Reporting Service Server URL. Because of security? NO. Reporting Service Server can manage different types of security which doesn’t put headache on your development team but what if your end user need UI layer say in Silverlight? How can you embed in the Reporting Service. We have ReportViewer Windows\Web control which provides a very rich of functionality to View Reporting Service (Local and Server) Reports. In our walkthrough we use Server Report.
Let’s open our previous solution and add a new ASP.NET web application project: InternetSalesWebsite
Default.aspx page open in source view, switch to Design view. 

rs-p3-1

Read the rest of this entry »


Building ASP.NET Reporting OLAP-Based Application Part-2

April 19, 2009

In the previous post we learned how to build simple cube using BIDS, and if you’re follower I’ve forgot something important is deployment the cube on the Analysis Services.
1- We just need to add some attributes to the dimensions(DimPromotion, DimProduct) as each of which pure (contains just the key) for some reasons we need to show the user the name of product, or the promotion because it very hard to make human treat with numbers contrary to machines which prefer them. We shall add some attributes to the dimensions to make it meaningful.

2- Double click on DimPromotion; the dimension design window opened you find Data Source View, Hierarchies and Attributes; simply drag EnglishPromotionName from the Data Source View table to Attributes.
3- Repeat the previous step with the DimProduct to add EnglishProductName

rs-p2-7
Read the rest of this entry »


Building ASP.NET Reporting OLAP-Based Application Part-1

April 18, 2009

Here I’ll talk about how to integrate your asp.net application with Reporting Service through ReportViewer web control which provides rich functionality to deliver Reporting Service Report through asp.net applications.

In real life applications; Analysis Service and Reporting Service on server machine, Web Server another server machine and clients usually on another domain access the website to do something.

Let’s take a look on this diagram to visualize what happened in intra applications which one of its functionality shows reports this reports actually based on OLAP Data (SSAS used here)

Infrastructure Architecture

Here we build OLAP Cube as Report data source.

So, let’s begin to build our report based on Cube which built from AdventureWorksDW Read the rest of this entry »