• State Not Answered
  • Locked Locked
  • Replies 8 replies
  • Subscribers 96 subscribers
  • Views 6087 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

    Hi hleigh,

    the following should do the trick:

    Using BI AS DbBulkImport(table, _

                             VID_GetValueOfDialogdatabases("ConnectionString"), _

                             Nothing, _

                             VID_BuildAuthString())

    Please note that ConnectionString needs to be decrypted first if your database is encrypted.

    please also note that this class was removed from the API in version 7 and that the BulkImportAsync method needs to be used instead.

     

    HTH,

     Oliver

Reply
  • 0 over 8 years ago

    Hi hleigh,

    the following should do the trick:

    Using BI AS DbBulkImport(table, _

                             VID_GetValueOfDialogdatabases("ConnectionString"), _

                             Nothing, _

                             VID_BuildAuthString())

    Please note that ConnectionString needs to be decrypted first if your database is encrypted.

    please also note that this class was removed from the API in version 7 and that the BulkImportAsync method needs to be used instead.

     

    HTH,

     Oliver

Children
No Data