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. The 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
Please note that as of August 2021, Starfish Ray does not support reading of file attachments to copy files to another location due to performance concerns about such usage. In this scenario, the recommended options are to use FTP (preferably SFTP or FTPS) or to run Starfish locally on your server.
Both the 32-bit and 64-bit versions of the Starfish Ray require .NET 4.7.1.
- Log into your account at https://designer.starfishetl.com
- Click Connections -> New Ray. Give it a name and click Save.
- On the Manage Rays page, download the Ray software ZIP file and extract it to a path on your PC (ie: C:\StarfishRay)
- To 'Unblock' the downloaded files, it may be necessary to run the following PowerShell command: Get-ChildItem -Path 'C:\StarfishRay\' -Recurse | Unblock-File
- Edit the StarfishRay64.exe.config file with a text editor.
- Ensure the ConnectorPath setting is pointed to a valid path.
- Copy & Paste the Ray ID and Token from the browser into the config file in the corresponding settings.
- Save the config file.
- 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.
- 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.
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.