Skip to content

Software Development News: .NET, Java, PHP, Ruby, Agile, Databases, SOA, JavaScript, Open Source

Methods & Tools

Subscribe to Methods & Tools
if you are not afraid to read more than one page to be a smarter software developer, software tester or project manager!

Database

Implement InfoSphere Data Replication for Sybase with a remote database server

IBM - DB2 and Informix Articles - Thu, 03/26/2015 - 05:00
This tutorial explains how to implement InfoSphere Data Replication for Sybase with a remote database server, in an easy step-by-step manner.
Categories: Database

PostgreSQL Data Sync 15.3 released

PostgreSQL News - Thu, 03/26/2015 - 01:00

SQL Maestro Group announces the release of PostgreSQL Data Sync 15.3, a powerful and easy-to-use tool for PostgreSQL database contents comparison and synchronization.

The new version is immediately available at
http://www.sqlmaestro.com/products/postgresql/datasync/.

Top 5 new features:
  1. An ability to select or disable certain synchronization operations (Insert, Update, and Delete) has been implemented. The corresponding command line switches have been added as well.
  2. Now it is possible to specify SQL scripts to be executed before and/or after synchronizing data of each table.
  3. Synchronization script file name and log file name are now stored in the project file. These settings can be overwritten with the appropriate command line options.
  4. The first page of the wizard has been redesigned in order to provide more comfortable access to recently opened projects and display the latest company news.
  5. The progress windows are redesigned in the modern style and become more informative.

There are also some other useful things. Full press release is available at the SQL Maestro Group website.

Categories: Database, Open Source

Primavera Launches Project Portfolio Management Cloud Services Accelerators for Financial Services, Public Sector, and Engineering and Construction Industries

Oracle Database News - Wed, 03/25/2015 - 13:12
Primavera Launches Project Portfolio Management Cloud Services Accelerators for Financial Services, Public Sector, and Engineering and Construction IndustriesOracle’s new accelerators enable organizations to manage the lifecycle of initiatives, projects, programs, and contracts using rich functional capabilities, built-in industry best practices, and the power of the cloud
ORACLE INDUSTRY CONNECT – Washington DC – March 25, 2015

Organizations across industries are managing unprecedented change, whether due to increasing regulations, shifting competitive environments, or the need to constantly innovate. And these companies all have two things in common—any transformation must happen quickly, and the solutions deployed must be finely tuned to match how they work. In response to this need, Oracle has launched three new cloud services accelerators for enterprise project portfolio management (EPPM) in the financial services, public sector, and engineering and construction industries. Combining the proven history of Oracle’s Primavera products with Oracle’s cloud expertise, these purpose-built accelerators enable organizations to effectively address the challenges associated with managing project, program, portfolio, and contract lifecycles in their respective industries.

“Gone are the days of one-size-fits-all project and contract management tools. Our customers need cloud-based, specialized solutions that fit how they do business, get them up and running quickly with industry best practices, and provide the flexibility and power to change and grow with their needs. That’s why we have launched these three process- and industry-specific accelerators. With this announcement, we are looking to the cloud as the catalyst that will enable our customers to use EPPM to transform their organizations at the speed that they demand,” said Mike Sicilia, senior vice president and general manager, Primavera Global Business Unit, Oracle.

The three new cloud services accelerators include:

Oracle Business Process Portfolio Management Cloud Accelerator: To support financial institutions’ business transformation, continuous process improvement, and regulatory compliance change management, this accelerator provides end-to-end functionalities for managing, tracking, and executing service innovation initiatives, operational projects, and process changes across the enterprise. It complements the analytics capabilities of governance, risk, and compliance applications such as Oracle Financial Services Operational Risk, creating a comprehensive change management solution for the financial services industry.
Oracle Public Infrastructure Monitoring Cloud Accelerator: Governments at all levels are investing in infrastructure projects to improve quality of life for constituents while also reducing waste and improving efficiencies. To best manage these complex undertakings, this accelerator provides top-down project planning and bottom-up monitoring, enhancing the effectiveness of infrastructure changes for any type of government management—from federated to centralized. Oracle Contract Management Cloud Accelerator: In the engineering and construction business, projects are a team effort—contractors and owner organizations need to coordinate and collaborate to control contract management and keep costs in line with project expectations. This accelerator provides these organizations with preconfigured, flexible rules and processes, enabling them to quickly start managing contracts and controlling change throughout the project lifecycle with a system that allows for future business growth and expanded requirements.

At Oracle Industry Connect in Washington DC, these accelerators will be on display and discussed in the conference’s Primavera track, which begins with a keynote on Wednesday, March 25, from 3:45 p.m. to 5:45 p.m.


Additional Information

To learn more about Oracle’s Primavera solutions, connect on Twitter at @OracleEPPM and on Facebook at facebook.com/oracleprimavera.

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit oracle.com.

Trademark

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Contacts:

Kaitlin McCready
Oracle
+1.216.925.5972
kaitlin.mccready@oracle.com

Liz Vandendriessche
O’Keeffe & Company
+1.443.223.3378
evandendriessche@okco.com

Categories: Database, Vendor

Oracle Introduces Oracle’s MICROS Workstation 6 Point-of-Service Terminal

Oracle Database News - Wed, 03/25/2015 - 13:11
Press Release Oracle Introduces Oracle’s MICROS Workstation 6 Point-of-Service Terminal Sleek workstation design and superior reliability enhance staff and guest experiences

ORACLE INDUSTRY CONNECT, WASHINGTON DC—Mar 25, 2015

News Summary

As hotels and restaurants employ mobile, social, and informational tools to connect with guests, they require a new type of “engagement” device at the point of service (POS). To meet this need, Oracle today introduced Oracle’s MICROS Workstation 6 with a fresh, modern design that provides hospitality and select retail venues with a next-generation POS terminal that works in concert with mobile, cloud, and social media to deliver consistent, integrated content across multiple sources.

Learn More

Customer Testimonials

Learn More

For hospitality businesses, Oracle’s MICROS Workstation 6 is part of an integrated strategy built around content delivery, moving well beyond transactions to offer guest recommendations, roll out special promotions, and personalize the guest experience. The workstation is a single engagement device that shares digital content from a variety of sources with both staff members and guests, from sharing a training video with a new worker to helping a guest view a spa package or menu special being offered.

Building upon a deep industry hardware legacy, Oracle’s MICROS Workstation 6 incorporates the design elements of mobile POS hardware to deliver an elegant, stationary engagement device with an attractive finish and small footprint. The ergonomic, all-in-one design minimizes the visual obstruction between guest and staff, while a 15.6-inch-wide HD touchscreen enables a beautifully rich, horizontal information format. The mount allows staff to adjust the screen angle or swivel it around for a guest to view.

The new terminal also expands the integrated family of Oracle’s MICROS engagement devices, which includes Oracle’s MICROS R-Series Tablet and Oracle’s MICROS E-Series Tablet in 8-inch and 11-inch versions. With an intuitive user interface and similar look and feel, Oracle’s MICROS Workstation 6 helps employees move seamlessly between tablet and workstation.

