1 of 1 people found this helpful
I think these documentation pages could help:
- Adding external database connections - Documentation for BMC TrueSight Capacity Optimization 11.5 - BMC Documentation
- Configuring database connection using Perl or Java ETLs - Documentation for BMC TrueSight Capacity Optimization 11.5 - B…
So how do I get those to show up in the configuration of my custom ETL? Isn't that part of why I would use Integration Studio?
We suspect that there isn't any additional activity that you should have to do in order to see the option to select custom data sources. I have asked support to create an escalation in development and investigate this as a potential problem rather than expected knowledge transfer or sharing we thought we were going to provide in the community.
Do you have a screenshot of your custom connector in the TSCO user interface that shows the external connections is missing from your ETL that you could share here? I assume that the screenshot you showed above was an example from a different custom connector.
Any additional information like gathering logs and ETL tasks will be requested from your open support case.
In case we do discover that it is a configuration issue that we probably should have documented better, we will update documentation, share with you details in your case, and share the configuration required in this post so that others will learn as well from your query.
Thanks, in advanced,
Can you open Integration Studio, and also share a screenshot of the Run Configuration from IS for your connector. We suspect that the problem is that the ETL was created to connect to a service and not a database. We can tell from the screenshot whether the database option was selected.
Here is a screenshot for how the configuration should look like when configured to connect to a database.
Assuming this is the problem, changing the connector to be configured for database connection and not a service connection will likely require an a query update from development and you can pursue that option in your support case.