Import data from MS SQL Server.

[jurahf]

Hello.
I have custom data model. One of custom types (Order) should be associated with another custom type (Department).

The company has a MS SQL Server database, in which departments are stored. The departments have a name and optional reference to parent department. New departments may be added, and old departmenrs may be removed.

I can not understand what it will be on Alfresco. Is there something like a dictionary in Alfresco? Is it worth to using categories?
Is it possible to import data from MS SQL Server to Alfresco?

Thanks.

[jurahf]

Nothing?