How to Import Data from Oracle database to SharePoint Online list

Question

How to Import Data from Oracle database to SharePoint Online list

Anonymous

Can anyone give me some concise, understandable steps through which to import data from an Oracle database to a SharePoint Online list? I know that it includes working with BCS and Secure Store but I'm having trouble finding anything that is either up to date or applicable to SPO rather than on-prem.

Thank you in advance.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

Answer accepted by question author

8 additional answers

Answer 1

Hi Lisa,

We can confirm that we can connect Oracle database to Power BI and the data in Power BI can be imported into SharePoint Online. Here are some articles for your reference:

Connect to an Oracle database

Manage your data source - Oracle

SharePoint Lists Integration

However, I can’t confirm whether your Oracle databased can be successfully connected to SharePoint Online list using Power BI. Since we have a specific forum that handling Power BI related queries and issues, for the detailed information and the definitive answer, we recommend you browse to Power BI forum for professional support. Engineers and members there have more experience about this kind of question than us.

Thanks for your understanding.

Joanne

Answer 2

Hi Lisa,

Thanks for your update.

If you need this to be dynamic, we may try connecting Oracle database to a SQL server first, then import the data in SQL server to SharePoint Online.

Here are some articles for your reference:

Creating a Linked Server for Oracle in 64bit SQL Server

Connect To Oracle (OracleToSQL)

SharePoint 2013:BCS Connect To Oracle DB No Code (this article applies to SharePoint Online as well)

Import data from SQL to SharePoint Online

***Disclaimer:****Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.*

If you have further questions about how to create connection between Oracle database to SQL server, we suggest posting your question in MSDN forum for professional support. It is the specific channel that handling this kind of queries and issues.

If you'd like to find some solutions via Power BI, we recommend you browse to Power BI community for dedicated assistance. Engineers and members in that forum have more experience about your question.

We appreciated your understanding.

Joanne

Answer 3

Hi Lisa,

Here are some steps that you can try.

(Since I don't have an Oracle database to let me test, I am not for sure that they must work.)

Import the data from your Oracle database to Excel, for the details you can refer to Connect to an Oracle database (Power Query).
Export this Excel file to a SharePoint Online list. For your reference: Export an Excel table to SharePoint, Create a list based on a spreadsheet.

Regards,

Joanne

Answer 4

Anonymous

Hi Lisa,

Could you share any update with us?

Regards,

Joanne

Answer 5

What about Power BI and connectors? If we are using a connector with Oracle DB to be able to use its data in Power BI, can we use the connector to import/connect to/with a SPO list?

We also need this to be dynamic--not just a copy/paste of current data. We must be able to interact with and update it by refreshing the data from the Oracle DB as well as making an entry that is pushed back to the DB.

Please advise. Maybe someone else has worked with an Oracle DB BCS situation in SPO/O365?

Share via

How to Import Data from Oracle database to SharePoint Online list

8 additional answers