Skip to main content

Notifications

Community site session details
Power Apps - Building Power Apps
Answered

Migrate data tables from AS400 to sharepoint online very urgent

Like (0) ShareShare
ReportReport
Posted on 15 Dec 2023 16:35:56 by 2,245

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

Categories:
  • Suggested answer
    rd27 Profile Picture
    4 on 16 Oct 2024 at 06:33:07
    Migrate data tables from AS400 to sharepoint online very urgent
    I am not sure about the AS400 but SysTools SharePoint Migrator can help you to perform tenant to tenant migration.
  • BCLS776 Profile Picture
    8,988 Super User 2025 Season 1 on 15 Dec 2023 at 23:27:26
    Re: Migrate data tables from AS400 to sharepoint online very urgent

    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

  • Veblitz Profile Picture
    2,245 on 15 Dec 2023 at 22:01:16
    Re: Migrate data tables from AS400 to sharepoint online very urgent

    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

  • Veblitz Profile Picture
    2,245 on 15 Dec 2023 at 21:49:27
    Re: Migrate data tables from AS400 to sharepoint online very urgent

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

  • Verified answer
    BCLS776 Profile Picture
    8,988 Super User 2025 Season 1 on 15 Dec 2023 at 21:43:08
    Re: Migrate data tables from AS400 to sharepoint online very urgent

    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

  • Veblitz Profile Picture
    2,245 on 15 Dec 2023 at 21:32:13
    Re: Migrate data tables from AS400 to sharepoint online very urgent

    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

  • BCLS776 Profile Picture
    8,988 Super User 2025 Season 1 on 15 Dec 2023 at 20:57:25
    Re: Migrate data tables from AS400 to sharepoint online very urgent

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 89 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 60

#3
stampcoin Profile Picture

stampcoin 48

Overall leaderboard