How to enable the SQL PDI
Modified on Wed, 18 May 2016 07:54 by Kevin Ricciardo — Categorized as: FAQ
Required permissions: The default All Permissions group + Schedule Email Alerts.
Login to the central administration domain
Go to Administrative Options>Provider/User Manager
Expand Central Administration's Users and Permissions
Expand Users>"Your User Account Name"
Highlight Individual Permissions
In the search box along the top right type "Schedule Email Alerts"
Right click on Schedule Email Alerts and select "Grant"
Click Save then click Close
On the Administrative Options menu click on Provider Data Import
Click Import from SQL Server
Check the Enable PDI SQL Server Import check box
In the Time box enter a time 5 minutes into the future from your current time. (This can be changed later).
Check the Daily check box. (This can be changed later).
Click Close
Highlight the provider domain the SQL PDI should be enabled for in the Provider List
Click F3: Configure Provider
Check the Automatic Import check box in the Provider Data Options box
Click Save
Wait 5 minutes
After 5 minutes verify the addition of the new database CW_PDI to your CAREWare SQL Server instance using Management Studio
Once the creation of the CW_PDI database is complete you will be able to enter all incoming data in the available tables. These tables adhere to the same restraints as the PDI Access template file. You can refer to the PDI Specifications document for the complete list of required fields.
Any unmapped incoming fields will generate a red exclamation mark in the bottom left corner of the PDI Provider Manager. To resolve missing mappings:
Click on Unmapped Files
Highlight the file on the right side then click F1: Mapped Provider Codes
Map the incoming SQL provider to the actual CAREWare provider. Type the provider name in the CAREWare provider search box.
Click Save
Back to
Frequently Asked Questions