- What's New
- Service Overview
- Getting Started
-
User Guide
- Database Evaluation
- Object Migration
- SQL Statement Conversion
- Conversion Configuration
- SQL Audit
- Data Source Management
- Permissions Management
- Interconnection with CTS
- Best Practices
- Security White Paper
-
API Reference
- Before You Start
- API Types
- Calling APIs
-
API
- API Version Management
- Quota Management
- SQL Statement Conversion
- Evaluation Project
-
Migration Project
- Creating a Migration Project
- Querying Migration Projects
- Querying the Status of a Migration Project
- Checking Target Database Permissions
- Querying Permission Check Results
- Querying Migration Project Details
- Submitting Syntax Conversion of Objects
- Querying Syntax Conversion Progress of Objects
- Submitting Verification
- Querying the Verification Progress
- Downloading a Migration Error Report
- Deleting a Migration Project
- Permissions Policies and Supported Actions
- Appendixes
- SDK Reference
-
FAQs
-
Product Consulting
- Instance Freezing, Release, and Deletion
- Which Schemas in Source Databases Are Ignored for Migration?
- What Are the Differences Between Syntax Conversion and Migration & Verification in a Migration Project?
- What Are the Database Schema Changes After an Oracle Database Is Migrated to the Target Database?
- Why Cannot I Use Some Functions?
- What Is the Function of the dsc_ora_ext Schema Generated After Migration to the Target Database?
- What Should I Do If Data Collection Fails or Is Slow Due to the Small Values of Certain Oracle SGA Parameters?
- What Should I Do If Data Collection Fails and a Message SNAPSHOT TOO OLD Is Displayed?
- What Is the Mapping Between the GaussDB Versions Displayed on the UGO Console and Self-built GaussDB Versions?
- What Are VPCEP Resource Quotas?
-
Database Connections
- What Should I Do If I Cannot Connect to the Source Oracle Database During Database Evaluation Project Creation?
- What Should I Do If I Failed To Connect to the Source Database as User sys?
- How Do I Create GaussDB Databases Compatible with Source Databases?
- What Should I Do If My Database Fails to be Connected?
- SQL Server Connection Test Failed (Error Code=0, SQLState=08S01)
-
Evaluation Project
- How Do I Select a Connection Method?
- How Does UGO Collect Data from Source Databases?
- How Does UGO Check Database Permissions?
- What Are the Possible Causes for an Object Collection Failure?
- In GaussDB, How Do I Configure a Search Path If A Statement Without Schema Name Fails To Be Executed?
- What Is Native Compatibility, Conversion Compatibility, Partial Compatibility, or Incompatibility?
- What Is the Relationship Between Migration Risk (Top 10 risk SQL) and Risky SQL Summary?
- What Are Reconstruction Statistics and How Are Reconstruction Points Measured?
- What Should I Do If An Object Collection Error (Closed Connection) Is Displayed During Evaluation Project Creation?
- What Should I Do If "ErrorCode=4036" Is Displayed During Evaluation Project Creation?
- What Should I Do If "ErrorCode=17002" Is Displayed During Evaluation Project Creation?
- What Do I Do If the Assessment Task Is Connected but the Pre-check Fails?
- What Is the Impact of the Collection on the Source Database?
-
Migration Project
- Why Is There No Available Evaluation Project During Migration Project Creation?
- When Should I Use the Conversion Config Function?
- What Should I Do If SQL Modifications Failed to Be Saved During Object Correction?
- How Do I Solve ERROR: syntax error at or near "@"?
- What Are the Possible Causes for an Object Verification Failure?
- What Are the Impacts of GUC Parameter Settings of GaussDB on Migration?
- How Do I Set GaussDB GUC Parameters?
- Why Is the Number of Indexes Different After Oracle Data is Migrated to GaussDB?
- What Should I Do If There Are ctid, xc_node_id, and tableoid Columns in GaussDB?
- Why Is Data Inconsistent When SELECT Statements Without ORDER BY Are Used for Query in Distributed GaussDB?
-
Product Consulting
- Videos
- General Reference
Show all
Copied.
Creating a Data Source
Scenarios
You can perform unified data source management. Currently, this function is used only for SQL audit.
Prerequisites
The data source to be created must be connected successfully.
Procedure
- Log in to the UGO console.
- In the navigation pane, choose Data Source Management.
- Click Create Data Source in the upper right corner.
- Configure parameters as needed.
After the basic information is configured, the Test button next to Test Connection is available.Figure 1 Creating a data source
Table 1 Parameter description Parameter
Example Value
Description
Name
app_db_01
Name displayed in the data source management list.
The name must contain 5 to 50 characters, start with a letter, and end with a digit or letter. Only letters (case-insensitive), digits, underscores (_), and hyphens (-) are allowed.
DB Type
GaussDB
Type of the source database to be configured. Currently, only GaussDB, MySQL, and PostgreSQL are supported.
Network Type
Public network
Public network: An EIP is used to connect to a database.
If the database has an IP address whitelist, add the EIP to the whitelist to ensure that UGO can connect to the database.
Connection Method
Service name
Only the server name can be used for connection.
DB Name
demo_db_01
Name of a database to be managed.
Enter a string of 2 to 128 characters, including letters, digits, periods (.), underscores (_), hyphens (-), dollar signs ($), and number signs (#). The value must start with a letter, digit, period (.), underscore (_), or hyphen (-) and can contain quotation marks (").
Host Type
Host IP Address
Only the host IP address can be used.
Host IP Address
192.168.1.2
Host IP address, which can be an IPv4 or IPv6 address
NOTE:
When DB Type is set to MySQL, IPv6 address can be used.
Host Port
4000
Port of the database to be managed
Username
demo_user_01
Username of the database to be managed.
The value is a string of 2 to 128 characters, including letters, digits, underscores (_), hyphens (-), dollar signs ($), and number signs (#). It must start with a letter, digit, period (.), underscore (_), or hyphen (-) and can be enclosed in double quotation marks.
Password
Pass@worD&^
Password of the database to be managed.
The password can contain up to 50 characters.
- Click Test. If the test is successful, Connected is displayed, and the Create button in the lower right corner is available.
If the test failed dut to network faults or insufficient permissions, an error is displayed. You cannot create a data source.
- Click Create. A message is displayed, indicating that the project is created.
- Click OK to go to the Data Source Management page. View the data source you created in the list.
You can search for a data source by data source ID, data source name, database name, database type, IP address, or port.Figure 2 Viewing a data source
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