SSIS simply helps to Migrate data’s from Netsuite to outside Databases which are mainly loaded in SQL server.
Mostly Export is done through Visual studio Community towards SQL Server which is located in Microsoft Azure platform.
Part_1: Netsuite Connection Setup through SuiteAnalytics Connect(ODBC Driver)
Part_2: Creating a project in Integration Services Project Template(Visual Studio community)
Part_3: Setting Up Connection Between SuiteAnalytic Connect & Azure Sql Server
3.1: Creating Control Flow & Data Flow Task in SSIS Toolbox
3.2: Adding ODBC source (For SuiteAnalytic Conn) & OLE DB Destination(Sql Database)
//Info: For Sql server Connection, We have to create Both Sql Server(logic Server) and New Database in Azure Virtual Machine.
Add Firewall (Client IP) & Select Option for ‘Allow Azure Resource Connection’
Part_4: Execute SSIS Task
(If Process Run Successfully, A Green Tick mark is Displayed in Source & Destination.)
Part_5: Switch to SQl Database -> Select Table (In Query Editor) -> Select Newly Created Table -> Pass Sample Query To list Data
SSIS server preview
//Info: Even though we modify Netsuite Data & then ReDeploy SSIS Task + Refreshing table in Sql server make no changes in final result.
We have to create New Table And then ReDeploy Required task to view changes(Both Changes are Listed Below[Drive_Link]
Add_On: The Migration can also Done through CDataSync.(Token Based Authentication). The Netsuite Table can be easily Visited Directly through Netsuite Preview Method.
Click here to Preview the Results:
https://drive.google.com/drive/folders/1KbQINsAY1xoSSmtEg6pJjyVpPEdmQjwU?usp=sharing