Trying to view calls coming from exe generated in CA:Gen to Oracle DB

[runatyr]

We have code that has been on a mainframe and converted with a tool called

(CA:Gen)

The code created a Windows exe that, when executed, will reach out to an Oracle/Exadata DB to retrieve data.

I know that normally in Dynatrace we see windows services reaching out to oracle and MSSQL databases

when we have the oneagent installed. 

That said, how do I go about having oneagent detect the calls being made by this CA:Gen generated exe?

What information do I need to provide to Dynatrace to detect this traffic?

Please advise and thank you!

[AntonPineiro]

Hi,

Is that .exe autodiscover by Dynatrace OneAgent? Appears in host process list?

Best regards

[runatyr]

The exe was autodiscovered by the oneagent. It does appear in the host process list.

[AntonPineiro]

Hi,

Is host in fullstack? Which database framework if being used? You can double check Technology support.

Best regards

[runatyr]

host is full stack... deep monitoring is enabled.... we are trying to call an oracle DB 😊

[AntonPineiro]

Hi,

Did you check database framework used to make database calls? You have database framework supported in relation to Java, .NET and other technologies in before link.

Best regards

[runatyr]

Anton:

When you say "Check the database framework" we know that from the following

Gen generates programs in various programming languages,  COBOL, JAVA, C#, and C

The programs are then compiled and linked using the appropriate precompilers and compilers for the database being targeted and the language generated.

For what we are looking at, Gen generates the C code programs.  If the programs have SQL, the Oracle 19c PROC  precompiler is used and then the C compiler and linker installed with Visual Studio 2019 is used to compile and link the C code into the executable.

Does this help answer how your question about the DB framework?

(We are calling oracle as outlined above)

Thanks,

[AntonPineiro]

Hi,

My point is, if you go to that process in Dynatrace. Which main and secundary technologies appears? Do you see database framework in the supported list?

For example, imagine it is in relation to .NET. Those are supported:

• ADO.NET
• Amazon DynamoDB.
• Azure Cosmos DB
• MongoDB .NET driver.

If your process is using one of those, you will be able to see database service in relation those SQL queries, automatically.

Best regards

[runatyr]

I have seen CA:Gen create the code . It specifically creates code for a windows.exe it creates to talk to an oracle DB. That said, my understanding is that is will be necessary to implement open telemetry or the oneagent SDK in order to do this.