StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSiebel COM interface - Python
primarykey
Id
16722555
data
AcceptedAnswerId
17942509
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-05-23T19:45:20.570
FavoriteCount
0
LastActivityDate
2017-06-19T22:14:58.347
LastEditDate
LastEditorUserId
0
OwnerUserId
1017268
ParentId
0
PostTypeId
1
Score
0
ViewCount
1090
LastEditorDisplayName
text
Body
I have been asked to explore various ways in which Siebel COM interface can be accessed in order evaluate the best possible solution. So far we have been able to access the COM interface through Excel (VBA) and PHP now I need to explore if the same is possible in Python. From my initial research I know python does provide access to DLL's using win32 api but there is no comprehensive tutorial available to get me started. Below the code snippets that we use for excel and php. Excel snippet:: <pre><code>Private Function CreateConn(strConnect As String, strEnterprise As String, strPort As String, strPass As String) As Boolean Dim errCode As Integer Dim errText As String Dim SiebelApp As SiebelDataControl Set SiebelApp = CreateObject("SiebelDataControl.SiebelDataControl.1") CreateConn = True SiebelApp.Login "host=""siebel://" & strConnect & ":" & strPort & "/" & strEnterprise & "/EAIObjMgr_enu""", _ "sadmin", strPass errCode = SiebelApp.GetLastErrCode() If errCode <> 0 Then errText = SiebelApp.GetLastErrText CreateConn = False Exit Function </code></pre> PHP Snippet:: <pre><code><?php function CreateConn($strConnect, $strEnterprise, $strPort, $strPass) { global $errText; $SiebelApplication = new COM('SiebelDataControl.SiebelDataControl.1') or die("Unable to instantiate SiebelDataControl"); $ConnStr = "host=\"siebel://".$strConnect.":".$strPort."/".$strEnterprise."/EAIObjMgr_enu\""; $SiebelApplication->Login($ConnStr, "sadmin", $strPass); $errCode = $SiebelApplication->GetLastErrCode(); if ($errCode != 0) { $errText = $SiebelApplication->GetLastErrText(); return false; } else { return true; } } ?> </code></pre> Can someone help me with example snippet for python to accomplish the same thing i.e creating connection?? Thanks
Tags
<python-2.7><com><siebel>
Title
Siebel COM interface - Python
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USNeel
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.