Quick BI:Add an Alibaba PolarDB for Oracle data source

Procedure

1. Add the elastic IP address (EIP) of the exclusive resource group for Data Integration or the CIDR block of the vSwitch with which the resource group is associated to the IP address whitelist of the data source that the resource group needs to access.

   Before connecting to the Alibaba PolarDB for Oracle, add the Quick BI IP address to the Alibaba PolarDB for Oracle whitelist. For more information about how to add a Alibaba PolarDB for Oracle whitelist, see Set a whitelist for a cluster.

2. Add a Hologres data source and verify that the data source can be connected.

   1. After you log on to the Quick BI console.

   2. Follow these steps to add a data source.

      1. Go to the Create Data Source page.

      2. Click Show More.

         

      3. Select the Alibaba PolarDB for Oracle data source.

         

   3. In the Configure Connection dialog box, configure the following parameters based on your business requirements.

      Item	Description
      Display Name	The name of the data source. The name is displayed in the data source list. The name cannot contain special characters or start or end with spaces.
      Database Address	The public endpoint of the PolarDB for Oracle database. If you use a VPC data source, you must enter the internal endpoint and port of the database. Log on to the PolarDB console. In the Network Information section, obtain the database endpoint. Example: xxxxxxxxxxxxxxxxxxxxxx.ppas.rds.aliyuncs.com. For more information, see View or apply for an endpoint.
      Port Number	The corresponding port number of the database.
      Database	The name of the database to be connected.
      Schema	The schema of the database.
      Username and Password	The username and password that are used to access the database. Make sure that the username has the create, insert, update, and delete permissions on the tables in the database.
      VPC data source	If the database is deployed in a virtual private cloud (VPC), select VPC data source and configure the parameters. AccessKey ID and AccessKey: the AccessKey ID and AccessKey secret that are used to access the destination database. Log on to the RAM console and obtain the AccessKey ID and AccessKey secret. Instance ID and Region: the ID of the database instance and the region where the database resides. Log on to the PolarDB console to obtain the ID and region of the instance.
      Initialize SQL statements	If you select this check box, you can set the initialization SQL. The SQL statement that is initialized and executed after each data source connection. Only SET statements are allowed. The statements are separated by semicolons and line breaks are not allowed.

   4. Click Test Connection to verify that the data source can be connected.

      

   5. Click OK.