Open topic with navigation

TIBCO ActiveMatrix BusinessWorks™ Plug-in for Snowflake 6.3.0

# Pushing an Application to Cloud

This section contains information on how to push an app containing ActiveMatrix BusinessWorks™ Plug-in for Snowflake to the cloud.

The information mentioned in this section supersedes any information documented in the "Pushing an App to the Cloud" section in the TIBCO Cloud™ Integration documentation. Before attempting to push the app to the cloud, you must provide the Snowflake JDBC driver, snowflake-jdbc.jar.

For more information, see the section Adding Plug-in Supplements below.

Adding Plug-in Supplements

The Snowflake JDBC driver, snowflake-jdbc.jar installed during Snowflake client installation must be added using tibcli. The supplement must be added using the tibcli regardless of whether the app pushed from the command-line or the Web UI.

Note: To get the list of supported versions of Snowflake jdbc jar, refer to the Snowflake plug-in Readme file.
This is necessary only once for an entire organization. Subsequent app pushes by users in that organization automatically use the supplemented plug-in.

Perform the following steps to supplement the plug-in by using an additional jar:

1. Only an org admin can supplement the libraries required.
2. Navigate to TIBCO_HOME/bw*/palettes/snowflake/<version>/runtime/plugins.
3. Copy the Snowflake tpshell folder com.tibco.tpshell.snowflake.jdbc_6.2.0.001 into a new folder.
4. Compress com.tibco.tpshell.snowflake.jdbc_6.2.0.001 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 TIBCO Cloud Integration 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.

   Adding Plug-in Supplements is necessary only once for an entire organization. The supplemented plug-in is automatically used for subsequent app pushes by users in that organization.

Supplementing from CLI

1. Copy the snowflake.zip file into a temporary directory on your local machine. Do not add a manifest.json file or any other files to this directory. Do not copy the files into the directory where tibcli is installed, or copy tibcli into the new directory.
2. Change directory to the temporary directory.
3. Run the following command.

       cli-install-dir/tibcli bwplugin supplement snowflake

Supplementing from Web UI

For details about supplementing the connector using the Web UI, see the "Supplementing Plug-ins and Connectors" topic in the TIBCO Cloud Integration documentation.

Supplementing from Web UI is necessary only once for an entire organization. The supplemented plug-in is automatically used for subsequent app pushes by users in that organization.

Supplementing from the API

For details about supplementing the connector using the API, see the "TIBCO Cloud™ Integration API" topic in the TIBCO Cloud Integration documentation.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveMatrix BusinessWorks™ Plug-in for Snowflake

Copyright © 2020-2024. Cloud Software Group, Inc. All Rights Reserved.