Using Create Service Wizard to Create a Service

In TIBCO Business Studio, you can use the Adapter Service General Configuration window to create adapter services.

1. From the Service Type list, select the service type you want to create and click Next.
   The adapter Location, Configuration, and Service Name fields are filled automatically.

   

2. In the Schema Type window, select a schema object.

   

   1. Click the browse button to open the ADB Business Object Schema Picker window.
   2. Click either of the following tabs to select a schema object and then click OK.
      The tabs are:

      • Local Business Object: if you want to select an object from the local repository, use this tab. Select the fetched object you want to use, and click OK.
        Note: If you want to select a schema object from the Local Business Object tab, ensure that the schema object exists in the Schema Browser view.
      • Remote Business Object: if you want to select an object that has not been fetched to the local repository, use this tab. If no object exists in the remote repository, you have to create a connection for the database. For more information, see Fetching Tables or Stored Procedures.
   3. Expand the destination and right-click the schema object to fetch an object.
   For Publication Service and Subscription Service, you have to select a table. The following figures show how to fetch a table for Publication Service or Subscription Service:

   

   

   

   

   

   For custom RPC Service, you have to select a stored procedure, function, or package. After you select Request-Response from the Service Type list and click Next, the Schema field is automatically filled with the SQL_REQUEST class. You can click the browse button to open the ADB Business Object Schema Picker window and fetch an object you want.

   

   The following figures show how to fetch a stored procedure for custom RPC Service:

   

   

   Note: In the Store Procedure Download Dialog window, when you select a stored procedure, function, or package, you can also specify the options in the Procedure Schema Information panel. For details, see Fetching Stored Procedures.

   

3. Optional: In the Transport Session window, select a transport session for the service.
   The Transport Session window displays the default transport for a service. You can select a different transport session.
   1. Click the browse button to open the Model Select window.
      
   2. Select a transport session.
      • If the transport session you want to use is created, select it from the list.
      • If you want to create a new transport session, click New.

        In the New Transport window, specify a name for the transport you want to use, select a transport type and a specific option, and click OK. Then select the session you just created.

        

   3. Click OK.
4. Click Finish.