| |
Results |
|
SBM 11.3+: How to run a command line data import (ODBC Import)
|
Beginning in SBM 11.3, you can run an import option set from the command line, allowing you to schedule imports or start an import from within another script.
|
|
|
|
Importing from excel spreadsheet on 64 bit version of SBM
|
When importing from an Excel spreadsheet on a 64 bit version of SBM , the odbc window will not include the drivers needed to create a DSN to the Excel spreadsheet.
|
|
|
|
How-To View Oracle Sessions from SBM
|
The following Oracle query will all the DBA to see sessions and the applications making them. To identity SBM Application Engine and AE common logger applications, it is possible to edit the Windows ODBC connections ( SBM _AE and SBM _CL by default) and edit settings on the client monitoring tab. Here is a sample tab:
|
|
|
|
How to enable SBM to communicate via SSL with a SQL Server database
|
If your MS SQL Server is setup with the Force Encryption value set to yes then you will have to make the following changes for SBM to communicate with it. If your SQL server is setup this way then the Application Engine components will work fine because they connect via ODBC but the JBOSS components will fail to connect via JDBC and need the following changes made to the JDBC connection string in order to connect to the SQL Server database.
|
|
|
|
How to Delete the Mashup2009 DSN Manually After SBM Uninstall
|
HKEY_LOCAL_MACHINE\SOFTWARE\ ODBC \ ODBC .INI\Mashup2009
|
|
|
|
Oracle Advanced Security and SBM (data encryption)
|
3. Open the OBDC Adminstrator 4. Edit your ODBC data source and go the the Advanced Security tab. Set your encryption level and data integrity level to '3 - Required' and set the required types. You have now set encryption and integrity for the Application Engine (user interface).
|
|
|
|
How to Give Full Administrative Access to an SBM user.
|
database via ODBC . To open the wizard, select Reset Administrative User Access from the Tools menu,
|
|
|
|
SBM 2008/2009: How to switch SBM from Sql Server database to an Oracle database (or vice versa)?
|
Create Oracle User with required privileges and import the sample database. Create Oracle ODBC definition and connect to it via the Mashup Asministrator Ensure that IIS has access to the Oracle directory as per installation guide.
|
|
|
|
Readme for SBM 10.1 as of 9th February 2012
|
* Microsoft SQL Server 2008 Oracle Database Client Connectors Oracle ODBC connections that use the Oracle driver are no longer supported.
|
|
|
SBM Version Diff
|
Differences Between Versions Note: Be sure to create a 'System' data source.\r\n\r\nSystem data sources are necessary for the\r\nWeb Server component of SBM .\r\n\r\nUse the System DSN tab in the ODBC Administrator\r\ndialog to configure a 'System' data source.
|
|
|
