Connection

Available in VPC

Connection stores the information on access to data sources. Accordingly, the scanner can access the data sources only when it is connected to the connection. The Connection menu allows you to create and manage connections.

Create connection

To create a connection, follow these steps:

1. From the NAVER Cloud Platform console, click Services > Big Data & Analytics > Data Catalog, in order.
2. Click Configuration > Connection in order.
3. Click the [Create connection] button.
4. When the Create connection pop-up window appears, input the name and description of the connection.
5. Select the data source to connect in the Data type drop-down menu.
   • If you selected Cloud DB for the first time, the pop-up window for the Consent for personal information collection and use appears. Check the information, click the checkbox, and click the [Agree] button.
6. Input the information in accordance with the selected data type.

   • When Cloud DB Type is selected

     • Select the DB service and database with the source data.
     • To connect to the data source, input the username and password of the DB account created above.
       • If you selected Cloud DB for MySQL, the pop-up window from CloudDB for MySQL > DB Server > Manage DB > Manage DB User should contain 169.254.85.% registered as the Access IP of the account.
       • If you selected Cloud DB for PostgreSQL, the pop-up window from CloudDB for PostgreSQL > DB Server > Manage DB > Manage DB User should contain 169.254.85.% registered in the Enter CIDR to allow DB Access of the account.
       • If you selected Cloud DB for MSSQL, the pop-up window from CloudDB for MSSQL >DB Server > Manage DB> Manage DB User should contain 169.254.85.% registered as the Access IP of the account.
       • If you selected Cloud DB for MongoDB, the pop-up window from CloudDB for MongoDB >DB Server > Manage DB> Manage DB User should contain 169.254.85.% registered as the Access IP of the account.

   • If you have selected JDBC type

     • Enter the JDBC URL you wish to access. The default port can be omitted.

     • If you selected JDBC, the access IP of the destination must have 110.165.25.5 registered.

     • List of accessible DBMS: Microsoft SQL Server, MySQL, PostgreSQL

     • The following table includes a list of supported JDBC driver versions and accessible DBMS versions.

       Product	Driver version	Accessible DBMS version
       Microsoft SQL Server	12.4.0	SQL Server 2014 or higher
       MySQL	8.0.30	8.0 and 5.7
       PostgreSQL	42.5.0	8.4 or higher

   • When Object Storage is selected

     • Select the bucket with the source data.
     • Click the [Create bucket] button to create a bucket. For more information on bucket creation, see Create bucket.
7. Click the [Create] button.

Search connection and check information

To search for the created connection and check information, follow these steps:

1. From the NAVER Cloud Platform console, click Services > Big Data & Analytics > Data Catalog, in order.
2. Click Configuration > Connection in order.
3. Input the connection name or description in the search bar and click to search for the connection.
4. Click the connection and check the information.
   • Name: connection name
   • Description: description entered when creating the connection
   • Data type: connected data source
   • Creation date: date when the connection was created
   • Data details: detailed information on the connected data source
     • When connected to Cloud DB for MySQL: connected DB service/database
     • When connected to JDBC: connected JDBC
     • When connected to Object Storage: connected bucket
   • Updated date: most recent date of when the connection information was edited

Edit connection

To edit the created connection description and source data information, follow these steps:

1. From the NAVER Cloud Platform console, click Services > Big Data & Analytics > Data Catalog, in order.
2. Click Configuration > Connection in order.
3. Click the connection you want to edit and click the [Edit] button.
4. When the Edit connection pop-up window appears, edit the connection information.
   • For more information on each item, see Create connection.
5. Click the [Edit] button.

Delete connection

To delete the created connection, follow these steps:

1. From the NAVER Cloud Platform console, click Services > Big Data & Analytics > Data Catalog, in order.
2. Click Configuration > Connection in order.
3. Click the connection you want to delete and click the [Delete] button.
4. When the pop-up notification window appears, check the cautions and click [Delete].