Managed DB
Inforiver provides a managed Azure SQL database connection for writeback POC purposes. You will be provided with access to the tables created. The administrator can either enable or disable the managed DB connection.
The destination details contain the following information:
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FvpAPoEcOzKS53sIQFOYo%252Fmanage-db-columns.png%3Falt%3Dmedia%26token%3Dad5486b1-568c-4734-9f14-ff309e11d93b&width=768&dpr=4&quality=100&sign=12c3c29e&sv=1)
Destination name - The name of the created database destination. Clicking on any of the destination names will display an overall summary of the destination along with the read only credentials for the table.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FMg0fQTDQyYSnuKLsDtHZ%252Fwb-database-summary.png%3Falt%3Dmedia%26token%3De5bbcba6-ce2d-4585-9eab-e510a299fcf3&width=768&dpr=4&quality=100&sign=be5daae0&sv=1)
Report name - The name of the report to which this database destination belongs to
Created at - The date and time at which the database was created
Created by - The name of the user who created it
Action - A 'Trash' to delete the created DB destination. Clicking on this icon will display a confirmation model. Enter the table name of the destination to be deleted in the modal and click 'Confirm' to confirm the deletion.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FNWE9Ia2uuXUNh1zwYUr5%252Fdelete-destination-confirmation.png%3Falt%3Dmedia%26token%3D4220bc12-396e-42a3-b47b-67336d3cab5b&width=768&dpr=4&quality=100&sign=f491d509&sv=1)
The managed DB settings page also has a 'Created by' filter.
Clicking on this drop-down will display a list of all the users who have created a database destination and you can easily filter the destinations based on the creator.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FOmiRu0qx8B2tdBExcJYK%252Fsettings-created-by.png%3Falt%3Dmedia%26token%3D1b7fa6ed-5152-4d10-861a-66f4c0b8fc83&width=768&dpr=4&quality=100&sign=d073f2bb&sv=1)
Click the 'Reset all' link to clear all the applied filters.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FCZSctdr8uXhsjceCINsL%252Freset-all-db-filter.png%3Falt%3Dmedia%26token%3Deb472802-6dd2-4b36-9f6b-92af288ee204&width=768&dpr=4&quality=100&sign=c39184e2&sv=1)
Create a ManagedDB destination
To create a new Azure Managed DB destination, Click the 'Writeback' option in the toolbar of your Inforiver report.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252F3231gOMowUPi06z7LjOG%252Fwriteback-destination.png%3Falt%3Dmedia%26token%3D9f7d94cf-f97d-4a55-aed1-8b57dd1cfac8&width=768&dpr=4&quality=100&sign=ea88e721&sv=1)
If you haven't previously configured any writeback destinations, clicking the writeback option will open up the 'Configure destination' modal. Click 'Continue'.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FBezJyKkQqc6P7PUf96T5%252Fconfigure-destination.png%3Falt%3Dmedia%26token%3D451660f4-7437-4f12-896d-8f8bd0dc9b84&width=768&dpr=4&quality=100&sign=16efb746&sv=1)
Else if you have already configured the destination, then click the 'Settings' option in the toolbar and navigate to the 'Destination' settings.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FqBMHjzS2nnEcMot96uLl%252Fwriteback-destination-settings.png%3Falt%3Dmedia%26token%3Df042741a-c0b0-41db-ba52-78510ccd07d8&width=768&dpr=4&quality=100&sign=2b656e08&sv=1)
Click the 'Manage' link under the destinations tab.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FTHwJoBCIW3LfJfvHj8tS%252Fmanage-wb-destination.png%3Falt%3Dmedia%26token%3Dc2f8ce1c-e419-428e-897a-255f14f048de&width=768&dpr=4&quality=100&sign=bdaa5642&sv=1)
Either of these options will take you to the destinations page. On the destinations, page click on the 'Add new destination' button at the top right corner.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FmHxkoeudQegJGPrZ0bql%252Fadd-new-destination.png%3Falt%3Dmedia%26token%3Db5da58df-14ac-42b9-b337-45af6ee7a114&width=768&dpr=4&quality=100&sign=cd0251e6&sv=1)
This will open up the 'Add Destination' modal. In the modal, select the 'Azure SQL' option with the managed DB label and click 'Continue'
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FxKpQtPtSry583BGLpgZ5%252Fazure-destination.png%3Falt%3Dmedia%26token%3D5123d021-f94d-4feb-982a-ef4cee9a3e00&width=768&dpr=4&quality=100&sign=5c3e1d66&sv=1)
The 'Terms of service' modal opens up. Click 'Continue' as an acknowledgment of accepting the terms of services.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FowweU2FbMbF8CkLvpeD0%252Faccept-tos.png%3Falt%3Dmedia%26token%3D23b359ab-c9cd-4116-be9b-107eff677f88&width=768&dpr=4&quality=100&sign=aa670042&sv=1)
On the next page, the 'Connections details' are displayed. Enter your table name in the 'Table name' field and click 'Save destination'
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FFJ30FYjuolhL4jBhLroH%252Fadd-new-destination.png%3Falt%3Dmedia%26token%3Dac862af3-859a-4b97-abbf-8339e2f885e8&width=768&dpr=4&quality=100&sign=4dd17007&sv=1)
The new destination will get saved and it will also get displayed both on the destinations page as well as in the managed DB settings page.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FL2BDI22LyoZAkjfNcO6r%252Finforiver-db-summary.png%3Falt%3Dmedia%26token%3D34aec028-ac40-4348-a67a-991b00d43a72&width=768&dpr=4&quality=100&sign=e2d30d6c&sv=1)
In this section, we have covered the managed DB settings. Navigate to the next chapter to learn more about the asset settings.
Last updated