Needed: Automated Database Integration

 It’s long been a truism that data is one of the key assets, if not the key asset, for an enterprise. Our recent conversations with customers are putting a new spin on this insight. They are telling us why database integration and automation are increasingly important to them to not only reduce costs, but to increase agility. Integration Requirements By integration we mean the ability to quickly and easily combine data from multiple source relational databases into one, or more, central databases while keeping the original databases intact. Such integration allows customers and suppliers to share production and parts information without the expense of implementing EDI. Field auditors at a federal agency are using our own DataPortal to easily share relational databases of audit records to give managers a cross-geography view of agency performance. An online retailer could use such integration to combine information from multiple suppliers and distributors into a single database so web customers can get an up-to-date view of stock on hand and ship dates. Much of this information is stored in relational databases. Our customers are telling us they need to integrate these databases without stripping out the table structures and table references that allow ad-hoc queries. They also need to retain the complex data types (anything from engineering change orders to marketing images) they store in relational platforms. Customers also need to be able to identify which database fields originated in which source database. Such tracking by the source of information is important for anything from identifying which supplier has the lowest prices or most inventory to identifying the source of cost or sales issues within multiple business units. Customers also tell us they need to perform this integration easily and quickly. Ideally, they’d like to see it automated. This not only reduces data management costs, but helps an organization respond with greater agility to changing business needs. For example, the more quickly a major aerospace manufacturer can see database information from new suppliers, the more quickly it can fill its needs for critical parts. The more quickly a CFO can see integrated cost and sales databases from various business units, the more quickly he can see and fix problems.  Our Solution Traditionally, database integration has required days, weeks or months of work by skilled database administrators using database management tools. These days, that is unfeasible both from a cost and a time perspective....

Read More

Six EDI Hassles You Never Have to Face Again

Six EDI Hassles You Never Have to Face Again

By Howard W. Sabrin, executive vice president. I recently got off a one hour call with an EDI (electronic data interchange) veteran, discussing his experiences with the venerable data sharing format. EDI has been around since the ‘60s, and for some purposes it’s absolutely the way to go. But hearing the questions this EDI user asked made me realize how much extra work EDI customers are doing, especially if all they need to do is share relational databases. Folks who’ve been using EDI for years may not realize how much of the work that costs extra time and dollars in EDI is handled automatically by relational databases. Here are six quick examples of EDI hassles you can avoid, without damage to your business, through direct database sharing. Converting data to a standardized EDI form on the sending end, and converting it back to a form the recipient’s systems can use. If you’re sharing relational databases, all both sides need to do is agree on a common database design (e.g. tables, columns, data types). Since all work is done within the database, there’s no need to get network, security, firewall, or software development staff involved. If any data must be pre- or post-processed, it can be done using standard database tools by your database staff. Avoiding duplicate entries and other data integrity issues. Database transaction processing capabilities prevents data from being written unless it can be written without error and repeat data writes until they are successful. Each data entry is tagged with a unique identifier set, preventing the same data from being entered repeatedly. No further coding or other work with specific EDI formats is required. Creating an audit trail to assure no loss or corruption of data. Using familiar database queries, the source and destination data can easily be compared to the last byte to assure integrity. Unlike EDI systems where transactions must be tracked through multiple components, the results of these simple queries serve as your audit trail. Integration with ERP and CRM systems. Since many of these systems are built on relational databases, business data from one partner’s database platform can be transferred directly and securely over the Web to another partner’s database. No integration or reformatting of data to match specific EDI formats work is required. Agreeing on, and implementing, common security protocols. DataPortal uses secure Web protocols (e.g. HTTPS) and has layers of password...

Read More

A Visual Explanation of DataPortal™ vs. EDI – Our Data Sharing Infographic

A Visual Explanation of DataPortal™ vs. EDI – Our Data Sharing Infographic

In the past, sharing complex data over the web in a quick and efficient manner was a daunting, and often times, overwhelming  process. Until now! We’ve developed an easy to use, web based software application that takes the stress, aggravation and expense out of sharing complex data over the web. Meet DataPortal™. To help demonstrate the simplicity of DataPortal™ and why it is the best solution for your data sharing needs, we’ve put together this amazing data sharing infographic that will walk you through the ins and outs of DataPortal™. We cover the basics from what sets DataPortal™ apart from other data sharing tools like EDI to how DataPortal™ works and who has has success with it. Scroll down to learn more » Embed This Image On Your Site (copy code below): Courtesy of:...

