NetSuite SuiteAnalytics Connect ODBC and JDBC Connection String Generator

jdbc:ns://1234567.connect.api.netsuite.com:1708;ServerDataSource=NetSuite2.com;Encrypted=1;NegotiateSSLClose=false;CustomProperties=(AccountID=1234567;RoleID=3)

Driver class: com.netsuite.jdbc.openaccess.OpenAccessDriver   (file NQjc.jar on the classpath)
User: your NetSuite login email    Password: your NetSuite password

// Minimal Java connection test
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;

public class ConnectTest {
    public static void main(String[] args) throws Exception {
        Class.forName("com.netsuite.jdbc.openaccess.OpenAccessDriver");
        String url = "jdbc:ns://1234567.connect.api.netsuite.com:1708;ServerDataSource=NetSuite2.com;Encrypted=1;"
                + "NegotiateSSLClose=false;CustomProperties=(AccountID=1234567;RoleID=3)";
        try (Connection c = DriverManager.getConnection(url, System.getenv("NS_USER"), System.getenv("NS_PASSWORD"));
             ResultSet rs = c.createStatement().executeQuery("SELECT id, tranid FROM transaction WHERE ROWNUM <= 10")) {
            while (rs.next()) {
                System.out.println(rs.getString(1) + " " + rs.getString(2));
            }
        }
    }
}

Windows: ODBC Data Source Administrator (64-bit) > System DSN > NetSuite DSN > Configure > General tab

Name:                  NetSuite
Account ID:            1234567
Role ID:               3
Service Host:          1234567.connect.api.netsuite.com
Service Port:          1708
Service Data Source:   NetSuite2.com   (pick with Browse)
Then click Test Connect and sign in with your NetSuite email and password.

DSN connection string (Excel, Power BI, scripts):
DSN=NetSuite;UID=<netsuite login email>;PWD=<password>

DSN-less connection string (Windows):
DRIVER=NetSuite Drivers 64bit;Host=1234567.connect.api.netsuite.com;Port=1708;Encrypted=1;AllowSinglePacketLogout=1;Truststore=system;SDSN=NetSuite2.com;UID=<netsuite login email>;PWD=<password>;CustomProperties=AccountID=1234567;RoleID=3

Excel: Data > Get Data > From Other Sources > From ODBC > choose NetSuite > enter credentials > pick tables in the Navigator, or open Advanced options and paste a SQL statement.

# /opt/netsuite/odbcclient/odbc64.ini   (use odbc.ini for the 32-bit driver)
[ODBC Data Sources]
NetSuite=NetSuite ODBC Drivers

[NetSuite]
Driver=/opt/netsuite/odbcclient/lib64/ivoa27.so
Description=NetSuite2.com via SuiteAnalytics Connect
Host=1234567.connect.api.netsuite.com
Port=1708
ServerDataSource=NetSuite2.com
Encrypted=1
AllowSinglePacketLogout=1
TrustStore=/opt/netsuite/odbcclient/cert/ca4.cer
CustomProperties=AccountID=1234567;RoleID=3

-- NetSuite2.com test queries
SELECT id, tranid FROM transaction WHERE ROWNUM <= 10

SELECT id, tranid, trandate, type FROM transaction
WHERE type = 'SalesOrd' AND trandate >= ADD_MONTHS(SYSDATE, -1)