Data Engineering Technical Blog

Summary Visual Studio Online is cloud version of TFS which we can connect using Visual Studio to retrieve projects collections and work items. The VSO does not give access to any backend database like CRM tools and exposes its data through REST API and ODATA. Requirement : Pull project and work item collection from VSO and store the same in SQL Azure, which will be used for analysis. Solution : Create SSIS package to connect to VSO using OData connection and pull VOS data like project , work items etc and connect to SQL Azure and store the desired data. Prerequisite Install Odata for SSIS from (  https://www.microsoft.com/en-us/download/details.aspx?id=42280  ) Create alternate account password in VSO, the same will be used in SSIS Odata connection manager. Steps to create SSIS package Create connection to Azure and VSO Open SSDT and create new SQL Server Integration Service project, add a new package and go to the connection manager and right click, yo...

Step 1: Configuring SQL Reporting Services – Web Service URL Simply go to Reporting Services Configuration Manager and choose Web Service URL and populate the following needed information. The fields are named properly so I guess there is no need for further explanation. What this does is that it configures the IIS for you depending on what Virtual Directory names you had declared. Step 2: Configuring SQL Reporting Services – Create a Report Database Same here, fields need no further explanation except for one which is Native Mode and SharePoint Integrated mode which I will explain below. Choose create a database or if you already have one choose an existing one. For this example, we will create a new one: Connect to the database where you want your Report Data to be stored: Give it a Name and a Report Server Mode. With SharePoint Integrated Mode the report RDLs are stored on SharePoint and not in the Report Database. For this instance, we will use the SharePoint ...

CHANGE THE CONFIGURATION ENTRY IN REPORT SERVER FOLDER ·         Navigate to the report server folder which “C:\Program Files\Microsoft SQL Server \ MSRS_vv.MSSQLSERVER\Reporting Services\ReportServer” ·         Open the rsreportserver.config file and add the below entry below <Configuration> ·         < HTMLViewerStyleSheet > Pink </ HTMLViewerStyleSheet > remember that Pink is will be your CSS file name which we will create in next step. ·         Save and close the file. ADD Pink.css file in the Style folder ·         Open the Styles folder in \ReportServer and create a file named Pink.css ·         Copy the content of HTMLViewer.css to file name Pink.css. ·         Now you can modify the content of Pink.css according to ...