Page History
The web services listed in this section are used to manage data sources.
Note: Yellowfin also supports the use of these web services for individual client organizations. You can list multiple, or load or update an individual client organization data sources using the LISTDATASOURCES, LOADDATASOURCE and SAVEDATASOURCE functions respectively.
Anchor | ||||
---|---|---|---|---|
|
Expand | |||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||
This web service retrieves a list of all those data sources that are available to the authenticated user and client org. The response will include contain an array of an AdministrationDataSource object with the source ID and source name for each data source that has been found.
Request ParametersThe following parameters should be passed with this request:
Request ExampleBelow is a SOAP XML example for this request:
Response ParametersThe returned response will contain these parameters:
Response ExampleThe service will return the below response, according to our SOAP example:
InstructionsSee below for step-by-step instructions on how to perform this call, using a Java example: Expand | | ||||||||||||||||||||||||||||||||
|
Code Block | ||||
---|---|---|---|---|
| ||||
rsr.setLoginId("admin@yellowfin.com.au");
rsr.setPassword("test");
rsr.setOrgId(new Integer(1));
rsr.setFunction("UPLOADLICENCE"); |
Provide the new licence for your instance. The licence will be a byte array; you can encode it to Base64 and use the util method to convert it.
Code Block | ||
---|---|---|
| ||
byte[] lic = com.hof.util.Base64.decode("Base64 Encoded String of licence file");
rsr.setBinaryData(lic); |
Code Block | ||
---|---|---|
| ||
AdministrationServiceResponse rs = null;
rs = rssbs.remoteAdministrationCall(rsr); |
Initialize the Administration web service. Click here to learn how to do this.
The response will contain the StatusCode. (See details in the Response Parameters table above.)
String | Client Org Internal Reference Id (optional). This lists data sources of a specified client org. If this parameter is not used, the primary org data sources are listed. |
Request Example
Below is a SOAP XML example for this request:
Code Block | ||
---|---|---|
| ||
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:web="http://webservices.web.mi.hof.com/">
<soapenv:Header/>
<soapenv:Body>
<web:remoteAdministrationCall>
<arg0>
<loginId>admin@yellowfin.com.au</loginId>
<password>test</password>
<orgId>1</orgId>
<function>LISTDATASOURCES</function>
</arg0>
</web:remoteAdministrationCall>
</soapenv:Body>
</soapenv:Envelope> |
Response Parameters
The returned response will contain these parameters:
Response Element | Data Type | Description |
---|---|---|
StatusCode | String | Status of the web service call. Possible values include:
|
DataSources | AdministrationDataSource[] | Object array containing all available data sources. |
Response Example
The service will return the below response, according to our SOAP example:
Code Block | ||
---|---|---|
| ||
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
<S:Body>
<ns2:remoteAdministrationCallResponse xmlns:ns2="http://webservices.web.mi.hof.com/">
<return>
<datasources>
<accessLevelCode>UNSECURE</accessLevelCode>
<connectionDriver>org.hsqldb.jdbcDriver</connectionDriver>
<connectionPath/>
<connectionString>jdbc:hsqldb:file:/Applications/Yellowfin 7.4 86/tutorialdata/newskiteam;shutdown=true</connectionString>
<connectionTimeout>180</connectionTimeout>
<connectionType>JDBC</connectionType>
<connectionTypeCode>GENERICUSER</connectionTypeCode>
<inheritChildSourceFilters>false</inheritChildSourceFilters>
<maxRows>10000</maxRows>
<maxmimumConnections>5</maxmimumConnections>
<minimumConnections>1</minimumConnections>
<refreshTime>3</refreshTime>
<sourceDescription>Ski Team is the demonstration and tutorial database.</sourceDescription>
<sourceId>54700</sourceId>
<sourceName>Ski Team</sourceName>
<sourceType>HSQLDB</sourceType>
<timezone>AUSTRALIA/SYDNEY</timezone>
<userName>SA</userName>
<userPassword>cDahEHuTOrk=</userPassword>
</datasources>
<datasources>
<accessLevelCode>UNSECURE</accessLevelCode>
<connectionDriver>org.hsqldb.jdbcDriver</connectionDriver>
<connectionString>jdbc:hsqldb:file:/Applications/Yellowfin 7.4 86/data/configdb;shutdown=true</connectionString>
<connectionTimeout>180</connectionTimeout>
<connectionType>JDBC</connectionType>
<connectionTypeCode>GENERICUSER</connectionTypeCode>
<inheritChildSourceFilters>false</inheritChildSourceFilters>
<maxRows>10000</maxRows>
<maxmimumConnections>5</maxmimumConnections>
<minimumConnections>1</minimumConnections>
<refreshTime>3</refreshTime>
<sourceDescription/>
<sourceId>54701</sourceId>
<sourceName>Yellowfin Configuration Database</sourceName>
<sourceType>GENERICJDBC</sourceType>
<timezone>AUSTRALIA/SYDNEY</timezone>
<userName>SA</userName>
<userPassword>cDahEHuTOrk=</userPassword>
</datasources>
<datasources>
<accessLevelCode>UNSECURE</accessLevelCode>
<connectionDriver>net.sourceforge.jtds.jdbc.Driver</connectionDriver>
<connectionPath/>
<connectionString>jdbc:jtds:sqlserver://:1433/</connectionString>
<connectionTimeout>180</connectionTimeout>
<connectionType>JDBC</connectionType>
<connectionTypeCode>GENERICUSER</connectionTypeCode>
<inheritChildSourceFilters>false</inheritChildSourceFilters>
<maxRows>10000</maxRows>
<maxmimumConnections>5</maxmimumConnections>
<minimumConnections>1</minimumConnections>
<refreshTime>3</refreshTime>
<sourceDescription/>
<sourceId>70108</sourceId>
<sourceName>c</sourceName>
<sourceType>MSSQLSERVER</sourceType>
<timezone>AUSTRALIA/SYDNEY</timezone>
<userName/>
<userPassword>cDahEHuTOrk=</userPassword>
</datasources>
<datasources>
<accessLevelCode>UNSECURE</accessLevelCode>
<connectionDriver>org.postgresql.Driver</connectionDriver>
<connectionPath/>
<connectionString>jdbc:postgresql://10.10.0.117:5432/employees</connectionString>
<connectionTimeout>180</connectionTimeout>
<connectionType>JDBC</connectionType>
<connectionTypeCode>GENERICUSER</connectionTypeCode>
<inheritChildSourceFilters>false</inheritChildSourceFilters>
<maxRows>10000</maxRows>
<maxmimumConnections>5</maxmimumConnections>
<minimumConnections>1</minimumConnections>
<refreshTime>3</refreshTime>
<sourceDescription/>
<sourceId>70101</sourceId>
<sourceName>Oracle database</sourceName>
<sourceType>POSTGRESQL</sourceType>
<timezone>AUSTRALIA/SYDNEY</timezone>
<userName>postgres</userName>
<userPassword>6monvQ6/nGZMnqeGlK/yEw==</userPassword>
</datasources>
<datasources>
<accessLevelCode>UNSECURE</accessLevelCode>
<connectionDriver>oracle.jdbc.OracleDriver</connectionDriver>
<connectionPath/>
<connectionString>jdbc:oracle:thin:@10.10.5.184:1521:orcl</connectionString>
<connectionTimeout>180</connectionTimeout>
<connectionType>JDBC</connectionType>
<connectionTypeCode>GENERICUSER</connectionTypeCode>
<inheritChildSourceFilters>false</inheritChildSourceFilters>
<maxRows>10000</maxRows>
<maxmimumConnections>5</maxmimumConnections>
<minimumConnections>1</minimumConnections>
<refreshTime>3</refreshTime>
<sourceDescription/>
<sourceId>70109</sourceId>
<sourceName>Oracle</sourceName>
<sourceType>ORACLE</sourceType>
<timezone>AUSTRALIA/SYDNEY</timezone>
<userName>bijin</userName>
<userPassword>FKpY9TvYog7WT9ZdYhoCUg==</userPassword>
</datasources>
<datasources>
<accessLevelCode>UNSECURE</accessLevelCode>
<connectionDriver>net.sourceforge.jtds.jdbc.Driver</connectionDriver>
<connectionPath/>
<connectionString>jdbc:jtds:sqlserver://:1433/</connectionString>
<connectionTimeout>180</connectionTimeout>
<connectionType>JDBC</connectionType>
<connectionTypeCode>GENERICUSER</connectionTypeCode>
<inheritChildSourceFilters>false</inheritChildSourceFilters>
<maxRows>10000</maxRows>
<maxmimumConnections>5</maxmimumConnections>
<minimumConnections>1</minimumConnections>
<refreshTime>3</refreshTime>
<sourceDescription/>
<sourceId>70110</sourceId>
<sourceName>f</sourceName>
<sourceType>MSSQLSERVER</sourceType>
<timezone>AUSTRALIA/SYDNEY</timezone>
<userName/>
<userPassword>cDahEHuTOrk=</userPassword>
</datasources>
<errorCode>0</errorCode>
<messages>Successfully Authenticated User: admin@yellowfin.com.au</messages>
<messages>Web Service Request Complete</messages>
<sessionId>8dbd54ecedc55238ece1408713fbc692</sessionId>
<statusCode>SUCCESS</statusCode>
</return>
</ns2:remoteAdministrationCallResponse>
</S:Body>
</S:Envelope> |
Instructions
See below for step-by-step instructions on how to perform this call, using a Java example:
Expand | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||
|
Complete Example
Below is a full example of this web service call. To use it for yourself, carry out the following the steps:
- Copy the code and save it as ws_listdatasources .jsp.
- Put the file in the root folder: Yellowfin/appserver/webapps/ROOT.
- Adjust the host, port, and admin user details according to your environment.
- Run http://<host>:<port>/ws_listdatasources.jsp from your Internet browser.
Code Block | ||||
---|---|---|---|---|
| ||||
<%
/* ws_listdatasources.jsp */
%>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="com.hof.util.*, java.util.*, java.text.*" %>
<%@ page import="com.hof.web.form.*" %>
<%@ page import="com.hof.mi.web.service.*" %>
<%
AdministrationServiceResponse rs = null;
AdministrationServiceRequest rsr = new AdministrationServiceRequest();
AdministrationServiceService ts = new AdministrationServiceServiceLocator("localhost", 8080, "/services/AdministrationService", false);
AdministrationServiceSoapBindingStub rssbs = (AdministrationServiceSoapBindingStub) ts.getAdministrationService();
rsr.setLoginId("admin@yellowfin.com.au");
rsr.setPassword("test");
rsr.setOrgId(new Integer(1));
rsr.setFunction("LISTDATASOURCES");
rs = rssbs.remoteAdministrationCall(rsr);
if ("SUCCESS".equals(rs.getStatusCode())) {
out.write("<table>");
out.write("<tr>");
out.write("<th>Source ID</th><th>Source Name</th>");
out.write("</tr>");
for (AdministrationDataSource administrationDataSource: rs.getDatasources()) {
out.write("<tr>");
out.write("<td>" + administrationDataSource.getSourceId() + "</td><td>" + administrationDataSource.getSourceName() + "</td>");
out.write("</tr>");
}
out.write("</table>");
} else {
out.write(rs.getStatusCode());
out.write(rs.toString());
}
%>
|
Anchor | ||||
---|---|---|---|---|
|
Expand | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
This web service retrieves the metadata of a single data source, that is specified using the Source ID. Request ParametersThe following parameters should be passed with this request:
Request ExampleBelow is a SOAP XML example for this request:
Response ParametersThe returned response will contain these parameters:
Response ExampleThe service will return the below response, according to our SOAP example:
InstructionsSee below for step-by-step instructions on how to perform this call, using a Java example:
Complete ExampleBelow is a full example of this web service call. To use it for yourself, carry out the following the steps:
|
Anchor | ||||
---|---|---|---|---|
|
Expand | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
This web service can be used to create a new Yellowfin data source connection or modify an existing one. For this to work properly, you will need to provide all the parameters for the AdministrationDataSource object, otherwise important parameters will be replaced with NULLs. To create a source in a client org, log in as a user of that client org.
Request ParametersThe following parameters should be passed with this request:
The following parameters will need to be specified in the AdministrationDataSource object:
The following parameters will be required for the AdministrationDataSourceOption objection:
Request ExampleBelow is a SOAP XML example for this request:
Response ParametersThe returned response will contain these parameters:
Response ExampleThe service will return the below response, according to our SOAP example:
InstructionsSee below for step-by-step instructions on how to perform this call, using a Java example:
Complete ExampleBelow is a full example of this web service call. To use it for yourself, carry out the following the steps:
|
Anchor | ||||
---|---|---|---|---|
|
Expand | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
This web service is used to link the default org. data source with client org. sources for the Client Source substitution model. Request ParametersThe following parameters should be passed with this request:
The following parameters are provided in the AdministrationDataSourceClientLink object.
Request ExampleBelow is a SOAP XML example for this request:
Response ParametersThe returned response will contain these parameters:
Response ExampleThe service will return the below response, according to our SOAP example:
InstructionsSee below for step-by-step instructions on how to perform this call, using a Java example:
Complete ExampleBelow is a full example of this web service call. To use it for yourself, carry out the following the steps:
|