Modifying powrmart.ini
When reading or importing a table, you can receive a pop-up warning, such as the following, concerning a missing DLL.
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.
-
Using the Import Tables option in the Informatica PowerCenter Designer, the system displays a pop-up warning about a missing DLL. Click OK.
-
The system displays another pop-up letting you know that Informatica is using EXTODBC.DLL to support Vertica. Click OK.
Note: The two pop-up messages are warnings only and do not affect the import of tables or the execution of workflows.
- Open the
powrmart.ini
file for editing. -
Add the following line in the section
ODBCDLL
.Vertica Database=PMODBC.DLL