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):