WhiteCup DataPump URL Change

On 4/12/2024 we will be changing some of our internal URL's to have better consistency between our products. This will require that the URL being used by the DataPump is updated in the application.properties file. This is a quick change, but is mandatory for the pump to continue functioning properly. Below are instructions on how to make this change (see Windows or Linux instructions depending on the machine where your DataPump is installed).

Make sure to not make these changes before 4/12 or else there won't be updated data in White Cup BI until after our upgrade is finished.

As a note, we're planning on beginning the upgrade process at 3pm PT on 4/12/2024. If this URL change is made before this time on 4/12, then there might be some errors in the DataPump log because it can't connect yet. These errors will not matter, the DataPump should correctly connect after we finish the deployment of the upgrade. This upgrade is expected to take no longer than 2 hours to complete.

Windows Instructions:

1. Locate the location of the DataPump folder
   • This folder is typically stored at the following location: C:\Program Files\DataPump
   • It's possible that it's stored in a separate location, if this is the case, you can get the DataPump folder location by taking a look at the properties on the pump service. Here's how to do this:
     1. Open the "Services" application
     2. Find the "White Cup Data Pump" service within the list
     3. Right click and choose "Properties"
     4. The "Path to executable" info will show you the path of the service. The first part of that will be what we need. Here's an example on what this could look like:
2. Once you have opened the DataPump folder in the file explorer, open the config folder
3. This is where the application.properties file is stored. Open this file
4. Towards the top there's a line that should say "pump.issuer-uri=https://login.tdfanywhere.com". We want to change this to "pump.issuer-uri=https://login.whitecupgo.com".
5. Once the change is made, save the file. 
   • If you get an error about needing the text editor to be started as an admin, follow the below instructions:
     1. Open the application search
     2. Search for Notepad
     3. Right click and choose "Run as administrator". This is how this should look:
     4. Once Notepad is opened as an admin, click "File" in the top left, and select "Open..." from the drop down. Then follow steps 3 & 4 from above to reopen, modify, and save the file.
6. Once the file has been modified and saved, we'll need to restart the service.
7. To restart the service, open the "Services" appliction
8. Find the "White Cup Data Pump" service within the list
9. Right click the service and choose "Restart" from this list
10. Once this is finished, then you are done with the URL change!

Linux Instructions:

1. A quick note, anywhere you see double quotes surrounding a phrase or command, make sure NOT to include them while following the instructions.
2. Locate the location of the DataPump directory
   • This directory is typically stored at the following location: /opt/DataPump
   • It's possible that it's stored in a separate location, if this is the case, you can get the DataPump directory location by taking a look at the properties on the pump service. Here's how to do this:
     1. Run the following command:

        • systemctl status DataPump

     2. You can find the location of the DataPump directory from the outputed information. Here's how this can look:
3. Navigate into the DataPump directory using cd. Using the above example, the command would look like this:

   • cd /opt/DataPump

4. Go into the config directory by doing cd config
5. From here, you can modify the application.properties file. Enter the following command to get into the editor:

   • sudo vi application.properties

6. Once you're in the editor, you should see a line towards the top that says: "pump.issuer-uri=https://login.tdfanywhere.com". Enter the 'i' key to enter Insert mode (this will allow editing)
7. Use the arrow keys to navigate to the line mentioned in step 6
8. Delete out the "tdfanywhere" portion of the line
9. Type in "whitecupgo" where the "tdfanywhere" was removed
10. The line should now say: "pump.issuer-uri=https://login.whitecupgo.com"
11. Hit the ESC key to exit insert mode
12. Hit the ":" key
13. Enter "wq" to save the document
14. Next we'll need to restart the DataPump service to get the change to take effect.
15. Run the following command to stop the service:

    • sudo systemctl stop DataPump

16. Run the following command to start the service:

    • sudo systemctl start DataPump

17. Run the following command to check the status of the service:

    • sudo systemctl status DataPump

18. The "Active" portion of the status output should say "active (running)". If this is the case, then you are finished with the URL change!