Connecting to a Database at Design Time: YSL Classic

Although optional, connecting to a database is especially helpful when defining the parameters of a function. When connected to a database, additional parameter field lists appear for a selected function, whose values reflect the data from the database.

Connecting to a database from the Database Connection Options tab is only relevant when the YSL report is generated into the local instance of Excel. For more information about the Database Connection Options tab, see “Database Connection Options Tab”.

If you use Conductor to generate a YSL report, YSL Classic disconnects from your database after the report is generated. This is because Conductor sends an e-mail with the generated YSL report as an .xls file object and thus the generating is over. For more information, see “Generating YSL Reports in Voyager Conductor: YSL Classic”.

If you connect to a database without running Enterprise or Voyager, the security measures that you set up in either of these programs are not active because the YSL connection to the database is independent of Enterprise or Voyager.

YSL can connect to a database in both SQL and Oracle platforms. Since the connection to the database is outside of Enterprise or Voyager, you must connect as the DBO (database owner) (if you are using YSL Classic 2.6x or 2.7x) or as a property manager with a user login (if you are using YSL Classic 2.8x) that has been assigned to you by your company's DBA (database administrator).

Finally, it is important to note that the YSL design-time connection to a database is read-only; YSL draws data from the database to assist in designing the YSL report, but YSL in no way alters or modifies the data in the database.