You use the SQL Connect dialog box to connect to an SQL database. You must connect to an SQL database before creating a rules file or performing a data load or dimension build that uses SQL database data.
In the following boxes, you enter or select your connection information:
User name—Username for the database
Password—Password for the username
Essbase Server—Instance that serves as the client for the SQL database
Application—Application that serves as the client for the SQL database
Database—Database that contains the rules file that is used to connect to the SQL database
After you connect, you can view the contents of the specified tables in Data Prep Editor.