I have an OCI server and wanted to write a java code to create some custom reports using Insight Connect API... Has anyone got a working example with which I can build my reports

[mraghave]

Using Insight Connect API just on a server and not the DWH

[ostiguy]

The DWH is a far better option for most reporting use cases.

All of the API reference info and examples are available on the OCI HTTP portal:

Advanced -> Insight Connect API

[mraghave]

There is no  DWH server license, there is only OCI server.

I have gone through the API reference guide and have started working on those examples. I was looking if there are any working scripts on top of which I can build or modify.