MAC Platform


in:	AIS HOME \| ABOUT US \| CONTACT US \| HELP INDEX \| FAQ INDEX \| SITE INDEX \| GLOSSARY \| AIS INTRANET

AIS Home > Data Warehouse > MAC Platform

MAC Platform - For Mac OSX and OS9

Mac Platform OSX
The Macintosh OSX needs to install an ODBC driver in order to connect to the Data Warehouse SQL Server. Below are some resources that might help you locate a driver. Prior to purchasing any driver, we strongly suggest that you obtain a 30 day free trial to make sure it works correctly with all your installed software.

http://www.actualtechnologies.com/ (Their SQL Server ODBC Driver)
http://www.datavations.com/ (Their Connect4 software)
http://www.openlinksw.com/ (Their Open Link software)

Another option would be Virtual PC. More information on Virtual PC can be found at:
http://www.apple.com/macosx/applications/virtualpc/
Mac Platform OS9 The below OS9 instructions are for people who currently have a SequeLink license. We do not have any more SequeLink licenses. Since they must be purchased in bulk, and will not work on the Mac OSX, we will not be purchasing any more licenses.

To avoid computer connectivety problems, please use the DNS host name when configuring computers.
The host name of the server is: warehouse.oas.psu.edu

Click the Apple symbol in the upper left corner of the screen.

Select Control Panels.

Select ODBC Setup PPC.

At the ODBC Data Source Administrator (Fig. 1), select the User DSN tab.

Fig 1 - ODBC Data Source Administrator
Figure 1

At the Create New Data Source dialog box (Fig. 2), select Intersolv 3.10 SequeLink PPC and then click Finish.

Fig 2 - Create new data source
Figure 2

At the next dialog box (Fig. 3), select the General tab. Fill in the following:

Data Source Name: warehouse
Description:
SequeLink Data Source: warehouse.oas.psu.edu

Figure 3

Select the Advanced tab (Fig 4).

At the UID/PWM Mapping pull-down menu, select 1 - DBMS.
Return to the General tab and click OK.

Fig 4 - Intersolv 3.10 SequeLink PPC
Figure 4

Click OK to close the ODBC Data Source Administrator box.

Navigate to the SequeLink CAT ADMIN PPC (Fig. 5), application and double-click the icon. (This is located in the SequeLink folder on your hard drive.)

Fig 5 - SequeLink Folder
Figure 5

At the SequeLink Data Source dialog box (Fig.6), fill in the following:

In the Service (RDBMS) area..

Name: warehouse
Type: Microsoft SQL Server
Database: <Fill in the name of your database>
User: <Power user’s ID>
Password: <Power user’s password>
Prompt for Service Password: checkmark this box

In the Host(server/router)..

Type: Windows NT
User: <Leave this blank>
Password: <Leave this blank>
Prompt for host password: Uncheck this box

In the Network area..

Type: TCP/IP
Host: warehouse.oas.psu.edu

Fig 6 - Add SequeLink Data Source
Figure 6

Click Save.

Optional..<click Test to verify your connection is successful> (Fig. 7)

Name: SLSQLServer
Database: Enter the name of your database.
User: Power User ID
Password: Power user password
Click OK

Fig 7 - Complete SequeLink Settings
Figure 7

It will bring up a statement “Connection Passed” or “Connection Failed” Click the Close button to close the dialog box.

For further assistance, contact the AIS Support Center.

Also available: Initial Connectivity Setup for the Macintosh Workstation (online tutorial)

Questions: AIS Support

Printer friendly view