Odbc Data Sources and Dat Software for Windows

Data Monkey G.D.H.
$269 - Dataday Solutions Limited

Data Monkey GDH is an ETL and Database Administration application that works with ODBC compliant data sources. With this one tool you can move and manipulate data between ANY odbc compliant data source. With Data Monkey GDH you are able to run adhoc SQL statements the way you would in applications like Toad, SQL plus or Query Analyzer making it a great tool for database administration, but with Data Monkey GDH, you use the same tool, with the same feature set regardless of the database type your connecting to. Now combine this with the same level of ETL features only seen in applications like DTS and Power Center and you start to get an idea of the endless possibilities Data Monkey gives you. Create your own native .Net transformation functions giving you a level of power and flexability that's hard to find elsewhere. Move data from mySQL into Oracle then from there into SQL server then Excel, XML,FoxPro,Access,Siebel Analytics, Goldmine, Analysis Services or whatever else you've got. Once you've created your Data Monkey job, you can then schedule it to run whenever you want. Use the lightweight console application to call your Data Monkey ETL jobs in 'Batch' mode. Execute the job from within your own applications via code or script. Perfect if you need your new application's data import to be powerful and flexible. Embed the console application directly into SQL Server DTS packages. Perform 'Quick Backups' to copy multiple tables into an Excel workbook at the click of a mouse. (perfect for backing up reference data or daily transactions.) You also get Global Parameters, FTP, Configurable Actions, Integrated Email support, SQL BCP Utility, Quick Backups, advanced control over data transformation via C# or Vb.net and the ability to chain jobs together.

---

---

Database Assistant
$39 - Markosoft Inc

The Markosoft Database Assistant is an all-in-one database access tool for use in viewing and editing data from virtually every major type of database including Oracle, MS SQL Server, Informix, MS Access, Sybase, and dBase. Features include the ability to perform wildcard queries, insert, update and remove records, query generating capabilities, free-form queries, and the ability to create ASCII files and insert records from ASCII files.

Additionally, the Database Assistant provides a way to pre-configure all of the data sources that you commonly use, which also provides a way to select a database in just seconds using a single button click.

Finally, shortcuts for accessing FTP accounts via the WS_FTP application can be created with the Database Assistant and quick access menu options are available for displaying individual table definitions and for viewing the records in a list view.

The Database Assistant includes an easy to use interface and many advanced features that are not even found in much more expensive database access applications. Additionally, the flexibility of performing direct entry into data fields or using free-form SQL statements for updating and retrieving records along with a much lower purchase price gives the Database Assistant a definite advantage over the competition. Increase the productivity of all of your data access and manipulation tasks today with the Database Assistant.

---

---

DTM Data Modeler
$179 - DTM soft

DTM Data Modeler is a CASE tool for database developers that supports both forward and reverse engineering. It is an easy-to-use tool allowing you to work both with logical and physical data models in the form of an entity-relationship (IDEF1X notation) diagram. The product is intended for database architects and developers and works with data sources via the ODBC, OLE DB, IDAPI or Oracle Call Interface, which means compatibility with all modern DBMS. Along with basic model properties (sets of entities and relationships between them), the program allows you to create indexes and triggers on the physical level corresponding to the tables of the database that is modeled. The foreign key migration feature makes schema development easier and more visual and also reduces the probability of errors in the integrity of the model. The program can create database schema objects directly in the database as well as to create SQL scripts corresponding to the model and taking into account the settings specified by the user.
The built-in scale and print tools of the model allow you to get a visual representation of the model in the hard copy form for presenting or discussing it. Powerful reverse-engineering tools make it considerably easier to work with existing databases and also provide easy migration from other tools. Both full and selective generation of model objects is available to the user, which makes the product more flexible.

---

Altova MapForce Professional Edition
$499 - Altova, Inc.

Altova MapForce 2008 Professional Edition is the premier data mapping tool for transforming between XML, database, and flat file formats. This award-winning visual data mapper converts data instantly or auto-generates a royalty-free application for execution of recurrent conversions. Its underlying MapForce Engine can even be used as a flexible component within your own data exchange applications. With the power to map between any combination of XML, databases, and/or flat files, Altova MapForce is the definitive tool for data integration and information leverage. Simply open information sources and targets, drop in data processing functions from the customizable libraries, and drag connecting lines between the elements you wish to associate. MapForce automatically connects matching child elements. Numerous functions come standard with MapForce (e.g., filter, concatenate, sum, average, replace, etc.), and you can even create and save your own complex data processing functions. Once a mapping is defined, you can instantly view and save the output. Furthermore, with just a click of the mouse, you can choose between XSLT 1.0, XSLT 2.0, XQuery, Java, C++, or C# and automatically generate an application to automate regular or repeated transformations. MapForce supports every major database, including IBM DB2, Microsoft Access, SQL Server, Oracle, MySQL, Sybase, and any other ADO or ODBC database. It even supports mapping XML data to and from IBM DB2 9: pureXML databases. MapForce Professional Edition integrates with Microsoft Visual Studio .NET and Eclipse, so you can use its advanced functionality from within these leading IDEs. It is an indispensable tool for information architects, database administrators, application developers, and systems integrators working to programmatically integrate data in a cost-effective, standards-based way. Give your data direction! Download a free trial of Altova MapForce 2008 Professional Edition today.

---

odbc2csv
$0 - BitDaddys Corp.

odbc2csv offers the programmer a simple, fast and effective method to collect DSN information from the local ODBC driver and output it to comma separated values. The csv output can be redirected to provide command line batch or script processing the information it needs to process Data Sources for sql export. Extract odbc dsn information information and easily pull into spreadsheet software like ms excel, or parse the data in your command line batch processing. Include with your program and utilize with system calls to collect and act on the provided information!

---

DTM SQL editor
$129 - DTM soft

DTM SQL editor is a set of powerful database management tools that allow you to achieve two goals: to have unified access to different types of databases and to have a set of solutions that makes processing your data easy.
DTM SQL editor gives database users, developers and administrators an ability to access different desktop or client-server databases (provided you have the ODBC, OLE DB or the IDAPI driver or the OCI interface installed).
DTM SQL editor is especially convenient, since most organizations use several different types of databases and each stores data in different formats and with varying parameters. Having a program that can get data from various sources is essential. In addition to quickly switching between different data sources, DTM SQL editor lets you see the database schema and the results of the query execution.
The program gives you a powerful set of tools to edit SQL scripts and to build SQL statements using a convenient wizard-like interface. The program also includes a connections manager, a database schema viewer, an option to view the execution history and other handy tools conveniently integrated in a single user interface.
The application supports clipboard and data export tools. It can export data to plain text, HTML or XML documents, and Microsoft Excel spreadsheets. You can also save the results of your query as a set of SQL statements.
The other advantages of DTM SQL editor are: one-click access to the file history and the history of the scripts you executed, syntax highlighting, multilevel Undo/Redo features and integrated search and replace tools. The program's step-by-step SQL builder (query builder) is the most intuitive and natural way to build complex SQL statements visually without submersing yourself into SQL.
DTM SQL editor supports plug-ins and comes with an SDK (software developer kit), which allows you to significantly increase the range of possible applications of this program.

---