Build Linked server from NetSuite to SQL server 2017
如何建立Linked server 讓兩邊DB對接，方便我們使用oracle (推測是Netsuite的DB)的來源，寫入MS SQL server 2017的destination呢？
MicroSoft integration services
這就不是我愛說，M$表面上很多方法，實際上都亂無章法，這邊小弟斗膽整理一下，就我ETL的角度來認知。
SSMS Linked Servers ( M$ SQL Server Management Studio )
這是最直覺的方式，也是小弟自己偏愛的scripting方式。兩邊DB打通，我愛怎麼搞就怎麼寫。ETL工具有時太UI化了，煩死。然而普羅大眾我還是推薦UI啦。不是人人都能腦海地圖，UI其實方便在資料層的連結、架構，也方便溝通。
Steps
a. Linked Servers
b. New Linked Server
* Linked Server Name
* Choose “Other data source” for ODBC
**Microsoft OLE DB Provider for ODBC Drivers
c. Fill blanks
-General
* Product name: Customized name
* Data source : Left it blank
* Provider String: Driver=NetSuite32;Uid=****;Pwd=****;AccountID=****;RoleID=****;
Make sure all the credentials are keyed in.
-Security
* Choose “Be made using this security context” (just the same as provider string)
Remote login: (Uid=)****
Password: (PWD=) ****
-Server Options
- Successful
