Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Financial Reporting Studio Connect to HFM?
Answers
-
Hi Rodney,
Have you installed HFM desktop or ADF drivers on the client machine? If not, this is the issue...
Regards,
Thanos
-
Definitely the HFM client and ADF needs to be installed,
Also, for the Database Connection Properties:
Database Connection Name: a name you give for your connection. could be anything
Type: Financial management
Server: Your HFM server name
User ID: the HSS user/password
Application:the HFM application name.
-
HFM client is installed but ADF drivers have not been installed on the client machine. I will try this from one of the servers in the environment with ADF drivers and the client installed to try and bypass this issue
-
I dont understand how it would connect to HFM with the application server name if its a SQL backend, I would figure that it would need to be the database server for the server. I found the database connection manager within workspace but I seem to be getting the same issue with hanging up for about 3 minutes and then receiving an error message which states "Error connecting to database connection gdcustst12: Class not registered" gdcustst12 is the name of our HFM application server.
-
Hi Rodney,
I m no HFM expert, since i m an infrastructure guy, but with my experience, the HFM connects to a database, and the HFR talks to the HFM and not the database that it is connected to. So, the database connection in question is in fact the HFM server name and not the SQL database server name. The connection on my system is working perfectly. At first, we had some problem with the firewall ports, but after we open them, everything works just fine.
Please let us know how your infrastructure is done? is your HFM server on the same server as the foundation / HFR server? is there any firewall in question?
-
we have 5 servers and HFR and HFM are installed on different servers but the firewall wouldn't play a part in this issue between servers due to rules we have set in place. do you mind sending a screenshot of what your database connection properties look like for HFR for the connection to HFM?
-
-
Hi Rodney,
HFM may be a database back-end application but the data you are going to retrieve will come via the HFM application... this is why you need the ADF drivers.
Regards,
Thanos
-
I understand now, I have a call with Oracle scheduled for now so I will see what they say and then follow up with you guys after the call. Thanks for the help
-
After working with oracle, we determined that the issue was DCOM was not configured on the foundations server. This is the case because HFM and HFR are installed on separate servers within my environment.
