Connecting to a DWS Data Source
Overview
ROMA Connect can use the DWS data source for creating data integration tasks or data APIs. Before using the DWS data source, you need to connect it to ROMA Connect.
Use the PostgreSQL data source to connect to a DWS database. (The DWS data source is to be unreleased and thus not recommended.)
Prerequisites
Each connected data source must belong to an integration application. Ensure that an integration application is available before connecting a data source, or create one first.
Procedure
- Log in to the ROMA Connect console. On the Instances page, click View Console next to a specific instance.
- In the navigation pane on the left, choose Data Sources. In the upper right corner of the page, click Access Data Source.
- On the Default tab page, select DWS and click Next.
- Configure the data source connection information.
Table 1 Data source connection information Parameter
Description
Name
Enter a data source name. It is recommended that you enter a name based on naming rules to facilitate search.
Encoding Format
Default: utf-8
Integration Application
Select the integration application to which the data source belongs.
Description
Enter the descriptive information.
Connection Address
Enter the IP address and port number for connecting the database in the DWS cluster.
Database Name
Enter the name of the database to be connected in the DWS cluster.
Username
Enter the username for connecting to the database.
Password
Enter the password for connecting to the database.
The following figure shows how to configure DWS data source connection.
Figure 1 Example of DWS data source connection configuration
- Click Check Connectivity to check the connectivity between ROMA Connect and the data source.
- If the test result is Data source connected successfully, go to the next step.
- If the test result is Failed to connect to the data source, check the data source status and connection parameters, and click Recheck until the connection is successful.
- Click Create.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot