Java Microsoft Access Database
Java Microsoft Access Database
Microsoft Great Plains Integration Manager 10.0 Technical Notes
Microsoft Dynamics GP version 10.0 advanced such new technologies as eConnect in and this seems to be general trend to walk away from proprietary tools, such as Microsoft Dexterity to Microsoft specific platforms, such as .Net, COM+ and MS SQL Server Stored Procedures, as you know eConnect core contains encrypted stored procs. Historically Great Plains IM was based on OLE technology, where GP workstation was used as OLE server and business logic validation was done in GP forms, where OLE mechanism was entering fields values. Let’s take a look at new and traditional features available in IM version 10.0, it is in our opinion in transition to be rewritten completely in eConnect, but at this time it is available with both traditional and eConnect connectors:
1. eConnect connector. For GP consultants, you should be aware that eConnect connector requires specific company, if you remember how OLE connector works – it recognizes the company, from where you call Integration Manager and so you do not need to specify the company in integration settings. eConnect requires the company target to be specified. eConnect integration performance should be higher comparing to traditional connector, as eConnect doesn’t use slow OLE technology and imitates business logic (or in other words it replicates Dexterity functionality) in SQL stored procedures (which are performed on the server). Typical GP integrations involve Sales Order Processing module (this includes eCommerce scenarios) as well as Purchase Order Processing module (where you integrate EDI vendor invoices, for example) and at this time, GP IM 10.0 eConnect connector enables these integrations, which is very optimistic note
2. IM upgrade. Typical scenarios are when you are upgrading skipping two versions, let’s say from GP IM 7.5 to 10.0. In this scenario you need to do two steps upgrade – first to GP IM 9.0 and then to 10.0
3. VBA programming for Integration Manager. This technology may seem outdated as VBA was popular in late 1990th to automate MS Excel and MS Access type of scenarios. However VBA and Modifier modules are still available with Microsoft Dynamics GP purchase or upgrade. VBA scripting is event driven one, so you should review the options to alter IM business logic on pre and post integration, pre and post document. This article format is short and we can not give you sample VBA scripts here, however if you have development budget and would like to get advanced technical and programming help, we would be happy to assist you
4. GP IM advanced techniques. Translation technology. Each field is available for translation logic. You can load Excel translation table to IM directly. Translation logic allows you to map external item number id to your internal one, or in collection agency example it allows you to translate vendor it to customer id, as collection business is reversed one, where sales means collection
5. IM in cross platform integrations, here we need to stress ODBC standard and advanced integrations. Microsoft SQL Server 2000 and 2005 linked server construction allows you to deploy either direct SQL select statement or OPENROWSET one. Now is you are coming from Oracle and Oracle EBusiness Suite world, similar integration concept is available from Oracle EDI. If you are on Linux Red Hut and PHP and MySQL, please consider ODBC bridge or appeal to Java technology. If you PHP is sitting on MS Windows platform you can deploy direct call to MS SQL Server 2005 or 2000
6. GP data conversion and Integration Manager. Legacy data massage, conversion, is available and IM usage is very helpful. Microsoft Dynamics GP offers IM installation or initial migration license, which is limited to the number of days
7. The most popular Integration Tables in Great Plains: SOP10100, SOP10200, RM00101, RM00102
8. Integration Manager and Great Plains Dexterity connections: DEX_ROW_ID is one of the most popular questions among the developers community. If you do direct SQL insert statement feed into GP tables, DEX_ROW_ID is outoincremental and so you don’t need to populate it
9. GP and MS CRM connector. It is outside of GP IM, so please do not be confused. MS CRM connection business is pretty much taken over by Scribe Software, so please check with these folks first. Also, SAP Business One is very popular small business ERP and MRP (Manufacturing module and extensions) platform, where you can have Microsoft CRM to be integrated. From Microsoft Dynamics CRM side you can use SQL views and stored procedures to store exported data in the custom database, and from SB1 side you use Sap B1 SDK to program SB1 integrated objects: Sales Orders or Sales Invoices
10. XML Web Service Approach. As XML is in essence text, it is the platform independent data (or text files) stream. To open Web Service to UNIX client, from GP side you typically involve C3 or VB.Net developer
11. IM closing remarks. Great Plains Integration Manager is both end user and developer friendly tool. If you are VBA or Microsoft.Net programmer you should be able to build sound integration on IM platform. eConnect will more likely be the main IM transformation technology, so if you are deploying IM integrating techniques, you should follow eConnect news
About the Author
Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com - [email protected] 1-866-528-0577, 1-630-961-5918, serving customers USA/Canada nationwide: Illinois, California, New York, Quebec, Ontario, Colorado, Utah, Wisconsin, Florida, Texas. Local service is available in Houston & Dallas: Richmond, Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, Mission Bend, Jersey Village, Fort Worth; serving GP customers in Chicago, IL: Naperville, Aurora, Joliet, Wheaton, Bolingbrook, Romeoville, Lyons, Niles, Downers Grove, Lisle, West Chicago, Barrington, Schaumburg, Elk Grove Village, Lombard, Morris, Ottawa, Marseilles, Seneca, Oswego, Plainfield, Darien, Winchester, Hinsdale.
Anyone know of free database building software that is better than Microsoft Access?
I have built a little database for my company in access. I have done some programming in Java and C++, but I don't really want to build everything from scratch necessarily. Anyone know of a program where I can customize my own database that is better than access.
Even something like a Free POS or TPS system would be cool, I could use that for a project I am working on for a pizza shop with limited resources.
Two quick thoughts/suggestions...
If it's strictly a database tool you're looking for, my suggestion would be mySQL. It's free, and one of the most commonly used (and easy to use) databases in use today. If however you are looking for an end to end solution that does both the front end and back end work for you, I would suggest FileMaker Pro. It will also allow you to import any data you may already have in your current access db.
Good luck.
Java Microsoft Access Database
JAVA to MS Access Connection (JDBC-ODBC bridge)
Robust solutions for your enterprise
Database driven web applications have redefined internet in the past decade. Gone are the days when websites comprised of static content running on HTML which had no dynamic interaction with the users.
With the emergence of dynamic web based applications, end user interaction with Access development was launched to an altogether different level. Be it providing up to date news, or to marketing your product, or to run an online poll – Dynamic web applications are a solution.
The reason Database driven web applications grabbed popularity is as follows:
- Database driven web applications do not run on the client side making them
- significantly light weight relative to heavy client side applications.
- Database driven web applications can be managed and controlled from a
- single central unit making them easier to run and maintain.
- Database driven web applications are more cost effective.
- Database driven web applications have a higher degree of penetration due to massive internet user base.
Apart from the ones mentioned above, there are countless other reasons which make Database driven web applications this revolutionary.
Success of Database driven web applications also meant more and more people and technologies got focussed towards it. While in its early days, Database driven web applications were built on top of open systems like Java or Microsoft related technologies. This meant a whole lot of code to be written to control the behaviour of an application. As time passed by frameworks like Struts came in which had a lot of regular and common controller code already encapsulated it which could be customized through configuration changes.
However all this while a lot of developer focus was going into redundant tasks that were common for all applications. This brought about a major change called code generation. Visionaries soon realized that the best way to increase productivity and gains was through code generation. Companies came up with products that could build web applications simply by click of button.
One such product that created a revolution in the field of code generation and Database driven web applications development is Alpha Five from Alpha software. Using Alpha software set of tools, developers can develop powerful and dynamic, Database driven web applications without any coding. Alpha five can have the developers connect to a variety of databases including Microsoft Access Database and Oracle.
About the Author
I am The webmaster at www.alphasoftware.com -- An database management company, Our goal at Alpha Software is to provide you with exceptional software along with outstanding customer service. If you have any questions, suggestions, comments or issues with your experience here, please tell us.
Java Microsoft Access Database
