Cozyroc SFTP Plugin

Author:  Eric Vasbinder 

Support Status:  Supported

Integration Method:  Automatic Imports Through Pickup Directory

Connection Method:  SFTP ingress and egress

Delivery Method:  SSIS Package with Auxiliary Cozyroc Plug-in Libraries

Hosted:  YES

• Hosting Location:  Vista Server (usually D1 or APP for EA environments) - This both an installable SFTP library and an SSIS package, thus it can be installed directly on the Vista server

Additional Charge:  NO

Product Use Case:

Synchronization of various information to and from Vista, using SFTP.

Similar Products:

N/A

ERP Connection Overview: 

As per many other server-side integrations to third-party products, this product is designed to talk to Vista's database by obtaining import and/or export files (e.g. CSV files) from the third party solution or Vista (for export files), which are then placed either into Vista's autoimport pickup directory or a separate share for eventual upload into a third party server.   

Deployment Methodology:

This product consists of an SSIS package that triggers the CozyRoc plugin and the SFTP plug in itself:  a set of simple SFTP extensions called "Cozyroc".  Trimble Viewpoint will host this package and extension in our cloud upon customer request. 

CRITICAL NOTE:  The SSIS Package is usually custom-built by partners, such as BIG, Tilson, Dell Boomi, and others.  Only the CozyRoc plugin libraries may be installed by Viewpoint personnel.  Beyond that, YOUR PARTNER MUST BE INVOLVED TO PROCEED WITH THE USE OF THIS METHOD TO ACCESS SFTP FROM VISTA.

Detailed Instructions:

• 1. Customer:  Submit a cloud support request to have this SSIS package and Cozyroc extension installed.

  2. Viewpoint:  Install Cozyroc extension.

  3. Partner (BIG, Tilson, Dell Boomi, etc.):  Supply Viewpoint with SSIS Package and configuration details.

  4. Viewpoint:  install supplied SSIS package.

  5. Partner or Customer:  Configure package to pull data from other location via SFTP and to place the resulting import files into the Vista pickup directory.

tl;dr:   This "shim" component may be hosted in the Trimble Viewpoint cloud.  Customers wishing to use this tool must submit a support request to Viewpoint cloud support to have Viewpoint install the SFTP plugin bits ("CozyRoc").  The partner involved must then also supply the SSIS package needed to trigger the CozyRoc plugin.  The customer and/or partner then configures this solution.