CONTACT US FOR A FREE DISCOVERY CALL

Insights

How To extract NetSuite Data using Web tables in Azure Data Factory


If you are a NetSuite ERP user who wants to extract NetSuite data into a SQL Database without the use of an expensive ODBC Connector, this method will assist in achieving that.

By leveraging the output of your data to a SQL database you can connect your financial data to our Finance Analytics dashboard The method explained here is to use the ‘Enable Web Query’ functionality of NetSuite reports.

  1. Create a report in NetSuite with required data to be extracted or use an existing report.
  2. Enable Web Query functionality on the report by going into customize report and additional options
  3. Generate a .iqr file by clicking on the icon to generate .iqr file, and copy it to a local folder.
  4. Open the local copy of the .iqr file in a text editor to copy the url. Modify the URL to look like below. Replace the email address with the respective email address that has permissions to access NetSuite. https://XXXXX.app.netsuite.com/app/reporting/webquery.nl?compid=XXXXX&entity=XXX&email=abcd@abcd.com&role=XX&cr=XXX&hash=XXXXXXXXXXXXXX
  5. You can now test the link address on a browser window to see whether the output report is generated in HTML format.
  6. Using Azure Data Factory pipeline, you can now execute a copy command, to output data from NetSuite.
  7. Create a Web table link service and configure the self-hosted integration run time and paste the URL in the url text box.
  8. Select ‘anonymous’ for the authentication type. Configure the sink as SQL Database link service. The pipeline can be run by setting the necessary table mappings.

Written by: Chathura (Chat) Wijesinghe. Chat is an Azure BI Developer & Data Architect with over 16 years of BI development experience. Chat shares these simple tips on extracting NetSuite Data, with the use of Azure Data Factory web tables. This blog was influenced by Charles Webb’s blog post on Extracting NetSuite data to Power BI
Share on facebook
Share on twitter
Share on linkedin
Share on reddit
Share on email

Contact Us

Receive a FREE 30-minute consultation with one of our BI Consultants

Find Out

Request a Quote
close slider

Book a Free Consultation Call ​