Supplementing to TIBCO Platform

To ensure the functionality of the TIBCO ActiveMatrix BusinessWorks™ Plug-in for Snowflake on the TIBCO® Platform, incorporate the plug-in supplements into the TIBCO® Control Plane before deploying any application that utilizes the plug-in.


Generating Plug-in Supplements

1. Navigate to "TIBCO_HOME/bw*/palettes/snowflake/<version>/runtime/plugins" directory.

2. Copy the Snowflake tpshell folder "com.tibco.tpshell.snowflake.jdbc_version" into a new folder.

3. Compress "com.tibco.tpshell.snowflake.jdbc_version" folder and name it "snowflake.zip."
Note: To allow the Snowflake activities to handle the timestamp data type properly after pushing the application to the cloud, use the "CUSTOM_ENGINE_PROPERTY" variables under "Environment Controls > Engine variable" in the user interface to set custom engine properties. The variable "CUSTOM_ENGINE_PROPERTY" value must be populated in the following way:
"javax.xml.datatype.DatatypeFactory=com.sun.org.apache.xerces.internal.jaxp.datatype.DatatypeFactoryImpl".

Supplementing from Web UI on the TIBCO Control Plane

1. Log in to TIBCO Control Plane.

2. Click "Data Planes" from the left navigation.

3. On the Data Plane card of your choice, click "Go to Data Plane."

4. Go to the Integration Capabilities and click "Upload Supplement".

5. In the Upload Supplement dialog, select a plug-in or driver from the dropdown list.
   
6. Drag your supplement "snowflake.zip" archive onto the window. You can also click "browse to upload" to find the files on your system.  

7. After you select the file, click "Upload selected file" and close the window.

Note: Adding the plug-in supplement is only necessary once for a Data Plane. Subsequent application pushes in that Data Plane automatically use the supplemented plug-in.

Supplementing from the API

For details about supplementing the connector using the API, see the "API for Uploading Supplements" topic in the TIBCO® Control Plane documentation.