Automating delimited file aggregations using the File Upload Utility

Content Video Library
,
1

Description

Join Expert Ambassador Krishna Mummadi as he showcases a few ways to use the File Upload Utility tool in Identity Security Cloud. Krish will show how to delimit file aggregations automatically, compare feed files, avoid unnecessary access gaps, and send emails with workflows.

Find the File Upload Utility and other awesome tools in the CoLab!

Resources

The Powershell script is in the process of being added to the CoLab.

Automating delimited file aggregations using File Upload Utility
Automating delimited file aggregations using File Upload Utility1920Ă—1080 101 KB

7 Likes
2

I am receiving below “Connection Timeout” in our env, what are the parameters that I will need to check to resolve the issue. Please advise

<
java.net.SocketTimeoutException: Connect timed out
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:546)
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:333)
at java.base/java.net.Socket.connect(Socket.java:648)
        at okhttp3.internal.platform.Platform.connectSocket(Platform.java:130)
        at okhttp3.internal.connection.RealConnection.connectSocket(RealConnection.java:263)
        at okhttp3.internal.connection.RealConnection.connect(RealConnection.java:183)
        at okhttp3.internal.connection.ExchangeFinder.findConnection(ExchangeFinder.java:224)
        at okhttp3.internal.connection.ExchangeFinder.findHealthyConnection(ExchangeFinder.java:108)
        at okhttp3.internal.connection.ExchangeFinder.find(ExchangeFinder.java:88)
        at okhttp3.internal.connection.Transmitter.newExchange(Transmitter.java:169)
        at okhttp3.internal.connection.ConnectInterceptor.intercept(ConnectInterceptor.java:41)
        at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:142)
        at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:117)
        at okhttp3.internal.cache.CacheInterceptor.intercept(CacheInterceptor.java:94)
        at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:142)
        at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:117)
        at okhttp3.internal.http.BridgeInterceptor.intercept(BridgeInterceptor.java:93)
        at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:142)
        at okhttp3.internal.http.RetryAndFollowUpInterceptor.intercept(RetryAndFollowUpInterceptor.java:88)
        at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:142)
        at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:117)
        at okhttp3.RealCall.getResponseWithInterceptorChain(RealCall.java:229)
        at okhttp3.RealCall.execute(RealCall.java:81)
        at retrofit2.OkHttpCall.execute(OkHttpCall.java:207)
        at sailpoint.service.SailPointService.createSession(SailPointService.java:110)
        at sailpoint.utils.FileUploadUtility.call(FileUploadUtility.java:235)
        at sailpoint.utils.FileUploadUtility.main(FileUploadUtility.java:145)/>
3

From where you are running File Upload Utility command, some server in your environment or your computer ?

Check running from your computer as well, it just calling an API which is public. Guess some network connectivity issues in server from where you are running.

Cheers
Krish

1 Like
4

Great video, Very informative! Thanks, Krishna
Quick question: What’s the best way to schedule this PowerShell script to run automatically? Should I use Windows Task Scheduler, or is there a better method?

1 Like
5

Of course, Windows Task Scheduler

2 Likes
6

Hi. What would be the best way to implement HA for File Upload Utility? Lets say I have 2 IQService hosts (Primary and Secondary) and they both connect to a shared drive to pickup the delimited file. If the first IQServer host with File Upload Utility goes down, what is best practice for failing over to the second IQServer (w file upload).

Regards,
Matt

7

where can i found the powershell script