2022-01-31 Oracle

QueryResolverFactory

Is ManagedDataAccess the right one ?

For now, added a copy

remove copy ?

BaseBIQueryResolver

DBProviders

BIMetaDataHanlder

What gets cached may be sanitized ?

SmartCacheService does not sainitize

Need to confirm

In that case the caching must be by user or not include the sanitization

Use Datasync Driver

ManagedDataAccess

New oracle connection pour test la dll

Oracle versionning

publictoken guid and version to add to nectariinstaller

Find proper place and syntax

Doc on how to configure provider

Ensure it works with packages

Reload config on the fly

Make test worksheet

Alias name too long for fields

Done but what about tables ?

Tables have same problem

Is this case likely to happen?

DBExpression joins add a Concat type

Adds "||" in between arguments

Meant for use in values (select, join conditions, filters ...)

Not meant for joins

Create new concat | reuse existing one ?

Check if Datasync has usage for concat

Concat is only used in joins at the time being

VisitConcatExpression is only overriden for Oracle and base QueryTranslator

Was there a specific reason why we needed || in datasync ?

Could it be related to Oracle version

Investigate in code / test datasync with oracle with fix

Part of OG implementation

Check dbExpression tests for Oracle and other providers

Add unit tests in dbExpression tests unit tests

Fix test ?

Technically it makes sense, just not for joins

Is this our implementation or Microsofts ?

Check dbExpressions from Microsoft

BIMetadataHandler timeout

What to use ?

What to use for regular queries ?

Do we have a setting in Env & Datasources ?

sqlgen

we use mostly process, not sqlcolumnsmedata

should we switch it to use as much as possible from sqlColumnsMetadata instead ?

Adding management of dbtype

Is cas necessary for all fields ?

Just calculations maybe ?

What if a view has a calculation (decimal issue)

Check how nectari currently handles casts

ORACLE_DataSourceConverter

pooling

schemas

extra connection properties

Culture

RequestDAL

NecDefaultCulture

DBProvider

System_Data_SqlCient_Provider

RecordReaderOfArrayOfStrings

For the culture, supposed to be handled already

Check commit fd1b2b84 for other changes

Test Oracle ou SQL french

Prompts / selection page data format

Mostly dates and datetimes

Using in filters

sqlGen

Wrong name ?? Should be Oracle.ManagedDataAccess

Name is correct as per oracle documentation

See DbProviderFactoriesRegistrator for .Netframework