We are trying to fetch the data from custom query from an IRIS database but unfortunately Dynatrace offer custom queries extension for Oracle, MSSQL, MySQL, DB2, PostgreSQL, Informix or SAP HANA databases.
So, in order to achieve this how we can run the database query via Synthetic Monitoring or can we achieve this via Synthetics ?
You can raise a product idea to add support for that to the SQL data source.
If I were you I'd create a python script to connect to the database and send in the data to Dynatrace using the API. That way you can easily convert it to Extension Framework 2.0 in a couple of months once Python is available there.