| Table of Contents |
|---|
Introduction
Several campus shadow and feeder systems have the need to translate legacy Financial System (FS) data to the new Kuali Financial System (KFS) format. As these systems convert to use the new KFS attributes, they will need to validate and extract KFS data The Data Warehouse team currently provides programmatic access to validate and extract in the Business Object and Domain Object queries via HTTP Post.
...
This section will provide information for programmers on how to connect and use the web services.
WSDL and Endpoint
- Dev WSDL location: https://thea.adcom.uci.edu/WebServices/DWHServer?wsdl
- Dev Endpoint: https://thea.adcom.uci.edu/WebServices/DWHServer
- Prod WSDL location: https://systems.oit.uci.edu/WebServices/DWHServer?wsdl
- Prod Endpoint: https://systems.oit.uci.edu/WebServices/DWHServer
For Java applications a client library is provided in the commons Java library. It is recommended to have the latest version (currently oit-commons-dwh-client-1.0.5.jar) to have the latest services available.
To configure your endpoint using the Java client, there are two endpoints available where the production endpoint is the default.
To override the default production endpoint:
- create a properties override file on your classpath at location edu/uci/oit/commons/dwh/client/properties/dwhClientApplicationEndpoints.properties
- override the endpoint with endpoint=${dev} to connect to development web services
| Warning | ||
|---|---|---|
| ||
For any applications using oit-commons-dwh-client-1.0.4 and below, the default production endpoint URL will need to be overridden using the override mechanism described and can override the endpoint property directly: |
For applications written in a language other than Java, a client can be created using the Web Services WSDL
Configuration Notes
- DWH_ws.jar seems to be conflicted with cxf-2.1.1.jar (DWH_ws.jar does NOT need CXF.jar)
...
- Translate FS attributes to KFS attributes
- Validate, extract and provide related attributes for:
- Charts
- Accounts (including SubAccount)
- Fiscal Period
- Object (including Object Level and Consolidation)
- Project
- Organization
- Sub-Account
- Sub-Object
- Vendor
- Purchase Order Transactions
- Capital Assets
- Full Accounting Line
- Retrieve transactional data (ledger transactions, encumbrances, etc.)Retrieve balances