I know that MS SQL Server has a native Master Data Services.

Are there any other MDM for MS SQL Server?

    1 answer 1

    1. Talend mdm
    2. Informatica mdm
    3. Pentaho mdm
    4. TIBCO MDM

    It seems there is something in RedHat, based on JBoss ...

    But there is a direct connection to the database only in Informatica MDM, the rest are connected via JDBC.

    Iluxa1810, the fact is that when you physically copy the directory, the connection with the source is lost, for example: there is a source code repository. It is ruled by 3 developers. The fourth came made a copy from the repository and began to edit too. As a result, the three developers are doing well, they did checkout & change & commit, and the fourth has seams. If the links are not specified, if the logic is not built, then the changes will not be synchronized.

    The database type here is of "secondary" value. The main thing is to have a connection to it, and in your case ODBC will allow you to connect to the Access database, but it will not work very quickly, like the database itself.

    • Are there any MDMs that are able to keep the Access Database directories up to date? Let's say there are a dozen mdb files that are stored in one place. Copies of these files can be created and copied to other places. In the Moment of how changes in the main repository occur, these changes are reflected in other files that were copied from the main repository. - iluxa1810
    • Something like this ... Can you describe what and how it was planned to link the systems, data and so on? The most interesting why the Access DB is used ... - nmaw
    • I will try to explain especially without going into the details of those. Process: There are N Access directories that are stored in one place (Let it be MainR). In order to use the directories in the project, they are copied into the project folder. Now if there is a need to add a value to the reference book, then add the value by hand to MainR, then this reference book should be replaced with the current one in the projects where it is used. Now it is not automated. And now the question arises: Is it possible to use a ready-made MDM system, if you can, how much you have to bother with crutches - iluxa1810
    • or is it easier to make something of your own? Roughly speaking, this picture is obtained. There is a reference book in MainR, and it is used in 10 projects (Ie, there are 10 copies.). There may be another project that will use it and then the system should see it. When changing to MainR, all 11 directories should be synchronized. - iluxa1810
    • Using access is a limitation of the process. - iluxa1810