Migrate data tables from AS400 to sharepoint online very urgent

(0) Share

Report

Posted on by Veblitz

2,249

Kindly let me know if it's doable to migrate table data from AS400 to sharepoint online list

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

BCLS776 8,994 Moderator on at

Like (1)

Report
You migrate data via CSV files to a SharePoint List, but keep in mind some key differences from other DBs:

A SharePoint List is not a relational database

As a cloud resource on shared infrastructure, a List has far different performance characteristics than an on-premises dedicated service

A SharePoint List has very different security/privacy capabilities. In short, the whole thing is open to anyone authorized to see any part of it

Hope that helps,

Bryan

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (0)

Report

Thanks a lot. Do we have any migration tool for migrating as400 to office365? There are gigabytes of data. Which is the reliable tool for migration if any please suggest. Much appreciated

Was this reply helpful? Yes No
Verified answer

BCLS776 8,994 Moderator on at

Like (1)

Report

There's no pre-built tool that I am aware of, but I noticed there is a recently-added preview connector. I haven't used it, so I can't comment on how well it works.

Bryan

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (0)

Report

There are some as400 forms and how to migrate those without tool. Kindly shed some light. Much appreciated.

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (0)

Report

Problem statement is we have as400 forms data which sends data to lotus notes and from these data there is one application been developed that utilizes these data from above datasources. Is it possible to migrate into office365

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (0)

Report

This is way off topic from your original post and I haven't run into anyone using Lotus Notes for a very long time. Your question has massive technical details to sort out before anyone can offer you a clear answer, and this forum is probably not the place to seek out that level of technical expertise. Have you tried IBM?

Sure, you can migrate data of some kind into a SharePoint List, but depending on the data it might not be easy and it might not be the best way to do what you to accomplish.

Bryan

Was this reply helpful? Yes No
Suggested answer

rd27 4 on at

Like (0)

Report

I am not sure about the AS400 but SysTools SharePoint Migrator can help you to perform tenant to tenant migration.

Was this reply helpful? Yes No