Talk to API

Hi there,

I had a third party product which is Java based and it has its own APIs which talks to the DB associated.

Now the issue is, i have is to use those APIs to pull and push the data from that particular DB from TeamSite. What would be the best possible way to do the same? All pointers/suggestions are welcome.

Thanks,

Find more posts tagged with

Comments

Jcse

Hi there,

I had a third party product which is Java based and it has its own APIs which talks to the DB associated.

Now the issue is, i have is to use those APIs to pull and push the data from that particular DB from TeamSite. What would be the best possible way to do the same? All pointers/suggestions are welcome.

Thanks,

Hi

I couldn't get much from your requirement .

Well, you can associate any DB with TS.Now As far as connectivity is concern in java, you can use desired connection string and driver based on the DB.

If you are already having an java based API,you can use that APIs also for interacting with DB just by establishing the connection using accurate drivers.

Please specify your exact requirement.

Ambuj

Hi

I couldn't get much from your requirement .

Well, you can associate any DB with TS.Now As far as connectivity is concern in java, you can use desired connection string and driver based on the DB.

If you are already having an java based API,you can use that APIs also for interacting with DB just by establishing the connection using accurate drivers.

Please specify your exact requirement.

I guess he wants to use that Java API within TeamSite.

kaalraa

Yes, as we have not been given/required to do a direct access to DB. It is a client preference to pull and push data to DB using Java API only.

kaalraa

Hi

I couldn't get much from your requirement .

Well, you can associate any DB with TS.Now As far as connectivity is concern in java, you can use desired connection string and driver based on the DB.

If you are already having an java based API,you can use that APIs also for interacting with DB just by establishing the connection using accurate drivers.

Please specify your exact requirement.

Hi,

Actually, i have DCTs on TS and there is a product 'Z' which has its own API to talk to the DB given by client. Now, while saving DCR in DB, we need to use those APIs which were written in Java.

The client does not want to talk directly to DB bypassing the product Z. In case it could not be done, they are still asking to write our own APIs which could interact with DB.

Hope this clarifies.

Ambuj

Yes, as we have not been given/required to do a direct access to DB. It is a client preference to pull and push data to DB using Java API only.

This might help..

http://devnet.interwoven.com/forums_vb/showthread.php?t=23272&forumid=11&highlight=java+calls

Jcse

Hi,

Actually, i have DCTs on TS and there is a product 'Z' which has its own API to talk to the DB given by client. Now, while saving DCR in DB, we need to use those APIs which were written in Java.

The client does not want to talk directly to DB bypassing the product Z. In case it could not be done, they are still asking to write our own APIs which could interact with DB.

Hope this clarifies.

Hi

What mechanism/flow you are using for Saving DCR to DB.
Are you using DataDeploy or any external mechanism which read DCR file and creates field as per the DCR elements and finally save them in tabular format.

kaalraa

Hi

What mechanism/flow you are using for Saving DCR to DB.
Are you using DataDeploy or any external mechanism which read DCR file and creates field as per the DCR elements and finally save them in tabular format.

Hey,

We are using XML type DCRs which would be then deployed to DB in Tabular format. The only requirement client has put to use the pre-provided API by another product 'Z'.

Thats the reason why we are finding the ways through already exisitng APIs .

Ambuj

Hey,

We are using XML type DCRs which would be then deployed to DB in Tabular format. The only requirement client has put to use the pre-provided API by another product 'Z'.

Thats the reason why we are finding the ways through already exisitng APIs .

I tried googling and I can see some perl -> java integration. I mean we can call Java APIs from a perl code. If that is possible then rest of the flow is quite clear.

Save DCR - Perl Command - Java API - DB

Did you look into this possibility?

Jcse

Hey,

We are using XML type DCRs which would be then deployed to DB in Tabular format. The only requirement client has put to use the pre-provided API by another product 'Z'.

Thats the reason why we are finding the ways through already exisitng APIs .

OK,then as i understand may be you can do it by creating an Java Class which has following control--

read the attached DCR(XML) using an XMLReader, extract the elements of DCR and the values of those elements(that's your data)
Get an Instance of DB Connection using the Product 'Z' API,establish the connection
Create an Table if already not created,create the field according to the DCR elements extracted earlier.
Then,Push the Data into the table using DBObject already got from Product 'Z' API
Once you got the DBObject,use the Product 'Z' API for CRUD operation on DB

Now you can call this Java Class on an ExternalTask of WF, and also on the Save Event of DCR using callServer method of FormAPI.

vy8359

The approach we took in the past is to to deploy java cssdk client app and Teamsite on same server. The app server we used was Websphere. You can also call external URLs from teamsite workflow if you can host your java app on external server. Have your java app talk to teamsite thru cssdk.