Transcript Online Databases

Database Workshop
May 30, 2008
© 2008 by Fred Kagel, Dir., [email protected], Freehold Computer Training Ctr. All rights reserved.
GoogleBase
•Immediately Publishable
•Immediately Searchable
•Certain entries expire in 30 days
How to Create
• Log In: http://base.google.com/base
• You will need an email account
Types of Databases
• Course Schedules
• Events and Activities
• Housing
• Jobs
• Products
• News Articles
• Personals
• References
• Reviews
• Services
• Travel Packages
• Vacation Rentals
• Your own
Fields
• Predetermined based on type of database
Fields
•
•
•
•
•
•
•
•
Text
Number – Units
Number
Date
Large Text
Web URL
Checkbox
Location
•
•
•
•
•
•
•
•
Author: Fred Kagel
Memory: 4 GB
Bedrooms: 2
Birthday: 1/1/1980
Directions: Turn right…
http://www.bcug.com
Parking included?
1 Main St., Anytown, US
GoogleBase
Data Bulk Feeds
Pervasive DataTools
Pervasive DataTools - Data Builders
The Pervasive Data Builders are the tools to
use for building perfectly-structured files for
importing into a specific target application -including online/hosted stores.
Source Side
• The Data Builders support reading data from
literally dozens of Sources - including databases,
text files, spreadsheets, flat files, application
exports, etc. The graphical tool gives you the
power to completely view all the Source data in
its native format, so you can see exactly what
needs to be mapped to your Target. Filtering
and sorting can be used to constrain the Source
data sets.
Target & Mapping
• A world class Source-to-Target drag-n-drop
•
mapping UI is available to perform any needed
re-structuring of fields and columns to get them
into the exact Target format...that is pre-built
for you!
A full-blown transformation capability is in the
same mapping UI, with easy wizards for editing,
reformatting, cleansing and otherwise
manipulating the data contents on-the-fly so
that only clean data is imported into your target
application!
Supported Target Formats
•
•
•
•
•
•
•
•
•
•
Epicor Vantage
Google GMail Contacts
NetSuite
QuickBooks IIF
QBXML
SugarCRM
Amazon Store
eBay Store
GoogleBase
Yahoo Store
These possibilities
interested me.
And these as well.
Demos for Starters
http://pervasivedatatools.com/support/training-demos
Microsoft FrontPage
• Configures a Webpage to send contents from
a form directly to a database
• Add a table to a Webpage that will retrieve
and display database content
• Configures Access 2002 w/o opening Access
• Import existing Access database
• Edit database content from Web interface
Requirements
• Host must support Front Page Extensions
and ASP.NET (Active Server Pages)
– Pages get saved as .asp instead of .htm or
.html
• Web Presence Provider
– http://www.microsoftwpp.com/dbproviders/
• Global.asa in root directory of web
Database Wizard
• File | New | Page or Web
– Web Site Templates
– New from Template
• Choices
– Create New Database
– Connect to Existing
– Use sample (Northwind)
• Enter name for connection
Next
• Enter Fields
What do you get
• Submission Form
• Results Page
• Database Editor
Collective Intelligence
Nothing special!
I just like this graphic!