Oracle’s MICROS Workstation 6 operates the Microsoft Windows Embedded 8.1 Industry Pro system and runs the latest Intel Atom processor for high performance and low thermal output. A modular, integrated, three-track magnetic card reader allows for 3DES or AES encryption upon swiping. In addition, Oracle’s MICROS Workstation 6 includes six USB ports, allowing users to attach peripherals such as printers, scanners, and cash drawers.

Like legacy MICROS hardware, the new workstation is designed to stand up to harsh, often unpredictable service environments and operates in a wide range of temperatures. It features a spill- and impact-resistant enclosure that can withstand the day-to-day abuse common in the hospitality and retail industries. With no moving parts, the workstation is designed for long-lasting durability.

The new terminal leverages select Oracle Hospitality and Oracle Retail applications to provide a fluid, intuitive touchscreen experience and minimize the learning curve for new employees. Oracle software and hardware is engineered to work together so implementation is simple and seamless.

Backed by Oracle’s industry-leading technology, service, and support, Oracle’s MICROS Workstation 6 provides adaptability to changing operational requirements and access to the latest technology. As part of the Oracle portfolio of hardware, software, and related services including cloud solutions, the terminal builds upon Oracle’s commitment to providing solutions that optimize business processes and offer guests superior service and experience through connected technology.

  • “Oracle’s MICROS Workstation 6 gives us a more modern look and intuitive user interface that supports hotel and restaurant staff at the point of service,” said John Huddle, director of Information Technology at Silver Diner, the iconic American restaurant chain. “We believe Oracle’s MICROS product delivers a better overall guest experience while providing us with a durable and flexible long-term solution.”

    “Technology continues to reshape the hospitality industry and allows a renewed focus on the guest. The design of Oracle’s MICROS Workstation 6 leverages new, modern technologies to help improve guest transactions, streamline business operations, and enhance guest loyalty,” said Ray Carlin, vice president, Strategy and Solutions Management, Oracle Hospitality. “The next-generation point-of-service terminal is a guest engagement device that is feature rich, elegant, and integrated with mobile, as well as exceptionally reliable and durable.”

  • Additional customers using Oracle Hospitality solutions tell their stories here
Contact Info Katie Barron
Oracle
+1.202.904.1138
katie.barron@oracle.com Angela Seutter
Amodeo Associates
+1.612.280.1493
seutter.angela@gmail.com About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit http://www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Katie Barron

  • +1.202.904.1138

Angela Seutter

  • +1.612.280.1493

Follow Oracle Corporate

Categories: Database, Vendor

New Oracle Consumer Study Challenges Retailers to Adapt to Modern Retail Marketplace

Oracle Database News - Wed, 03/25/2015 - 13:10
Press Release New Oracle Consumer Study Challenges Retailers to Adapt to Modern Retail Marketplace

Oracle Industry Connect, Washington DC—Mar 25, 2015

Enabled by technological advances, today’s consumers are reaching across borders and channels for shopping experiences that provide unprecedented choice and convenience. A new consumer research report, “Retail Without Limits - A Modern Commercial Society,” explores how a technology-powered “invisible hand” has transformed the retail environment and reveals lessons for retailers as they adapt to this new, nearly limitless retail marketplace.

Retail Without Limits

Find out what 5,000 consumers from around the world want from retailers.

Read the report

The report, issued today, is the result of a survey of 500 participants from each of 10 countries—Australia, Brazil, China, France, Germany, India, Japan, Russia, the UK, and the US. Findings reveal that consumers across the world are driven by convenience and want a converged commerce experience, in which retailers combine the best of digital and in-person resources.

What sets retailers apart in a global marketplace is giving shoppers better information where and when they need it. 70 percent of global respondents say that the best way retailers can add value to their shopping experience is to provide easy access to information about products and services online and in stores. Consumers’ demand for transparency and access transcends formats and borders. More than two-thirds of global consumers say that they are using smartphones to browse or buy products, and 56 percent have purchased direct from offshore international retailers.

“Consumers are enjoying an expanding global marketplace, and they are shopping it with the nearest mobile device,” said Jill Puleri, senior vice president and general manager, Oracle Retail. “As retailers embrace this new global, mobile consumer they must also maintain profitability and lay the foundation for ongoing change.”

Retailers Must Learn, Adapt, and Execute

The study highlights that there are opportunities for retailers to differentiate themselves and win customers through better in-store experiences, more-effective mobile strategies, and increased access to information regarding inventory and pricing. Key findings are broken into the following categories:

The Convergence of Commerce: 83 percent of global respondents want retailers to invest in technology, and 57 percent of these stated that converged commerce was key. In China and Germany, this figure rises to 78 percent and 70 percent respectively.

Demand for Transparency: This outstrips any other consumer requirement in terms of adding value to an experience (70 percent). Access to product information across digital channels or in-store is also rated highly by global respondents (59 percent).

Mobile, Apps, Social: Mobile is the fastest growing method of shopping globally, with over two thirds of consumers (67 percent) stating they are using smartphones to enhance their shopping experiences.

The Global Opportunity: Over half (56 percent) of global respondents have bought goods from an offshore international retailer, with only the US (39 percent), Japan (41 percent) and the UK (43 percent) falling below the global average.

The Privacy Conflict: 56 percent of consumers say they recognize that giving retailers access to information can improve their shopping experience, but retailers need to move cautiously and build trust, because 55 percent of consumers have reservations or disagree with retailers having access to personal information. 23 percent are happy to download an app that allows retailers to track their movements in store and online.

Differentiate With Your Store: Stores are increasingly involved in online orders; the report shows that the percentage of consumers who buy goods online and collect them continues to rise. However, globally, 44 percent of consumers still prefer to shop in-store and take items home, most notably in Australia (69 percent), followed by Germany (57 percent), France (54 percent), the US (50 percent) and Russia (45 percent). Consumers still love at-home delivery, and 34 percent listed buying online with home delivery as their favorite way to shop.

“The consumer is driving the agenda, Oracle is in a unique position to support the new fundamentals of converged retail – right product, right place, right time, right price—anywhere,” said Puleri.

Retail Without Limits—A Modern Commercial Society

Oracle commissioned the study with Redshift Research in January 2015 to explore the expectations and habits of 5,000 adult shoppers via its online consumer panel.

Oracle will continue to release country-specific results relevant to local market segments.

Contact Info Greg Lunsford
Oracle
+1.650.506.6523
greg.lunsford@oracle.com Mary Ellen Amodeo
Amodeo Associates
+1.612.963.5797
meamodeo@gmail.com About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit http://www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Learn More Oracle RetailSubscribe to the Oracle Retail Community Talk to a Press Contact

Greg Lunsford

  • +1.650.506.6523

Mary Ellen Amodeo

  • +1.612.963.5797

Follow

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Communications Advances Network Function Virtualization by Delivering Carrier-Grade Data Center Performance

