i have an SQLSERVER database which has many schema and databases present in it, how can I add them in Diyotta Datapoint
i have an SQLSERVER database which has many schema and databases present in it, how can I add them in Diyotta Datapoint. Instead of typing the names of all theĀ schemas and databases how can I avoid this manual step?
If there are many databases and schema names in the datapoint, Diyotta provides an option of selecting from the list of schemas/databases present in the SERVER.
Once the datapoint details are provided in the PROPERTIES tab, then try to do TEST DATAPOINT. Once the TEST DATAPOINT is done move to the database tab and click on the database/schema tab and select them based on the need.
Schemas: Once the database is selected then it lists all the schemas included in that particular database.