Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

I cannot simply load a file into DataSet, file does not have extension but it is same as .csv

Accepted answer
31
Views
3
Comments
PPPFP -Oracle
PPPFP -Oracle Rank 1 - Community Starter

Why do I need to rename file to .csv to try to load into a dataset? I'm using Analytics Desktop (MACOs) version.


If I drag file to new dataset , Oracle Analytics open the file in a "text"editor like and when I close it it close all the tool.


Also, I'mt trying to create a ADB connection and it does not create anything and also does not show any simple error message. It just let the "creation"page open and does nothing.


Also, eve nif I rename file it shows error message, but nothing in message that I could debug.

Best Answer

  • For the file type -- today we do use the file type to determine how to parse the file. Supported file types are:

    .xlsx, .xls, .csv, .text, .txt, .tsv, .tab

    For the ADB connection, it is not clear what is happening here. Can you make a connection with these credentials via SQL developer or other desktop tool?

Answers