Load Data from On-premises MySQL Database into Fusion Data Intelligence (Preview)

As a service administrator, you can use an extract service remote agent to connect to your on-premises MySQL database.

1. Set up the remote agent to load data from your on-premises MySQL database into Oracle Fusion Data Intelligence.
   See Set up the Remote Agent to Load Data into Fusion Data Intelligence (Preview).
2. Check the port number for your on-premises MySQL database and create a service request with server host and port details to enable network connectivity to the on-premises MySQL server.
3. Specify the remote agent and configure the on-premises MySQL database on the Data Configuration page in Oracle Fusion Data Intelligence by following these steps:
   1. On the 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 On-Prem as the connection type.
      
      
      
      
   5. In Connectivity Type, select Remote.
   6. In the Remote Agent field, select the remote agent connection that you created, for example, MySQL-Remote Agent. Enter an email address to receive notifications in Notification Email, and 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 "%r%a%o%%"
        Note
        
        If column name matches with pattern provided, then Fusion Data Intelligence 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 "%e%art%new"
        Note
        
        If column name matches with pattern provided, then Fusion Data Intelligence 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.
      
      
      
      
      
   7. 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 on-premises MySQL database unless you perform a metadata extract.
   8. Confirm that you see the Remote Agent and on-premises MySQL database connections on the Manage Connections page.
   9. Test both the connections by selecting the Test Connection option in Actions. You can check the statuses of all these requests on the Data Configuration Request History page.
   10. 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.
4. 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 on-premises MySQL database data. Select the applicable on-premises MySQL database source tables. See Augment Your Data.