How to Exclude null relation in laravel eloquent oracle and mysql relation

@Tray2 it throws error sir $data = Supplier::with('contracts') ->paginate(10); this is my query in controller by the way the Supplier is Oracle db while the contracts inside in with method is mysql db

@jurietylier Who the hell made that design decision? You should stay in the same rdbms, not mix them.

So, you query one table in the Oracle database, and then you want to fetch an related model from an MySQL database?

I'd say that it sounds like a really bad idea.

Which of the databases is the main application database?

I suggest moving all data into a single database schema, it will make your life much easier.

@Tray2 yes sir is it impossible to do that kind of stuff?

@Tray2 the oracle database is reference database only but id want to sort the oracle and get the related model in mysql

@jurietylier Possible, probably, recommended no.

@Tray2 okay sir thanks for the response

@jurietylier I would then create a database view, in your mysql schema that loads the data you need from your oracle db.

You will have to google how to connect from MySQL to Oracle, the other way around you can use a Oracle Database Gateway.

The easiest would be to export all the tables you need from the oracle database and import them into mysql, or the other way around.

So in general terms, pick one db and stick to it.

@Tray2 okay sir thanks for the recommendation much appreciated