Oracle Database News - Wed, 03/25/2015 - 13:09
Oracle Communications Advances Network Function Virtualization by Delivering Carrier-Grade Data Center PerformanceWith an industry-first for Enhanced Platform Awareness resource optimization, Oracle Communications collaborates with Intel to demonstrate end-to-end service and network function orchestrationORACLE INDUSTRY CONNECT – Washington DC – March 25, 2015

In a move to transform their networks, many communications service providers (CSPs) are starting to transition from their traditional appliance-based network functions to a virtualized, software-based model—also known as network function virtualization (NFV). The promise of this approach is more service agility and lower operational costs. But virtualization had yet to prove that it can deliver the same network speed and reliability performance provided by traditional network appliances—until now. Working with Intel and leveraging Enhanced Platform Awareness in OpenStack, Oracle Communications has delivered the industry’s first successful demonstration of carrier-grade network performance in a virtualized environment.

The project, led by Oracle and using the Intel® Open Network Platform (ONP), demonstrates that CSPs can realize more of the promise of NFV. Specifically, the initiative proves that by intelligently directing network activity to the Intel® processor, CSPs will have more capabilities in software that were previously limited to hardware. In turn, this means that CSPs could maintain service quality levels and develop new offers for customers as soon as CSPs begin to migrate their network functions to the data center.

“This initiative does more than just optimize Oracle Communications products for the Intel® Open Network Platform,” said Liam Maxwell, vice president of products for Oracle Communications. “It takes the theory of delivering carrier-grade capabilities in a commercial data center and turns it into reality. We’ve proven that we can orchestrate services and network functions from the top of the management and orchestration (MANO) stack all the way to individual network processors, and we can do it at scale.”

“The Intel® Open Network Platform server combines industry-leading server architecture with open source software to enable quicker delivery of NFV solutions. Our work with Oracle demonstrates how a powerful server can act as the catalyst for end-to-end NFV orchestration,” said John Healy, general manager, Software Defined Networking Division, Network Platforms Group, Intel Corporation.

For this initiative, Oracle Communications optimized specific products for the Intel ONP using OpenStack open source infrastructure management software and its Enhanced Platform Awareness capabilities. The optimized products are part of Oracle’s orchestration framework, including Oracle Communications Network Service Orchestration Solution. By directing the Intel platform to dynamically establish data center resource pools that mimic the specialized characteristics of a network appliance (such as large memory pages), the orchestration software can then route the work to the correct pool, based on each function’s unique needs. Moreover, this orchestration activity can work for any network equipment vendor’s interface, preserving the CSP community’s requirement to support multi-vendor environments. Oracle and Intel contribute to and support the widely accepted OpenStack initiative.

The project highlights the importance of orchestrating network functions at the processor-attribute level. In this scenario, Oracle Communications solutions optimize performance of the Intel XeonTM E5-2600 v3 processor, which is built specifically for networking requirements. The platform offers NFV software adaptability for network functions, while meeting the performance and reliability found in network appliances.

“NFV resource orchestrators need awareness of infrastructure inventory and capability as well as network function requirements in order to match the two for optimal cost and performance. Oracle and Intel have achieved noteworthy platform awareness with this project. Intel contributed broadly to the OpenStack Enhanced Platform Awareness Initiative, and now Oracle is the first to actually harness this capability as a function of its intelligent orchestration framework,” said Dana Cooperson, research director, head of Telecoms Virtualization Research, Analysys Mason.

The Oracle Communications Network Service Orchestration Solution with Enhanced Platform Awareness using the Intel ONP will be on display at Oracle Industry Connect 2015, March 25 through 26, in Washington DC. Executive keynote speakers from Intel will address the value of the open industry collaboration on Wednesday, March 25, at 3:45 p.m., along with a panel discussion on Enhanced Platform Awareness on Thursday, March 26, from 10:45 to 11:30 a.m. in the Oracle Communications track at this collaborative, cross-industry event.


Additional Information

To learn more about Oracle Communications in network function virtualization and other Oracle Communications solutions, please connect on Twitter @OracleComms and on facebook.com/oraclecommunications..

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit oracle.com.

Trademark

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Intel and Xeon are registered trademarks of Intel Corporation in the United States and other countries. OpenStack is a registered trademark of the OpenStack Foundation. Other names may be trademarks of their respective owners.

Contacts:

Kaitlin McCready
Oracle
+1.216.925.5972
kaitlin.mccready@oracle.com

Lisa Fisher
O’Keeffe & Company
+1.703.883.9000, x156
lfisher@okco.com

Categories: Database, Vendor

Genie Retail Energy Improves Operations and Increases Efficiency with Oracle Utilities Load Profiling and Settlement

Oracle Database News - Wed, 03/25/2015 - 13:09
Genie Retail Energy Improves Operations and Increases Efficiency with Oracle Utilities Load Profiling and Settlement

ORACLE INDUSTRY CONNECT, WASHINGTON DC—March 25, 2015— Oracle today announced that Genie Retail Energy (GRE), a leading retail utility serving more than 360,000 electric and natural gas meters in six states, has deployed Oracle Utilities Load Profiling and Settlement with PowerRunner’s fully integrated FORrunner Forecasting Analytics accelerator as a physical and financial data aggregation solution to more efficiently validate, edit, and estimate usage data to forecast and settle with market operators. This solution provides GRE with an automated, in-house, microforecasting solution across multiple electricity and natural gas market segments.

GRE forecasts its own energy requirements, and the limitations of its legacy system forced it to manage some territories outside of its incumbent forecasting network, which proved to be time-consuming and inefficient.

With Oracle Utilities Load Profiling and Settlement and FORrunner in place, GRE can efficiently and securely forecast demand and settlement. Additionally, the solution provides GRE with a forecasting platform that can support its expansion into new energy market segments and products. The Oracle and PowerRunner solution is now integrated with GRE’s customer information system (CIS) and other IT systems, enabling the company to implement the appropriate PowerRunner modules to quickly create highly accurate forecasts when entering a new utility territory.

“By replacing our inefficient legacy system with Oracle Utilities Load Profiling and Settlement with PowerRunner, we have significantly improved our operational productivity. Our forecasting processes now run very smoothly, and we look forward to realizing additional efficiencies in the future,” said Terrence Stronz, chief financial officer, Genie Retail Energy.

“With Oracle Utilities Load Profiling and Settlement in place, GRE now has access to the market-leading, fastest, most-accurate aggregator of consumption and financial data available, ultimately enabling it to improve its forecasting processes,” said Rodger Smith, senior vice president and general manager, Oracle Utilities.

Additional Information

To learn more about Oracle Utilities, follow @OracleUtilities on Twitter and join the Oracle Utilities community on Facebook.

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Contact Info

Samantha Thai
Oracle
+1.510.917.5564
samantha.thai@oracle.com

Lacy Cooper
O’Keeffe & Company
+1.540.364.5913
lcooper@okco.com

Categories: Database, Vendor

We Energies Deploys Oracle DataRaker to Enhance Customer Service, Improve Operational Efficiency, and Reduce Costs

