Appendix : Legacy Presto components : Mashables and Mashups : Mashables : Connect Information Sources as Mashables : Register Custom Database Mashables
Register Custom Database Mashables
 
Enabling/Disabling Data Alteration Operations and Other Security Considerations
Viewing Details for Tables, Views or Stored Procedures
Removing Tables, Views or Stored Procedures from the Mashable
Removing Columns for Table or View Operations
Changing Column Names or Datatypes for Tables or Views
Removing Table or View Finders
Changing Finders for Tables or Views
Adding Finders for Tables or Views
You or a Business Analytics administrator must configure the data source for this database.
Users can register basic mashable information sources for databases based on one table, view or stored procedure. Business Analytics administrators can register more complex, custom mashable information sources for databases based on any number of tables, views, stored procedures or combinations of these resources within a given schema or catalog in one data source.
Registering a mashable information source for a database generates a standard set of operations, based on database generator configuration.
You can fine tune the standard operations generated for a database mashable that you are registering. You can also add custom queries or finders for more complex database requirements.
1. Click Admin Console in the Business Analytics Hub main menu.
2. Expand Mashable Database Services and click Register Database Services.
3. Click Register new Database Service.
4. Enter a unique Name for this mashable information source.
MashZone NextGen uses the mashable name to assign a unique identifer to mashables. Mashable names can contain characters from the character sets supported by the MashZone NextGen repository, numbers, spaces, tabs, line ends and these common symbols: _ ~ - * ' .
It is a good practice to name mashables based on their purpose, such as AccountsPayable, rather than on deployment or technical information. This will make it easier for other users to recognize and work with the mashable.
5. Enter an optional Description for the mashable information source.
6. Select the Datasource for this mashable.
7. Depending on the type of database, select a Schema, a Catalog or both.
For most types of databases, you select a schema. If information for both fields is available, select both to narrow the list of database assets.
Note:  
For MySQL databases, choose the Catalog entry that identifies the name of the database.
After a few seconds, information for the tables, views and stored procedures in this schema or catalog for this data source are displayed.
8. Check the tables, views or stored procedures that you want to expose in this mashable information source.
*Click in the check box next to Tables, Views or Procedures to select all the listed artifacts.
*Or, click individual tables, views or stored procedures.
If you are not sure of exactly which tables, views or stored procedures you want, you can include them now, review their detail and then remove them from the mashable before you finish registering it.
9. Click Proceed.
10. Enable or disable operations with security implications; review table, view or stored procedure details; or update table or view details as needed to define the operations to include in this mashable:
*Enabling/Disabling Data Alteration Operations and Other Security Considerations
*Viewing Details for Tables, Views or Stored Procedures
*Removing Tables, Views or Stored Procedures from the Mashable
*Removing Columns for Table or View Operations
*Changing Column Names or Datatypes for Tables or Views
*Removing Table or View Finders
*Changing Finders for Tables or Views
*Adding Finders for Tables or Views
11. Once the mashable operation details are complete, click Proceed.
Business Analytics registers the mashable and turns this mashable information source on (by default).
Copyright © 2013-2017 Software AG, Darmstadt, Germany. (Innovation Release)

Product LogoContact Support   |   Community   |   Feedback