When setting up the connections for the databases in the CSA (both PPM and DWH schemas) you may be informed after clicking Save that its status is Unavailable.
What does that mean exactly, and how is the status determined to be Available or Unavailable.
At a high level, in order for the status to show Available after clicking on Save, then the CSA was able to make a connection to the database with the username and password provided.
If using a custom JDBC URL to make the connection, this information is also used. If you are not using a custom JDBC URL, then the URL will be formed from the following fields depending on your chosen DBMS vendor:
Oracle will use your Hostname, Port, and Service ID fields.
Microsoft SQL Server will use your Hostname, Port, and Database Name fields. If you are using a named-instance of SQL Server, then the Instance Name field can be used instead of the port.
If a connection does not succeed with this information, and presuming that an independent connection can be made to the database using the same details through another tool, then the following instructions can help narrow down the cause as to why.
Please note that the other fields on the Database pages are not used to determine the Status field, so details such as the tablespaces or whether you have any data or tables in the schema itself does not matter at this point in time.