Oracle Database News - Wed, 03/25/2015 - 13:08
We Energies Deploys Oracle DataRaker to Enhance Customer Service, Improve Operational Efficiency, and Reduce Costs

ORACLE INDUSTRY CONNECT, WASHINGTON DC—March 25, 2015— We Energies—which provides electrical service to areas of Wisconsin and Michigan’s Upper Peninsula, and natural gas and steam energy to areas of Wisconsin—is committed to ensuring the highest levels of customer satisfaction. After undertaking the rollout of a mass fixed automated meter reading (AMR) network that will provide daily reads on approximately 1.6 million endpoints, the utility deployed Oracle DataRaker to update its IT infrastructure and to help enable more-proactive identification and prevention of imprecise meter readings for an overall improved meter-to-bill process.

With Oracle DataRaker in place, We Energies reduced its break-to-fix time by using data analytics to quickly find metering issues and prioritize meter repairs.

“Using data analytics was a game changer for how we approach our work and allowed us to gain the greatest possible benefit from our metering investments. We increased efficiency, improved customer satisfaction, and avoided IT costs,” said Joan Shafer, senior vice president, Customer Services, We Energies.

“After undertaking its fixed AMR network rollout, We Energies wanted to ensure improved customer service. With Oracle DataRaker, the utility improved its meter-to-bill department processes by reducing costs and delays in identifying meter issues,” said Rodger Smith, senior vice president and general manager, Oracle Utilities.

Additional Information

To learn more about Oracle Utilities, follow @OracleUtilities on Twitter and join the Oracle Utilities community on Facebook. Learn more about We Energy by reading the company’s customer success story.

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Contact Info

Samantha Thai
Oracle
+1.510.917.5564
samantha.thai@oracle.com

Lacy Cooper
O’Keeffe & Company
+1.540.364.5913
lcooper@okco.com

Categories: Database, Vendor

Dombivli Nagari Sahakari Bank Chooses Oracle FLEXCUBE as its Core Banking Solution

Oracle Database News - Wed, 03/25/2015 - 13:06
Press Release Dombivli Nagari Sahakari Bank Chooses Oracle FLEXCUBE as its Core Banking Solution Leading Cooperative Bank in India to transform operations and improve customer experience with Oracle FLEXCUBE Universal Banking

ORACLE INDUSTRY CONNECT, WASHINGTON DC—Mar 25, 2015

Dombivli Nagari Sahakari Bank Ltd. (DNS Bank), one of the leading scheduled urban cooperative banks in India, has chosen Oracle FLEXCUBE Universal Banking to transform its banking operations. The deal was finalized in May, 2014, and DNS Bank expects to go live with a state-of-the-art system in 2015. With 42 branches spread across 13 districts of Maharashtra and a business mix of Rs 5,500 crore, DNS Bank has a plan to grow to more than Rs 15,000 crore with more than 100 branches by 2019.

By implementing a new-generation core banking solution based on Oracle FLEXCUBE, DNS Bank plans to optimize its operational efficiency, profitability, and growth. With Oracle FLEXCUBE, DNS Bank hopes to provide superior customer experience, faster delivery of new and agile products and services and secure, feature-rich banking channels such as mobile and internet banking. Oracle FLEXCUBE will provide DNS Bank with the ability to improve business intelligence and decision support, provide better cross-sell and up-sell opportunities and reduce operating costs with ease of IT management.

“We congratulate DNS Bank in taking this step ahead toward a greater customer centricity through technology. We are excited to work with the bank and to showcase Oracle FLEXCUBE’s capability to address the cooperative bank sector. With more than 500 institutions using Oracle FLEXCUBE across the world, we have proven our capability to meet the benchmarks of different banking segments, showcasing true flexibility and ability to execute successful transformations,” said Chet Kamat, senior vice president, Oracle Financial Services.

DNS Bank is the first cooperative bank in India to implement Oracle FLEXCUBE, replacing the bank’s existing legacy system. By taking advantage of FLEXCUBE’s module-based system , transaction-processing capabilities and process framework, DNS Bank will have the ability to standardize its operations, create a robust service-oriented architecture and to process a large number of transactions with high availability.

“DNS Bank believes that with technology, we can offer differentiated and customized services to our customers. Changing our core system to a modern core banking system such as Oracle FLEXCUBE is a huge step ahead in our evolution. We are pleased with the functionality that Oracle FLEXCUBE delivers, its modern architecture, and its adaptability to the requirements of a cooperative business model such as ours,” said Uday Karve, chairman, DNS Bank.

Contact Info Valerie Beaudett
Oracle
+1 650.400.7833
valerie.beaudett@oracle.com Mary Tobin
O'Keeffe and Company
+1.503.658.7396
mtobin@okco.com About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit http://www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Get Started Learn more about Oracle Financial Services and Oracle FLEXCUBE Retail Banking Talk to a Press Contact

Valerie Beaudett

  • +1 650.400.7833

Mary Tobin

  • +1.503.658.7396

Follow Oracle Corporate

Categories: Database, Vendor

Debub Global Bank Deploys Oracle FLEXCUBE Universal Banking to Underpin Ambitious Expansion Plans

Oracle Database News - Wed, 03/25/2015 - 13:05
Press Release Debub Global Bank Deploys Oracle FLEXCUBE Universal Banking to Underpin Ambitious Expansion Plans Ethiopian bank adopts Oracle core banking with Oracle’s SPARC servers and Oracle’s StorageTek tape and SAN storage to support cross-channel ‘Anywhere Any Branch’ strategy

ORACLE INDUSTRY CONNECT, WASHINGTON DC—Mar 25, 2015

Recently established Debub Global Bank (DGB) has become the latest bank in Africa to select Oracle solutions to underpin their expansion plans. The bank will be deploying Oracle FLEXCUBE Universal Banking, Oracle’s SPARC T5-2 server, and Oracle’s StorageTek storage solutions" to achieve its vision of becoming best-in-class within Africa’s banking industry. The hardware and software solution provides the foundation on which DGB can roll out its “Anywhere, Any Branch” cross-channel strategy.

“With one of the fastest growing economies in Africa and the entry of ambitious players such as Debub Global Bank into the finance sector, Ethiopia has the potential to become established as a leading financial center in the region,” said Sonny Singh, senior vice president and general manager, Oracle Financial Services. “By running Oracle FLEXCUBE on Oracle servers with Oracle StorageTek tape and SAN storage, DGB has a strong, scalable foundation to support its expansion plans and execute its ‘Anywhere, Any Branch’ strategy across channels.”

With Oracle FLEXCUBE, DGB will benefit from consolidated customer and product details across all banking departments. The combination of Oracle FLEXCUBE software with Oracle hardware will help the bank protect its data, reduce its operational costs and improve time to market as well as deliver a better customer experience with anywhere, anytime banking. Additionally, Oracle Solaris is ideally suited for the banking industry, with security features designed to easily meet and document compliance with industry standards obligations. Oracle FLEXCUBE supports payments, retail, small and medium-size enterprise loans, trade finance, and treasury offerings.

