We are current trying to find workarounds linking Spotfire with data which can only be sourced via ODBC as the ODBC-JDBC bridge with Java is no longer supported. However, I am seeing some challenge replicating what we had using the "Add Database" (Add Data Table... > Add > Database) functionality because I can't see a way sending parameter to make it an on-demand load, hence the idea.
Please investigate if connectors could be used instead.