NetSuite ODBC and JDBC via DBeaver

In a new data warehousing project that I'm involved with, I ran into some challenges connecting to and pulling data from NetSuite ODBC server using SuiteAnalytics Connect. It was quite a journey to finally find the right tool, as many SQL Clients - including the one from Oracle and Microsoft - were not as robust and flexible to connect to NetSuite's ODBC.

After digging around, I found an "Universal Database Tool" called "DBeaver" that is free for developers, SQL programmers, database administrators and analysts. It was very flexible that I could connect to any database if I had the JDBC available.

And I wanted to share these steps (as detailed as possible), hoping that no one else runs into the issues I had and waste so much time.

These steps are based on MacOS, but it's not very different on Windows either. If you need the guide to connect to NetSuite using DBeaver on Windows, please let me know.

1) Download and install DBeaver Community from https://dbeaver.io/

2) Download and install SuiteAnalytics Connect - refer to SuiteAnswers article 38965 and related topics. I downloaded and extracted JDBC for MacOS since ODBC isn't available.

3) Launch DBeaver Community. We need to add NetSuite driver. Go to Database > Driver Manager, and click New.

4) Give it a proper name and description. Set Class Name to com.netsuite.jdbc.openaccess.OpenAccessDriver and leave the URL Template and Default Port blank. Click "Add File" and choose the NQjc.jar file that was extracted from step 2). Click OK.

5) Once the driver is added, you can hit OK to exit from the driver manager window. Click on New Connection or go to Database > New Connection. Select the driver you created in step 4), and hit Next.

6) Enter below URL to JDBC URL field, and add your user name and password. Account Id and Role Id can be found on "Set Up SuiteAnalytics Connect" page.

jdbc:ns://odbcserver.na1.netsuite.com:1708;ServerDataSource=NetSuite.com;encrypted=1;Ciphersuites=TLS_RSA_WITH_AES_128_CBC_SHA;CustomProperties=(AccountID={accountId};RoleID={roleId})

7) When you click on Test Connection... you will see a Success box if things went well!



Offer, Counter Offer, Rejection, Promotion

Past few weeks have been pretty stressful. Not only because of work and school, but also because of all other things that happened around them.

I had applied to a few places, either directly or through recruiting agencies. In some cases, hiring managers sent me notes and emails. Among a couple of offers and many rejections, I accepted an offer from a company, then cancelled all my other scheduled on-site interviews.

I'm not sure if the new company would have cared, but I wanted to at least show that I'm not some sort of job hunter trying to get a salary increase. As I received a verbal offer, I showed my diligence and cancelled all my other on-site interviews. The recruiting agent nor the hiring manager would have known this, but I did tell the internal HR representative that I am cancelling all my phone interviews and on-site interviews.

After getting the offer, I gave my resignation notice. Obviously, my current employer tried to retain me. Although my original plan was to leave my current employer at all costs, ultimately, I accepted the counter-offer from my current employer after rejecting for 3 times, as the 4th offer was something irresistible. Now the recruiting agency and the new company is very disappointed, and the recruiting agent, although said not requesting me to justify my reasons, is asking me to reconsider and justify my reasons. Really? I'd expect you to at least look into my current employer's profile before saying shit about it. It may not have a great reviews on Glassdoor, but it know what it's doing.

Recruiters are great

Many recruiters appeal to you personally, regardless how professional they are. Also, they help with all the logistics so you can focus on what is important - research of the company, the role, preparing for the interview

Most recruiters are annoying

They just send you an email, often with an unprofessional format of the email (copy & paste), and most importantly, with an opportunity that is completely unrelated to my career. Come on, I have my resume and profile set to public everywhere. I don't expect you to know the difference between a Java job and a JavaScript job, but I really don't know how a helpdesk job relates to my career profile.

Recruiters are like babysitters

Often times, however, I felt they were "babysitting" me, telling me how to be there on time, how to dress, what to do before the phone interview, after the phone interview, etc. I am a working professional, and I know what interests me and what does not. I also know how to behave and build relationships. I understand you want your cut, but babysitting someone who's been working for 10 years is a joke.

Some recruiters don't even bother you

They always ask what you are looking for. There was a recruiter I submitted multiple applications through with. Unfortunately, I didn't end up getting any of the job, but I asked him why he's not referring me to jobs that I know are open. He told me that those jobs don't meet my salary expectations, commute requirements or both. Some recruiters don't seem to get the "point."

At the end, I am content with the career progress. And I'm deeply sorry for the recruiter and the employer. But obviously, coming to a decision is never easy, and I had a few sleepless nights before making my decision. And I am a grown up and will take any responsibilities or circumstances seriously.

And no, the tech in Boston is not small.

#Life is unfair for #success, so #TryHard

Life is unfair. You need to be not only smart and diligent but also lucky for success.

If you are only smart and diligent, then you will end up working for the ones who are smart and diligent and lucky.

If you are diligent and lucky, then you will end up working for the ones who are smart and diligent but not lucky.

If you are only smart or only diligent, then your life is screwed.

So, try hard.

Palau, Nha Trang, Sydney, Guam, Hawaii, New Caledonia, Fiji, American Samoa, French Polynesia, and more...

A big change is coming to my life, and now it's time to make a decision. I will soon move back to Korea and travel a lot.

The first stop? I must decide on a summer vacation spot for July!!

There are sooooo many places I want to visit, and they are all good, so it's a such a difficult decision to make..

My first option is Palau. It's only about 5 hours away from Seoul, and there isn't anything to do! I'm sure all I can do there is "rest".

Palau

Others in the list are: French Polynesia, Fiji, American Samoa, New Caledonia, Nha Trang and Guam. French Polynesia seems to be the best place by far, while it takes close to 18 hours to get there.

There is no doubt that if there was a direct flight for about 14 hours to French Polynesia, I will not consider any other places.

Bora Bora, French Polynesia

Fiji could be the 2nd best option - there is a direct flight with duration of 10 hours. I think it can be a perfect vacation place, while mom's telling us that Fiji wasn't as good as expected, while she was on a golf tour about 5 years ago.

Fiji

New Caledonia and American Samoa look very good option too, while Guam and Hawaii are more famous vacation places among Koreans.

Some are suggesting Nha Trang, but my concern is that places Southeast Asia are probably hot and humid during summer.

Well, why would it matter if I'm only staying in the hotel room & balcony with AC on? Maybe I'll end up resting at the cheapest place...