Deploying an Application with Teradata Database Through CLI

If you have a TIBCO ActiveMatrix BusinessWorks Plug-in for Database application that uses a Teradata database, follow these steps to deploy the application through CLI:

Prerequisites

  1. To start the agent, run the ./bwagent command from BW_HOME/bw/version_number/bin.
  2. To start the administrator, run the ./bwadmin command from BW_HOME/bw/version_number/bin.
  3. To change the mode to enterprise, run the mode enterprise command. This command is required to run the deployed application.
Note: You must follow the procedure as described in this section if you want to deploy your application on TIBCO Business Studio server.

Procedure

Design Time

  1. Create a BusinessWorks application with a JDBC shared resource and a ADB activity like you normally do.
  2. Copy the tdgssconfig.jar and the terajdbc4.jar files to the BW_HOME/bw/version_number/config/design/thirdparty folder.
  3. Go back to TIBCO Business Studio and click the JDBC shared resource Test Connection button.
    A notification pops up that you need to add the Runtime environment for the custom driver. Click OK and then you are prompted to create the custom driver.
  4. Follow the instructions to create the custom driver and click Test Connection.
    A successful connection is established.
  5. Continue to set up your JDBC connection so that it connects with the design time.

Run Time

  1. In TIBCO Business Studio, go to Run > Run Configuration.
  2. Click Bundles tab and ensure that the custom driver is selected.

Deploying the Application on TIBCO Business Studio Server

  1. Go to the custom driver created earlier and open the manifest.mf file.
  2. Go to the Dependencies tab and add the javax.xml.parsers. This is a mandatory step because the Teradata JAR files are dependent on some xml parsers to work. Click Save.
  3. Export the project to TIBCO_HOME/bw/version_number/system/shared. The project is exported as a JAR.
  4. Select the custom project and clear the classpath, project, and build.properties check boxes. Provide the export destination and the JAR file name and then click Next.
  5. Select the Use existing manifest from the workspace radio button.
  6. Click Browse to select the manifest file from the custom project and click OK and then Finish.
  7. The file selected earlier is exported as a JAR file.
  8. Go back to TIBCO Business Studio. Right-click the name of the project and select Deploy Application.
  9. Follow the wizard to create the domain, appspace, and appnode.
    You can see the application in running state.

What to do next

  1. To start the administrator, go to BW_HOME/bw/version_number/bin and run the command ./bwadmin.
  2. Go to the directory yourDomain/yourAppSpace/yourAppNode-xxxx, where xxxx is the port number and in most cases is 6081.
  3. To get the log of the currently picked appnode, run the getlogfile appnode command.

If you want to see debug options from the getlogfile then go to the BW_HOME/bw/version_number/domains/your-Domain/appnodes/youAppNodeName/youAppNodeName-xxxx/logback.xml.

Append the following code for the ADB palette: 
<logger name="com.tibco.bw.palette.adbplugin.runtime">
<level value="DEBUG"/>
</logger>

Append the following code for the JDBC shared resource: 

<logger name="com.tibco.bw.sharedresource.jdbc.runtime">
    <level value="DEBUG"/>    
  </logger>
Note: To push application with Teradata database connection on docker, prerequisite steps must be followed. You follow steps to create JAR file as mentioned earlier. After the JAR file is created, unzip the JAR file. A folder is created. Move this folder under BWCE_HOME/bwce/version_number/docker/resources/addons/jars