Reason for Templates Directory stored under ADBconnections

Use of Templates Directory under ADBConnections in BW 6.x .

======================================== Product: TIBCO ActiveMatrix Adapter for Database Version: 7.2 Product: TIBCO ActiveMatrixBusinessworks Version: 6.3.x and above OS: All Supported Operating Systems ========================================

When a new JDBC connection (.sharedadbc) has been created in BW6.x for ADB adapter, it creates a "Templates" directory under the ADBConnection directory. It is the expected behavior of the JDBC connection because the Templates directory stores templates(template connection) to create a JDBC connection configuration for an adapter instance.

BW 6.x creates the JDBC connection (.sharedadbc)(i.e.template connection) under the Templates directory while creating the JDBC connection for AdapterInstance. These templates are reusable, that being,  the same JDBC Connection templates are used to configure multiple adapter instances.

While configuring an adapter instance using the JDBC connection in the "Templates" directory, the new connection is created and stored in the ADBConnections directory and the connection stored in the directory is used for fetching the data from the table while configuring the adapter services.

When the JDBC Connections stored in the Templates directory are deleted, the ADB adapter works without error because the ADB adapter uses a JDBC connection in the ADBConnections directory, hence the path in the connection reference box is given as /ADBConnections/ADBAdapterInstanceName.sharedadbc.

Now, for the migrated project.

When the Adapter project is migrated from BW5.x to BW 6.x, it creates only one JDBC connection as ADBAdapterInstanceName.sharedadbc under the ADBConnections directory and the ADB adapter uses the ADBAdapterInstanceName.sharedadbc . But if there is a need to use connection values in ADBAdapterInstanceName.sharedadbc for other ADB adapter instances, you must copy the ADBAdapterInstanceName.sharedadbc(template connection)in the Templates directory, because reusability is only offered by connections stored in the Templates directory.

ADB Connection creation scenarios:

1) The first way is to right click the project and create an "Adapter for Database Connection". In this scenario, it is actually creating a template connection under the template folder.
2) The second way is to create a new connection in the adapter configuration. In this scenario, It  will create a template connection under the template folder and the actual connection under the "ADBConnections" folder.
3) The third way is to refer to an existed connection in the adapter configuration. In this scenario, use copy of the referred template connection and paste to the "ADBConnections" folder.