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
- 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.
- Select Loader. On the right of Loader WebUI, click the link to open the Loader web UI.
- On the Loader page, click New job.
- Click Add next to Connection and set connection parameters.
For details about the parameters, see Loader Connection Configuration.
- 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
- On the Loader page, click New job.
- Click the drop-down list of Connection to view the connections you have created.
Editing a Connection
- On the Loader page, click New job.
- Select the name of the connection to be edited from the Connection drop-down list.
- Click Edit next to Connection.
- On the dialog box displayed, modify the connection parameters based on service requirements.
- Click Test.
- Click Save.
If a Loader job has integrated into a Loader link, editing the link parameters may affect Loader running.
Deleting a Connection
- On the Loader page, click New job.
- Select the name of the connection to be deleted from the Connection drop-down list.
- Click Delete.
- 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.
Parameter |
Description |
---|---|
Name |
Name of a Loader connection |
Connector |
Select generic-jdbc-connector. |
JDBC Driver Class |
JDBC driver classes are as follows:
|
JDBC Connection String |
Database access address, which can be an IP address or domain name. Enter the database connection string. In the following examples, 10.10.10.10 indicates the IP address and test indicates the database name.
|
Username |
Username for accessing the database |
Password |
Password of the user. Use the actual password. |
Parameter |
Description |
---|---|
Name |
Name of a Loader connection |
Connector |
Select ftp-connector. |
FTP Mode |
Select ACTIVE or PASSIVE. |
FTP Protocol |
Select:
|
File Name Encoding Type |
Encoding type of the file name or file path. |
Parameter |
Description |
---|---|
Name |
Name of a Loader connection |
Connector |
Select sftp-connector. |
Parameter |
Description |
---|---|
Name |
Name of a Loader connection |
Connector |
Select hdfs-connector. |
Parameter |
Description |
---|---|
Name |
Name of a Loader connection |
Connector |
Select oracle-connector. |
JDBC Connection String |
Connection string used for connecting to the database |
Username |
Username for accessing the database |
Password |
Password of the user. Use the actual password. |
Parameter |
Description |
---|---|
Name |
Name of a Loader connection |
Connector |
Select oracle-partition-connector. |
JDBC Driver Class |
Enter oracle.jdbc.driver.OracleDriver. |
JDBC Connection String |
Connection string used for connecting to the database |
Username |
Username for accessing the database |
Password |
Password of the user. Use the actual password. |
Parameter |
Description |
---|---|
Name |
Name of a Loader connection |
Connector |
Select mysql-fastpath-connector.
NOTICE:
When mysql-fastpath-connector is used, the mysqldump and mysqlimport commands of MySQL must be available on NodeManagers, and the MySQL client version to which the two commands belong must be compatible with the MySQL server version. If the two commands are unavailable or the versions are incompatible, see http://dev.mysql.com/doc/refman/5.7/en/linux-installation-rpm.html. Install the MySQL client applications and tools. For example, you need to install the following RPM packages in the RHEL-x86 system (select the package version based on the site requirements):
|
JDBC Connection String |
Connection string used for connecting to the database |
Username |
Username for accessing the database |
Password |
Password of the user. Use the actual password. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.