- Flexera Community
- :
- FlexNet Manager
- :
- FlexNet Manager Forum
- :
- Using Business Adapter Studio to upload data to other databases
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
Just curious if it's possible to use the Business Adapter Studio to upload data to other databases? I've tried but I get an error "Invalid object name 'DatabaseConfiguration'" when it attempts to connect to the other database.
Appreciate your help! Thanks!
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Matt,
Yes, sure.
You have to prepare the target staging SQL database as it needs to contain a few stored procedures ([CountChar], [GetTenantID], [IsMultiTenantEnabled]) as well as a few tables. These objects are available in the [FNMSCompliance] database by default. If you use another SQL database for staging your data, you have to add the missing objects to the target database before using Business Adapter Studio.
Documentation - as well as a SQL script 'FNMSStageCreation.sql" for adding these additional objects - is provided with the 'Business Adapter Practice Guide' that is available for download from the 'Flexera Practice Guides' section in the 'Learning Center'.
You can use the 'Other Resources > Learning Center' menu on this site and locate the 'Flexera Practice Guides' tile. Downloading the documentation and resource files will require a valid customer or partner account on the Flexera community though.
Please check this related post, too.
This thread has been automatically locked due to inactivity.
To continue the discussion, please start a new thread.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Matt,
Yes, sure.
You have to prepare the target staging SQL database as it needs to contain a few stored procedures ([CountChar], [GetTenantID], [IsMultiTenantEnabled]) as well as a few tables. These objects are available in the [FNMSCompliance] database by default. If you use another SQL database for staging your data, you have to add the missing objects to the target database before using Business Adapter Studio.
Documentation - as well as a SQL script 'FNMSStageCreation.sql" for adding these additional objects - is provided with the 'Business Adapter Practice Guide' that is available for download from the 'Flexera Practice Guides' section in the 'Learning Center'.
You can use the 'Other Resources > Learning Center' menu on this site and locate the 'Flexera Practice Guides' tile. Downloading the documentation and resource files will require a valid customer or partner account on the Flexera community though.
Please check this related post, too.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Excellent! Thanks @erwinlindemann , appreciate the quick response and advice. That fits with my "gut" feeling about the error. (that it needed to see some specific items to proceed) And I am current customer, so I'll check out the Learning Center as well.
