Skip to main content

In the world where OpenDB can write D3 data to (say) an Oracle Table, have any of you had the experience to (for whatever reason) write from Oracle to D3?

In other words – (say using the ODBC) - I can use SQL statements to INSERT/UPDATE and DELETE a row; this "instruction" is driven from the Oracle side in order to facilitate a D3 file (record) to be modified (WRITTEN TO / UPDATED / DELETED).

How do you deal with the aspect of Multivalued fields – the D3 SQL documentation is a little flaky IMO and there are no real examples of what I wish to achieve and that is to INSERT/UPDATE a value within a MULTIVALUE (defined) attribute.

The “safe” alternative is to write to a “normalised” D3 table and then have a function in D3 to sort things out!

I'd like to know how you may have solved this in a more elegant manner.

Regards

Stefano

In the world where OpenDB can write D3 data to (say) an Oracle Table, have any of you had the experience to (for whatever reason) write from Oracle to D3?

In other words – (say using the ODBC) - I can use SQL statements to INSERT/UPDATE and DELETE a row; this "instruction" is driven from the Oracle side in order to facilitate a D3 file (record) to be modified (WRITTEN TO / UPDATED / DELETED).

How do you deal with the aspect of Multivalued fields – the D3 SQL documentation is a little flaky IMO and there are no real examples of what I wish to achieve and that is to INSERT/UPDATE a value within a MULTIVALUE (defined) attribute.

The “safe” alternative is to write to a “normalised” D3 table and then have a function in D3 to sort things out!

I'd like to know how you may have solved this in a more elegant manner.

Regards

Stefano

As discussed at length the other day, writing to "normalized" tables in D3 is the way to go. SQL-CREATE-TABLE will handle this for you when it encounters multivalued attributes.

Terms & ConditionsAccessibility statement