The IpProvider table provides the definition of a provider/profile object.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| providerid | integer | not null | The ID of the profile/provider. Note: profile and
provider are one in the same.
|
| deviceid | integer | with null | The ID of the device used for the profile/provider. |
| providertype | smallint | not null | The interface or provider type of this profile/provider. |
| oneconnperreq | integer1 | with null | Limits the use of this profile to one database connection
per request. Several requests can use this profile at the
same time. However, no request can use the profile to
connect more than once to the database. If a request
attempts to use the profile more than once, an error results
|
| onereqatatime | integer1 | with null | Check to allow only one request to use this profile at a time. The request can connect to this profile as many times as necessary. If several requests using this profile are scheduled to run at the same time, they cannot be executed simultaneously. Instead Script Manager will run one at a time. |
Product Name: Data Transformer
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| providerid | requestprovider | providerid |