Managing Loader Links (MRS 3.x and Later Versions)

Scenario

You can create, view, edit, and delete links on the Loader page.

This section applies to MRS 3.x or later.

Creating a Connection

1. Log in to the service page.

   For MRS 3.x or later, log in to FusionInsight Manager (for details, see Accessing FusionInsight Manager (MRS 3.x or Later)) and choose Cluster > Services.

2. Select Loader. On the right of Loader WebUI, click the link to open the Loader web UI.
3. On the Loader page, click New job.
4. Click Add next to Connection and set connection parameters.

   For details about the parameters, see Loader Connection Configuration.

5. Click OK.

   If connection configurations, for example, IP address, port, and access user information, are incorrect, the connection will fail to be verified and saved.

   

   You can click Test to immediately check whether the connection is available.

Viewing a Connection

1. On the Loader page, click New job.
2. Click the drop-down list of Connection to view the connections you have created.

Editing a Connection

1. On the Loader page, click New job.
2. Select the name of the connection to be edited from the Connection drop-down list.
3. Click Edit next to Connection.
4. On the dialog box displayed, modify the connection parameters based on service requirements.
5. Click Test.
   • If the test is successful, go to 6.
   • If the test fails, repeat 4.

6. Click Save.

   If a Loader job has integrated into a Loader link, editing the link parameters may affect Loader running.

Deleting a Connection

1. On the Loader page, click New job.
2. Select the name of the connection to be deleted from the Connection drop-down list.
3. Click Delete.
4. In the displayed dialog box, click OK.

   If a Loader job has integrated a Loader connection, the connection cannot be deleted.

Loader Connection Configuration

Loader supports the following connections:

• generic-jdbc-connector: For details about parameter settings, see Table 1.
• ftp-connector: For details about parameter settings, see Table 2.
• sftp-connector: For details about parameter settings, see Table 3.
• hdfs-connector: For details about parameter settings, see Table 4.
• oracle-connector: For details about parameter settings, see Table 5.
• mysql-fastpath-connector: For details about parameter settings, see Table 7.
• oracle-partition-connector: For details about parameter settings, see Table 6.