We are trying to get data out of NS into a data warehouse via ODBC. I was wondering what tools do people use? We were looking at other tools like Informatica, Boomi etc, but they all use SuiteTalk. This would be an enterprise solution so it would need to be automatic.

Celigo is a great product in my experience, you should be able to achieve that. You might need to build some middle ware in between with a lot of these solutions.

I highly recommend using Stitch. It is built for exactly what you’re looking for and I believe it’s a better option for this use-case than a middleware like Boomi or Celigo. We sync about 200K rows per night, but we’ve done as much as 2-3M as well so I think it scales very well. They have two options - connecting via SOAP or ODBC. It’s very simple to set up. Once connected, you choose the tables and columns and specify a destination and they take care of the rest. We have it syncing to an S3 bucket in AWS, but there’s a variety of different destinations you can sync to. The only time we have to touch it is when the NetSuite password expires. One thing to note is that they do use the NETSUITE.COM datasource, which apparently is being deprecated for some reason, even though it’s a cleaner schema than NETSUITE2.COM. I haven’t heard if they have any plans to create an integration for NETSUITE2.COM.

As stated, pretty pointless going down the netsuite.com schema route now they are no longer providing schema updates for it. netsuite2.com has no admin access so the 'easy' access to all tables has now gone. I'm syncing the entire 1,700 set of tables via the new DWI account (which replaced the admin access), but its a pig to work with being TBA with time restrictions. You can still connect to netsuite2.com with a user account, but then you have to mess about with permissions which you might get away with dependant on requirements.

Have you considered the new NS Analytics Warehouse?

@eblackey ok we will take a look into that. I think my manager just started taking a look into that one since Boomi and Celigo are pretty expensive.

@Chris what data warehouse back end are you using? In one of my previous engagements we used SQL server using DTS to move data from NS to SQL server and I think that also used SuiteTalk to communicate. All those other tools would still need to communicate via SuiteTalk to get the data.

Curious what limitations you’ve seen on custom fields @Eric B. I might not have run into those yet. Thanks!

We had an issue with a custom field at one point where Stitch was complaining about exceeding the max field length. We wanted to exclude that field from the mapping but it would be an all or nothing (check or uncheck Custom Fields) so it wouldn’t do specific custom fields.

Interesting. Thanks

Take a look at Celigo. https://www.celigo.com/integrations/templates/snowflake-data-warehouse-business-process-automation/