[]
        
(Showing Draft Content)

Connect to StarRocks

To connect to a StarRocks data source in Wyn Enterprise, follow these steps,

  1. On the Resource Portal, navigate to + (Create) > Create Data Source.


    Screenshot 2024-11-11 at 11.41.16 AM


  2. Select StarRocks from the data source list on the left or from the icon view on the right.


    Screenshot 2024-11-11 at 11.45.00 AM


  3. Fill in the database configuration information for the selected data source as described in the below table.


    Field

    Description

    Name*

    Specify a name for the data source.

    Server*

    Server name or address.

    Port*

    Enter a port number. The default port number is 9030.

    User*

    Enter the user name to connect to the StarRocks database.

    Password

    Enter the password for the StarRocks database user.

    Database*

    Enter the StarRocks database server instance name or select an instance from the dropdown.

    Use Configuration String (Advanced)

    Use this option to connect to the data provider through a connection string. The format of the connection string is: Server=myServerAddress; Port=mySeverPort; Database=myDataBase; Uid=myUsername; Pwd=myPassword;

    Use Table/Field Name Mapping

    If you check this option, you can either import a CSV file or manually enter the display names for the required tables or fields in the Mapping dialog. In the case of the RDBMS databases, you can also import the name mapping information from another database. For more information on mapping tables and column names, visit this help article.

    *Required fields


  4. Verify the database connection by clicking the Test Connection button. If the data source is available, and the credentials are correct, you receive a notification on successful connection.


  5. Click the Create button after the connection is successful.


    Screenshot 2024-11-11 at 11.48.44 AM


  6. You can view the added data source in the Categories tab of the Resource Portal.