Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Automatic synchronize of database after data load

0 views
Skip to first unread message

Tri-Roger

unread,
Oct 21, 2009, 10:56:01 AM10/21/09
to
Hello,

we would like to load location information directly into the ASSETLOCATION
table (we are using MS SQL Server 2005). This is working nicely, but the
locations are shown in DAX only if I synchronize the database (or table)
after the import.
We would like to run the import of location data nightly, so my question is:
can I somehow run a Database synchronization automatically? Maybe by using a
batch job?

Appreciate your help
Roger

André Arnaud de Calavon

unread,
Oct 21, 2009, 4:24:01 PM10/21/09
to
Hi,

It is not recommended to import records directly into the SQL tables, but
aways use AX or the .net Business connector for updating or insert records.
So all business logic is used when inserting or updating records.

There is no periodic function for the synchronisation process in AX. If you
want to have one you should write a batchable class which processes the
synchronisation of tables. You can look how from the form "SysSqlAdmin".
There is a button on this form that start synchronisation.

Another solution can be an import program within AX that reads the location
information from an external system and writes it into the AssetLocation
table. This should be a batchable class as well.

regards,

André

Tri-Roger

unread,
Oct 22, 2009, 2:40:06 AM10/22/09
to
André,

thanks for the information, I'll have a look at the "SysSqlAdmin" form.

Thanks
Roger

0 new messages