Starfish Ray: Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
No edit summary
Line 3: Line 3:


[[File:StarfishRayCommandPrompt.png]]
[[File:StarfishRayCommandPrompt.png]]
''Starfish Ray running in Console Mode''
''Starfish Ray running in Console Mode''



Revision as of 20:35, 7 September 2018

Overview

The Starfish Ray is a light-weight footprint service installed on a client machine which enables the movement of data from a system behind the firewall to other cloud-based systems. Our cloud hosted Starfish software facilitates this movement of data. The Ray establishes a SSL connection (typically over websockets) to our hosted environment, then listens for requests. They Ray authenticates using a predefined Auth Token. After authentication, the Ray listens for requests from the server to pull or push data. This is always done in real-time - no data is ever stored on the server. This design enables database and legacy software to communicate with cloud applications without the need to open ports or punch holes in the customer's firewall.

Starfish Ray running in Console Mode

Installation

  1. Log into your account at https://designer.starfishetl.com
  2. Click Connections -> New Ray. Give it a name and click Save.
  3. On the Manage Rays page, download the Ray software ZIP file and extract it to a path on your PC (ie: C:\StarfishRay)
  4. To 'Unblock' the downloaded files, it may be necessary to run the following PowerShell command: Get-ChildItem -Path 'C:\StarfishRay\' -Recurse | Unblock-File
  5. Edit the StarfishRay64.exe.config file with a text editor.
  6. Ensure the ConnectorPath setting is pointed to a valid path.
  7. Copy & Paste the Ray ID and Token from the browser into the config file in the corresponding settings.
  8. Save the config file.
  9. To run Starfish Ray as a CONSOLE application, simply launch StarfishRay64.exe. When running in console mode, you must ensure the application stays open and running.
  10. To run Starfish Ray as a WINDOWS SERVICE application, run the "_Install 64-bit Service.bat" batch file (As Administrator). Then go to Services, and find "Starfish Ray (64-bit)" and Start it.

Platform

There is also a 32-bit version of the Starfish Ray available in the download (StarfishRay32.exe). Use this only in cases where you need to use ODBC or OLEDB with 32-bit drivers.