The question recently came up regarding Cobra’s Integration Wizard (IW) and how to get it to connect to a P6 database from within an n-Tier deployment; specifically where should the ODBC data source and Primavera Integration API be installed to get this working.
ODBC
Setting up an Oracle ODBC Driver and Data Source
Setting up an Oracle ODBC Driver and Data Source requires more steps than the Microsoft SQL Server database setup. This article explains the steps including tnsnames.ora configuration. Connecting to an Oracle database via and ODBC driver requires the following steps