Installing SAP BusinessObjects 4.1 Server on Windows 10 (home version)

Installing SAP BusinessObjects 4.1 Server on Windows 10 (home version) — Not supported by SAP(!!!)

Open file product.seed.xml under “51046778\DATA_UNITS\BusinessObjectsServer_win\dunit\product.businessobjects64-4.0-core-32” using text editor. Then modify the “AllowedSuffix” value into Workstation (line 1520):

 

<prerequisite id=”getWindowsVersionPreReq 2″ description=”#prereq.WindowsServerVersionPreReqText#” reason=”#prereq.WindowsServerVersionPreReqNotOkText#” type=”error”>

<action id=”CompareVersion”>

<arg name=”maxVersion” value=””/>

<arg name=”minVersion” value=”6.0″/>

<arg name=”VersionNeedToCompare” value=”[$os.version]”/>

<arg name=”Property” value=”Windows2008Above”/>

<arg name=”AllowedSuffix” value=“Workstation”/>

</action>

<condition property=”Windows2008Above” value=”1″/>

</prerequisite>

 

 

Installing SAP BusinessObjects Explorer 4.1 on Windows 10

 

Open file product.seed.xml under “51046788_4\51046788_\DATA_UNITS\Explorer_win\dunit\product.explorer-4.0-core-32” using text editor. Then modify the “AllowedSuffix” value into Workstation (line 154):

 

<prerequisite id=”getWindowsVersionPreReq 2″ description=”#prereq.WindowsServerVersionPreReqText#” reason=”#prereq.WindowsServerVersionPreReqNotOkText#” type=”error”>

<action id=”CompareVersion”>

<arg name=”maxVersion” value=””/>

<arg name=”minVersion” value=”6.0″/>

<arg name=”VersionNeedToCompare” value=”[$os.version]”/>

<arg name=”Property” value=”Windows2008Above”/>

<arg name=”AllowedSuffix” value=“Workstation”/>

</action>

<condition property=”Windows2008Above” value=”1″/>

</prerequisite>

Connect to Sysbase IQ from Business Object 3.1

D:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\jdbc

modify the jdbc.sbo file

<DataBase Active=”Yes” Name=”Sybase Adaptive Server 15″>
<Class JARFile=”dbd_jdbc,dbd_sybase”>com.businessobjects.connectionserver.java.drivers.jdbc.sybase.SybaseDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
      <ClassPath>
        <Path>d:\Test\jconn3.jar</Path>
      </ClassPath>
<Parameter Name=”JDBC Class”>com.sybase.jdbc3.jdbc.SybDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:sybase:Tds:$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Sybase</Parameter>
<Parameter Name=”Version”>sybase_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>sybase</Parameter>
<Parameter Name=”SQL Parameter File”>sybase</Parameter>
<Parameter Name=”Strategies File”>sybase</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>sybase15,sybase,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
</DataBase>

JDBC data source connection configuration on SAP Business Objects

You can find the file under <Installation_path>\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\jdbc

jdbc.sbo file example (BOXI 3.1)

