130 likes | 283 Views
Data Connection UI. Design walkthrough. Excel. Visual Studio. Report Builder. Report Designer. Model Designer. RS Data Source UI. AS Data Source UI. Office Data Connection Wizard. VS Data Connection UI. ODBC Admin UI. Microsoft Query. OLEDB Data Link UI. ODBC Connection Wizards.
E N D
Data Connection UI Design walkthrough
Excel Visual Studio Report Builder Report Designer Model Designer RS Data Source UI AS Data Source UI Office Data Connection Wizard VS Data Connection UI ODBC Admin UI Microsoft Query OLEDB Data Link UI ODBC Connection Wizards ADO.NET OLEDB ODBC ... SQL Oracle ... XLS MDB AS SAP ... Current MS data connection UI technologies
New Data Connection Selecting from existing connections Select a connection or report model Select a existing connection: Recently used shared connections Other shared connections AdventureWorks http://host1/site1/doclib/folder1/AdventureWorks.rsds Nice description of my connection rosedataNorthwind http://host2/reportserver/Data Sources/rosedataNorthwind Nice description of my connection Browse… Create a new connection in my report Help Back Next Cancel
New Data Connection Data Source Credentials Database credentials Asking credential info Select a connection or report model Select a existing connection: Connecting to AdventureWorks Recently used shared connections Other shared connections AdventureWorks http://host1/site1/doclib/folder1/AdventureWorks.rsds Nice description of my connection rosedataNorthwind http://host2/reportserver/Data Sources/rosedataNorthwind Nice description of my connection Connect using: Remember my password for this connection User name: joeuser Password: Browse… Connect Cancel Create a new connection in my report Help Back Next Cancel
New Data Connection Happy path completed Connection succeeded. Connection: AdventureWorks Location: http://host1/site1/doclib/folder1/AdventureWorks.rsds Click Finish to close the wizard. Help Back Finish Cancel
New Data Connection Creating new connection Select a connection or report model Select a existing connection: Recently used shared connections Other shared connections AdventureWorks http://host1/site1/doclib/folder1/AdventureWorks.rsds Nice description of my connection rosedataNorthwind http://host2/reportserver/Data Sources/rosedataNorthwind Nice description of my connection Browse… Create a new connection in my report Help Back Next Cancel
New Data Connection Creating new connection Select a connection or report model Select a shared connection: Recently used shared connections Other shared connections AdventureWorks http://host1/site1/doclib/folder1/AdventureWorks.rsds Nice description of my connection rosedataNorthwind http://host2/reportserver/Data Sources/rosedataNorthwind Nice description of my connection Browse… Create a new connection in my report Help Back Next Cancel
New Data Connection Detecting data source Identify the location and type of the data source Enter the location of the data source (examples): ducky1 Browse… Detect the data source type: Manually configure the connection Manually configure the connection Detect Detect Detecting data sources at this location.... Help Back Next Cancel
New Data Connection Selecting data source Identify the location and type of the data source Enter the location of the data source (examples): ducky1 Browse… Detect the data source type: Manually configure the connection Detect Select the data source: ducky1 Microsoft SQL Server ducky1\OTHERINSTANCE Microsoft SQL Server Help Back Next Cancel
New Data Connection AdventureWorks AdventureWorksDW master Northwind Selecting database Connection succeeded. Data source: ducky1 Type: Microsoft SQL Server Connect as: joeuser Choose a database: Help Back Finish Cancel
New Data Connection AdventureWorks New connection completed Connection succeeded. Data source: ducky1 Type: Microsoft SQL Server Connect as: joeuser Choose a database: Help Back Finish Cancel