nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Refresh Metadata for SQL Server with underlying database configured as object name case sensitive

User_ZV37X

Today was working on getting SQL server tables into ADB Lakehouse (ADW) of FDI. Installed the plumbing i.e. Remote Agent and setup my connection.

Then tested the connection - all well. Then selected to Run "Refresh Metadata" and it failed on Invalid object name SYS.EXTENDED_PROPERTIES.

So opened this SR 4-0002759157 and Support Team concluded after Zoom session - the issue is with SQL Server configured as case sensitive for collation.

i.e. SQL_Latin1_General_CP1_CS_AS if this is change to SQL_Latin1_General_CP1_CI_AS - Refresh Metadata will succeed.

They pointed me to this Idea Lab.

The ask is to support SQL_Latin1_General_CP1_CS_AS collation.

BTW This SQL server database is affiliated with MUNIS ERP system used by many-many cities in US.

All would love to go to Oracle Utilities like us at City of Durham - and all will want to look at historical data in FDI and use analytics.

Thanks

atul

Find more posts tagged with

Submitted

FDI

Status: Submitted

Comments

There are no comments yet