<?xml version=”1.0″ encoding=”UTF-8″?><!DOCTYPE DriverConfiguration SYSTEM “../sbo.dtd”><DriverConfiguration>
<Defaults>
<Class JARFile=”dbd_jdbc”>com.businessobjects.connectionserver.java.drivers.jdbc.JDBCDriver</Class>
<JDBCDriver>
<ClassPath>
<Path>$ROOT$/dbd_jdbcwrapper.jar</Path>
</ClassPath>
<Parameter Name=”JDBC Wrapper”>com.businessobjects.connectionserver.java.drivers.jdbc.wrapper.JDBCWrapper</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Generic</Parameter>
<Parameter Name=”SQL External File”>jdbc</Parameter>
<Parameter Name=”SQL Parameter File”>jdbc</Parameter>
<Parameter Name=”Description File”>jdbc</Parameter>
<Parameter Name=”Driver Capabilities”>Query</Parameter>
<Parameter Name=”Extensions”>jdbc</Parameter>
<Parameter Name=”Connection Shareable”>Yes</Parameter>
<Parameter Name=”Shared Connection”>No</Parameter>
<Parameter Name=”Array Fetch Available”>True</Parameter>
<!–  define &quot;magic&quot; value 0 for Array Fetch Size to use default JDBC Fetch Size  –>
<Parameter Name=”Array Fetch Size”>0</Parameter>
<Parameter Name=”Array Bind Available”>False</Parameter>
<Parameter Name=”Max Rows Available”>Yes</Parameter>
<Parameter Name=”Query TimeOut Available”>Yes</Parameter>
</Defaults>
<DataBases>
<DataBase Active=”Yes” Name=”Generic JDBC datasource”>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>define java class for JDBC driver</Parameter>
<Parameter Name=”URL Format”>$DATASOURCE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Generic</Parameter>
<Parameter Name=”Version”>jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>jdbc</Parameter>
<Parameter Name=”SQL Parameter File”>jdbc</Parameter>
<Parameter Name=”Description File”>generic_jdbc</Parameter>
<Parameter Name=”Driver Capabilities”>Query</Parameter>
<Parameter Name=”Transactional Available”>No</Parameter>
<Parameter Name=”Max Rows Available”>No</Parameter>
<Parameter Name=”Query TimeOut Available”>No</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”MS SQL Server 7.x”>
<Class JARFile=”dbd_jdbc,dbd_mssql”>com.businessobjects.connectionserver.java.drivers.jdbc.mssql.MSSQLDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.microsoft.jdbc.sqlserver.SQLServerDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:microsoft:sqlserver://$DATASOURCE$;DatabaseName=$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Microsoft</Parameter>
<Parameter Name=”Version”>mssqlserver_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>sqlsrv</Parameter>
<Parameter Name=”SQL Parameter File”>sqlsrv7</Parameter>
<Parameter Name=”Strategies File”>sqlsrv</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>sqlsrv7,sqlsrv,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Procedures</Parameter>
<Parameter Name=”Quote Identifiers”>False</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”MS SQL Server 2000″>
<Aliases>
<!– You can add an alias here if you are using some connections that are defined with an older database engine –>
<Alias>MS SQL Server 6.5</Alias>
</Aliases>
<Class JARFile=”dbd_jdbc,dbd_mssql”>com.businessobjects.connectionserver.java.drivers.jdbc.mssql.MSSQLDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<!– Configuration is done for SQL Server 2000 JDBC Driver –>
<Parameter Name=”JDBC Class”>com.microsoft.jdbc.sqlserver.SQLServerDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:microsoft:sqlserver://$DATASOURCE$;DatabaseName=$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Microsoft</Parameter>
<Parameter Name=”Version”>mssqlserver_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>sqlsrv</Parameter>
<Parameter Name=”SQL Parameter File”>sqlsrv7</Parameter>
<Parameter Name=”Strategies File”>sqlsrv</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>sqlsrv2000,sqlsrv,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Procedures</Parameter>
<Parameter Name=”Quote Identifiers”>False</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”MS SQL Server 2005″>
<Class JARFile=”dbd_jdbc,dbd_mssql”>com.businessobjects.connectionserver.java.drivers.jdbc.mssql.MSSQLDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<!– Configuration is done for SQL Server 2005 JDBC Driver –>
<Parameter Name=”JDBC Class”>com.microsoft.sqlserver.jdbc.SQLServerDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:sqlserver://$DATASOURCE$;DatabaseName=$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Microsoft</Parameter>
<Parameter Name=”Version”>mssqlserver_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>sqlsrv</Parameter>
<Parameter Name=”SQL Parameter File”>sqlsrv</Parameter>
<Parameter Name=”Strategies File”>sqlsrv</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>sqlsrv2005,sqlsrv,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
<Parameter Name=”Quote Identifiers”>False</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”MS SQL Server 2008″>
<Class JARFile=”dbd_jdbc,dbd_mssql”>com.businessobjects.connectionserver.java.drivers.jdbc.mssql.MSSQLDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<!– Configuration is done for SQL Server 2008 JDBC Driver (2.0)  –>
<Parameter Name=”JDBC Class”>com.microsoft.sqlserver.jdbc.SQLServerDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:sqlserver://$DATASOURCE$;DatabaseName=$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Microsoft</Parameter>
<Parameter Name=”Version”>mssqlserver_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>sqlsrv</Parameter>
<Parameter Name=”SQL Parameter File”>sqlsrv</Parameter>
<Parameter Name=”Strategies File”>sqlsrv</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>sqlsrv2008,sqlsrv,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
<Parameter Name=”Quote Identifiers”>False</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Oracle 9″>
<Aliases>
<!– You can add an alias here if you are using some connections
that are defined with an older database engine –>
<Alias>Oracle 7.3</Alias>
<Alias>Oracle 8</Alias>
<Alias>Oracle 8.0</Alias>
<Alias>Oracle 8.1</Alias>
</Aliases>
<Class JARFile=”dbd_jdbc,dbd_oracle”>com.businessobjects.connectionserver.java.drivers.jdbc.oracle.OracleDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>oracle.jdbc.OracleDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:oracle:thin:@$DATASOURCE${:$DATABASE$}</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Oracle</Parameter>
<Parameter Name=”Version”>oracle_jdbc.setup</Parameter>
<Parameter Name=”Description File”>oracle</Parameter>
<Parameter Name=”SQL External File”>oracle</Parameter>
<Parameter Name=”SQL Parameter File”>oracle9</Parameter>
<Parameter Name=”Strategies File”>oracle</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>oracle9,oracle,jdbc</Parameter>
<Parameter Name=”Escape Character”>/</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
<Parameter Name=”Catalog Separator”>.</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Oracle 10″>
<Class JARFile=”dbd_jdbc,dbd_oracle”>com.businessobjects.connectionserver.java.drivers.jdbc.oracle.OracleDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>oracle.jdbc.OracleDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:oracle:thin:@$DATASOURCE${:$DATABASE$}</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Oracle</Parameter>
<Parameter Name=”Version”>oracle_jdbc.setup</Parameter>
<Parameter Name=”Description File”>oracle</Parameter>
<Parameter Name=”SQL External File”>oracle</Parameter>
<Parameter Name=”SQL Parameter File”>oracle</Parameter>
<Parameter Name=”Strategies File”>oracle</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>oracle10,oracle,jdbc</Parameter>
<Parameter Name=”Escape Character”>/</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
<Parameter Name=”Catalog Separator”>.</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Oracle 11″>
<Class JARFile=”dbd_jdbc,dbd_oracle”>com.businessobjects.connectionserver.java.drivers.jdbc.oracle.OracleDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>oracle.jdbc.OracleDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:oracle:thin:@$DATASOURCE${:$DATABASE$}</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Oracle</Parameter>
<Parameter Name=”Version”>oracle_jdbc.setup</Parameter>
<Parameter Name=”Description File”>oracle</Parameter>
<Parameter Name=”SQL External File”>oracle</Parameter>
<Parameter Name=”SQL Parameter File”>oracle</Parameter>
<Parameter Name=”Strategies File”>oracle</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>oracle11,oracle,jdbc</Parameter>
<Parameter Name=”Escape Character”>/</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
<Parameter Name=”Catalog Separator”>.</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”DB2 UDB v8″>
<Aliases>
<!– You can add an alias here if you are using some connections that are defined with an older database engine –>
<Alias>DB2 UDB v7</Alias>
<Alias>DB2 UDB v6</Alias>
<Alias>DB2 UDB v5</Alias>
</Aliases>
<Class JARFile=”dbd_jdbc,dbd_db2″>com.businessobjects.connectionserver.java.drivers.jdbc.db2.DB2Driver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.ibm.db2.jcc.DB2Driver</Parameter>
<Parameter Name=”URL Format”>jdbc:db2://$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>IBM</Parameter>
<Parameter Name=”Version”>db2_jdbc.setup</Parameter>
<Parameter Name=”Description File”>db2</Parameter>
<Parameter Name=”SQL External File”>db2</Parameter>
<Parameter Name=”SQL Parameter File”>db2udb</Parameter>
<Parameter Name=”Strategies File”>db2</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>db2v8,db2udb,db2,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Procedures</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”DB2 v9″>
<Class JARFile=”dbd_jdbc,dbd_db2″>com.businessobjects.connectionserver.java.drivers.jdbc.db2.DB2Driver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.ibm.db2.jcc.DB2Driver</Parameter>
<Parameter Name=”URL Format”>jdbc:db2://$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>IBM</Parameter>
<Parameter Name=”Version”>db2_jdbc.setup</Parameter>
<Parameter Name=”Description File”>db2</Parameter>
<Parameter Name=”SQL External File”>db2</Parameter>
<Parameter Name=”SQL Parameter File”>db2udb</Parameter>
<Parameter Name=”Strategies File”>db2</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>db2v9,db2udb,db2,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Procedures</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Sybase Adaptive Server 12″>
<Aliases>
<!– You can add an alias here if you are using some connections that are defined with an older database engine –>
<Alias>Sybase SQLServer 11</Alias>
<Alias>Sybase Adaptive Server 11</Alias>
</Aliases>
<Class JARFile=”dbd_jdbc,dbd_sybase”>com.businessobjects.connectionserver.java.drivers.jdbc.sybase.SybaseDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.sybase.jdbc3.jdbc.SybDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:sybase:Tds:$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Sybase</Parameter>
<Parameter Name=”Version”>sybase_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>sybase12</Parameter>
<Parameter Name=”SQL Parameter File”>sybase</Parameter>
<Parameter Name=”Strategies File”>sybase</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>sybase12,sybase,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Sybase Adaptive Server 15″>
<Class JARFile=”dbd_jdbc,dbd_sybase”>com.businessobjects.connectionserver.java.drivers.jdbc.sybase.SybaseDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.sybase.jdbc3.jdbc.SybDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:sybase:Tds:$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Sybase</Parameter>
<Parameter Name=”Version”>sybase_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>sybase</Parameter>
<Parameter Name=”SQL Parameter File”>sybase</Parameter>
<Parameter Name=”Strategies File”>sybase</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>sybase15,sybase,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Informix Dynamic Server 7.3″>
<Class JARFile=”dbd_jdbc,dbd_informix”>com.businessobjects.connectionserver.java.drivers.jdbc.informix.InformixDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.informix.jdbc.IfxDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:informix-sqli://$DATASOURCE$/$DATABASE$:informixserver=$INFORMIXSERVER$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>IBM</Parameter>
<Parameter Name=”Version”>informix_jdbc.setup</Parameter>
<Parameter Name=”Description File”>informix</Parameter>
<Parameter Name=”SQL External File”>informix</Parameter>
<Parameter Name=”SQL Parameter File”>informix</Parameter>
<Parameter Name=”Strategies File”>informix</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>ids7,informix,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Informix Dynamic Server 2000″>
<Class JARFile=”dbd_jdbc,dbd_informix”>com.businessobjects.connectionserver.java.drivers.jdbc.informix.InformixDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.informix.jdbc.IfxDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:informix-sqli://$DATASOURCE$/$DATABASE$:informixserver=$INFORMIXSERVER$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>IBM</Parameter>
<Parameter Name=”Version”>informix_jdbc.setup</Parameter>
<Parameter Name=”Description File”>informix</Parameter>
<Parameter Name=”SQL External File”>informix</Parameter>
<Parameter Name=”SQL Parameter File”>informix</Parameter>
<Parameter Name=”Strategies File”>informix</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>ids2000,informix,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Informix Dynamic Server 10″>
<Class JARFile=”dbd_jdbc,dbd_informix”>com.businessobjects.connectionserver.java.drivers.jdbc.informix.InformixDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.informix.jdbc.IfxDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:informix-sqli://$DATASOURCE$/$DATABASE$:informixserver=$INFORMIXSERVER$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>IBM</Parameter>
<Parameter Name=”Version”>informix_jdbc.setup</Parameter>
<Parameter Name=”Description File”>informix</Parameter>
<Parameter Name=”SQL External File”>informix</Parameter>
<Parameter Name=”SQL Parameter File”>informix</Parameter>
<Parameter Name=”Strategies File”>informix</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>ids10,informix,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Informix Dynamic Server 11″>
<Class JARFile=”dbd_jdbc,dbd_informix”>com.businessobjects.connectionserver.java.drivers.jdbc.informix.InformixDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.informix.jdbc.IfxDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:informix-sqli://$DATASOURCE$/$DATABASE$:informixserver=$INFORMIXSERVER$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>IBM</Parameter>
<Parameter Name=”Version”>informix_jdbc.setup</Parameter>
<Parameter Name=”Description File”>informix</Parameter>
<Parameter Name=”SQL External File”>informix</Parameter>
<Parameter Name=”SQL Parameter File”>informix</Parameter>
<Parameter Name=”Strategies File”>informix</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>ids11,informix,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Teradata V2 R6″>
<Aliases>
<Alias>Teradata V2 R5</Alias>
</Aliases>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.ncr.teradata.TeraDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:teradata://$DATASOURCE$/COMPAT_DBS=TRUE,COMPAT_ISSIGNED=TRUE</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Teradata Corporation</Parameter>
<Parameter Name=”Version”>teradata_jdbc.setup</Parameter>
<Parameter Name=”Description File”>jdbc2</Parameter>
<Parameter Name=”SQL External File”>teradata</Parameter>
<Parameter Name=”SQL Parameter File”>teradata</Parameter>
<Parameter Name=”Strategies File”>teradata</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>teradatav2r6,teradata,jdbc</Parameter>
<Parameter Name=”Escape Character Available”>False</Parameter>
<Parameter Name=”ForeignKeys Available”>False</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Teradata 12″>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.teradata.jdbc.TeraDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:teradata://$DATASOURCE$/COMPAT_DBS=TRUE,COMPAT_ISSIGNED=TRUE</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Teradata Corporation</Parameter>
<Parameter Name=”Version”>teradata_jdbc.setup</Parameter>
<Parameter Name=”Description File”>jdbc2</Parameter>
<Parameter Name=”SQL External File”>teradata</Parameter>
<Parameter Name=”SQL Parameter File”>teradata</Parameter>
<Parameter Name=”Strategies File”>teradata</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>teradata12,teradata,jdbc</Parameter>
<Parameter Name=”Escape Character Available”>False</Parameter>
<Parameter Name=”ForeignKeys Available”>False</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Teradata 13″>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.teradata.jdbc.TeraDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:teradata://$DATASOURCE$/COMPAT_DBS=TRUE,COMPAT_ISSIGNED=TRUE</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Teradata Corporation</Parameter>
<Parameter Name=”Version”>teradata_jdbc.setup</Parameter>
<Parameter Name=”Description File”>jdbc2</Parameter>
<Parameter Name=”SQL External File”>teradata</Parameter>
<Parameter Name=”SQL Parameter File”>teradata</Parameter>
<Parameter Name=”Strategies File”>teradata</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>teradata13,teradata,jdbc</Parameter>
<Parameter Name=”Escape Character Available”>False</Parameter>
<Parameter Name=”ForeignKeys Available”>False</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”MySQL 4″>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class file directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.mysql.jdbc.Driver</Parameter>
<Parameter Name=”URL Format”>jdbc:mysql://$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Sun</Parameter>
<Parameter Name=”Version”>mysql_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>mysql</Parameter>
<Parameter Name=”SQL Parameter File”>mysql</Parameter>
<Parameter Name=”Driver Capabilities”>Query</Parameter>
<Parameter Name=”Extensions”>mysql4,mysql,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”MySQL 5″>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.mysql.jdbc.Driver</Parameter>
<Parameter Name=”URL Format”>jdbc:mysql://$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Sun</Parameter>
<Parameter Name=”Version”>mysql_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>mysql</Parameter>
<Parameter Name=”SQL Parameter File”>mysql</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Force Execute”>Procedures</Parameter>
<Parameter Name=”Extensions”>mysql5,mysql,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Progress OpenEdge 10″>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<!–  We only support JDBC type 4 driver, OpenEdge JDBC 10.1 or higher  –>
<Parameter Name=”JDBC Class”>com.ddtek.jdbc.openedge.OpenEdgeDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:datadirect:openedge://$DATASOURCE$;databaseName=$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Progress</Parameter>
<Parameter Name=”Version”>progress_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>progress</Parameter>
<Parameter Name=”SQL Parameter File”>progress</Parameter>
<Parameter Name=”Driver Capabilities”>Query</Parameter>
<Parameter Name=”Extensions”>progress10,progress,jdbc</Parameter>
<Parameter Name=”Catalog Separator”>.</Parameter>
<Parameter Name=”Query TimeOut Available”>No</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Netezza Server”>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>org.netezza.Driver</Parameter>
<Parameter Name=”URL Format”>jdbc:netezza://$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Netezza</Parameter>
<Parameter Name=”Type”>Open</Parameter>
<Parameter Name=”Version”>netezza_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>netezza</Parameter>
<Parameter Name=”SQL Parameter File”>netezza</Parameter>
<Parameter Name=”Driver Capabilities”>Query</Parameter>
<Parameter Name=”Extensions”>netezza,jdbc</Parameter>
<Parameter Name=”PrimaryKey Available”>Yes</Parameter>
<Parameter Name=”ForeignKeys Available”>Yes</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Data Federator Server”>
<Class JARFile=”dbd_jdbc,dbd_datafederator”>com.businessobjects.connectionserver.java.drivers.jdbc.datafederator.DataFederatorDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>LeSelect.ThinDriver.ThinDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:leselect://$DATASOURCE$;catalog=&quot;$DATABASE$&quot;</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>SAP BusinessObjects</Parameter>
<Parameter Name=”Version”>datafederator_jdbc.setup</Parameter>
<Parameter Name=”Description File”>datafederator</Parameter>
<Parameter Name=”SQL External File”>datafederator</Parameter>
<Parameter Name=”SQL Parameter File”>datafederator</Parameter>
<Parameter Name=”Strategies File”>datafederator</Parameter>
<Parameter Name=”Driver Capabilities”>Query</Parameter>
<Parameter Name=”Extensions”>datafederator,jdbc</Parameter>
<Parameter Name=”Query TimeOut Available”>No</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Derby 10 Embedded”>
<Class JARFile=”dbd_jdbc,dbd_derby”>com.businessobjects.connectionserver.java.drivers.jdbc.derby.DerbyEmbeddedDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>org.apache.derby.jdbc.EmbeddedDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:derby:$DATASOURCE$</Parameter>
<Properties>
<Property Name=”create”>true</Property>
</Properties>
</JDBCDriver>
<Parameter Name=”Family”>Apache</Parameter>
<Parameter Name=”Version”>derby_jdbc.setup</Parameter>
<Parameter Name=”Description File”>jdbc2</Parameter>
<Parameter Name=”SQL External File”>derby</Parameter>
<Parameter Name=”SQL Parameter File”>derby</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>derby10,derby,jdbc</Parameter>
<Parameter Name=”Qualifiers Available”>No</Parameter>
<Parameter Name=”Query TimeOut Available”>No</Parameter>
<Parameter Name=”Escape Character”>\</Parameter>
<Parameter Name=”Catalog Separator”>.</Parameter>
<Parameter Name=”Force Execute”>Procedures</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”HSQLDB 1.8 Embedded”>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>org.hsqldb.jdbcDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:hsqldb:file:$DATASOURCE$</Parameter>
<Properties>
<Property Name=”shutdown”>true</Property>
</Properties>
</JDBCDriver>
<Parameter Name=”Family”>HSQLDB</Parameter>
<Parameter Name=”Version”>hsqldb_jdbc.setup</Parameter>
<Parameter Name=”Description File”>jdbc2</Parameter>
<Parameter Name=”SQL External File”>hsqldb</Parameter>
<Parameter Name=”SQL Parameter File”>hsqldb</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>hsqldb,jdbc</Parameter>
<Parameter Name=”Query TimeOut Available”>No</Parameter>
<Parameter Name=”Catalog Separator”>.</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”PostgreSQL 8″>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>org.postgresql.Driver</Parameter>
<Parameter Name=”URL Format”>jdbc:postgresql://$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>PostgreSQL</Parameter>
<Parameter Name=”Version”>greenplum_jdbc.setup</Parameter>
<Parameter Name=”Description File”>jdbc</Parameter>
<Parameter Name=”SQL External File”>postgresql</Parameter>
<Parameter Name=”SQL Parameter File”>postgresql</Parameter>
<Parameter Name=”Driver Capabilities”>Query</Parameter>
<Parameter Name=”Extensions”>postgresql8,postgresql,jdbc</Parameter>
<Parameter Name=”Query TimeOut Available”>No</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”GreenPlum 3″>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>org.postgresql.Driver</Parameter>
<Parameter Name=”URL Format”>jdbc:postgresql://$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>GreenPlum</Parameter>
<Parameter Name=”Version”>greenplum_jdbc.setup</Parameter>
<Parameter Name=”Description File”>jdbc</Parameter>
<Parameter Name=”SQL External File”>postgresql</Parameter>
<Parameter Name=”SQL Parameter File”>postgresql</Parameter>
<Parameter Name=”Driver Capabilities”>Query</Parameter>
<Parameter Name=”Extensions”>greenplum3,greenplum,jdbc</Parameter>
<Parameter Name=”Query TimeOut Available”>No</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Ingres 2006″>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.ingres.jdbc.IngresDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:ingres://$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Ingres</Parameter>
<Parameter Name=”Version”>ingres_jdbc.setup</Parameter>
<Parameter Name=”Description File”>jdbc</Parameter>
<Parameter Name=”SQL External File”>ingres</Parameter>
<Parameter Name=”SQL Parameter File”>ingres</Parameter>
<Parameter Name=”Driver Capabilities”>Query</Parameter>
<Parameter Name=”Extensions”>ingres2006,ingres,jdbc</Parameter>
<Parameter Name=”Query TimeOut Available”>No</Parameter>
<Parameter Name=”Catalog Separator”>.</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
</DataBases>
</DriverConfiguration>

