Configuring access to Greenplum databases You can configure access to a Greenplum database by configuring an ODBC data source definition DSN for Greenplum and by adding the directory location of the Greenplum parallel file distribution program gpfdist to the system path. It may need to change the settings for the flat file source. The system was unable to find the Datasource process for application. The values that are specified for the library path and path environment variables at the project or job level are appended to the existing system values for these variables. Now, we need to copy the lines from the Oracle Wire Protocol section and paste it to the end of the file. Interactive Reporting Madison Created: Hi, I am trying to remember, but, did you try leaving the password blank?

Uploader: Dobar
Date Added: 4 April 2017
File Size: 58.65 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 56385
Price: Free* [*Free Regsitration Required]

Vijay Kurian February 13, at 3: Login to Hypfrion, create a rules file for the target database. As giving password in ODBC file is an confidential, can we have any workaround?

Configuring Data Sources

Earlier, we used app copy utility to create the duplicate app. This spawned datasource process creates a new logfile for each application. Oracle port number SID: Hello Nick, This is a great blog.

The exact error message appears, outside of HFM. Oracle doesn’t seem to be helpful.

The Oracle documentation tells us we can find the file in the following location: About Vijay Kurian Known as the Clem Fandango of EPM consulting, Vijay Kurian has been developing enterprise solutions for companies for the last 12 years increment years if reading post If we want to clear data combinations before the data load, switch to the “Clear Data Combinations” tab.


Notify me of follow-up comments by hy;erion.

Or you can place the file data source on a single server, share it between many computers on the network, and easily maintain the connection information in one location. The Greenplum Connector stage uses ODBC to connect and to execute statements and uses hyperrion gpfdist program to exchange data with the Greenplum database.

Configuring access to data sources

If you find it hard, you can execute the following command to find the file for you: Tejaswini B November 25, at One thing to realize is HFM is still only partially Java based. Select the Combinations to clear from the Dimension list and then continue.

However, Before you can use the ODBC connector in a job, you need dobc configure database drivers, driver managers, and data source names. One of the main logs to investigate is under.

Create your own Oracle Hyperion Virtual Environment: Hi Nick, I created another hyperlon app using “Duplicate Application” option in Consolidation Administration and im able to open without errors.

A machine data source is especially useful when you want to provide added security, because only users who are logged on can view a machine data source and it cannot be copied by a remote user to another computer. Beware, the information found in this blog is for informational purposes only and comes without any warranty or guarantee of accuracy. Setting the library path environment variable To apply an environment variable to all jobs in a project, define the environment variable in the InfoSphere DataStage and QualityStage Administrator.


For example, if you have no version field in the source data, but you have the “Version” dimension in the target Essbase cube.

Swetha November 28, at Newer Post Older Post Home. There are still significant portions of HFM representing legacy code written in C.

It is all about Hyperion Essbase – Load and Export SQL Data

Initializing critical errors log Taking a step back, since all of this is actually wrapped into a Java Server container, one additional place for logs is the Windows service start log:. Interactive Reporting Madison Created: You can click “Add Some bit database client software installations include bit version and bit version of the client libraries.

Obdc Mukka February 11, at