E17781_01/admin.112/e18585/img/apex_create_workspace.jpg' alt='Install Sample Schemas Oracle 11G Tutorial' title='Install Sample Schemas Oracle 11G Tutorial' />Creating Master and Work Repository This tutorial explain how to create Master and Work Repository in Unix and windows environment with Oracle 1.ODIMASTER and ODIWORK defined as Master and Work Repository.Oracle recommends creating snpm and snpw for Master and Work Repository.I intend to use ODIMASTER and ODIWORK as it makes it easy and sense when any one looks into it.After Oracle Data Integrator ODI Installation, create these schemas as follows namely.Install Sample Schemas Oracle 11G Tutorial' title='Install Sample Schemas Oracle 11G Tutorial' />Oracle Database Online Documentation 11g Release 2 11.Application Development.Application development for Oracle Database involves a wide range of programming.Use the following Codes to create the required schema, attached the required tablespace as per your requirement for home or testing environment dont worry about the Tablespace.CREATE USER ODIMASTER IDENTIFIED BY ODIMASTER GRANT CONNECT,RESOURCE TO ODIMASTER CREATE USER ODIWORK IDENTIFIED BY ODIWORK GRANT CONNECT,RESOURCE TO ODIWORK CREATE USER WORKSCHEMA IDENTIFIED BY WORKSCHEMA GRANT CONNECT,RESOURCE TO WORKSCHEMA CREATE USER ODIMASTER IDENTIFIED BY ODIMASTER.GRANT CONNECT,RESOURCE TO ODIMASTER.CREATE USER ODIWORK IDENTIFIED BY ODIWORK.GRANT CONNECT,RESOURCE TO ODIWORK.CREATE USER WORKSCHEMA IDENTIFIED BY WORKSCHEMA.GRANT CONNECT,RESOURCE TO WORKSCHEMA In UNIX environment please use the following environment variables to connect to the ODI Installed Folderexport ODIHOMEhomeoracleOra.Homeoracledi export ODIJAVAHOMEhomeoracleOra.Homejre1.PATHPATH ODIHOMEbin cd homeoracleOra.HomeoracledibinNote Please change your HOME PATH i.ODI is installed as it is for me Creating Master Repository In Windows Go the Following path as shows in the above image or you can call the REPCREATE.BAT in windows from the cmd prompt or.UNIX environment from oracledibin folder.Enter the required information to create the Master Repository.User Username to connect to the database, for my example I am using ODIMASTERPass Password for the particular above mentioned user.Id Give any number from 0 5.Password for my example its ODIMASTERTechnology Use the technology you are using above to connect, for my example I am selecting Oracle.Driver Click and select your respective technology jdbc driver, for my example its oracle so I am using.Oracle.Driver. You can learn about each driver in Description as you scroll through all the drives listed there.C Software Free Download For Windows Xp 32 Bit .URL Enter the corresponding url for respective driver technology, for my example iam using localhost.This tutorial explain how to create Master and Work Repository in Unix and windows environment with Oracle 11g with ODIMASTER and ODIWORK defined as Master and.Oracle Database Express Edition.Getting Started Guide.Release 2 11.E1858505.May 2014.Welcome to Oracle Database Express Edition Oracle Database XE.Program-Manager1.png' alt='Install Sample Schemas Oracle 11G Tutorial' title='Install Sample Schemas Oracle 11G Tutorial' />Sid ORCL Change your parameters depending on your environment.To learn about url see Description in the image.Final click on Test connection, if every parameter is correct it will show Successful message.Click on and Master Repository will be created.Logging into Topology Manager Now type.TOPOLOGY.BAT in the oracldibin directory or point to the icon of the Topology as show in the image.To login into Topology Manager and you will see a similar screen, click on new shown below.Type in the required parameters, generally the parameters are same as above.For me oracle its like this.For Oracle Data Integrator Connection.Give a login name i.Repository, you can give any meaningful description eg development, testing etc.USER SUPERVISOR PASSWORD SUNOPSIS Please use capital alphabets, they are case sensitive For Database Connection Master RepositoryUse the same User and password that you have used while creating Master Repository as discussed above while creating master repository.Finally click Test to test the connection.Click ok and type again.After logging in, select your login name and click ok.Now you will logged in the Topology Manager, go to fifth tab i.Repositories and you will see Master and Work Repositories as shown below.Creating Work Repository Right Click on Work Repositories and click on Insert Work RepositoryYou will see a Data Server, as shown below ,Name Name for your Work repository, it can be anything Technology Technology you are using to connect, for my example its Oracle User Username for the database ODIWORK Password Password for the particular above mentioned user Let the other default parameters be as it is.Go to Next Tab JDBCGive the JDBC Driver and JDBC Url depending on your technology.Click on Test to test the connection.Click yes and if everything is correct you will see.Else connection failed, if failed please check your parameters.Finally a window will pop up, enter the.ID for the Work Repository and the meaningful Work Repository Name to it.Finally you will see the Work Repository defined as shown below in the sample image.Connecting to the Designer.Now we are going to connect to the above Work repository and do our development.Type in the terminal.Click on New and type in the following parameters.Enter the same information and the only thing new is Repository Name type in the above work repository if you remember, else click on this icon under Work Repository box.You will see a list of the Work Repository you created.Select and click ok.Test the connection, if everything is fine you will have successful connection.Later select your new Login Repository creates above and automatically username and password will be entered.Click ok and you will log into the Designer to create your First interface.Learn more about it from Getting Started guide from Oraclehttp www.Integrating Oracle Forms 1.Java.Scriptlt Do not delete this text because it is a placeholder for the generated list of main topics when run in a browser Purpose.In this tutorial you set up and run an application that demonstrates Oracle Forms and Java.Script integration.The application uses Cascading Style Sheets CSS and a popular third party Java.Script library called j.Query.Approximately 3.The demonstration application integrates simple forms with a d.HTML menu system that controls both the form and other d.HTML objects appearing in the same browser window, such as a date picker and an image viewer.With this application you can demonstrate how Oracle Forms can call out to these browser widgets and call into the Oracle Forms Runtime via the Forms client applet.The resulting application, with the menu and the date picker visible, looks like this Before starting this tutorial, you should.Have access to or have installed Oracle Forms version 1.You may use either Release 1 R1 or Patch Set 1 PS1, although the directory structures of these releases are somewhat different.Have access to an Oracle database with the scott schema EMP and DEPT installed.Warning For security reasons, it may not be advisable to install the sample schemas into a production database.If you do install them, you should use passwords other than default passwords, although default passwords are used in the examples shown in tutorials provided by Oracle.When you are finished using the sample schemas for tutorial and demo purposes, you may drop them by issuing the following SQLlus command for each installed sample schema DROP USER lt schemaname CASCADE If you are using the sample schemas for the first time, you may find that you must unlock the schema user, and then grant CONNECT and RESOURCE roles to it.You can do this by using Oracle Enterprise Manager, which is part of Oracle.Alternatively, you can issue the following SQLlus commands ALTER USER scott IDENTIFIED BY tiger ACCOUNT UNLOCK GRANT CONNECT, RESOURCE to scott.Use Internet Explorer 7 or later.Version 6 of IE and any version of Firefox does not allow the applications Java.Script menu a Milonic menu to show in front of the Forms applet.However, the Milonic menu can be used with frames see Resources.This demonstration uses a few Web standards that may be unfamiliar to Forms developers, such as d.HTML This acronym stands for dynamic HTML, an umbrella term for using client side languages like Java.Script, or server side languages like PHP and Java Server Pages, to create dynamic as opposed to static Web pages.Java.Script Java.Script has emerged as the dominant client side scripting language.Like PLSQL, it is pointerless, but while PLSQL is compiled to byte code, Java.Script is interpreted.It is imperative, weakly typed, and object oriented but prototype based rather than class based, and its functions are first class entities.CSS CSS stands for Cascading Style Sheets, which you can use to define the style of a Web site.You use it in the demonstration application to make the applet appear to be a part of the larger browser page.DOM An understanding of the DOM, or Document Object Model, is crucial in order to be effective when programming in Java.Script.The DOM is the model by which HTML objects are represented and manipulated.See Resources for more information on these topics.Use following steps to setup the application.From the expanded zip file, copy the.JSIntegSolutionsjsdemo folder to a directory of your choice.Open the modules in Forms Builder, connect as scott, and compile the forms to the same directory as the.Copy the js.Forms configuration directory.The path for this directory is defferent depending on the release of JDeveloper that you are using For Release 1 R1 lt middlewarehome userprojectsdomainslt domain servers.WLSFORMSstageformsapp1.For Patch Set 1 PS1 lt oracleinstance configForms.Componentformsserver.Copy these directories.JSCal.Effectsand these files jquery.For Release 1 R1 lt middlewarehome userprojectsdomainslt domain serversWLSFORMSstageformsapp1.For Patch Set 1 PS1 lt middlewarehome userprojectsdomainslt domain serversWLSFORMStmpWLuserformsapp1.Edit jsdemo.These values are located toward the end of the file.Create a new configuration section called javascript in the formsweb.In 1.Enterprise Manager, but you can also edit the file manually.For the sake of simplicity, this tutorial shows manually editing the file.Add some parameters to the configuration section.The defaults for height and width are a little too big for the application.The new color scheme called swan looks good for this application, so set colorscheme and look.And.Feel to accomplish that.Make sure that Java.Script support is turned on, and also name the applet.Use the following settings javascriptwidth4.Screenno backgroundno color.Schemeswan look.And.Feeloracle logono appletnameformsapplet enable.Javascript. Cannot Ping Windows Vista Machine . Eventtrue base.HTMLjpijs.Edit the default.Add the directory where you saved the forms to the environment variable FORMSPATH.For example, append to FORMSPATH D DataMy.FormsJSInteg.Demo To demonstrate the features of the application, perform the following steps.Run the application by issuing the following URL in your browser, substituting the value for lt host http lt host 9.You do not need to invoke the servlet URL frmservlet because the iframe in the application calls the Forms servlet.Use the self explanatory Java.Script menu to navigate to submenus and perform different operations.For example, invoke the Query menu, enter an employee name, such as WARD, in the search box, and click Go.The form displays the record for the specified employee.To redisplay all the records, select Query Execute from the menu.Navigate to the hiredate field in Employees form.Use the up and down arrow keys to scroll between records, noticing the corresponding change in the date picker calendar.Select a date from the calendar, which updates the hiredate of the employee record.Select.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |