Ann: JustData Enterprise V2.1 Data Tools
Date: Sat, 28 Apr 2001 10:03:32 +1000
Message-ID: <j62ketka3q1e1h9dafoe84b0g0u5jverkl_at_4ax.com>
Moderator of list: Would you be so kind as to post the following announcement?
JustData Enterprise V2.1 Features (2.1.6.255)
Summary
JustData is a rapid data generation tool for IT person(s) who need to create
large amounts of structured data, prior to testing applications. Working with
. ADO/SQL ANSI92 compliant databases systems
. General applications
. Spreadsheet applications
· MSSQL Server V6.0 - 7.0 BCP application · Oracle 7.0 - i8.0 SQL*Loader application TOPICS
. Overview
· Supported Applications · Export Database data
. Import Database data
· Create and export millions of data records/rows · JustData DataProfile · JustData DataObjects · JustData TextObject · JustData Automation · JustData Data Pumping · JustData Bulk Copying · JustData FastData · Country/Masks Category · Supported Datatypes · JustData's Regional Formats · Cryptography · Tips for Power Users · Sample DataProfiles
. Requirements
. Still To Come
. Web
. Download
. Order from ShareIT
. Contact JustSoft
Overview
Welcome to JustData, the JustSoft application that's the ultimate data testing tool for IT personnel worldwide. With JustData, you can quickly generate live and test data in minutes with an absolute minimum effort and reduce the time spent preparing any application for testing purposes.
JustData works with the Windows environment with popular ADO/SQL ANSI92 compliant databases. All this and more for just US$199 for the (single user) Desktop Edition.
Our goal with the JustData application is to be the "WinZip" of data. By that we mean the best data management tool for Windows, just like the "WinZip" application is to file compression.
Supported Applications
· Database systems (ADO/SQL ANSI92 compliant) · Excel spreadsheet applications, version (Office 95, Word 7.0 - Office 97, Word 8.0) · MSWord version (Office 95, Word 7.0 - Office 97, Word 8.0) · MSSQL Server V6.0 - 7.0 BCP application · Oracle 7.0 - i8.0 SQL*Loader application · Other database systems based on user request · Interchange application data by Advanced Data Tablegram format ADT Export Database data to
. Database Metadata single/all table objects to structure to file
. Table object data to delimited text files for single/all table objects
. Table object data to SQL Insert scripts for single/all table objects
. Table object data to Advanced Data Tablegram format files for single/all table objects
Create and export millions of data records/rows to:
. Clipboard
. CSV text files
. CSV (user defined) text files
. Delimited text files
. Fixed Width text files
. SQL Insert scripts
. XML transport mediums
JustData DataProfile
A dataprofile defines and stores the rules for building the test or live data structure for a specific country (using a JustData Regional Format). Each row of the data profile has specific instructions that are used in the data building sequence. There are many sample data profiles with JustData.
JustData DataObjects
DataObjects is a metaphor for a collection of data objects, where those DataObjects may well be a database system, spreadsheet (worksheets) application or other that are connectable via the ADO and MDAC architecture. Permitting the user to connect to, then allow JustData to interrogate the underlying data structure; thereby allowing the JustData application to automate and pump data into the underlying data structure.
. Connect as passive or active mode
· Save and reload data connection and parameters · Build connections to any database source · Save & reload automation profiles · Select/view the system tables · View field object information covering: · Dataset status · Catalog name · Fieldname · Can modify status · Datatype · Size · Precision · Nullable · Position · Has Default · Default · View Index information covering: · Index names · Index fields · Primary · Unique · Descending · Case Insensitive
JustData TextObject
TextObjects is a metaphor for a text file(s) that may have somewhat structured data, where the columnar data is separated by a character like a comma or semicolon (but not limited to). JustData merges text file(s) data columns into the dataprofile thereby permitting the user to export the required data columns out to a text file with all column(s) of data.
JustData includes sample textobject's that demonstrate the features of the TextObjects.
JustData allows multiple (we mean many) TextObjects within one dataprofile. Essentially the dataprofile could be considered a melting pot, where you can mix and match any data from multiple sources and mix them altogether. Selectively choosing which column(s) of data that you require from each loaded TextObject, then exporting to file.
Import from multiple text files (columns) as
· AsText - string · AsBoolean - logical · AsCurrency - currencies · AsDate - Date · AsDateTime - datetime · AsFloat - float · AsInteger in integer · AsNumber - number · AsTime - time
JustData Automation
Automation are the actions performed by JustData prior to data pumping into a data structure such as a database system.
All Automation source files are standard TAB delimited text files that are created by the JustData DirectIO functions, thereby allowing the user to view and or re-use these files for other purposes within JustData, or alternately with other applications.
JustData Data Pumping
Data Pumping is the final process after creating dataprofiles for each assigned DataObject. Pumping the data directly into the connected DataObject.
JustData Bulk Copying
Bulk copying of data into the most popular database systems is our goal here, to this end we have created and included an interface to both Microsoft's SQL Server database 6.0 thru to 7.0 BCP application and Oracle's database i8.0 SQL*Loader applications.
At this point in time Bulk Copy of Data is subject to beta testing and or changes prior to unlocking the complete functionality included, what we are seeking is feedback from persons as to the content, layout, design and features of this section.
JustData FastData
· For Business, Country/Masks, General, People Categories
Covering the most often used data elements in the computing today. You can drag & drop an item from the Business, General, Masks and People categories directly into the profilegrid.
The purpose behind creating these categories was to provide the end user with access to the most often used titles, thereby facilitating quick dataprofile creation.
Need to create accurate formatted data for any circumstance for any country worlwide then the Country/Masks will simplify the task
Country/Masks Category
· Create mask data with user defined rules for: · Australia · Canada · Denmark · France · Germany · Italy · Japan · Korea · Netherlands · Norway · Spain · Sweden · Taiwan · UK · USA · Build your own data masks for any other country not specified
You can drag & drop an Item from the Country/Masks category directly into the profilegrid, with the attached rules.
In Melbourne Australia the car registration numbers are made up of 3 characters followed by a space or hyphen then three numbers eg:
Australia | Auto4 Reg. No
· QVV-437 · UYU-227 · FTO-661 · PNX-962 · RBX-616
which are controlled by the formatting characteristics of >LLL\-000;0; with the data specified as AAA,ZZZ;111,999
Only character data within the range of AAA,ZZZ of will be used, likewise only the numeric data within the range of 111,999 will be used. Any character or numeric data value outside of the specified range is ignored.
Australian Tax File No's are made up of 9 alphanumeric characters, where optional formatting allows the alphanumeric characters to be grouped into three groups eg:
Australia | Tax File No
· 153 954 249 · 214 582 614 · 188 547 411 · 887 198 772
which are controlled by the formatting characteristics of !000 000 000;0; with no data specified, therefore the data is generated by random numerals (but could also have been designated with range data as well).
Supported Datatypes
· AsDataType* AsText, AsBoolean, AsCurrency, AsDate, AsDateTime, AsFloat, AsInteger, AsNumber, AsTime.
· Bits Data bits eg: 0 - 1 · Binary Binary numbers eg: 01011 etc. · Characters Ascii characters eg: Aa - Zz etc. · Currencies $456,87.99 - ¥456,87.99 - £456.87,99 including variations etc. · Credit Credit card number generation for enRoute, Diners_Club, American_Express, Visa, MasterCard, Discover. · Crypto Intermediate cryptography data generation. · Dates 31/12/1999 - 12/31/1999 - 31.12.1999 - 12-31-1999 including format variations. · DateTimes 31/12/1999 08:27 am - 12-31-1999 15:27:33 including variations. · Fraction Fractional numbers as text eg: 169/5284. · FloatPoint 456,444.93403444 - 456.444,93403444 including variations. · Hexdecimals AB34 - FFFF etc. · ISODates ISO Dates eg: 06/03/1987 First Day 5, Week 10,1987. · Integers -128 - 127, -32768 - 32767. · LargeNo Large No eg: 54876815910705212313782349512106569439460739904893029409380808528310050643415775. · Logical True - False - [NULL] - Unknown and variations. · LongInteger Large integers eg: -2147483648 - 2147483647. · Masks Data masks for countries worldwide covering user defined data eg: Drivers license V2854 232 6, Australian Business No 17-533-124-3466, Bankcard No 3784 9392 4628 3887. · Mixed Part No SKU 34K55-9294U including variations. · MultiMixed ALSKDJ4599 - 4599ALSKDJ including variations. · Number 123,456.44 - 123.456,44 including variations. · Numb2Word Convert numbers to word eg: two billion thirty four million forty five thousand three hundred thirty five and 90/100. · Roman Roman numbers LXXVI etc. · Scientific 3.4440e+04 To 9.9933e+07 including variations. · ScanFiles Scanning file systems for matching file and attributes. · TextObject* User selectable single/multiple data columns from one or more text files, also supporting the AsDataType*. · Times 00:01:55 - 23:59:59 including variations.
JustData Regional Formats
You can create as many different regional formats as you like with JustData, regional formats permit the creation of data for say "France" today and reuse that same dataprofile for the "USA" tomorrow or when ever. Create data for say "Germany" today and reuse the same dataprofile for "New Zealand" tomorrow.
Wow, just think for a moment, no more revisiting (recreating the same data) the same script/one of program just to convert test or live data between different countries.
Database datatype conversion chart covering:
· ADO Value · ADO Datatype · Access · Delphi · JustData · OLE DB · Oracle · SQL Server · Description
Cryptography
Cryptography allows authorized persons to communicate and exchange sensitive data or information, thereby not allowing unauthorized persons to learn or understand the meaning of that information. Most ciphers or encryption routines are widely distributed, and available to almost everyone, are being used widely and that the routines that are easily obtained via the internet.
So the questions begs to asked, just how safe is it? For every problem there is in almost all cases is a solution. With the appropriate software tools the task of understanding or learning about information thats been encrypted is becoming a simpler task. Therefore here's is a basic cryptography method somewhat different in viewpoint, but we must it clear that this simple process is not fool proof, it's easily cracked/de-crypted when the Method and or processes are known. Conversely when the Method or processes are not known and no mention of the techniques disclosed then the encrypted information is more secure.
· Ascii Cryptography Data Tables ACDT
ACDT is not a substitution for an encryption process, nor is the ACDT data absolutely secure, nor are the examples here upto brute force cracking. Then again the same can apply to encryption processes that are used today. What we are saying is that using the ACDT data in conjunction with an application that can pre process and reliably post process can help to increase the security of the underlying data.
Tips for Power Users
JustData is very flexible in many ways, there are many secrets that the developers can share with you to make the JustData application even better.
Tip: With a General category item, you are not bound to the default datatype, you can override the default profilegrid entries by changing the data type in the profile grid type column.
Each category from FastData is loaded from file with the extension of DST, you can also edit these files thereby renaming say a "PostCode" to a "Zip" or "PostCode/Zip". The order within these files must be maintained otherwise JustData will export incorrect data.
Most of JustData's DataType's permit numerous formatting variations, more than we've included in the original application.
Sample DataProfiles
· JustData ships with 30+ sampe dataprofiles covering:
· Accounts.jsd · Airline.jsd · Author.jsd · Billing Hours.jsd · Books & ISBN No.jsd · Business.jsd · Checks.jsd · Company.jsd · Contact Management.jsd · Contacts.jsd · Credit Card Payments.jsd · Dates.jsd · Employees.jsd · Events.jsd · Income.jsd · Insurance Agent.jsd · Integers Mixed-Negative-Positive.jsd · Invoices.jsd · Logical Events · MultiMix.jsd · Numbers Mixed.jsd · Orders.jsd · Patient Events.jsd · Person.jsd · Shipping Orders.jsd · TextObject1.jsd · TextObject2.jsd · TextObject3.jsd · Times.jsd
Requirements
· 3.5 MB free hard disk space · Pentium CPU · 32 (64 better) MB RAM · Windows 95/98 or Windows NT version 4.0 · MDAC 2.1 or later for database connectivity
Still To Come
· see below for Monthly releases of new JustData features
TextPipe and JustData are considering merging into one application, that is:
· Crystal Software Australia http://www.crystalsoftware.com.au · JustSoft Pty Ltd http://www.justsoft.com.au
are examining the benefits to you the end user of merging these two individual applications into one product. From the end users point of view this would bring together the absolute best set of software tools covering
· Data conversion · Data creation · Data filtering · Data management · Data mining · Data replication · Database search & replace · File encryption · Search & replace · Text conversion · Text exchange · Text manipulation · and much much more
Let us know your thoughts on the merits of TextPipe and JustData merging into one complete application, you can email both companies at:
. Subject: Merge both TextPipe & JustData
· Crystal Software Australia mail_at_crystalsoftware.com.au · JustSoft Pty Ltd mail_at_justsoft.com.au
Monthly releases of new JustData features will occur from May 2001 covering (but not limited to):
· Finalization of Automation sequencing · Multiple encryption routines · Command line automation of JustData · Generate unique records of data for database · Create data for relational database table objects · Create data based on the "Terradata" format · Bulk copying of data to other database applications · Scheduling of JustData · Printable reports on applied data rules, dataprofiles structure(s) used and data pumpingactions
· Database replication of data & structure from X database to Y database · Tell us your wish list and we'll look into applying your ideas Web
. http://www.justsoft.com.au/
The latest price list can be downloaded from http://www.justsoft.com.au/order.txt
Download the latest version of JustData from the justsoft website:
. http://www.justsoft.com.au/jstdat21.zip
Order from ShareIT
. http://shareit1.element5.com/programs.html?productid=142797&language=English
Contact JustSoft
· Email: mail_unspam_at_justsoft.com.au · WWW: http://www.justsoft.com.au · Contact: Darryl Impey · Fax +61-3 9560-7356 · Voice: +61-3 9560-7356. · After hours number. Please leave a contact name, number and time, · and we will try to get back to you within 24 hours. · Our time zone is GMT + 10 hours. · JustSoft Pty Ltd · ACN 070 935 429 · Melbourne, Victoria · Australia
Copyright © 1999, 2001 JustSoft Pty Ltd, Australia
From Darryl Impey - JustSoft P/L Melbourne, Australia
http://www.justsoft.com.au/
JustData Enterprise V2.1 Data Tools
Download: http://www.justsoft.com.au/jstdat21.zip
IMPORT, EXPORT & GENERATE ADO/SQL db data, XML and more
mailto:mail_at_<nojunkmail>justsoft.com.au
Received on Sat Apr 28 2001 - 02:03:32 CEST