8 Shipping an Adapter

To package an adapter so that you can ship it for use in other companies, you must provide an installation script and instructions for your customers.

Installation Script Write a PL/SQL installation script that loads both of the packages you created in Step 1 of development—with the final, production-quality functions and procedures. The installation script must:

• Create an input parameter that accepts the value of the user group ID of the user group the customer company wants to assign to the Adapter Area.

• Read Package B from the file system, create a CLOB of the file, and pass the CLOB to the CreateSourceCode API in Package A; see "Adapter Development Process".

Instructions Provide instructions that include the following information:

• The user group to be assigned to the Adapter Area should include a role with View (only) access to the Adapter Area and all objects within it, and should include all users who will need to define or run Load Sets, Data Marts, Programs, or Business Areas of the new adapter type.

  The user who is running the installation script must also be included in the user group with a role that has Create and Modify privileges on all objects in the Adapter Area.

• Customers must follow all the steps in Chapter 7, "Setting Up an Adapter".