As part of the rollout, Oracle Consulting Services and BFSI Consulting, a Gold level member of the Oracle PartnerNetwork, will assist DGB with its implementation.

"We now have a scalable and reliable foundation to realize our vision of becoming a best-in-class bank in Africa,” said Aman Semir, IT director and CBS project manager, Debub Global Bank S.C. “Debub Global Bank has transformed its legacy platform to improve the customer experience with faster time to market of new, tailored product offerings and drive exponential customer growth. Oracle’s products will continue to serve as the backbone of our bank’s IT infrastructure and system solutions.”

  • Follow @OracleFS on Twitter, join the Oracle Financial Services Facebook community, or read the Oracle Financial Services blog.  To learn more about Oracle Hardware join the Oracle Hardware Facebook community or read the Oracle Hardware blog.  
Contact Info Valerie Beaudett
Oracle
+1 650.400.7833
valerie.beaudett@oracle.com Mary Tobin
O'Keeffe and Company
+1.503.658.7396
mtobin@okco.com About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit http://www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Get Started Learn more about Oracle FLEXCUBE Talk to a Press Contact

Valerie Beaudett

  • +1 650.400.7833

Mary Tobin

  • +1.503.658.7396

Follow

Follow Oracle Corporate

Categories: Database, Vendor

Alliance for Clinical Trials in Oncology Foundation Selects Oracle Health Sciences Cloud Solutions as the IT Platform for Its 10-Year Clinical Study

Oracle Database News - Wed, 03/25/2015 - 13:01
Alliance for Clinical Trials in Oncology Foundation Selects Oracle Health Sciences Cloud Solutions as the IT Platform for Its 10-Year Clinical Study

ORACLE INDUSTRY CONNECT, WASHINGTON DC—March 25, 2015—Alliance for Clinical Trials in Oncology Foundation, a nonprofit organization that supports the mission to reduce the impact of cancer, has selected Oracle’s Siebel Clinical Trial Management System and Oracle Health Sciences IRT as the IT platform for a comprehensive, 10-year clinical study, conducted in partnership with a tier-one pharmaceutical company and sponsored by Alliance Foundation Trials (AFT). The solutions will provide a proven platform for the decade-long study as well as future Alliance research initiatives.

“As part of our mission to reduce the impact of cancer, it is imperative that our clinical trials run as successfully and efficiently as possible. Going into a 10-year study, we need a proven, enterprise-scale clinical trial management infrastructure that we can count on today and into the future,” said Monica M. Bertagnolli MD, president, Alliance for Clinical Trials in Oncology Foundation and chief executive officer, AFT. “Oracle Health Sciences applications provided a competitive solution.”

Siebel Clinical Trial Management System will help AFT ensure the efficiency and integrity of its studies, reducing risk while boosting research team productivity. The organization plans to create a centralized trial management database that provides users with the most relevant information based on their specific roles and responsibilities and is designed to speed access to critical data, improve monitoring and patient safety, and keep data secure. Users can also access the system via any browser from any device, further elevating productivity and the user experience.

The deployment of Oracle Health Sciences IRT is designed to enable AFT to more effectively manage patient randomization and global supply chains by extending interactive voice response (IVR) and interactive web response (IWR) systems. AFT also expects to gain the insight needed to change study parameters midstream while reducing service delivery and change-order costs, and looks to optimize the cost of event charges by leveraging the web in addition to the phone for capture.

AFT will benefit from the scalability, cost-effectiveness, and rapid deployment that cloud-based solutions deliver. It plans to leverage Oracle Health Sciences Cloud for Oracle Health Sciences IRT and a third-party cloud service provider for Siebel Clinical Trial Management System.

“Oracle is pleased to support AFT as it embarks on this important 10-year research study. Oracle Health Sciences solutions provide a highly reliable foundation that helps to drive efficient, effective, and insightful research. Our flexible cloud-based delivery options are designed to help AFT achieve faster time to deployment, lower cost of entry, and ready scalability when needed,” said Steve Rosenberg, senior vice president and general manager, Oracle Health Sciences.

Additional Information

Join the Oracle Health Sciences community on Facebook and follow @OracleHealthSci on Twitter.

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit oracle.com.

About Alliance for Clinical Trials in Oncology Foundation

Alliance for Clinical Trials in Oncology Foundation raises funds to help Alliance for Clinical Trials in Oncology (part of the National Cancer Institute’s National Clinical Trials Network) answer important treatment questions through large-scale clinical trials. The foundation also conducts research in breast, lung, prostate, and bladder cancer that is supported by nonfederal sources through the limited liability entity Alliance Foundation Trials, LLC (AFT). Learn more about the Alliance.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Contact Info

Samantha Thai
Oracle
+1.510.917.5564
samantha.thai@oracle.com

Mary Tobin
O’Keeffe & Company
+1.503.658.7396
mtobin@okco.com

Categories: Database, Vendor

Boise State University Selects Oracle ERP Cloud to Transform Financial Processes and Reduce IT Complexity

Oracle Database News - Wed, 03/25/2015 - 06:16

Oracle, The World's Largest Enterprise Software CompanyPress Release

Boise State University Selects Oracle ERP Cloud to Transform Financial Processes and Reduce IT Complexity

Cloud-based enterprise resource planning solution will help university modernize systems, enhance user experience, and deliver scalability to support future growth

ORACLE INDUSTRY CONNECT, WASHINGTON DC — March 25, 2015 Oracle today announced that Boise State University, a public research institution located in Boise, Idaho, selected Oracle Enterprise Resource Planning Cloud (Oracle ERP Cloud) to transform core financial processes and gain new agility to advance educational opportunities. By selecting Oracle’s cloud-based solution, the university will also eliminate the initial and ongoing costs of purchasing, building out, and modernizing hardware infrastructure—reducing its data center footprint and IT management burden while delivering scalability, reliability, and rapid time to value. Boise State will work with Oracle Consulting on the implementation.

Oracle ERP Cloud was chosen to help the university to achieve four important goals:

    § Automate and transform business processes across the entire ERP lifecycle including financial management and billing, procurement, grant management, project management and reporting to drive greater operational efficiency and organizational effectiveness.

    § Empower staff with information and critical insight when and where they need it

    § Reduce IT complexity and boost IT agility to meet rapidly changing needs

    § Improve total cost of IT ownership while ensuring scalability

In the first phase of the deployment, the university plans to roll out the system to more than 500 users—including finance team members, university administrators, and academic staff members. Oracle ERP Cloud, through its intuitive user interface as well as dashboard functionality, enables business users to access the financial and operational information they require without the need for IT team assistance, improving decision-making.

Boise State University, like many academic enterprises, found that its legacy on-premises ERP environment, which required ongoing investment as well as time-consuming and expensive upgrades, did not provide the agility the university required to keep pace with changing needs. As important, it prohibited the university from quickly adopting and benefiting from powerful new application functionality. With Oracle ERP Cloud, Boise State eliminates the direct and indirect costs associated with on-premises upgrades so it can benefit immediately from the latest features and advances, all while achieving scalability and reliability.

