Hello,
if I try to create an IAL-Object or a QuickReport with a link to another db I get:
"code":2019,"message":"ORA-02019: connection description for remote database not found"
Is that not possible?
Best Regards,
Erik
Solved
DB-Links in QuickReports or IAL-Objects
+1Best answer by SamiL
Hi,
If this is a managed cloud environment (*.ifs.cloud), all such connections are generally blocked.
If it is a remote deployment, you should talk to whoever is hosting your solution.
It is also likely that the mentioned frameworks do not support more than SELECT statements, ie. the DB link should first be built directly from Oracle (which should be possible in a remote deployment) - and then it might be possible to include data from it if the SELECT from Quick Report or IAL reaches the link. I haven’t explored this myself and there may be further obstacles.
For example migration jobs do however work in this way - the DB link is created in Oracle and then the data can be accessed.
Another approach is using BI for reporting, for example the IFS Tabular Models (optional SKU 10127) fetch the data into a customer-hosted SQL server where you have full control of the server. Then you could do any links you normally can from a Microsoft SQL server.
The new approach is to pump into a datalake in Parquet (optional SKU 10128) but if you require database links the traditional SQL-framework might actually be more suitable.
Hi,
If this is a managed cloud environment (*.ifs.cloud), all such connections are generally blocked.
If it is a remote deployment, you should talk to whoever is hosting your solution.
It is also likely that the mentioned frameworks do not support more than SELECT statements, ie. the DB link should first be built directly from Oracle (which should be possible in a remote deployment) - and then it might be possible to include data from it if the SELECT from Quick Report or IAL reaches the link. I haven’t explored this myself and there may be further obstacles.
For example migration jobs do however work in this way - the DB link is created in Oracle and then the data can be accessed.
Another approach is using BI for reporting, for example the IFS Tabular Models (optional SKU 10127) fetch the data into a customer-hosted SQL server where you have full control of the server. Then you could do any links you normally can from a Microsoft SQL server.
The new approach is to pump into a datalake in Parquet (optional SKU 10128) but if you require database links the traditional SQL-framework might actually be more suitable.
+9Hi Sami,
I totally agree with you!
“ fetch the data into a customer-hosted SQL server where you have full control of the server.”
That ist exactly that what we are doing all the time.
Just this weekend one of my customers added “correction data” via excel into the MS SQL DWH database. To name 4 connections:
IFS ORACLE, infor data from old ERP, XLS for files like correction, budget, etc.
CSV for machinedata.
You can imagine, that there could be much more.
BR
Michael
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.