Batch add data source |
You can create only multiple MySQL, SQL Server, or Oracle connections at a time.
DataWorks provides templates for you to create multiple connections at a time. To
create multiple connections of a specific type at a time, download the corresponding
template, enter connection information in the template, and then upload the template.
The progress and result of creating connections are displayed in the Batch add data
source dialog box. You must configure the following information for each connection
in the template: connection type, connection name, description, URL, and applicable
environment. When you specify the applicable environment, the value 0 indicates the
development environment and the value 1 indicates the production environment.
|
New data source |
- Connections in the development environment: You can select such a connection when
you create a sync node, and then run the sync node in the development environment.
You cannot commit the sync node to the production environment for running.
- Connections in the production environment: You can use such a connection only in the
production environment. You cannot select such a connection when you create a sync
node.
Note The same connection must have the same name in the development and production environments.
|
Environment |
This parameter is not displayed for a workspace in basic mode. |
Operation |
- New: This button is displayed if no connection is configured for the corresponding environment.
Click the button to create a connection for the environment.
- Edit and Delete: These buttons are displayed if a connection is configured for the corresponding
environment. You can click Edit to modify the connection or Delete to delete the connection.
- Before you delete a connection from both the development and production environments,
check whether the connection is used by any sync node in the production environment.
The delete operation cannot be rolled back. After the connection is deleted, you cannot
select it when you configure a sync node in the development environment.
If a sync node in the production environment uses this connection, the sync node cannot
be run after the connection is deleted. Delete the sync node before you delete the
connection.
- Before you delete a connection from the development environment, check whether the
connection is used by any sync node in the production environment. The delete operation
cannot be rolled back. After the connection is deleted, you cannot select it when
you configure a sync node in the development environment.
If a sync node in the production environment uses this connection, you cannot obtain
metadata when you edit the sync node after the connection is deleted. However, the
sync node can be run in the production environment.
- Before you delete a connection from the production environment, check whether the
connection is used by any sync node in the production environment. If you select this
connection when you configure a sync node in the development environment, you cannot
commit the sync node to the production environment after the connection is deleted.
If a sync node in the production environment uses this connection, the sync node cannot
be run after the connection is deleted.
|
Select |
You can select multiple connections to test the connectivity of the connections or
delete them at a time.
|