SAP Business Objects Data Federator resources

SAP BusinessObjects Data Federator resources

http://download.sap.com/solutions/sapbusinessobjects/large/eim/datafederator/brochures/download.epd – here is a brochure by SAP BusinessObjects specialists devoted to the point of gaining an unified and real time view of information which originates from multiple data sources. Simultaneously, it’s an introduction to Data Federator tool’s idea. Additionally, there is everything what one could consider useful to know about the solution – business challenges it aspires to satisfy, features and capabilities, and use cases followed with a quick summary of facts..

http://www.sap.com/solutions/sapbusinessobjects/large/eim/datafederator/index.epx – even though the employees of SAP BusinessObjects don’t spread a lot of information about Data Federator, it’s good to check the company official website first. There is a short overview with features, functions, and benefits of Data Federator listed. Here are the fundamentals only, therefore – if one wants to know more, he should aptly called federate data from different sources..

http://alteksolutions.com/wp/index.php/2009/03/consolidate-or-federate-managing-the-need-for-information-access/ – here’s a very good article devoted to the two types of information management – consolidating and federating. The author, Ryan Muldowney, explains the advantages and disadvantages of each of options and – at once – pays a lot of attention to the Data Federator tool itself..

Change BO crystal password

Imports BusinessObjects.DSWS.BICatalog

