Connection

Available in VPC

Connections store access information for data sources. Therefore, you must connect connections to the scanner so that it can access the data source. The Connection menu lets you create and manage connections.

Create a connection

To create a connection:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to > Services > Big Data & Analytics > Data Catalog.
2. Navigate to Configuration > Connection.
3. Click [Create connection].
4. When the Create connection popup window appears, enter a Name and Description for the connection.
5. Select the data source you want to connect to from the Data type dropdown menu.
   • When you first select Cloud DB, a popup window asks you to agree to the collection and use of personal information. Read the instructions, click the check boxes, and click [Agree].
6. Enter the information based on the Data type you selected.
   • If you selected the Cloud DB type
     • Select the DB service and Database where your source data resides.
     • Enter the User name and Password for the DB account you created above to connect to the data source.
       • If you selected Cloud DB for MySQL: Navigate to CloudDB for MySQL >DB Server > Manage DB > Manage DB users, and in the popup window, 169.254.85.% must be registered in the access IP item .
       • If you selected Cloud DB for PostgreSQL: Navigate to CloudDB for PostgreSQL >DB Server > Manage DB > Manage DB users, and in the popup window, 169.254.85.% must be registered in the DB access allowed CIDR item for that account .
       • If you selected Cloud DB for MSSQL: Navigate to CloudDB for MSSQL >DB Server > Manage DB > Manage DB users, and in the popup window, 169.254.85.% must be registered in the access IP item .
       • If you selected Cloud DB for MongoDB: Navigate to CloudDB for MongoDB >DB Server > Manage DB > Manage DB users, and in the popup window, 169.254.85.% must be registered in the access IP item .
   • If you selected the JDBC type
     • Enter the JDBC URL you want to access. You can omit the default port.
     • If you selected JDBC, 110.165.25.5 must be registered in the access IP item at where you want to access from.
     • List of accessible DBMS: MSSQL, MySQL, PostgreSQL, and MongoDB
     • Access URL formats by DBMS
       • MySQL : jdbc:mysql://{domain-name}:{port}/{database-name}?{options}
       • PostgreSQL : jdbc:postgresql://{domain-name}:{port}/{database-name}?{options}
       • MSSQL : jdbc:sqlserver://{domain-name}:{port};{property=value};
       • MongoDB
         • Stand-alone : mongodb://{domain-name}:{port}/{database-name}?{options}
         • Singe Replica Set: mongodb://{domain-name}:{port}/{database-name}?{options} (Select 1 server between primary and secondary)
         • Sharding : mongodb://{domain-name}:{port},{domain-name}:{port},.../{database-name]?{options} (Input all servers)
   • Accessible DBMS versions

     Product	Accessible DBMS versions
     	MSSQL
     	MySQL
     	PostgreSQL
     	MongoDB

   Note

   To perform a MongoDB query from the Data Query service, you must have READ_WRITE permissions. 
   

7. Click [Create].

Search for connections and view information

To search for and view information about the connections you have created:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to > Services > Big Data & Analytics > Data Catalog.
2. Navigate to Configuration > Connection.
3. In the search bar, enter the connection name or description, then click to search for the connection.
4. Click the connection to view the information.
   • Name: Connection name
   • Description: Description entered when creating the connection
   • Data type: The data source you connected to
   • Creation date and time: The date and time when the connection was created
   • Data details: Details about the data source you connected to
     • If you selected Cloud DB for MySQL: Connected DB services/databases
     • If you connected to JDBC: connected JDBC
   • Update date and time: The date and time when the connection information was most recently edited
   • Connection status: The connection's connection status

Edit connection

To edit the description and source data information for the connection you have created:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to > Services > Big Data & Analytics > Data Catalog.
2. Navigate to Configuration > Connection.
3. Click to select the connection you want to edit and click [Edit].
4. When the Edit connection popup window appears, edit the connection information.
   • For more information on each item, see Create connection.
5. Click [Edit].

Delete connection

To delete a connection you have created:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to > Services > Big Data & Analytics > Data Catalog.
2. Navigate to Configuration > Connection.
3. Click to select the connection you want to delete, and then click [Delete].
4. When the Notification popup window appears, read the cautions and click [Delete].