Hi,

I want to insert Data from external DB into Remedy Regular form.

Please suggest any diff ways.

-Bobby

Hi,

The easiest way is to use AIE to achieve that.

You can also do this in SQL or using API's or using import or Web Services, etc...

You have so many ways to achieve that, you have just to choose the best way in your context.

I want to insert data through SQL from diff DB into Remedy Regular form. But can I usea INSERT stat for that? I heard that INSERT stat directly into Remedy table is not recommended duo to CORE fields in the form.

If their a specific format for the INSERT stat kindly please suggest.

-Bobby

Hi,

It's not recommended to insert directly in sql in the underlaying tables of forms.

You can insert either in a table associated to a view form, then use AR System workflow to push the values in other forms.

Or you can insert directly in the tables associated to the regular forms (not recommended, but possible). In this case, you have to :
* Get the nextid in the arschema table. For this form, you must have the nextid that increment 1 by 1.
* Insert in the T, B and H tables.
* Update the nextid in the arschema table.