Netsuite Analytics Connect
Looking for guidance on what other users are doing with Netsuite Analytics Connect. For example, I have a table of transactionline and transactionaccountingline. Each of these tables is 9mm rows and I need to join them together to get a master transaction table.
I was hoping to do this in the native connector but it looks like you can't join tables together in the source ( sql below )
Any thoughts from Suite Analytics users ? I'm just looking for a way to reduce rows / optimize credit usage. If there is a way to do this in Netsuite then feed to the Domo connector I'm open to that as well.
SELECT
TL.TRANSACTION
,TL.ID
,TL.UNIQUEKEY
,AL.ACCOUNT
,AL.POSTING
,AL.DEBIT
,AL.CREDIT
,AL.AMOUNT
,AL.NETAMOUNT
FROM TRANSACTIONLINE AS TL
LEFT JOIN TRANSACTIONACCOUNTINGLINE AS AL
ON TL.TRANSACTION=AL.TRANSACTION
AND TL.ID = AL.TRANSACTIONLINE
Best Answer
-
To answer my own question, the script above actually works via suiteanalytics connect in Domo
0
Answers
-
Have you tried using the TBA connector with a custom saved search?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@GrantSmith the saved search connector is terribly slow. I've seen run times of > 12 hours for under a million rows so that isn't an option
0 -
To answer my own question, the script above actually works via suiteanalytics connect in Domo
0 -
@calvert_schaefer looks like you have potentially found a solution but if you are still having issues let me know, I went through a lot of pain getting NetSuite and DOMO connected through Analytics connect but feel like I have a pretty good grasp on it now.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive