Introducing SQL Anywhere Studio
  Tutorial: Creating Reports with InfoMaker

Lesson 1: Getting Started

To use this InfoMaker tutorial, you must be connected to the Adaptive Server Anywhere sample database. To connect to the SQL Anywhere Studio 8.0 sample database you need to create a Database Profile.

To start InfoMaker

• From the Start menu, choose Programs > Sybase SQL Anywhere 9 > InfoMaker 8.0 > InfoMaker.

  The InfoMaker initial window appears. It includes the PowerBar, which has buttons for accessing the InfoMaker painters and online Help.

To create a Database Profile for the SQL Anywhere Studio sample database with InfoMaker

1. In InfoMaker, open the Database Profiles dialog by clicking DB Profile in the PowerBar.

2. Select ODBC and click New.

3. The Database Profile Setup dialog appears.

   • Enter the Profile Name Anywhere.

   • Select ASA 9.0 Sample as the Data Source.

   • Enter DBA as the user ID.

   • Enter SQL as the password.

   • Click OK.

   The profile Anywhere should now be listed under ODBC.

To connect to the Adaptive Server Anywhere sample database once a Data Source has been created

1. If it is not already open, open the Database Profiles window by clicking DB Profile in the PowerBar.

2. Select Anywhere from the ODBC group and click Connect.

What next? 

Next you will create a table using an InfoMaker wizard.