Sterling File Gateway will maintain the file transfer statical information along with Event codes. These event codes are specifically designed for IBM Control Center. Each code will particular describe the status of the file at each phase during the file transmission process like File Arrived, Replayed, redelivered, completed/success or Failed. If we integrate SFG with IBM control center, by default all these events will be captured by ICC.

Solution#1: You can configure CDC in ICC database so that real-time events will be captured and make sure these captured into another database within the same database instance. Now, you can write a program in any programming language (python preferable) to get these events from new database. In python program, you can subscribe to pub/sub topic to push them to bigquery and the further we can project them to looker studio.

Solution#2: Once ICC captures events from SFG, have your SQL query get the required events from ICC database by using python program. Please make sure you python program should send events/messages in json format to the pub/sub topic which is already subscribed to. And then, create bigquery dataset to pull the pub/sub messages from topic subscription. And then finally , we can project these events to Google looker studio for user interface.