Ab Initio Open Source Alternatives

Ab Initio Open Source Alternatives Ab Initio is an open source software modelling and simulation framework. It allows scientists, engineers and developers to create and run large-scale residency behaviour models that are entirely software-based. The software can be freely distributed under the GNU Public License. Ab Initio is a software tool that is used by many public organisations around the world, including: European Space Agency (ESA), Royal Navy of the United Kingdom, European Southern Observatory (ESO).

Ab Initio is an open source software package that offers a core set of tools for accelerating parallel performance and portability of C, C++, Java, and Fortran programs on a variety of platforms. Ab Initio comprises features and functionality that have been available in Fortran or C compilers or systems software for many years. We’ve selected the best features to give you the most accessible collection of useful features possible. This e-book discusses information about Ab Initio’s functions. It also includes comparisons between Ab Initio and standard products such as Intel Parallel Studio XE and PGI CUDA Fortran, as well as descriptions of other important details.

 Xplenty

Xplenty logo

Xplenty is a cloud-based ETL solution providing simple visualized data pipelines for automated data flows across a wide range of sources and destinations.

The company’s powerful on-platform transformation tools allow its customers to clean, normalize, and transform their data while adhering to compliance best practices as well.

Xplenty

Key Features:

  • Centralize and prepare data for BI.
  • Transfer and transform data between internal databases or data warehouses.
  • Send additional third-party data to Heroku Postgres (and then to Salesforce via Heroku Connect) or directly to Salesforce.
  • Xplenty is the only Salesforce to Salesforce ETL tool.
  • Lastly, Xplenty supports a Rest API connector to pull in data from any Rest API.

Cheminformatics

Cheminformatics involves the representation, manipulation and analysis of molecular data [5][6]. Cheminformatic toolkits, although they may contain standalone utility programs, are primarily designed to function as libraries for other programs so that common functions, such as parsing molecular data, need not be reimplemented. As libraries, the native programming language of a toolkit is particularly relevant as it influences the language programs that integrate with the toolkit can be written in. In some cases, alternative language bindings, which essentially translate between programming languages, may be available, but due to the use of different idioms by different languages (e.g., object-oriented vs. functional, manual vs. automatic memory management) use of these non-native bindings may be cumbersome. In addition to toolkits, we catalog standalone programs, including conformer generators for converted 2D information into 3D molecular structures (some of which have been critically evaluated [7]), and graphical environments for creating and managing workflows.

Skyvia

skyvia etl

Skyvia is a cloud data platform for no-coding data integration, backup, management and access, developed by Devart. Devart company is a well-known and trusted provider of data access solutions, database tools, development tools, and other software products with over 40 000 grateful customers in two R&D departments.

Skyvia includes an ETL solution for various data integration scenarios with support for CSV files, databases (SQL Server, Oracle, PostgreSQL, MySQL), cloud data warehouses (Amazon Redshift, Google BigQuery), and cloud applications (Salesforce, HubSpot, Dynamics CRM, and many others).

It also includes a cloud data backup tool, online SQL client, and OData server-as-a-service solution.

Key Features:

  • Skyvia is a commercial, subscription-based cloud solution free plans available.
  • Wizard-based, no-coding integration configuration does not require much technical knowledge.
  • Advanced mapping settings with constants, lookups, and powerful expressions for data transformations.
  • Integration automation by schedule.
  • Ability to preserve source data relations in target.
  • Import without duplicates.
  • Bi-directional synchronization.
  • Predefined templates for common integration cases.

 Usage activity

Substantial user usage within the last 18 months (more than 20 downloads a month on average from SourceForge, more than 20 stars or forks on GitHub, more than 10 citations a year, and/or a clearly active user community as indicated by traffic on mailing lists or discussion boards).2.

Moderate user usage within the last 18 months.3.

Minimal or no identifiable user usage within the last 18 months (fewer than 50 downloads total on SourceForge, three or fewer stars and/or forks on GitHub, or fewer than one citation a year).

We omit some packages with extended periods of inactivity (e.g., more than 10 years) where there is little evidence of any usage or packages that are referenced in the literature but for which we could not find a extant source code repository. We also omit packages that provide common and/or trivial functionality (e.g., molecular weight calculators) and those that require non-open source packages in order to function.

IRI Voracity

Voracity Logo

Voracity is an on-premise and cloud-enabled ETL and data management platform best known for the ‘affordable speed-in-volume’ value of its underlying CoSort engine, and for the rich data discovery, integration, migration, governance, and analytics capabilities built-in, and on Eclipse.

Voracity supports hundreds of data sources, and feeds BI and visualization targets directly as a ‘production analytic platform.’

Voracity users can design real-time or batch operations that combine already-optimized E, T, and L operations or use the platform to “speed or leave” an existing ETL tool like Informatica for performance or pricing reasons. Voracity speed is close to Ab Initio, but its cost is close to Pentaho.

IRI Voracity

Key Features:

  • Diverse connectors for structured, semi- and unstructured data, static and streaming, legacy and modern, on-premise or cloud.
  • Task- and IO-consolidated data manipulations, including multiple transforms, data quality, and masking functions specified together.
  • Transformations powered by multi-threaded, resource-optimizing IRI CoSort engine or interchangeably in MR2, Spark, Spark Stream, Storm or Tez.
  • Simultaneous target definitions, including pre-sorted bulk loads, test tables, custom-formatted files, pipes and URLs, NoSQL collections, etc.
  • Data mappings and migrations can reformat endian, field, record, file, and table structures, add surrogate keys, etc.
  • Built-in wizards for ETL, subsetting, replication, change data capture, slowly changing dimensions, test data generation, etc.
  • Data cleansing functionality and rules to find, filter, unify, replace, validate, regulate, standardize, and synthesize values.
  • Same-pass reporting, wrangling (for Cognos, Qlik, R, Tableau, Spotfire, etc.), or integration with Splunk and KNIME for analytics.
  • Robust job design, scheduling, and deployment options, plus Git- and IAM-enabled metadata management.
  • Metadata compatibility with Erwin Mapping Manager (to convert legacy ETL jobs), and the Metadata Integration Model Bridge.

Voracity is not open source but is priced lower than Talend when multiple engines are needed. Its subscription prices include support, documentation, and unlimited clients and data sources, and there are perpetual and runtime licensing options available, too.

Conclusion

Ab Initio is the first novel by American science fiction writer and military veteran Jerry Pournelle. The book was originally published electronically, under a non-commercial license in January 1979. This book provides an excellent examination of the future of computer programming, and inspired a legion of followers.

0 Comments

No Comment.