As part of the implementation, the university also looks to drive new levels of precision and transparency to grants management, a capability that is increasingly important as the organization rapidly expands its research and graduate programs.

“When we reviewed our options, Oracle ERP Cloud really stood out as a mature, reliable cloud solution in use across multiple industries. We are eager to experience the many benefits that Oracle ERP Cloud can deliver to our growing university, including greater agility to adapt to the rapidly changing dynamics in higher education and at our own institution. As we begin our move to Oracle Cloud, we are excited by the prospect that the savings from process improvements will more than offset the costs of the solution—all while delivering reliability and scalability and allowing us to benefit rapidly from the latest features and functionality,” said Jo Ellen Dinucci, associate vice president of finance and administration, Boise State University.

“The benefits of moving to a cloud based system are all there; reducing infrastructure costs, the opportunity to re-purpose staff to other needed areas, eliminating costly upgrades, keeping the system current, the ability to grow and scale as needed.” said Max Davis-Johnson, associate vice president/CIO, Boise State University.

“Boise State University is clearly demonstrating innovation at its best in the education and research industry by migrating to Oracle ERP Cloud,” said Cole Clark, global vice president of education and research, Oracle. “With this selection, the university can modernize its systems faster, with less effort and cost, and achieve rapid return on new services and applications. At the same time, it can benefit seamlessly from the most advanced functionality, while freeing IT team members to focus on projects that drive institutional innovation and excellence.”

Additional Information

Join Oracle Higher Education on Facebook and LinkedIn and follow @OracleHigherEdu on Twitter.

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit oracle.com.

Trademark

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

# # #

Contacts

Katie Barron
Oracle
+1.202.904.1138
katie.barron@oracle.com

Liz Vandendriessche
O’Keeffe & Company
+1.443.223.3378
evandendriessche@okco.com

Categories: Database, Vendor

Oracle HCM World to Bring Together Executives, Global Leaders, and HR Experts to Discuss Modern HR Best Practices

Oracle Database News - Tue, 03/24/2015 - 17:18
Oracle HCM World to Bring Together Executives, Global Leaders, and HR Experts to Discuss Modern HR Best PracticesHR industry event will feature critical HR discussions, expert keynotes, customer case studies and networking opportunities

Redwood Shores, Calif. – March 24, 2015 – To help HR professionals find, grow and retain the best possible talent in an increasingly competitive and mobile business environment, Oracle will host its second Oracle HCM World in Washington, DC on March 25 – 27, 2015 at the Gaylord National Resort & Convention Center. The conference will feature industry leaders to discuss critical HR topics and best practices, including workforce planning, recruiting, on-boarding, leadership development and training.

Oracle HCM World will help attendees address the most crucial challenges facing HR today by bringing together HR, talent management, business leaders, and industry influencers to share best practices and discuss how forward-thinking organizations are employing modern HR to transform their organizations. Attendees will also learn about the latest developments in workforce management, rewards and optimization as well as social sourcing, flexible learning, predictive insight, transformative decision-making and game-changing technologies.

Conference Highlights Include: Keynote address from Oracle CEO Mark Hurd and 66th Secretary of State Condoleezza Rice on Thursday, March 26 at 8:00 a.m. ET. During that keynote, Mark Hurd will share his thoughts on the digital workforce and Dr. Rice will discuss recent changes to the geopolitical landscape. Opening keynote from Cara Capretta, vice president, HCM Transformation, Oracle, and Bertrand Dussert, vice president, HCM Transformation, Oracle, to discuss the global trends impacting the HR function and modern HR best practices. Additional keynotes from Oracle executives, including Chris Leone, senior vice president, Oracle Applications Development; Oracle partners Accenture, PwC, and Deloitte Consulting LLP; and industry expert Dave Ulrich, professor of business at the Ross School, University of Michigan and partner at the RBL Group. More than 90 sessions, demos and keynotes in eight tracks including Social and Core Human Resources, Talent Acquisition, Modern HR, and HCM Mobile Cloud. Advice and best practices from cutting-edge Oracle HCM customers, including Ovation Brands, Concentrix, Compass Minerals, Inc., and Cox Enterprises. Customer appreciation event, “THE Bash at the Museum,” at the Smithsonian American Art Museum and National Portrait Gallery the evening of Thursday, March 26.

“Cloud, mobile and social technologies are changing every aspect of how a company engages with its workforce,” said Oracle CEO Mark Hurd. “In this time of digital disruption, relying on the most modern and comprehensive HCM capabilities is more crucial than ever. Oracle HCM World will help our customers ensure they keep pace with the latest HCM advancements in order to work collaboratively across the organization and attract and retain the best people.”

Additional Information Learn more about Oracle HCM World Register to attend Learn more about Oracle HCM by following us on Twitter and FacebookAbout Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

###

Danielle Cormier-Smith
Oracle

+1.610.766.3463
danielle.cormier@oracle.com

Danielle Tarp
Blanc & Otus
+1.408.921.7063
danielle.tarp@blancandotus.com

Categories: Database, Vendor

Newfield Supports Employee Performance with Oracle HCM Cloud

Oracle Database News - Mon, 03/23/2015 - 13:00
Newfield Supports Employee Performance with Oracle HCM CloudIndependent oil and gas company adopts cloud-based solution to manage critical human resource functions

Redwood Shores, Calif. – March 23, 2015 – In the oil and gas industry, expedition into new areas and successful development of ongoing operations drive growth. To capitalize on such opportunities, Newfield Exploration Company, a business engaged in exploring and producing oil and gas, adopted Oracle Human Capital Management Cloud (Oracle HCM Cloud), which gives employees and managers access to HR data and helps them identify and work toward individual, team, and company goals.

To support business expansion around the globe, Newfield will leverage the mobile capabilities of Oracle HCM Cloud, part of Oracle Applications Cloud, to eventually focus its 1,500 employees on goals and objectives that add value for shareholders. Newfield has selected Oracle HCM Cloud Mobile as the mobile interface its employees will use when the company is ready to launch this new application, based on features such as usability, goal-tracking capabilities, and real-time speed of the native iPad application.

Oracle HCM Cloud has helped Newfield strengthen employee development and foster teamwork and collaboration. Full visibility into goals and progress in Oracle HCM Cloud helps motivate Newfield employees to perform to their potential. Newfield plans to use Oracle HCM Cloud Mobile to increase personal connections across the growing team by giving employees who travel to different offices instant access to shared employee profiles—including backgrounds, previous interactions, and photos.

Additionally, with seamless integration into its existing cloud-based HR solution, Newfield’s IT department spends little time on upgrades and maintenance and is able to focus on end-user delivery and adoption.

“Advanced technologies like Oracle HCM Cloud are critical to our success as a company that thrives on discovering and working in uncharted territories,” said Thomas Smouse, vice president of administration and human resources, Newfield Exploration Company. “With Oracle HCM Cloud, we are transforming the way we communicate our goals throughout the organization, creating a more transparent environment. The increased clarity around goals has led to better collaboration and more productive employees focused on common milestones, which inevitably results in better business outcomes.”

