Joe Posted February 6, 2020 Posted February 6, 2020 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 Posted February 6, 2020 Posted February 6, 2020 @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 Posted February 7, 2020 Posted February 7, 2020 This has been moved to Integration Tools section
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now