Hey guys, I'm shopping for a data warehouse and looking closely at NSAW (need more flexibility with joins than saved searches and suite analytics + need to add meta and google ads data). I have meta and google ads data in big query (using the native data transfers from google). The question is: a) Use Oracle Analytics (the bi tool) to join the big query data to the Netsuite data. This would make a dataset from two different data warehouses. Concern is this would be really slow in practice. I only need updates once a day. b) Duplicate the big query data to the oracle autonomous database and do the dataset joins at the database level (not at the bi tool). This would obviously be faster but ads a extra dataflow. c) pay for a third party tool to move the data from meta and google to Oracle database directly, but its not cheap and an whole extra thing to setup and manage.

I'd be tempted to use a replication-like service like fivetran from Netsuite into bigquery, but it depends on how much you like bigquery, and if you can live with not "everything" making it across to reduce cost a bit. For a business like ours, Netsuite is a pretty small part of the data landscape, so locking ourselves into Oracle isn't a desirable outcome. But your mileage may vary

yeah, heard. netsuite is a large part of our data universe, so i think priority 1 is a super tight netsuite oracle integration, but i could end up regretting it.

Biased opinion as a Domo partner, but Domo + Netsuite works great together. Happy to chat!

You may have already, but I like stream processing with Kafka.