Additional Information Join Oracle on LinkedIn and follow @Oracle on Twitter Connect with Oracle HCM via blog, Twitter, and Facebook View the Newfield case study video Learn more about Oracle HCM Cloud and Oracle HCM Cloud MobileAbout Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

###

Danielle Cormier-Smith
Oracle

+1.610.766.3463
danielle.cormier@oracle.com

Danielle Tarp
Blanc & Otus
+1.408.921.7063
danielle.tarp@blancandotus.com

Categories: Database, Vendor

Epsilon Deploys Oracle Linux and Oracle VM to Deliver Solutions up to 20 Times Faster at a 35 Percent Lower Total Cost of Ownership

Oracle Database News - Mon, 03/23/2015 - 13:00
Epsilon Deploys Oracle Linux and Oracle VM to Deliver Solutions up to 20 Times Faster at a 35 Percent Lower Total Cost of OwnershipRedwood Shores, Calif. – March 23, 2014 News Summary

To meet the growing demands of its dynamic customer base, Epsilon, an all-encompassing global marketing company and a worldwide leader in creating connections between people and brands, needed a more flexible, cost-effective architecture to support its database and business intelligence offerings. With Oracle VM and Oracle Linux, Epsilon has significantly accelerated its service delivery while improving the resiliency of its infrastructure and reducing total cost of ownership. Epsilon can now rapidly provision high-performance, location-independent, elastic, and production-ready database and business intelligence environments for its customers—delivering these solutions up to 20 times faster than before.

News Facts To help reduce costs and improve operational efficiency, Epsilon deployed Oracle VM and Oracle Linux to run its database as a service (DBaaS) and business intelligence as a service (BIaaS) solutions. With more than 7,000 employees across 70 offices, Epsilon sought to deliver high-performance, elastic database and business intelligence environments while efficiently consolidating workloads and enhancing agility and speed for complex legacy applications. With its Oracle-based infrastructure, Epsilon has realized more than 35 percent savings in total cost of ownership. Epsilon selected Oracle VM because its design is focused on ensuring applications run well under virtualization, not just providing virtualization of the underlying hardware, which has helped to simplify provisioning of the multitier technology stack of databases and business intelligence solutions for its customers. Oracle VM’s prebuilt templates enable Epsilon to improve time-to-provisioning for its customers so they can rapidly deploy enterprise applications from test to production and simplify lifecycle management, resulting in increased customer loyalty. With Oracle VM, Epsilon can standardize its virtual machine images, which accelerates deployment times of Oracle Database 12c, Oracle Real Application Clusters, and Oracle Business Intelligence Enterprise Edition and streamlines the company’s IT processes and operational efficiency. Oracle VM has also enabled Epsilon to dramatically improve workload consolidation, helping the company to meet aggressive, client-specific requirements without significant downtime for hardware and software maintenance. In addition, Epsilon uses Oracle Enterprise Manager to manage its Oracle-based infrastructure through a single interface, simplifying management and helping to ensure always-on availability for critical customer systems. Supporting Quote "With Oracle technology, we have been able to build both DBaaS and BIaaS solutions that deliver superior capabilities to meet our customers’ scalability and performance demands and enhance customer loyalty, while lowering our overall total cost of ownership,” said Monish Sharma D.Sc., vice president, Technology at Epsilon. Supporting Resources Oracle Virtualization Download Oracle VM software (terms, conditions, and restrictions apply) Oracle’s Virtualization Blog Oracle Linux Follow Oracle VM on Facebook and Twitter Epsilon About Epsilon

Epsilon is a global leader in creating connections between people and brands. An all-encompassing global marketing company, it harnesses the power of rich data and groundbreaking technologies, engaging creative and transformative ideas to get the results its clients require. Recognized by Ad Age as the #1 World CRM/Direct Marketing Network and #1 US Agency from All Disciplines, Epsilon employs more than 7,000 associates in 70 offices worldwide. Epsilon is an Alliance Data company. For more information, visit epsilon.com, follow us on Twitter @EpsilonMktg, or call 1.800.309.0505.

About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center.  For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

TrademarksOracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Contact Info

Teri Whitaker
Oracle
+1.650.506.9914
teri.whitaker@oracle.com

Danielle Tarp
Blanc & Otus
+1.415.856.5182
dtarp@blancandotus.com

Categories: Database, Vendor

Getting Started with Database Engine Tuning Advisor in SQL Server – Part 2

Database Journal News - Mon, 03/23/2015 - 08:01

Arshad Ali demonstrates how you can use the command line interface to tune SQL queries and how you can use SQL Server Profiler to capture the workload for tuning with Database Engine Tuning Advisor.

Categories: Database

Analyze DB2 spatial data with a free geobrowser

IBM - DB2 and Informix Articles - Mon, 03/23/2015 - 05:00
A geobrowser for DB2, Informix and Netezza is now available as a free download. You can easily list tables containing spatial data and select the tables to be displayed as a map using a combination of points, lines and polygons. The color, symbols, linestyle and shading are user selectable. Map navigation tools allow you to zoom in and out, pan the map and select and display the alphanumeric values associated with each graphic object. The geobrowser can render the results of spatial analysis using DB2, Informix or Netezza. Application developers can use these components to construct custom spatial visualization applications. This tutorial shows you step-by-step how to use the free geobrowser to visualize data from DB2 tables.
Categories: Database

Community Spotlight: Grant Fritchey, Red Gate Software

In honor of the upcoming PASS Business Analytics conference, we wanted to take some time to spotlight the great work happening in the SQL and BI communities across the world. The conference is focused on business analytics, but PASS offers many great community activities for SQL Server and beyond. Learn about the various local and digital opportunities to connect with the PASS community here.

Name: Grant Fritchey
Role: Product Evangelist, Red Gate Software
Location: Grafton, MA, USA

What is an exciting project that you’re working on right now?

I’m helping to build a set of classes to teach people how to automate their database deployments in support of Database Lifecycle Management. Development is moving faster and faster in order to keep up with the demands of business. Because of this, databases must also be deployed faster and faster. But, you still have to ensure the protection of the vital business information stored within your databases. In the class I’m working on, we’ll show you how to get your database into source control alongside your application and how to perform continuous integration with databases. We’re going to cover all sorts of mechanisms for automating database deployments and database testing in order to work Database Lifecycle Management right into your Application Lifecycle Management.

What are your current analytics and/or database challenges, and how are you solving?

The main challenges we have with databases are the same ones we’ve always had: performance and uptime. The thing is, we have blazing fast hardware these days. Or, if you’re looking at online solutions like Azure, we have very large VMs as well as methods for sharing across servers and databases. All this means that the underlying architectures of our database systems can perform very well. But, we still have to deal with the database design and the T-SQL code being run against the database. More and more we’re taking advantage of ORM tools such as Entity Framework, which really do speed up development. But, around 10% of the queries still need to be coded by hand in order to ensure adequate performance. Add to this the fact that we need to deploy all this while still ensuring up-time on the databases… Figuring out how to get adequate functionality in place without affecting up-time is tough work.

