Implementation Options

Implementation Options

StarfishETL Implementation Options



StarfishETL On‐Prem – Install on your own server.

Pro
      Most secure option. Everything is behind the firewall
      Data doesn’t leave your organization
Con
      If not implementing yourselves, you will need to give a StarfishETL developer access to the Server, Web Services and the server with QuickBooks (QB)
      installed.
      You will be responsible for system updates
      You will be responsible for StarfishETL server on‐going maintenance
      Cost of the StarfishETL server. It can be on a shared server.
      Requires Windows servers and licensing. StarfishETL would cohabit with other applications
    StarfishETL Designer for Windows is in maintenance mode. Future updates to map will require connectivity to a test system for each end point that is exposed to the cloud.  Once changes are made, they will need to be exported to a local system and deployed locally using the StarfishETL Administration console.

StarfishETL Ray (direct to db, API or Web Service) 

StarfishETL Ray is a companion application installed on a server within the firewall that provides a second layer of security. The StarfishETL Ray connects to the StarfishETL Cloud servers and provides a bridge between on‐premises databases and StarfishETL Integration Platform as a service (iPaaS) application. All communication from the StarfishETL Ray originates from the client‐side. The StarfishETL iPaaS does not make requests to the Ray. It is not needed if StarfishETL iPaaS and all end points are deployed on‐Premises.
Pro
 Supports only Client‐side requests. No outside access.
 Light‐weight footprint – smaller program than StarfishETL On‐Prem
 Auto‐updater – You would not need to periodically update The Ray
 Design and maintenance can be accomplished off‐site via web interface.
 No outside access to on‐premises servers required
Con
 Installation of StarfishETL Ray
 StarfishETL Ray must have access through firewall to using secured HTTP

StarfishETL Cloud (iPaaS) 

Uses secure HTTP port to provide StarfishETL Cloud Designer and StarfishETL integration engines access to local databases. Management of the maps, scheduler, administration and design components are all web‐based.
Pro
  Programming, development and management does not require user logging onto the your domain. Should facilitate the application configuration and development.
  Port access can be further protected by white listing the StarfishETL server ‘s IP address
Con
  Port accessible from outside the firewall and if not locked down provides a potential vulnerability

    • Related Articles

    • Run Job Options

      Definitions/explanations of the different options for when you wish to run a job. Option Name Description Begin at Row Begin at Row/Leave blank to start at the first row. End at Row End at Row/Leave blank to process through to the end of all rows. ...
    • StarfishETL iPaaS Logging Features and Settings

      StarfishETL iPaaS Logging Features and Settings StarfishETL iPaaS has a number of options for logging and monitoring integration activity. Logging is required at various stages of the integration mapping process, during the testing phase prior to ...
    • Creatio / Hubspot Starter Template

      Note: Before beginning it is important to understand that while this is a prebuilt integration it is highly recommended that someone who is familiar with both systems, their databases and your processes perform the implementation.  It is also ...
    • Pipedrive Connector

      Connecting to Pipedrive Pipedrive uses token-based authentication to control access to its API. Using Token Authentication To authenticate to Pipedriver, you will need your Pipedrive API Key. You can find it by navigating to 'Settings' > 'Customize' ...
    • Sharepoint Connector

      Additional Documentation This Connector is based on the Sharepoint ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/RSG/ado/ If connecting to Sharepoint using Single ...