Connector Improvement: Enhance NetSuite Connector to support the NetSuite2.com Data Source
Completed
Enhance the NetSuite Connector to support the NetSuite2.com Data Source as the NetSuite.com Data Source is being deprecated and will no longer be updated with any new functionality.
NetSuite has made the following announcement earlier this week:
Connect NetSuite.com Data Source No Longer Being Updated
You are receiving this notification because you use SuiteAnalytics Connect. The NetSuite.com data source is still supported, but it will no longer be updated with newly exposed tables or columns, and it may be removed in the future. New tables and columns will now only be exposed to the NetSuite2.com data source.
This change is targeted for October 2021.
You are encouraged to start a transition process from NetSuite.com to NetSuite2.com. NetSuite2.com provides advanced query capabilities and has been available since 2019.2.
What is Changing?
Currently, SuiteAnalytics Connect provides access to the following data sources:
• NetSuite.com – Uses the only schema available up to 2018.2 to retrieve data. The details about the tables and columns in this schema are available through the Connect Browser.
• NetSuite2.com – Uses the schema that has been used in SuiteAnalytics Workbook since 2019.1. The details about the record types in NetSuite2.com, also known as the analytics data source, are available through the Records Catalog.
As of October 2021, the NetSuite.com data source will no longer be updated with newly exposed tables and columns, and no enhancements will be made. Users will still be able to access the NetSuite.com data source. However, the NetSuite.com data source will only include records exposed up to 2021.2, and support for NetSuite.com will end in a future release. As of that time, the use of the NetSuite.com will not be considered a best practice.
Benefits of Using the NetSuite2.com Data Source
The analytics data source is designed to display consistent data across SuiteAnalytics Workbook, which solves some previous inconsistencies in data exposure between saved searches, reports, and the NetSuite UI. It applies role-based access control, which contributes to improved security.
You are encouraged to use the NetSuite2.com when you work with SuiteAnalytics Connect. New tables and columns will now only be exposed to the analytics data source.
When you use SuiteAnalytics Connect with the NetSuite2.com data source, you must consider the following:
• New Data Warehouse Integrator (DWI) role - Previous to 2021.2, there was no role that allowed Connect users to have access to all NetSuite data through the NetSuite2.com data source. The Administrator role and the SuiteAnalytics - Read All permission were available for NetSuite.com only. As of 2021.2, the new Data Warehouse Integrator role allows users to have access to all NetSuite data through the NetSuite2.com data source, except for sensitive data, such as credit card information. The DWI role requires token-based authentication (TBA).
Note: The Data Warehouse Integrator role and token-based authentication are available for 2021.2 only. If you have not been upgraded to 2021.2 yet, you should start using the NetSuite2.com data source, but you will not be able to use the Data Warehouse Integrator role and token-based authentication until your account is upgraded.
• SuiteQL - Change your SQL queries to SuiteQL queries. You must run SuiteQL queries when you use the Connect Service with NetSuite2.com data source. If you do not change your queries, they will not work with the NetSuite2.com data source.
• Records Catalog - To see information about the record types and fields, joined record types and join properties, you can use the Records Catalog, which shows only data relevant to your account and role.
Required Actions
You should start to use the NetSuite2.com data source when you work with SuiteAnalytics Connect. To access the NetSuite2.com data source, you must set the Service Data Source connection attribute to NetSuite2.com. When you access the NetSuite2.com with the Connect Service, ensure that you change your SQL queries to SuiteQL queries.
For more information about this change, see Connect NetSuite.com Data Source No Longer Being Updated (SuiteAnswers ID 101873).
For more information about specific considerations, see the following topics:
• To learn about the required roles and permissions, see Role and Permission Considerations for NetSuite2.com (SuiteAnswers ID 39013).
• To change the connection attribute to access the analytics data source, see Selecting a Data Source (SuiteAnswer ID 82635).
• To learn about SuiteQL and best practices for querying the Connect Service, see SuiteQL (SuiteAnswers ID 87349) and Using SuiteQL with the Connect Service (SuiteAnswers ID 87353).
• To learn about the analytics data source and Connect, see The Analytics Data Source and SuiteAnalytics Connect (SuiteAnswers ID 82641).
If you have more questions, please contact NetSuite Customer Support.
Thank you,
The Oracle NetSuite Team
-
Official comment
Hi Dave -
Thanks for submitting this feature request! I'm the Product Manager for our Netsuite SuiteAnalytics connector.
I appreciate you sharing this recent announcement from Netsuite. As of now, your Fivetran Netsuite SuiteAnalytics connector will continue to operate as it always has, by syncing your critical Netsuite data to your data warehouse so you can make data backed decisions from it.
Currently, our Fivetran team is working to solidify our plans to continue support for Netsuite SuiteAnalytics. Future details to come!
Best,
Erin -
Erin Are there any details that can be shared now? It's been 2 months. We have an outstanding ticket and have requested escalation as well.
-
Hi,
Does Fivetran support data source netsuite2.com now?
Thanks,
Fabien
-
Hi all -
Thank you for following up on this feature request. Development is beginning this quarter to support Netsuite2.com.
However, at this time if you are currently unable to connect to our Fivetran Netsuite connector due to this limitation, please reach out to your CSM or email us at netsuite_questions@fivetran.com and we will be able to help you with an interim solution.
Thank you,
Erin
-
Hi Erin,
I have sent an email and a follow up during the last 2 weeks regarding this feature request.
What is the best channel to talk to somebody about the interim solution to connect Fivetran to NetSuite ? -
Hi Pierre -
Thanks for following up, I have responded to your email and contacted Netsuite on your behalf.
Best,
Erin
-
Hi All -
If you are a current NetSuite customer you should have seen an email go out earlier today announcing that NetSuite2 is now supported in Private Preview. If you wish to try this connector, please reach out to NetSuite_Questions@fivetran.com to have the feature enabled for your account.
For more information on the connector, please see our documentation here. There is a FAQ about the differences between the two sources as well.
Thanks for all of your patience on this!
Erin -
Dave,
We are in the process porting our reports and applications from Netsuite database to the Netsuite2 database and ran into an issue with the support_case table. It has a primary key "id" but is missing a last_updated timestamp so the table is considered re-import and not incremental. This causes the table to be replicated on weekends only. We request that the Netsuite Team add a last_updated timestamp column to the support_case table so that it can be incremental and replicated with each sync. Note that we did not have this issue with the Netsuite database support_incidents table.
Mike
Please sign in to leave a comment.
Comments
8 comments