Categories
- All Categories
- Oracle Analytics Learning Hub
- 29 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 236 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Ability to import views/ table with col names having special characters or spaces in double quotes
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