• State Not Answered
  • Locked Locked
  • Replies 8 replies
  • Subscribers 96 subscribers
  • Views 6084 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Using DBBulkImport API with current JobServer user.

hleigh
over 8 years ago

I'm looking to use this Object API for the bulk import of thousands of 1IM object - however the SDK documentation only details a single initializer

Public Sub New ( _
	tableName As String, _
	connectionString As String, _
	dbFactory As IDbFactory, _
	authString As String _
)

Does anyone know of a way that this API can be used with the current Connection / User as would be available on the Job Server ?

I want to avoid having to provide the username / password in the authstring parameter - rather utilizing the existing connection.

Thanks
Parents
  • 0 over 8 years ago
    Thanks for the reply Oliver - more useful than the one referring me to Powershell REST Doco I got from Tech Support !

    Anyway - tried using vid_BuildAuthString .. .

    1 : Using SystemDebugger to run script - ended up with "null pointer" exception in VID_BuildAuthString - seemed to fail on final iteration when building string when I added breakpoints . . .

    2 : Created a process to call script on Job Server - not much luck here - getting an "Authentication String is not valid" error . . . added some debug code to extract the result of the call to VID_BuildauthString() :

    "Authstring = Identifier=sa;Name=sa;EnvironmentName=sa;Display=Service Account;UID="

    Missing UID value on the end . . .

    According to SDK - the UID value is that of a linked Person - not present for sa System User

    So . . . What next ?? Any other suggestions ?
Reply
  • 0 over 8 years ago
    Thanks for the reply Oliver - more useful than the one referring me to Powershell REST Doco I got from Tech Support !

    Anyway - tried using vid_BuildAuthString .. .

    1 : Using SystemDebugger to run script - ended up with "null pointer" exception in VID_BuildAuthString - seemed to fail on final iteration when building string when I added breakpoints . . .

    2 : Created a process to call script on Job Server - not much luck here - getting an "Authentication String is not valid" error . . . added some debug code to extract the result of the call to VID_BuildauthString() :

    "Authstring = Identifier=sa;Name=sa;EnvironmentName=sa;Display=Service Account;UID="

    Missing UID value on the end . . .

    According to SDK - the UID value is that of a linked Person - not present for sa System User

    So . . . What next ?? Any other suggestions ?
Children
No Data