Load Data from MySQL Cloud Database into NetSuite Analytics Warehouse (Preview)

As a service administrator, you can use the NetSuite Analytics Warehouse extract service to acquire data from the MySQL Cloud database and use it to create data augmentations.

Ensure that MySQL Cloud is enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.

1. Check the port number for your MySQL Cloud database and create a service request with server host and port details to enable network connectivity to the MySQL server.
2. In NetSuite Analytics Warehouse, create the MySQL Cloud database connection using these instructions:
   1. In NetSuite Analytics Warehouse Console, click Data Configuration under Application Administration.
   2. On the Data Configuration page, click Manage Connections.
   3. On the Manage Connections page, click Create and then click Connection.
   4. In Create Connection, select Data Extraction in Usage Type and then select MySQL Cloud as the connection type.
      
      

      

      
      
   5. In the dialog for the MySQL Cloud database connection, provide these details:
      • Host Name: Enter the host name of MySQL server such as 100.111.252.64
      • Port Number: Enter the port number where the server is listening such as 3306
      • Database: Enter the database name you need to connect to such as airportdb
      • Credentials to access the database in User Name and Password
      • Last Update Date Column Pattern: Enter format such as "%mo%fie%te%"

        Note:

        If column name matches with pattern provided, then NetSuite Analytics Warehouse marks the column name with isLastUpdateDate = true and uses it for the incremental extract. For example, if pattern provided is “%mo%fie%te%“, then the column name modifiedDate is marked as isLastUpdateDate = true.
      • Initial Extract Date Column Pattern: Enter format such as "%cr%ted%te%"

        Note:

        If column name matches with pattern provided, then NetSuite Analytics Warehouse marks the column name with isCreationDate = true and uses it for the initial extract date extraction. For example, if pattern provided is: “%cr%ted%te%“, then the column name createdDate is marked as isCreationDate = true.

      
      

      

      
      
   6. Verify that the Refresh Metadata toggle is enabled to ensure that the metadata is refreshed when you save the connection.
      You can later refresh the metadata from the Actions menu on the Manage Connections page, if required.

      Note:

      You can’t create augmentations for MySQL Cloud database unless you perform a metadata extract.
   7. Click Save.
3. On the Manage Connections page, select Actions for the MySQL Cloud database connection and then select Test Connection.
4. To delete a connection, on the Manage Connections page, click Actions for the applicable connection and select Delete.

   Note:

   Ensure that you delete the functional areas, data augmentations, and custom data configurations related to the data connection before deleting it. You can't update or load data from deleted data connections to the warehouse.
5. After the connections are successfully established, navigate to the Data Configuration page, select the connection in Data Source, then click the Data Augmentation tile, and create a data augmentation using the MySQL Cloud database data. Select the applicable MySQL Cloud database source tables. See Augment Your Data.