Modifying powrmart.ini

When reading or importing a table, you can receive a pop-up warning, such as the following, concerning a missing DLL.

dll-popup

You can make a correction so that the warning no longer appears by adding the line Vertica Database=PMODBC.DLL to the powrmart.ini file in the section ODBCDLL. See the following example.

  1. Using the Import Tables option in the Informatica PowerCenter Designer, the system displays a pop-up warning about a missing DLL. Click OK.

    popup1

  2. The system displays another pop-up letting you know that Informatica is using EXTODBC.DLL to support Vertica. Click OK.

    popup2

    Note: The two pop-up messages are warnings only and do not affect the import of tables or the execution of workflows.

  3. Open the powrmart.ini file for editing.
  4. Add the following line in the section ODBCDLL.

    Vertica Database=PMODBC.DLL