Skip to main content

How to create SQL DB Views in MS SQL Server

This Article will cover below points:

  • How to create DB View in Microsoft SQL Server.
  • How to provide permissions to DB View.
  • How to export DB View to .sql file.

How to create DB View in Microsoft SQL Server:

Connect MS SQL Server to Siebel DB.

Expand the Siebel DB and navigate to Views

Right click on Views and Select New View..

dbv01

This might take few minutes on first use and it will open below new window from where you can create db view by selecting Table, Views etc. But I prefer to write query and directly use.Click on Close button.

dbv02

On Close you can see a new query window with three sections. 

  • 1st section will show the table/ view relational diagram.
  • 2nd section will show the Columns and their details.
  • 3rd window will have the SQL query.
dbv03

Copy and Paste the SQL query in 3rd section and click on other section, MS SQL Server will auto create the relation diagram and populate the Column details.

dbv04

From the top tool bar click on Save button and MS SQL Server will ask for DB View name, provide the appropriate name and click on OK button.

dbv05

Now go to the View and right click. From the menu click on Refresh and find your newly created DB View.

dbv06

How to provide permissions to DB View:

If you run SELECT query you receive permission error. To overcome this right click on DB view and Select Properties.

dbv07

From the Properties window click on Permission page. From this click on Search button. In new Select User or Role window type [SSE_ROLE] in Object name field and click OK button. Now click OK button on Properties window and re run the SQL query.

dbv08

How to export DB View to .sql file:

Right click on DB View name. From the menu click on Script View as > CREATE To > File.

dbv09

From the new window select the location where you want to save the .sql file. Provide the File Name and click on OK. All Done.

dbv10

See Also:

How to create External Table in Siebel Tools on SQL View

How to create SQL Views in SQL Developer from UI

Labels:

Comments

Post a Comment

Popular posts from this blog

How to set Profile Attribute in Siebel Workflow

For setting the Profile Attribute in Siebel Workflow, follow below steps: Add Business Service box in workflow. Open Business Service properties. Set  SessionAccessService in Business Service Name. Set  SetProfileAttr in Method Name. Then click on Business Service and set Input Arguments as below: Against Name argument you will add your profile attribute name and against Value argument you will add value for the new profile attribute, it could be from Process Property or Literal.
Post a Comment
Read more

How to call Popup Applet through Server Script in Siebel

Below is the script for calling popup applet through script: if (MethodName == "MethodName") { var oServiceAF = TheApplication().GetService("SLM Save List Service"); var inputPropAF = TheApplication().NewPropertySet(); var outputPropAF = TheApplication().NewPropertySet(); inputPropAF.SetProperty("Applet Name","ABC Popup Applet"); inputPropAF.SetProperty("Applet Mode","6"); inputPropAF.SetProperty("Applet Height", "700"); inputPropAF.SetProperty("Applet Width", "700"); oServiceAF.InvokeMethod("LoadPopupApplet", inputPropAF, outputPropAF) return (CancelOperation); } Applet Modes:  1=Base, 2=New, 3=Edit, 5=Query, 6=EditList
Post a Comment
Read more

How to query or find record in Siebel Business Component

You can perform query operation on Business Component through Workflow, eScript with the help of Siebel Operation, Inbound E-mail Database Operations (method: FindRecord) or EAI Siebel Adapter (method: Query but you need to create Integration Objects). This Business Component can be Virtual Business Component (VBC), External Business Component (EBC) or generic Business Component (BC).  See also: Difference Between Business Components and How to Create BC in Siebel through Object Wizard through Workflow with the help of Siebel Operation Create a workflow and provide the Business Object, business component should be in this BO for which you want to perform the query operation. From the Palettes window drag drop the Siebel Operation into workflow designer plane. Select the Siebel Operation box and open the properties window, provide the Business Component name from the drop down list and set Query in Operation field. You can set the search specification by two means either provide the fie
Post a Comment
Read more