Any record limit to SQL User Import utility?

[Joe]

Hi All, Having tested integration of people people data using the SQL User Import utility as per the Hornbill wiki, we have to import about 60k records. Is there any record limit on the utility?

[Martyn Houghton]

@Joe

We have not come across one with our imports, but not quite as many as that.

What are you using as the source? We always used SQL Server or MySQL as the source rather than importing from a csv file, as that many using the odbc CSV driver might be asking a lot.

The other thing to note is that unlike the Request Importer you can not use multiple API Keys or concurrent sessions, so it will be a sequential process.

My habit with these things has always to do them in batches making sure you use a 'order by statement' in the select query so that you can easily back out or restart a batch from a know position.

Cheers

Martyn

[Victor]

This has been moved to Integration Tools section