How To Write Custom SQL Logs In Elasticsearch/ Kibana?

[system]

How to write custom SQL logs in Elasticsearch/ Kibana ?

Below approaches which can be taken to consideration:

• Orchestrator API calls
  • via an Orchestrator HTTP request
  • for endpoints can be used Swagger
• or to create a project in Studio which uses SQL database activities to write the custom SQL logs in ElasticSearch/ Kibana and it does the following:
  • connects to SQL database (specify Connection Configurations & the DatabaseConnection output variable)
  • executes SQL query (modify the needed SQL query)
  • iterates through each line & column through the SQL log data table
  • assigns a variable for each found element and writes it to ElasticSearch/ Kibana

Final result (SQL vs Kibana):