What is everyone here using for the BI needs? We a...
# suitescript
c
What is everyone here using for the BI needs? We are wanting to extract data from Netsuite and build out a snowflake schema for analytical reporting. We’ve found the built in suiteanalytics and saved searches are far too limiting to be useful for anything beyond very basic reporting. We have a bunch of SuiteQL queries but the lack of database views or any formal rendering engine makes those a pain as well.
k
You could use Tableau or Looker though Snowflake
r
We use a product called relational junction from sesame software which replicates data from selected Netsuite tables into a SQL server database.
g
I highly recommend Power BI. Powerful and cheap.
n
We are using Talend to extract data and then load and transform in a PostgreSQL database.
m
@Nick Collins are you using the community version or paid subscription? Do you use JDBC to extract the data?
n
We use JDBC to do the extract. So it's the paid version.
m
Hmm in my last job I played around with talend as an ETL and remember getting JDBC working on the free version
I also used it as middleware for an e-commerce integration
j
Have you seen our pre-built Power BI Solution for NetSuite? Suiteapp: Satori Reporting & Data Warehouse. www.satorireporting.com