Description
Read & Write to any desktop side database Wirelessly with your Android Phone/Tablet(using local WiFi, VPN or USB/WiFi Tethering). Changes on device and any modifications in desktop database can synchronize wirelessly and instantly, so you will always have the most current information at your fingertips.Download & install desktop software on windows based PC from the following link.
http://www.cellica.com/download/CellicaDatabaseAndroidWiFi.exe
Features:
• No changes require in existing database design for syncing directly with database, which helps it be the easiest, most user-friendly solution available.
• View and update data on device, which will reflect to Server database immediately while in network.
• Supports offline access to data and Changes will be synchronized later once network is available.
• Synchronize Table/View or Stored Procedure of your database.
• Only the changed data is synchronized in compressed and encrypted format, resulting in reduced wireless data traffic and improves battery life of the devices.
• “Change Detection Logic” searches only updated data in desktop database and send it to device. Also Sync Server receives and synchronizes records collected/updated on device to desktop database.
• No record or size limit. It depends on space available on device’s internal memory(/SD card).
• Use SQL Select queries, Filters and Sorts to refine specific data set.
• Supported Databases: Microsoft Access(*.mdb,*.accdb)(97 and onwards), Microsoft Excel(*.xls,*.xlsx)(97 & onwards), Oracle, SQLServer, DB2, MySQL, PostgreSQL, FoxPro, dBase, R:BASE,Sybase, FileMaker Pro, Firebird & any ODBC Compliant Relational Database.
• Password protection for Profiles/Forms(SOHO/Enterprise Edition) & Application.
• Make a phone call for the selected field's numeric contents.
• Find and Find again option to search a record.
• Data is secured as 128 bit AES use for Encryption.
• Support Unicode language database such as Japanese/Chinese/German/ Russian etc.
• Transfer data to SD Card or Main memory.
• Supports Multi Record and Single Record View as default views for Database Profile on device.
• Supports Form: Design Custom user interface using simple and easy to use form builder interface.
• Design form on desktop with Label, TextBox, Button, Checkbox, Radio button, Combobox, DateTime, Page, Container, Location and Shape controls.
• Design a master/detail form or a parent/child form using subform control.
• Synchronize Image/Signature/PDF data with desktop database.
• Supports Time/Stamp feature to find when user update particular record.
• Supports Barcode Scan using inbuilt camera/External Bluetooth Barcode Scanner.
• Use Print functionality on forms.
• Create form in Portrait/Landscape mode
• Backup form design.
• Design reports layout on desktop and view Runtime generated reports using current content of Profile data on device.
Extra Features for SOHO/Enterprise Edition
• Set permissions for each users like Add/Edit/Delete records for each “Database Profile” and Sync Permissions to specify one way sync or both way sync to Control device side records updates capabilities for individual users.
• NFC Scan.
• Macro Programming feature.
• Graphs(Pie, Bar,Cluster,Stack,Area,Line).
Software has 10 days evaluation period.
User Guide:
http://www.cellica.com/AndroidCellicaDatabaseWiFiUserGuide.pdf
Purchase the full version software from the following link.
http://www.cellica.com/cellicadatabaseandroidWiFi.html
Quick steps for initial synchronization setting between desktop and device.
http://www.cellica.com/CellicaDatabase_Desktop_Android_SyncSettings.pdf
If you are using Firewall on your computer,please add port in Firewall from following path.
Control Panel-> Windows Firewall-> Exceptions(Tab)-> Here use "Add Port" button,you will get "Add a port" dialog.
Add whatever name you want to give this port information in "Name" Text field and Add "8585" in "Port number" text box.
Please confirm that "TCP" option is selected.
JimLewis
May 19, 2012 1:14:58 AM
Functionality of Desktop Component Restored 5/18/12: Have changed review of Cellica WiFi-only version to 5-STARS as Cellica has now revised its desktop app to work smoothly with Norton Internet Security 2012. In the update/reversion process, the specific settings for Samsung Galaxy Nexus (and the Galaxy Note) disappeared but choosing a device resolution of 800 x 1280 works well enough for me. Great app that gives me portable access to all my MS Access database and a choice of what tables, records, fields I want to work with on the go.
S
Apr 29, 2012 5:13:01 PM
Great app! Excellent support.
Paul
Mar 21, 2012 5:55:42 PM
Works very well, but unrefined App is good. Much better than handbase for Android. It's registered to a specific device, so forms are created for that resolution and in landscape OR portrait. They don't flip perfectly. App auto dials from phone fields, maps addresses, extensive field sorting, etc, etc. It has limits, but what it does it does well. It's an enterprise level app, not a toy. Customer service could be better.
Wilson
Feb 14, 2012 4:46:40 AM
One of the best database app... Synced more than 35000 records on my phone within minutes. Very fast. Barcode functionality is superb. Excellent app !!!
CST066
Feb 7, 2012 12:09:05 PM
Belongs In Beta Bought this software only to find out it is a mediocre application. They should put it back in Beta. The fields do not adjust when you use it in the landscape mode. The fields are too limited in size and will not allow the text to wrap. The real kicker was when it stopped syncing. I got shuffle back and forth between several tech support folks and then suddenly dropped. Don't waste your money here. My suggestion, go to HanDBase. At least it works and the fields are not as limited.
CandV
Jan 17, 2012 6:30:30 AM
Needs work The form editor works ok but needs heaps of refinement to make it useful on the latest devices. Data syncs very well
Rusty
Dec 12, 2011 6:19:44 PM
Why Does this app need dial out access to my phone? Uninstalling until I get a good answer.
David
Dec 7, 2011 6:03:05 PM
Nice! I created profiles for and synced 6 databases (MS Access and MS Excel) to my tablet in a matter of minutes. The syncing works perfectly and is very fast (one of the databases is over 50,000 records - it was very fast). The form editing program needs some work - the editor has a fixed window size despite more real estate being available. This makes it more difficult to create tablet-sized forms. Otherwise, very impressed so far.
CTEZ
Nov 14, 2011 6:18:08 AM
Learning curve too high. Takes too long to understand. No phone support for a $40 app??? Shame! GUI is an eye soar. Completely useless without several hours of trial & error.
Da Wei
Jun 13, 2011 9:01:50 PM
Not as simple to setup as non-WiFi version Asks for desktop's IP and port. IP is fine but port isnt something that is very clearly defined in any instructions. The default value of 8585 doesnt seem to work. Please help... The non-WiFi version though works like a charm and the only reason im looking to use the WiFi version is for instant sync. Three stars till helped.