11/26/2024 8:26:09 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.
|
|
|
|
OLEDB or Triggers
Posted: 14 May 07 2:10 PM
|
fiogf49gjkf0d I have the need to update the activity table when a record is inserted into the table. I was using a trigger, but soon discovered that the trigger was not "sync aware". The trigger is obviously firing on an insert, and I assumed that this would be sync aware, but no. So should I create the trigger to write through the provider, or should I just run a DTS that parses the database for the records that need to be updated. Which method is going to give me greater performance? If I want the activity field to be sent with the next sync session, it should be through the trigger, correct? |
|
|
|
Re: OLEDB or Triggers
Posted: 14 May 07 6:44 PM
|
fiogf49gjkf0d If you can describe how you can get a trigger to run through the provider, please let me know, or direct me to the instructions, as I did not know that it was even possible.
A scheduled DTS job should work - though it will run only on the main server. So it may take a few sync cycles before data gets back out to your remotes and the time lag may be unacceptable.
|
|
|
|
Re: OLEDB or Triggers
Posted: 15 May 07 4:26 AM
|
fiogf49gjkf0d You could configure your trigger to run the DTS package, though this requries that the sysdba account have SA access, and you would still have the sync cycle lag. |
|
|
|
Re: OLEDB or Triggers
Posted: 25 May 07 3:04 PM
|
fiogf49gjkf0d Update... it appears the sync records are written prior to the SQL insert to the Activity Table. As a result, the changes to the SECCODEID field were not being sync'd to the remotes. The fix was to create a DTS that utilizes the OLEDB provider to write the record. Yikes... I found dealing with the security for SSIS to be a royal PITA! but now it's working like a charm.. a gazillion hours later! |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|