Comparison of the model with the database in Oracle Developer Data Modeler

Lubosh

In Oracle Developer Data Modeler, I have a problem where a string of constrein is evaluated as not matching in the model and in the database based solely on the model missing end-of-line characters. How can I set these characters to be ignored (matched)? Or how best to solve it?

Could somebody help me?

SteveF-Oracle

Welcome to the Oracle Analytics Online Forum!

We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.

Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!

Hi @User_2EC4C,

It would be helpful for the community to respond if you provide some additional details.

What version of the model administration tool are you using?

Which analytics product and version are you using?

Which datasource/database product/version are you using?

Can you provide some screenshots/examples?

This way we can best guide you, even if it is to another community forum.

Thanks!

Gianni Ceresa

@User_2EC4C ,

Do you mean Oracle SQL Developer Data Modeler?

If yes, then you are in the wrong forum. Because it's a different platform your question can't be moved to the right place. You will need to repost it in https://forums.oracle.com/ords/apexds/domain/dev-community/category/sql-developer

Lubosh

https://community.oracle.com/products/oracleanalytics/discussion/comment/51509#Comment_51509

I am using Oracle SQL Developer Data Modeler Version 23.1.0.087

and Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0

I made import of Model from database:

import-from-db.jpg

I try to compare according to the pictures:

when I try to edit constreit to add new lines in Model:

the comparison shows a match.

But, when I try next comparation

and then I make merge from database to the Model I am on the same point as in begining.

I am surprised that the import from the database itself and the subsequent compliance check will not turn out well.

The given example is just one of many disagreements. I want to deal with them individually, but in the given case I can't even find any settings that don't take into account end-of-line characters when comparing.

Gianni Ceresa

As I said above, you have to repost your question in the other forum (link posted above to the right category).

This forum is about Oracle Analytics products, it doesn’t cover SQL Developer Data Modeler.