NetSuite 迁移-数据库问题

NetSuite Migrations(NetSuite 迁移)

本文介绍了NetSuite 迁移的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

有没有人在将数据迁移入和迁移出 NetSuite 方面有丰富的经验?我必须将 DB2 表导出到 MySQL，操作数据，然后导出 CSV 文件.然后获取帐户的 CSV 文件并再次操作数据以使帐户从旧系统匹配到新系统.有人尝试在 MySQL 中这样做吗?

Has anyone had much experience with data migration into and out of NetSuite? I have to export DB2 tables into MySQL, manipulate data, and then export ina CSV file. Then take a CSV file of accounts and manipulate the data again for accounts to match up from our old system to new. Anyone tried to do this in MySQL?

推荐答案

几个选项:

投资于连接到 NetSuite 和 DB2 或 MySQL 的数据转换工具.看看 Dell Boomi、IBM Cast Iron 等.这些工具允许您连接到两个系统、定义要提取的数据、执行数据转换功能和映射以及执行所有插入/更新或您需要执行的任何操作.

Invest in a data transformation tool that connects to NetSuite and DB2 or MySQL. Look at Dell Boomi, IBM Cast Iron, etc. These tools allow you to connect to both systems, define the data to be extracted, perform data transformation functions and mappings and do all the inserts/updates or whatever you need to do.

对于 MySQL 到 NetSuite，可以编写 php 脚本来访问 MySQL 和 NetSuite.在 NetSuite 方面，您可以使用 SOAP Web 服务，也可以在 NetSuite 中编写自定义 REST API.SOAP 可能比 REST 慢一点，但使用 REST，您必须自己编写 API(服务器端 JavaScript - 并不难，但有一个学习曲线).

For MySQL to NetSuite, php scripts can be written to access MySQL and NetSuite. On the NetSuite side, you can either do SOAP web services, or you can write custom REST APIs within NetSuite. SOAP is probably a bit slower than REST, but with REST, you have to write the API yourself (server side JavaScript - it's not hard, but there's a learning curve).

希望这会有所帮助.

这篇关于NetSuite 迁移的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！