How does data help you do your job better?

Decisions on what to do with systems need to be based on information, not guesses. Data gathered about my systems shows me where I need to prioritize my work and directs choices on resource allocation.

What’s your favorite example of how data has provided an insight, a decision, or a shift in how business gets done?

Recently I found that I was seeing a serious “observer affect” in how I was collecting performance data. While tuning queries I was using STATISTICS IO and STATISTICS TIME. I normally do this all the time. As I was adjusting the code, I wasn’t seeing the kind of performance improvements I expected. In fact, some of my solutions seemed to be working even worse. I was a little surprised because I thought I was following a good methodology, and so I tried turning off all the STATISTICS capturing and just used Extended Events. Suddenly, the tuning started was working extremely well. I went back and experimented until I discovered that for some of my queries STATISTICS IO was actually impacting query execution, affecting both the time and the reads. Turning it off cleared the problem completely. I’ve now changed to using extended events most of the time in order to minimize, or eliminate, that issue. Best of all, I’m able to use these within Azure SQL Database as well as in my earthed servers.

What or who do you read, watch, or follow to help grow your data skills?

I go to SQLSkills.com over and over, sometimes multiple times in a day. It’s one of the single best resources for detailed SQL Server information. I also go to SQLServerCentral.com regularly to ask and answer questions. It’s a great resource for expanding your knowledge.

What’s your favorite SQL command and why?

RESTORE DATABASE: Because it has saved my job and the companies I’ve worked for so many times.

How does Azure help you protect your local databases?

There are a couple of ways you can use Azure to extend local capabilities. The first, and probably the easiest, is to use Azure Blob Storage as a means of ensuring that you have off-site storage of your backup files. You could pretty easily write a PowerShell script that copies your backups to Azure Storage. But, starting in SQL Server 2012, you can also issue a backup command to go straight to Azure Storage. Either way, you can be sure there’s a copy of your backups in case you suffer a catastrophic event locally.

Another way to extend your local capabilities to the cloud is to set up a virtual network. You can incorporate Azure Virtual Machines directly into your local network. Because of this, you can set up Availability Groups between Azure VMs and your local machines. This would enable you to have a failover setup to Azure, allowing for additional protection of your data and your systems.

Are there other ways Azure can be used in combination with local databases?

It’s my opinion that every developer should be using a local copy of SQL Server for their development. This is to allow them to experiment, learn, and, well, break stuff, without affecting anyone else. But, some laptops might be underpowered, or this could in some way violate a corporate policy. As a workaround, people can take advantage of the fact that SQL Database covers the vast majority of standard SQL Server functionality, at the database level. This makes it a great place to develop and test databases, especially if you’re already developing applications for Azure. You only need to keep the database around while you’re developing, and because you can keep the size small, the costs are extremely minimal.

Any other benefits for Azure in combination with local machines?

Tons. For one, expanded capacity. What if you need to get a lot more servers online quickly, but you’re hurting on disk space, or the servers are on back-order? Go back to that virtual network we talked about earlier. Set that up and now you can very quickly, even in an automated fashion through PowerShell, add SQL Server machines to your existing systems.

Another thing you could do, although this not something I’ve tried yet, is take advantage of the fact that in SQL Server 2014 you can actually add file groups that are in Azure Blob Storage. Do you need extra disks, right now, that you can’t get from the SAN team? Well, if you can afford a bit of latency, you can just expand immediately into Azure Storage. I’d certainly be cautious with this one, but it’s exciting to think about the expanded capabilities this offers for dealing with certain kinds of disk space emergencies.

Thanks for joining us, Grant!

Know someone doing cool work with data? Nominate them for a spotlight in the comments.

Categories: Database

Manage performance and administer DB2 databases using IBM Data Server Manager

IBM - DB2 and Informix Articles - Fri, 03/20/2015 - 05:00
IBM Data Server Manager is a new, integrated tool for managing performance and administering DB2 for Linux, UNIX, and Windows databases. This tutorial starts with a brief introduction of Data Server Manager and a high-level explanation of the quick up-and-running process. The majority shows how Eric, a database administrator (DBA), can use Data Server Manager to investigate a statement performance alert. From start to finish, Eric uses one tool to learn about the alert, investigate the statement performance, review configuration changes, tune the statement, and review and implement the recommendations.
Categories: Database

Thomas LaRock Invites You to Attend the PASS Business Analytics Conference 2015

This is a guest blog post from Thomas LaRock, the President of PASS (Professional Association for SQL Server)

It’s no secret that the role of data in the IT industry, in business, and in the world at large is changing at a rapid pace. As technology continues to become a more integrated and integral part of our lives the value of data continues to rise.

At PASS we have a 16-year history of empowering IT professionals who use Microsoft data technologies. The SQL Server community is the largest and most engaged group of data pros in the world. PASS volunteers and the PASS Board of Directors work together to help the PASS community succeed in connecting, sharing, and learning from one another. A big part of that effort is keeping an eye on the future of the data profession.

What we see is that data analytics is the next frontier for professionals passionate about data. The growth of Big (and Little) Data, the advent of cloud computing, and advances in machine learning are all areas that present challenges for our community. Data analysts, data scientists, and line-of-business managers are in high demand as organizations realize the potential of collecting and understanding the wealth of information that is available from a variety of sources.

PASS is dedicated to helping our members harness the technologies, skills, and networks that are the foundation of solid and successful careers. We believe that keeping up with industry advances is a vital skill for all data professionals. Setting and achieving new goals as well as learning new ways of working with data is a must.

Whether you’re coming from a background in SQL Server, business intelligence, or social media there are specific cornerstones of turning all this data into something that can benefit your organization. We call this the “analyst’s journey.”

One such cornerstone is data discovery and integration. We want our members to be aware of the latest technologies in collecting, modeling, and preparing data for analysis. Next is data analysis and interpretation. We want to help our members understand the techniques and tools that enable sophisticated analysis, prediction, and optimization. Then there’s visualization: the creative side of things, where we get into report and dashboard design.

As with any career another key skillset is communication. The people who analyze and work with data are in the best position to help gain executive buy-in for data-driven business decisions. For years PASS has been the leader in helping data professionals improve their communication and soft skills.

One way in which we’re reaching out to those who want to learn more about analytics is the PASS Business Analytics Conference. This premiere event brings together a stellar lineup of business and analytics speakers including our keynote speakers Carlo Ratti and BI Brainz founder Mico Yuk. We have created a series of webinars and a Meet the Expert interview series to give people an idea of what the conference will offer. We also have replays from last year’s conference, and we have hours of training available through our Virtual Chapters.

We’re excited about data and analytics and we’re hearing from more and more SQL Server pros who share that excitement.

It’s a wonderful time to be a data professional.

See you in Santa Clara!

Thomas LaRock

President, PASS

PASSBAConference.com

Categories: Database