Ahmed Moomen Posted December 27, 2022 Share Posted December 27, 2022 hello dears i have one question that customer use tibco spotfire 11.4.5 in netan for reporting he need to add oracle data source to connect oracle database beside the current sybase datasource please advise with direct steps to add it Link to comment Share on other sites More sharing options...
Fredrik Rosell Posted December 28, 2022 Share Posted December 28, 2022 Hello,I recommend starting by checking the TIBCO Spotfire Server installation and administration manual for general instructions, starting with the overview page "Information Services" - https://docs.tibco.com/pub/spotfire_server/11.4.9/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/information_services.htmlIn short, the high-level process for adding a new type of Information Services data source is this: 1. Install database driver2. Add/enable data source template3. Create data source4. Create an Information Model for the data source5. End users can now start accessing the data using Information Links. Comment about #1: Install database driver In this case, for installing a driver for the data source, for Oracle, you can choose to use the DataDirect driver that ships with the Spotfire server. If you want to install a different driver, e.g. the one provide by Oracle, refer to https://docs.tibco.com/pub/spotfire_server/11.4.9/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/installing_database_drivers_for_information_designer_2.html. Remember to restart your TIBCO Spotfire Server after putting the new driver in place.Comment about #2: Add/enable data source template.There are existing data source templates for Oracle - see https://docs.tibco.com/pub/spotfire_server/11.4.9/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/included_drivers_and_data_source_templates_for_information_services.html - that you could enable and use as they are (or create a new, tweaked one if needed).You can add/enable data source templates using the configuration tool, or using command line. See https://docs.tibco.com/pub/spotfire_server/11.4.9/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/installing_database_drivers_for_information_designer_2.htmlComment about #3: Create data sourceFor instructions on how to create a data source, see the TIBCO Spotfire Analyst manual: https://docs.tibco.com/pub/sfire-analyst/11.4.5/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=id%2Fid_creating_a_data_source.htm&rhsearch=information%20designer&rhsyns=%20Comment about #4: Create an Information ModelRefer to the Analyst manual for general instructions on this:https://docs.tibco.com/pub/sfire-analyst/11.4.5/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=id%2Fid_general_guidelines_for_setting_up_an_im.htm&rhsearch=information%20designer&rhsyns=%20 Link to comment Share on other sites More sharing options...
Ahmed Moomen Posted January 16, 2023 Author Share Posted January 16, 2023 Dear Tibco Have a good day Can you please feedback if we can control data source privilege for the users Explanation more : * If I have users X – Y and have 2 data sources Oracle and Sybase how to let user X access both data sources And Y access the Oracle data source only and cannot access or see the other one Best Regards, [http://mediabank.ericsson.net/internet-media/Email_logo_Ericsson.png] Ahmed Moomen Ashor Integration Engineer -OSS MMEA DS SA OCC OSS NME Phone: +201552221339 Mail: Ahmed.Moomen@ericsson.com Supervisor: Ali.Zaiter@ericsson.com Address :Ericsson Km 28 Cairo-Alex desert road, Smart Village B124 , Giza , Egypt ericsson.com [http://mediabank.ericsson.net/internet-media/Email_Message.gif] Our commitment to Technology for Good and Diversity and Inclusion contributes to positive change. Follow us on: Facebook LinkedIn Twitter Link to comment Share on other sites More sharing options...
Fredrik Rosell Posted January 16, 2023 Share Posted January 16, 2023 Hello,There are two main aspect to that - you can control if a user (or more accurately, the group it belongs to) has access to/can see the Data Source at all using Library Folder Permission, and then you can also control what privileges the user has in the data source itself using various authentication options. Start by reading the page Overview of Data Sources in Information Designer (https://docs.tibco.com/pub/sfire-analyst/11.4.5/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=id%2Fid_data_sources_overview.htm&rhsearch=Designer&rhhlterm=Designer&rhsyns=%20) in the TIBCO Spotfire Analyst User's Guide. I have included the key information from that page below:"With Information Designer, user authentication to the data source can be made in two ways. The first way is to set up the authentication while creating the data source. In this case, all users connect with the same credentials. This is a simple way to authenticate users when everyone has the same permissions to the data source. Further limitation of the access to a data source can be applied by placing the data source within a folder with limited permissions for some users or groups. For more information, see Setting Folder Permissions.The other way is to require authentication each time an information link is used. This is useful when a more detailed security model is required. Using user authentication, row level security can be obtained. The credentials can either be supplied by the user or by a plug-in when running an information link against this data source. A plug-in minimizes the number of times one has to log into the TIBCO Spotfire environment, leaving it up to the plug-in to deliver the data source credentials. Without a plug-in, users will have to supply their data source credentials in a prompt. Credentials can be cached in the data source so that users are prompted only once for each session." Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now