An Einstein Analytics team wants to create a dashboard that displays values from an external, on-premise Oracle Database. What a

Question

FinnZ [79.3K]

3 years ago

7

An Einstein Analytics team wants to create a dashboard that displays values from an external, on-premise Oracle Database. What a

re two options to load the data from the Oracle Database into Einstein Analytics

Computers and Technology

1 answer:

Vedmedyk [2.9K] · Answer 1 · 2021-12-18T02:15:40+03:00

Answer:

1. Load the data as a CSV file.

2. Use Oracle Database connector.

Explanation:

In this scenario, an Einstein Analytics team wants to create a dashboard that displays values from an external, on-premise Oracle Database. The two (2) options to load the data from the Oracle Database into Einstein Analytics are;

1. Load the data as a CSV file: the data from the external, on-premise Oracle database should be loaded as a comma separated value (CSV) file because these data are normally a text source file. To load the data as a CSV file, the Einstein analytics team can either use the SQL developer, SQL loader, external table or SQL command-line tool and create a database table.

2. Use Oracle Database connector: this is use to import the comma separated values (CSV) files that has been created. It is the necessary program that helps user to connect with the on-premise Oracle Database in order to enable perform various actions such as create, delete, get, and update in a table. Thus, it would load the data from Oracle database into the Einstein Analytics.