Categories
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Ability to import views/ table with col names having special characters or spaces in double quotes
pankaj Tanwar
Rank 1 - Community Starter
Organization Name
Yarra Valley Water
Description
Currently, import into OAC errors out when we import table or view has special characters or spaces with double-quotes in column names. Given OAC has connectors to multiple databases the import functionality has to be more accepting of naming standards.
Use Case and Business Need
We have quite a few tables and views which have business col name with spaces in double-quotes these error out when importing in OAC. Along with that some of our source systems are sql server db and they do not follow naming conventions like Oracle. The limitation around import is negatively impacting user experience to bring data into OAC for analysis.
Original Idea Number: 889b137d98
1