Imports BusinessObjects.DSWS.BIPlatform

Imports BusinessObjects.DSWS.Publish

Imports BusinessObjects.DSWS.Session

Imports BusinessObjects.DSWS.QueryService

Imports BusinessObjects.DSWS

Imports BusinessObjects.DSWS.BIPlatform.Constants

Imports BusinessObjects.DSWS.BIPlatform.Dest

Imports BusinessObjects.DSWS.BIPlatform.Desktop

PartialClass Default2

Inherits System.Web.UI.Page

Dim Login AsString

Dim Password AsString

Dim Domain AsString

Dim AuthType AsString

Dim boSession As Session

Dim boCredential As EnterpriseCredential

Dim boConnection As BusinessObjects.DSWS.Connection

Dim biPlatform As BIPlatform

Dim bipConURL = “http://jeboxi31:8080/dswsbobje/services/BIPlatform”

ProtectedSub Page_Load(ByVal sender AsObject, ByVal e As System.EventArgs) HandlesMe.Load

‘logon info

Login = “Administrator”

Password = “Password123”

Domain = “jeboxi31”

AuthType = “secEnterprise”

‘logon to Enterprise info

boCredential = New EnterpriseCredential

boCredential.Login = Login

boCredential.Password = Password

boCredential.Domain = Domain

