Connect to remote documentum server from VBA

pjmorce

Hello

I am trying to find a solution to connect to a Documentum server from VBA.

I find a way which is maybe possible to do that but, it uses a method "getLocalClient".

Dim cx As DfClientX

Dim client As IDfClient

Dim session As IDfSession

Dim li As IDfLoginInfo

Set cx = New DfClientX

Set client = cx.getLocalClient

Set li = cx.getLoginInfo

li.setUser ("username")

li.setPassword ("password")

Set session = client.newSession("docbase", li)

However, my documentum server is running on a remote machine. So, anyone knows how can I connect to my remote server using VBA?

Thanks

Regards

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

DCTM_Guru

Let me me describe Webtop/WDK architecture:

1) Content Server

2) Webtop - web app running on app server

3) Browser - running on client machine

App server can be on the same box as Content Server.

So in your case, your VBA macro (running on client machine) needs to talk to app server (which can be on separate machine or same machine as content server).

All comments

DCTM_Guru

DFC uses dfc.properties to tell the client which server to connect to. Enter the server name in the host field and DFC will try to connect to that server using the credentials you provided.

pjmorce

Thanks a lot for your answer.

Actually, I have a VBA macro which creates a session to my documentum server, installed on my machine, in the c:/documentum folder. The dfc.properties file is in the config folder in that directory. Everything works fine, the session is created.

Now, imagine that I want to connect to a documentum server on the "dochost" host machine.

It is necessary to keep documentum installed on MY machine and configure the dfc.properties file in c:/documentum/config to indicate that the server to be used is on the "dochost" machine?

(dfc.search.ecis.host=dochost)

Thanks again

regards

BartThierens

It is not necessary to have DFC Runtime or Documentum installed on your machine.

Just add the folder that contains the dfc.properties to the classpath.

pjmorce

Thanks for your answer, but.... how can I put the dfc.properties directory folder on my VBA macro classpath?

(the question may seem stupid for you but I am new to macros...)

Thanks

regards

DCTM_Guru

You need to create a web app on your "dochost" machine. The web app will act like "client" and can use the dfc.properties file that is stored on dochost. You would then need to configure your VBA macro to call this web app.

This is identical architecture to the Application Connectors (Word, Excel, Powerpoint) for Webtop.

pjmorce

Thanks again for your answer.

This seems quite confuse.

Just to simplify, the architecture will be will be like this:

- on the local machine, the macro

- on the remote machine

- the documentum server

- a web app which make all the work and with the dfc.properties pointing to the documentum server

So, the web application can also be installed/running on the local machine. The important is that the dfc.properties file in the web app points to the remote machine... right?

Thanks again

Regards

DCTM_Guru

Let me me describe Webtop/WDK architecture:

1) Content Server

2) Webtop - web app running on app server

3) Browser - running on client machine

App server can be on the same box as Content Server.

So in your case, your VBA macro (running on client machine) needs to talk to app server (which can be on separate machine or same machine as content server).

pjmorce

Thank you.

I did not knew the existance of webtop.

I will try first to insert a file locally to watch if the entire chain works. After that, I will try with the remote server.

Best regards