CloverETL Server Project

From the CloverETL perspective, select FileNewCloverETL Server Project.

CloverETL Server Project wizard will open and it will guide you through the creation of the server project.

Connection to CloverETL Server

The first step is to create working connection to the CloverETL Server. Fill in CloverETL Server URL, User, and Password.

CloverETL Server Project Wizard - Server Connection

Figure 21.4. CloverETL Server Project Wizard - Server Connection


You can verify validity of the connection using the Test Connection button.

[Tip]Tip

You can use Remember password check box to save the password in your PC.

Once connection to the CloverETL Server is established, continue with the next step. This step has different dialogs for CloverETL Server and CloverETL Cluster.

The Sandbox on CloverETL Server

The second step of the wizard is to select an existing or create a new CloverETL Server sandbox. The sandbox will correspond to the project.

CloverETL Server Project Wizard - Sandbox Selection

Figure 21.5. CloverETL Server Project Wizard - Sandbox Selection


Use an existing sandbox or create a new one. In case you decide to create a new sandbox, the form is similar to the one present in CloverETL Server web interface. Refer to the CloverETL Server manual for further description on sandbox properties.

To create a project which only has data on the remote server, tick Do not cache sandbox files locally checkbox. This type of server project is known as RSE Server Project. In CloverETL 4.1.x and earlier, this project type was the only one available.

[Note]Note

One sandbox can be connected to a single workspace project only.

Press the Next button to create a new sandbox.

Next step: Specify Project Name

Sandbox on CloverETL Cluster

When using CloverETL Server deployed in cluster, the form for sandbox creation is different. Again, refer to the CloverETL Server manual for a description of sandbox types and their specific properties.

CloverETL Server Project Wizard - Clustered Sandbox Creation

Figure 21.6. CloverETL Server Project Wizard - Clustered Sandbox Creation


[Note]Note

In clustered environment, the shared sandbox type is the proper one to be bound to CloverETL Designer project, allowing the user to define and execute data transformations. Sandboxes of other types can be connected to workspace projects, too, but their purpose should be data access and distribution to the cluster.

Specify Project Name

The last step is to specify a name of the new CloverETL Server project. Keep the other values (Location, and File system) unchanged.

Giving a Name to the New CloverETL Server Project

Figure 21.7. Giving a Name to the New CloverETL Server Project


After clicking the Finish, CloverETL Server project will be created.