As a service administrator, you can use an extract service remote agent to connect to your on-premises Oracle PeopleSoft system.

1. Set up the remote agent to load data from your on-premises Oracle E-Business Suite system into Oracle NetSuite Analytics Warehouse.
   See Set up the Remote Agent to Load Data into NetSuite Analytics Warehouse (Preview).
2. Configure the remote agent and PeopleSoft data source on the Data Configuration page in Oracle NetSuite Analytics Warehouse using these instructions:
   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 the connection type based on the functional module that you want to connect to. For example, to connect to the "Financials" module, select Oracle PeopleSoft On-Prem - Financials as the connection type.
      
      
      
      
   5. In Create Connection for Oracle PeopleSoft On-Prem - Financials dialog, in Connectivity Type, verify that Remote is selected automatically.
      
      
      
      
   6. In Remote Agent, select the remote agent connection that you created earlier, for example, Remote Agent.
   7. Enter an email address to receive notifications in Notification Email, provide credentials for your PeopleSoft source in User Name and Password, and the URL of your PeopleSoft source in URL.
   8. 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 PeopleSoft unless you perform a metadata extract.
   9. Click Save.
   10. On the Manage Connections page, select Actions for the PeopleSoft connection and then select Test Connection. You can check the statuses of all these requests on the Data Configuration Request History page.
   11. 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.
3. 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 PeopleSoft data. Select the applicable PeopleSoft source tables. See Augment Your Data.