MindStick DataConverter is a powerful tool which helps you to:
1. View, Filter, Sort and Export the data from different sources (MS SQL, Oracle, Access, ODBC DSNs etc.) in one place
2. Export the query results in HTML, CSV, XML and .XLS (Excel) format
3. Minimize typing by saving most frequently used queries in a database as query snippets
4. Make changes on fly in a query result grid and export it to XML, HTML, CSV or .XLS (Excel) format to communicate your suggested changes to your team members without really making the database changes.
5. Share data which can be easily read and modified by another MindStick DataConverter user in grid format which allows filtering, sorting, group by features or any other user which can use XML, CSV or XLS(Excel) file
6. Easily create queries to fetch records
7. Lets you see database schema (Example - Tables) from different data sources (MS SQL, Oracle, Access, ODBC DSNs etc.) in one window.
You can download MindStick DataConverter from MindStick site, followed by Product section or you can directly download MindStick DataConverter by visiting http://mindstick.com/Products/DataConverter
Currently we do not provide any technical support regarding MindStick DataConverter but in near future we will be providing technical support, for the time being if you have any question or query regarding MindStick DataConverter then you can contact us by visiting http://mindstick.com/ContactUs URL.
No you don’t need to uninstall old version. MindStick DataConverter installer will do it automatically. For downloading latest version of MindStick DataConverter please visit on MindStick Product section page.
Using MindStick Data Converter, you can browse records from different – different databases, apply filters on those records and save records in form of XML, EXCEL, CSV and HTML files. So that you can easily transfer records from one place to another in several format.
Using MindStick Data Converter, you can browse records from different – different databases, apply filters on those records and save records in form of XML, EXCEL, CSV and HTML files. So that you can easily transfer records from one place to another in several format.
When you save any query text in MindStick DataConverter then that text is known as query snippet. You can save complex query in format of query snippet and use it again and again by drag and drop to query analyzer window.
When you want to execute your own queries, then you can use query analyzer of MindStick DataConverter. You can execute all SQL (Structured Query Language) statements in query analyzer window of MindStick DataConverter.
For executing any SQL query in MindStick DataConverter, follow the following steps:
Write down your query in Query Analyzer window of MindStick DataConverter.
Click on Run Query menu option.
When you establish connection with database, then all tables of database is displayed in Explorer window. All the query snippets which you have saved are also displayed in Explorer window of MindStick DataConverter. You can directly drag and drop query snippet and tables name in query analyzer window.
For showing and hiding explorer window, you need to follow the following steps: Go to Options menu. Click on Explorer sub menu option. By clicking on Explorer sub menu if Explorer is visible then it hides or vice versa.
You can view all saved query snippets by performing these steps. Open Explorer window. See at bottom of Explorer window and Find Query Snippets button if it is not visible then click on smart tag followed by Add or Remove Buttons then click on Query Snippets button. Click on Query Snippets button.
By performing above mentioned steps you will see all saved query snippets.
When you click on Tables button then all available tables will be displayed in Explorer window and when you click on Query Snippets then you will see all saved query snippets in Explorer window.
To change CSV separator you need to follow the following steps:
Click on option menu.
Click on Setting sub menu.
After performing this action, Setting dialog box is open where you can specify separator character for your CSV file.
Yes, you can use your own connection string for MindStick DataConverter. To use your own connection string you need to follow the following steps:
Open login window.
Check on Advance option.
Check on Custom Connection String.
Click on Next button then you will see a text area where you can enter your own connection string.
Whenever you want to use OleDb option or you want to provide your own connection string then you can use Advance option of Login window of MindStick DataConverter.
Whenever you want to execute your own SQL statements in query analyzer window of MindStick DataConverter then you can use Run Query button to execute it.
If databases are not displayed in Database dropdown list after providing connection string then you need to recheck the following:
Check connection string again, including server name, user id and password.
Check that particular database server have database or not. If it have database then check whether you have permission or not.
For changing all values of particular column you need to perform steps mentioned below:
Click on Update Local Grid Value menu option.
Update Local Grid Value dialog box opens.
Select column name from column drop down.
Add new vale in textbox.
Click on OK button to reflect these changes on local grid.
For exporting data in format of excel file you need to perform the following steps:
Right click on output area of MindStick DataConverter.
Click on Export option.
Finally click on EXCEL option
For creating query snippet you need to follow the following steps:
Type your query in query window.
Right click on query window.
Select Add Snippet/Add Selected Snippet menu option from pop-up menu.
Add Snippet dialog box open.
Provide name of snippet and click on ok button to save snippet.
Yes, you can filter records according to your need. To filter records according to your need perform the mentioned below steps:
Click on Filter icon.
Select Custom from filter drop down.
Filter dialog box appears. Here you can provide filtering according to your need.