Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Connect FAW with HCM tables
We are trying to make some reports with HCM data, these data are not found in the FAW subject areas, nor are they available in the OTBI subject areas, nor through data augmentation
Is there a way to connect directly to the HCM fusion tables to be able to query using the data model?
Answers
-
Hi @Samantha Aguilar C ,
In such scenarios, in custom DW solutions, we create BIP reports which queries the Fusion tables. The BIP report is triggered using ETL tools like ODI. The content is downloaded in the form of a CSV report, and, then loaded into a table in the data warehouse. If you have an ETL tool in addition to FAW, this approach can be followed.
Another alternate, is to write the output of the BIP report to a server using ftp. FAW has an option of creating a SFTP connection to a server. So that can be used to connect to the same server and load the BIP output data using data augmentation. I have not tried this approach yet, so not sure of any technical issues associated with it.
Best Regards,
Amrita.
0 -
Hi @Samantha Aguilar C ,
In such scenarios, in custom DW solutions, we create BIP reports which queries the Fusion tables. The BIP report is triggered using ETL tools like ODI. The content is downloaded in the form of a CSV report, and, then loaded into a table in the data warehouse.
If you have an ETL tool in addition to FAW, this approach can be followed.
Another alternate, is to write the output of the BIP report to a server using ftp. FAW has an option of creating a SFTP connection to a server. So that can be used to connect to the same server and load the BIP output data using data augmentation. I have not tried this approach yet, so not sure of any technical issues associated with it.
Best Regards,
Amrita.
0 -
Hi @Samantha Aguilar C ,
In such scenarios, in custom DW solutions, we create BIP reports which queries the Fusion tables. The BIP report is triggered using ETL tools like ODI. The content is downloaded in the form of a CSV report, and, then loaded into a table in the data warehouse.
If you have an ETL tool in addition to FAW, this approach can be followed.
Another alternate, is to write the output of the BIP report to a server using ftp. FAW has an option of creating a SFTP connection to a server. So that can be used to connect to the same server and load the BIP output data using data augmentation. I have not tried this approach yet, so not sure of any technical issues associated with it.
Best Regards,
Amrita.
0 -
Hi @Samantha Aguilar C ,
In such scenarios, in custom DW solutions, we create BIP reports which queries the Fusion tables. The BIP report is triggered using ETL tools like ODI. The content is downloaded in the form of a CSV report, and, then loaded into a table in the data warehouse.
If you have an ETL tool in addition to FAW, this approach can be followed.
Another alternate, is to write the output of the BIP report to a server using ftp. FAW has an option of creating a SFTP connection to a server. So that can be used to connect to the same server and load the BIP output data using data augmentation. I have not tried this approach yet, so not sure of any technical issues associated with it.
Best Regards,
Amrita.
0