Read More

DataPortal vs. Traditional Database Replication

DataPortal vs. Traditional Database Replication

With the growth in complex global supply chains, the sharing of complex business data, often in the forms of relational databases, has become one of the most in-demand business needs over the last ten years. The desire for raw government and private sector data to be shared across multiple platforms has only increased since 2009, when President Obama put laws in place requiring the data be made public. While Obama’s bill does a great job in mandating the kinds of information that needs to be made public (contracts, audits, inspector general reports, etc.), it is rather vague with regard to details on how the information will need to be provided. According to experts John Wonderlich, Policy Director at the nonpartisan Sunlight Foundation and Jim Harper, Director of Information Policy Studies at the Cato Institute, in order to provide any value in the information being shared, the entire back end database needs to be shared. It is impossible for any person or organization to determine how others will use, analyze or cross-reference the data being provided so making the data, in its raw format (relational databases) available is essential. DataPortal helps companies meet this need with database sharing using cloud technology that is a vast improvement over traditional database replication. DataPortal provides instant and effortless data sharing over the web, allowing multiple recipients to receive the same full database by simply clicking on a URL. DataPortal also keeps data in standard database form and works across multiple vendors, platforms and operating systems. The tool also offers a more flexible and efficient alternative to traditional Electronic Data Interchange (EDI) by eliminating unnecessary conversion of data, as well as the costly set up involved with EDI. Data is transferred from a DataPortal server to any supported database system (including MS SQL Server, Access, Oracle, DB2, MySQL and Firebird) using a DataPortal client – either Applets, that do not require installation, or Applications, which must be installed but provide more features than the simple Applet client. How does DataPortal Differ from Traditional Database Replication? With traditional database replication, when data is updated at the source, it must ripple through all replicated databases before the update can take effect. This is time-consuming and can cause conflict if multiple updates are being conducted at the same time. With DataPortal, the data being updated is read and written directly to and from the database without the unnecessary...

Read More

DataPortal Eases Data Sharing Burden for Supply Chain Management

DataPortal Eases Data Sharing Burden for Supply Chain Management

When a major aerospace manufacturer needed help bringing new suppliers on board, it turned to DataPortal. This manufacturer works with hundreds of suppliers sourcing specialized components ranging from custom fasteners to sophisticated avionics.  In the fast-changing aviation industry, recruiting a cadre of suppliers who can meet demand quality specifications while ramping production quickly at the right price is critical for success. Yet this manufacturer was finding it difficult to even evaluate prospective suppliers, much less start doing business with them. Just sharing information about the details of future production plans and designs required each potential supplier to go through the lengthy and expensive process of implementing an electronic data interchange (EDI) system. As an attempt at more agile data sharing, the manufacturer started providing order data that could be viewed on Web pages. However, many orders involved thousands of items and Web page data could not readily be processed by business applications. The order data really needed to be delivered where it could be directly accessed by business applications – through sharing a relational database. The manufacturer, and we, thought there had to be an easier way for the supply chain to be managed. Our solution was an easy-to-use Web portal that would allow a potential or actual supplier to log in and easily see the manufacturer’s future orders. This portal provided data on both short-term needs as well as future, six-month forecasts to give all potential suppliers the widest view into the manufacturer’s needs. Our work with this customer was one of the first uses of DataPortal technology for sharing relational databases over the Web. Across industries, more and more trading partners are sharing more and more information – everything from production plans to engineering change orders to media files – outside of traditional EDI or ERP (enterprise resource planning) systems. In these days of just-in-time inventory, short product cycles and relentless cost pressures, they must share this data quickly and efficiently. Our DataPortal software enables secure, instant and effortless sharing of relational databases in their original, relational form across the Web. It’s as easy as sharing a URL, with no programming, configuration, firewall modification, data conversion or even client software installation required. The need to recruit new suppliers is only one of the use cases  DataPortal fills. It is, of course, just as useful for a specialized supplier who can meet a custom need for a global...

Read More