The Datasource Explorer is a two-pane window that lets you navigate through the database objects and other elements available in your data sources. It also lets you initiate actions against the data source and its components. Our View menu command lets you open the Datasource Explorer.

The most fundamental Datasource Explorer task is to connect to a data source. When connecting to a data source an expandable object tree opens in the left-hand pane. You can expand nodes on the tree to drill down to lower level objects. The database’s node not only shows you the databases defined for the data source but lets you view the component database objects.

As you can see the key database objects are accessible. When you select a node on the left-hand pane, additional detail is displayed in the right hand pane. You can see the indexes that have been defined for the database. The right-hand pane provides key details for each index.

You can initiate many DBArtisan features from this listing. For most object types, the Datasource Explorer lets you Create or Edit objects, Drop objects, extract DDL from the objects, or migrate the object for different use on a DBMS platform. Actions specific to the object type and the DBMS platform are also available.

In the case of indexes on SQL Server databases you can see that the update statistics, rebuild index, disable index, and reorganize index sections are available.

Topics : Database Administration,

Products : DBArtisan,

How To Use the Datasource Explorer in DBArtisan

IDERA DBArtisan is a comprehensive database administration solution to manage multiple DBMSs from one central console. DBArtisan utilizes integrated performance analytics to maximize availability, performance, security and collaboration. DBArtisan’s highly effective wizards arm users with the ability to efficiently perform migrations, monitor database environments and plan for space and capacity needs.

With the expectation to be able to ‘do more with less’ in database environments that are constantly changing, DBAs need to be armed with the best tools. DBArtisan simplifies and automates common administration tasks and generates critical insights for long-term performance. From a single interface, DBArtisan facilitates the management of multiple major database platforms (Oracle, SQL Server, DB2 and Sybase), reducing training requirements and streamlining collaboration among different database teams across the organization. Learn More →

Contact IDERA: