Skip to content
ProjectControls.com
Oracle Primavera - PM6

Anyone Using SDK?

In the Open Standard
Forum GuestMember for 17 years 8 months
Created
6
3
0
Is anyone out there using SDK to connect to P3e, P3e/c, or Teamplay? How is your performance? It takes me up to two minutes for me to log on using SDK. It also takes that long for each SQL query.

I have also connected directly to the databases using ADO and OLE. Connection time is less than a second and responses to queries are just as fast.

1) Am I doing something wrong with SDK? Is anyone out there getting better response times?

2) Did Primavera purposely cripple SDK so as to make competition difficult or impossible by using their own interconnectivity against them? Inquiring minds want to know.
Save Follow Follow forum Report
Reply New topic

6 replies

Oldest first
  1. 0
    Bernard Ertl ·
    #1
    We are using ADO to interface with the Primavera SDK for P3e and P3e/c. The performance is quite acceptable on our end. Connection and log-in takes roughly 5-15 seconds on my old 400Mhz P-II with Win 98 and a slow HD (when P3e is not already running).

    It is quite reasonable to expect that connecting via the SDK will produce a performance hit over a direct connection. The SDK is adding another layer of processing. However, the SDK also offers some important functions and safety mechanisms to maintain the integrity of the data. I would not recommend altering the back-end data directly without the SDK.

    Two minutes seems an awful long time to wait for a connection and log-in. I would guess that there is some issue in your case that needs examining.

    BTW, in general, using ADO to manipulate a back-end database will never be as quick as using COM to manipulate data directly. Ie. you should not expect to automate P3e / P3e/c with the same speed that you could with P3. Its just the nature of the design structures.

    Bernard Ertl
    InterPlan Systems Inc. - Project Management Software, Project Planning Software
    Report
  2. 0
    Shirish Borkar ·
    #2
    Hi,

    Have you heard about Primavera Integration Server APIs. API does all those things which SDK can do. It is faster than SDK and more robust. Suggest you to use API instead of SDK.
    Report
  3. 0
    Dang Corp ·
    #3
    SDK login is slow, maybe due to the amount of PROJECT codes, resource codes you have etc. i have use SDK and API, SDK do gets slow when lots of global codes is loaded. SDK is not that bad, because you can use Microsoft technology to write your codes, any there is ways to improve the speed dramtically. (like multi threading, caching of the data). lots more. API is ok too, but only works with JAVA, if you have skills in Java, then go for API, it has more features and speed, You will need to purchase an extra license.
    Report
  4. 0
    Alex Wong ·
    #4
    Vu

    Good to C you back in action.

    SDK is the basic free of charge integration tool for P3e

    API of course is "better" because it cost you money to actually purchase it so it better be "Perform better".

    Alex
    Report
  5. 0
    Alex Wong ·
    #5
    Mario

    Are you sure that API is no charge. I got a different message from Primavera Australia and my company brough 500 users licenses but still they want to charge us for $20,000 for a licese of API. Any PAR can clarify this

    Alex
    Report
  6. 0
    Ronald Winter ·
    #6
    Refer to here for more on this subject. Good luck!
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?