Document aJNbJ5LOwjdjeXnN8x7xXdZwb

DownloadRandom document
Message From: Sent: To: CC: Subject: Killian, Cole [/O=EXCHANGELABS/OU=EXCHANGE ADMINISTRATIVE GROUP (FYDIBOHF23SPDLT)/CN=RECIPIENTS/CN=2D49BCB7ECD943178E281A7ADC7C635F-A3B37796-B8] 2/7/2025 3:43:24 PM Wilson, Kevin [Wilson.Kevin@epa.gov] Cunningham, James [Cunningham.James@epa.gov]; Coogan, Daniel [Coogan.Daniel@epa.gov] RE: Grants Datamart Connection Ran it, this is great. Thank you, Cole From: Wilson, Kevin <Wilson.Kevin@epa.gov> Sent: Friday, February 7, 2025 9:12 AM To: Killian, Cole <Killian.Cole@epa.gov> Cc: Cunningham, James <Cunningham.James@epa.gov>; Coogan, Daniel <Coogan.Daniel@epa.gov> Subject: RE: Grants Datamart Connection Sure - here's a sample query to run in Oracle SQL Developer that should prove helpful. Thanks, Kevin From: Killian, Cole <' Sent: Thursday, February 6, 2025 4:37 PM To: Wilson, Kevin ;on.Kevinicpepa.gov> Cc: Cunningham, James <Cun. ' n 'ames@epa.gov>; Coogan, Daniel <Coogan.Daniel@epa.gov> Subject: RE: Grants Datamart Connection Hi Kevin, Perfect. I now have Oracle SQL Developer client installed and can see that the updated NGGS permissions have gone through. Looking forward to the sample query. Best, Cole From: Wilson, Kevin <`Atikon.Kevinaen- vf> Sent: Thursday, February 6, 2025 2:15 PM To: Killian, Cole < n.CJie@epa.gov> Cc: Cunningham, James <Cunnirw --iJames@epa.gov>; Coogan, Daniel <Coogan.Daniel@epa.gov> Subject: RE: Grants Datamart Connection Hi Cole, I wanted to get back to you on the status of the items that I'm following up on from our meeting: 1.) Oracle SQL Developer client -- the request is in the system and has been prioritized, so a technician from the EISD hotline should be in the process of scheduling a time to install. 2.) Your NGGS account has been given reader access to all the different regions at EPA (Regions 1-10) in addition to HQ. Earthjustice/Sierra Club 2025-EPA-05146 ED_018033_00000487-00001 SC_EVERSPLIT0032141 3.) The Datamart team is putting together a sample query to pull grant information from the OARM OGDDM database, which should be ready soon. If there's something that I missed just let me know. Thanks, Kevin From: Killian, Cole < Sent: Thursday, February 6, 2025 10:02 AM To: Wilson, Kevin <," 'son.Kevin@epa.gov> Cc: Cunningham, James <r.,nr, lames@epa.gov> Subject: RE: Grants Datamart Connection Hi Kevin, Thank you, it was great meeting with you this morning too. Best, Cole From: Wilson, Kevin <'' Sent: Thursday, February 6, 2025 9:49 AM To: Killian, Cole <Kil n.CJIe@epa.gov> Cc: Cunningham, James <Cunr', sm.James@epa.gov> Subject: Grants Datamart Connection Hi Cole, It was great meeting with you this morning, and I'm planning on attending today's NGGS demo in person at 10:30AM. We'll put through the order for the Oracle SQL Developer client to be installed on your laptop for SQL access. Below is the connection information to the Oracle NGGS Grants DataMart that you will use to connect after the Oracle SQL Developer client is installed on your computer. I will see you soon. Thanks, Kevin Ex. 6 Personal Privacy (PP) A i PaSSword =. Ex. 6 Personal Privacy (PP) with OARM OGDDW RDR role authorization. i Connect information: . Ex. 6 Personal Privacy (PP) Thanks. Dave David Greene Database Analyst Advisor ITS-EPA IV MAINES Federal Civilian Division Earthjustice/Sierra Club 2025-EPA-05146 ED_018033_00000487-00002 SC_EVERSPLIT0032142 General Dynamics Information Technology 79 T.W. Alexander Drive, Bldg 4401, Suite 400 Durham, NC 27709 919-801-9153 sreene.david@epa.gov GENERAL OVNA.IV1ICL Inforrrvior Technology Earthjustice/Sierra Club 2025-EPA-05146 ED_018033_00000487-00003 SC_EVERSPLIT0032143