I'm hoping for some assistance in creating a script that will query a Teradata database. The query needs to contain 2 seperate querys for 2 sepearte connections. The first connection (Database 1) will do a row count on a specified table then return that count. The 2nd query (DB 2) will connect to another database then do a row count for a specified table. I want to see both of these counts as the result of the script.
Specifically, I am creating this script for a probe in Sitescope.
I do not currently have BTEQ installed on the Sitescope server.
I have the JDBC driver installed, which allows me to connect to the database. I beleive sqlplus is currently installed on the server. Do I have to use BTEQ?
I am not pretty much aware of your Sitescope server. I do not know if ssh authentication and execution can be done remotely, from another server. Maybe you can see if the feature of remote connection execution is possible. These days, I have seen many Network monitoring tools such as Ganglia,Monit, Munin, Collectd,Nagios...server monitoring tools that give good interaction. All information can be obtained from one house esp monitoring part. Execution part , like extracting extra info from another server, I have not tried. But I believe thin extra info can be done. Just my thought.