The Documentum Docbase O_o

Hi guys! I'm a Documentum noob (perhaps even less than that). I just want to clarify something.

I have Documentum 5.3 installed in my server, and then I found out that inside the installation folder is a database named, "DM_doc6_docbase." I opened it in SQL Server 2005 and I saw all the objects of Documentum stored in tables. Among them is table "dm_user_s." I opened the table and I saw the records of all users and their object ID's.

So here's the thing:

I need to get all Documentum users from an ASP.NET web application. Is it safe for me to use this database through SQL Server 2005 to SELECT all records from "dm_user_s" table? Are all Documentum installation has a "DM_<docbaseName>_docbase" inside its installation? Please help. Any kind of reply is most appreciated.

Thank you!

Kind Regards,

K. Macariola

Find more posts tagged with

Comments

sagar.singh

hello

you can get the desired information you want.

but it is not recommended as you should preferably use the DCTM objects rather than directly using RDBMS tables.

so you can query the dm_user table for the user names that are available, but obviously you should be logged in as a existing user.

Thanks

Sagar

kvm.macariola

Hi Sir Sagar!

Thank you very much for your immediate reply. I also had doubts about the security issue involved but at the moment, I think it would be most convenient for me to access the users this way because I'm using ASP.NET 2.0 and I am having trouble interfacing with Documentum using the latter since day one.

Anyway, thanks again!

Regards,

K. Macariola

sagar.singh

DFC API is available to be used with Java and .NET platform

kvm.macariola

Yes, and since I'm using .NET I need DFC PIA besides DFC itself. The DFC PIA is located in the installation folder of DFC. I have to make configurations to my IIS, to Documentum's dfc.dll, dmcl40.dll, dfc.properties and my web application's web.config file for me to be able to use the DFCs and ulitmately, interface with Documentum. I tried to go over these a couple of times for about 2 weeks; but to no avail, either Webtop is running or my web application is. I can't get both of them to work. I don't know why. So I've given up. Now, I resorted to using a Java class to handle all the talking (with Documentum) I needed for my ASP.NET web application because apparently, running DFC with Java is easier a thousand fold than it is with .NET... Although, thanks for the tip. It's just that I had so many frustrations these past few weeks.