Hi, Are you getting the same error when running a different Data Load definition, e.g., CRM, Maintenance? I assume yes base on the SSIS log error you get (Copy Data from Oracle to SQL Server db).After setting up your Azure Resources, did you update the Key Vault on the IFS side with information from your Azure Setup (e.g. Admin username of the Azure SQL Server, Admin user password for the Azure SQL Server)?The Key Vault update is done through the IFS Support ticket. I hope it helps :)
Hi Mohsin, You should change the sub forum of your question from Data Migration to Finance. Your topic is more related to Finance. This may be the reason you still have no answer to your question. Best Regards Martin Gestinge
Hi Johnathan, You should change the sub forum of your question from Data Migration to Finance. Your topic is more related to Finance. This may be the reason you still have no answer under your question. Best Regards Martin Gestinger
If you are running on APP 10, it is possible to access IFS Oracle Database from Power BI. Of course, you cannot connect directly to the database. Power BI would drop down immediately due to huge amount of data. There are some steps which needs to be included to get data from database in to Power BI. Install Power BI Gateway. 2. Create new workspace in web Power BI environment 3. Create own Data flow utilizing Power BI Gateway connection 4. Create your own model and set scheduling for data transfer.
Hi Thiwanke, Thank you for references, even the documentation is for APP 10, and I am in Cloud, it is almost same. For some else for looking for same issue, I am adding screenshot below for cloud. Thank you
Hi Disna, Thank you for your comment. Your approach looks nice and elegant. But I see now you are in APP 10 and I try to recreate something similar in IFS Cloud 21R1 and there is no window for BR System parameter where is ALL define and could be used in BR. But using % in functional parameter with NVL solve this as well. Thank you for your added details. Martin
Hi Disna, Can I ask you which operator (IN, = or LIKE) do you use in advanced filters with this standard and functional parametrs? Thank you Martin Gestinger
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.