boCredential.AuthType = AuthType

‘create the connection and logon

boConnection = New BusinessObjects.DSWS.Connection(“http://jeboxi31:8080/dswsbobje/services/session”)

boSession = New Session(boConnection)

boSession.Login(boCredential)

boConnection.URL = bipConURL

‘create the biplatform service

biPlatform = New BIPlatform(boConnection, boSession.ConnectionState)

‘used to query for the administrators cuid for use later

Dim query AsString = “query://{Select SI_CUID from CI_SystemObjects where si_name = ‘Administrator’ and si_kind = ‘User’}”

Dim rh As ResponseHolder

Dim oGetOptions AsNew GetOptions

oGetOptions.IncludeSecurity = False

‘get the admins cuid and store it

rh = biPlatform.Get(query, oGetOptions)

Dim userId AsString = rh.InfoObjects.InfoObject(0).CUID

‘query for the publication and get it as an infoobject

‘rh = biPlatform.Get(“path://InfoObjects/Root Folder/MyPublications/testPublication”, oGetOptions)

rh = biPlatform.Get(“query://{Select * from ci_infoobjects where si_name = ‘testPublication’ and si_instance = 0}”, oGetOptions)

Dim pubObj As BusinessObjects.DSWS.BIPlatform.Desktop.InfoObjects

Dim pub As BusinessObjects.DSWS.BIPlatform.Desktop.Publication

pubObj = rh.InfoObjects

‘create the publication from the infoobject

pub = CType(pubObj.InfoObject(0), Publication)

‘get the number of reports in the publication

Dim numOfObj AsNewInteger

numOfObj = pub.Documents.Length

‘hold the cuid of a report

Dim docCUID AsString

Dim counter AsInteger = 0

‘loop through all the reports, query for each and set to pdf

For counter = 0 To numOfObj – 1

docCUID = pub.Documents(counter).ToString

‘used to query for the reports with that cuid

query = “query://{Select * from CI_InfoObjects where si_cuid ='” + docCUID + “‘}”

‘get the report rh = biPlatform.Get(query, oGetOptions)

Dim infoObj As BusinessObjects.DSWS.BIPlatform.Desktop.InfoObjects

infoObj = rh.InfoObjects

Dim crObj As BusinessObjects.DSWS.BIPlatform.Desktop.CrystalReport

crObj = infoObj.InfoObject(0)

‘set its format to pdf

Dim procinfo As ReportProcessingInfo = crObj.PluginProcessingInterface

Dim repFormat AsNew CrystalReportFormatOptions

repFormat.Format = ReportFormatEnum.PDF

Dim fmt AsNew PDFFormat

fmt.AllPageExported = True

fmt.CreateBookmarksFromGroupTree = True

fmt.AllPageExportedSpecified = True

repFormat.FormatInterface = fmt

procinfo.ReportFormatOptions = repFormat

crObj.PluginProcessingInterface = procinfo

Next

‘set the output format to pdf for merge

Dim pubProcInfo(numOfObj – 1) As PubDocProcessingInfo

Dim formatInfo(0) As FormatInfo

pubProcInfo = pub.PubDocumentProcessingInfos

formatInfo(0) = New FormatInfo

‘formatInfo(0).Format = FormatTypeEnum.PDF returns a string of 1 and fails

‘with an invalid format type. must hard code crxf_pdf:0 for pdf

‘this would be the same work around for other types

formatInfo(0).Format = “crxf_pdf:0”

formatInfo(0).DocumentKind = “CrystalReport”

pubProcInfo(0).FormatInfos = formatInfo

pubProcInfo(1).FormatInfos = formatInfo

pub.PubDocumentProcessingInfos = pubProcInfo

‘subscribe administrator to the publication

biPlatform.SubscribePub(pub.CUID, userId)

‘create and grab the schedulinginfo objects from the publication

Dim pubSchedulingInfo As BusinessObjects.DSWS.BIPlatform.Desktop.SchedulingInfo

pubSchedulingInfo = pub.SchedulingInfo

‘set up the schedule

pubSchedulingInfo.RightNow = True

pubSchedulingInfo.ScheduleType = Desktop.ScheduleTypeEnum.ONCE

‘create and grab the publicationeventhandlers from the publication

Dim myPublicationEventHandlers AsNew BusinessObjects.DSWS.BIPlatform.Desktop.PublicationEventHandlers

‘set up the Zip merge for the scheduled object

Dim PublicationEventHandlerArray(1) As BusinessObjects.DSWS.BIPlatform.Desktop.PostProcessingEventHandler

Dim zipPublicationEventHandler AsNew BusinessObjects.DSWS.BIPlatform.Desktop.PostProcessingEventHandler

zipPublicationEventHandler.Name = “ZipMergePlugin”

zipPublicationEventHandler.ClassName = “com.businessobjects.publisher.postprocessing.plugin.ZipMergePlugin”

PublicationEventHandlerArray(1) = zipPublicationEventHandler

‘set up the PDF merge for the scheduled object

‘it must be the first eventhandler in the collection if you are going to

‘zip it as well

Dim pdfPublicationEventHandler AsNew BusinessObjects.DSWS.BIPlatform.Desktop.PostProcessingEventHandler

pdfPublicationEventHandler.Name = “PdfMergePlugin”

pdfPublicationEventHandler.ClassName = “com.businessobjects.publisher.postprocessing.plugin.PdfMergePlugin”

PublicationEventHandlerArray(0) = pdfPublicationEventHandler

myPublicationEventHandlers.PostProcessingEventHandlers = PublicationEventHandlerArray

‘set the zip merge event handler back to the publication

pub.PublicationEventHandlers = myPublicationEventHandlers

‘use this for passing the user cuid to the inbox destination collection

Dim DestinationsCollection(0) AsString

‘Set up the administrator inbox as the destination of the scheduled publication

Dim dests(0) As Destination

dests(0) = New Destination

dests(0).Name = “CrystalEnterprise.Managed”

‘Copy the properties from the Destination Plugin object into the report’s scheduling

‘information.

Dim destPluginFormat(1) As DestinationPluginFormat

destPluginFormat(1) = New DestinationPluginFormat

destPluginFormat(1).DistributionMode = DistributionModeEnum.FILTER_EXCLUDE_SOURCE_DOCUMENTS

destPluginFormat(1).FormatName = “com.businessobjects.publisher.postprocessing.plugin.ZipMergePlugin”

destPluginFormat(1).DistributionModeSpecified = True

destPluginFormat(0) = New DestinationPluginFormat

destPluginFormat(0).DistributionMode = DistributionModeEnum.FILTER_EXCLUDE_SOURCE_DOCUMENTS

destPluginFormat(0).FormatName = “com.businessobjects.publisher.postprocessing.plugin.PdfMergePlugin”

destPluginFormat(0).DistributionModeSpecified = True

dests(0).DestinationPluginFormats = destPluginFormat

‘set up the Inbox options

Dim inboxOpts AsNew ManagedScheduleOptions

inboxOpts.SendToOption = SendToOptionEnum.COPY

inboxOpts.DestinationOption = DestinationOptionEnum.INBOX

‘Set the destination to the admin inbox

DestinationsCollection(0) = userId.ToString

inboxOpts.Destinations = DestinationsCollection

‘Pass the inbox options back to the destination and then to the scheduling info of the publication

dests(0).DestinationScheduleOptions = inboxOpts

pubSchedulingInfo.Destinations = dests

‘run the scheduled publication

biPlatform.Schedule(pubObj)

‘log off the user

boSession.Logout()

EndSub

EndClass

How to Connect to SAS from Business Objects

http://scn.sap.com/thread/1657444

You only need to install the SAS/SHARE JDBC driver 9.1.3 on the Data Federator server machine in the folder ‘DF_INSTALL_DIR\LeSelect\Drivers’.

 
You don’t need to install the SAS/SHARE server. The SAS/SHARE server should be already installed on the machine where the SAS data sets are located. The server version should be at least 9.1.3.

 **For connecting to SAS you need to have license for SAS SHARE.
To connect to the SAS/SHARE server from Data Federator server you should have the following:

1. SAS/SHARE server host name

2. SAS/SHARE server port

3. user name

4. user password

Trouleshoot:
sharenet.S58.ex.txt:

Sharenet.S279.ex.txtDriver.Sharenet.S06.ex.txt: UserId/password not accepted by server..

Loading a webi doc to file

ProtectedSub load_webi()

ceSession = ceSessionmgr.Logon(userid, password, aps, auth)

Try‘Create the infostore object‘##should not have servername‘##ceEnterpriseService = ceSession.GetService(“”, “InfoStore”)

ceEnterpriseService = ceSession.GetService(

“InfoStore”)‘Dim ceAppStore As CrystalDecisions.Enterprise.in

ceInfoStore =

New InfoStore(ceEnterpriseService)‘Grab specific report excluding Instances

sQuery =

“select top 10 webi.SI_ID,webi.SI_NAME,webi.SI_PARENTID, folder.SI_NAME “ & _” from CI_INFOOBJECTS webi “ & _” JOIN CI_INFOOBJECTS folder ON webi.SI_PARENTID = folder.SI_ID “ & _” where webi.SI_NAME like ‘%Recon%’ and webi.si_progid like ‘CrystalEnterprise.Webi'”

sQuery =

“select top 3 * from ci_infoobjects where SI_NAME like ‘%Report%’ and si_progid like ‘CrystalEnterprise.Webi'”‘”

sQuery =

“select top 3 * from ci_infoobjects where SI_ID = 58596”

sQuery =

“select * from ci_infoobjects where SI_NAME like ‘Stale Account’ AND si_progid like ‘CrystalEnterprise.Webi'”

ceReports = ceInfoStore.Query(sQuery)

Dim counter AsInteger

Response.Write(

“<table border =1>”)ForEach ceReport In ceReports

counter = counter + 1

Response.Write(

“<tr>”)

Response.Write(

“<td>” & counter & “</td><td>” & ceReport.Title)Dim k AsIntegerDim webicount AsInteger = ceReport.Properties.CountFor k = 1 To webicount – 1

Response.Write(

” <li>” & ceReport.Properties.Item(k).Name & ” |” & ceReport.Properties.Item(k).Value.ToString())NextForEach oItem As CrystalDecisions.Enterprise.File In ceReport.Files‘If InStr(oItem.Name, “Recon”) > 0 ThenDim index AsInteger = oItem.Name.LastIndexOf(“/”) + 1Dim FILE_NAME AsString = “C:\temp\webi\” & ceReport.Title & counter & “.wid”‘ oItem.Name.Substring(index)‘test_rdm_facttype-dim.unvDim objWriter As System.IO.StreamWriterTry‘objWriter = (New System.IO.StreamWriter(FILE_NAME))Dim buffer(oItem.Size) AsByte

oItem.CopyTo(buffer)

 

Dim fStream AsNew FileStream(FILE_NAME, FileMode.OpenOrCreate)Dim bw AsNew BinaryWriter(fStream)

 

bw.Write(buffer)

bw.Close()

fStream.Close()

Catch ex As ExceptionFinallyEndTry

Response.Write(

“<li> File Name:” & FILE_NAME & ” || value=” & oItem.Size)

Response.Write(

“<li> File path:” & oItem.Name & ” || value=” & oItem.Size)‘End IfNext

Response.Write(

“</td>””<td>” & ceReport.ObjectType.ToString & “”)‘Response.Write(“<ul>”)Dim i AsIntegerDim count AsInteger = ceReport.Properties.CountFor i = 1 To count – 1‘Response.Write(” <li>Property==” & ceReport.Properties.Item(i).Name & ” || value=” & ceReport.Properties.Item(i).Value.ToString())Next

Response.Write(

“</ul>”)

Response.Write(

“</td></tr>”)Next

Response.Write(

“</table>”)Catch ex As ExceptionEndTryEndSub