DreamFactory
Postman
MuleSoft Anypoint Platform
Sentinet
AWS CloudTrail
Apigee
RapidAPI for Mac
Boomi
SQLified
SQLizer
Table Format Converter
OI ConvertCSV
Online Convert
Convertio
ExtendsClass SQL Converter
DBConvert for Excel and MySQL
DreamFactory is an API management platform used to generate, secure, document, and extend APIs. The platform is used within a wide variety of sectors, including banking, auto manufacturing, online gaming, consulting, and government.
Perhaps best known for its API generation capabilities, the platform can generate APIs for 20 databases including MySQL, Microsoft SQL Server, Oracle, and MongoDB, among others. Generators are also available for Excel, AWS S3, email delivery providers, and IoT.
Authentication and security is another core feature. APIs can be authenticated using API keys, Active Directory, LDAP, OAuth, OpenID Connect, SAML 2.0, and Okta. A robust yet convenient set of role-based access controls (RBACs) allow administrators to easily create highly tailored API access rules.
DreamFactory's scripting engine supports PHP, Python (version 2 and 3) and NodeJS. Developers can use the engine to create entirely scripted APIs which incorporate third-party libraries and packages. The scripting engine can also be used to extend existing endpoints, allowing developers to implement API composition, apply data masking and hiding, response transformation, and more.
Recently added features include restricted administrators, API scheduling, API auditing, and API generation connectors for Snowflake, Hadoop, and Apache Hive.
SQLified is a browser-based tool that converts CSV, TSV, and other delimited data files into clean, import-ready SQL —CREATE TABLE plus batched INSERT statements — for PostgreSQL, MySQL, SQLite, and SQL Server.
Unlike free one-off converters that choke around 100K rows, SQLified is built for production-scale loads: it reliably handles files of 1,000,000+ rows. It does smart type inference (INT/BIGINT, NUMERIC scale, dates, booleans, currency), lets you override any column's type, primary key, and nullability, and emits correctly chunked INSERT batches per dialect (including SQL Server's 1000-row limit and MySQL packet limits) so the output imports cleanly the first time.
Free to use for everyday conversions; Pro unlocks the largest files, batched output tuning, and an ad-free experience. A product of Octet Software.
DreamFactory SQLifiedDreamFactory is particularly recommended for developers who need to quickly generate APIs without spending extensive time managing backend infrastructure. It is suitable for small to medium-sized enterprises, independent developers, and teams that require rapid prototyping and development. Organizations looking for a solution to manage multiple data resources and integrate various third-party services can also greatly benefit from DreamFactory's capabilities.
SQLified's answer:
Our ability to infer data types, and produce massive insert statements quickly across multiple dialects.
SQLified's answer:
After using many online tools and being disappointed, I realized there was a need for a file that can create clean, type aware sql for bulk inserts. The product saves me tons of time every month dealing with large data sets in the payment industry and has reduced frustrations in dealing with them.
SQLified's answer:
There are numerous competitors, but none that do what SQLified does well: this is type inference, and creating runnable SQL script for extremely large inserts in multiple dialects.
SQLified's answer:
SQLified is designed for the solo developer, or the analytical employee dealing with large data sets, csv, or delimited files every day, and struggling with bulk insert. I want to eliminate that struggle so the real work can be done.
SQLified's answer:
Our tools are simple, effective, and require little processing power. We store no data; all work is "ephemeral" and done on the users machine. We do not track, store, or maintain any datasets whatsoever in regards to whatever is converted on the site. We are also not trying to be something we are not. We do what we do, which is flat file to SQL dialect conversion, and we do it well.
Based on our record, DreamFactory seems to be more popular. It has been mentiond 1 time since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.
Dreamfactory.com — Open source REST API backend for mobile, web, and IoT applications. Hook up any SQL/NoSQL database, file storage system, or external service and it instantly creates a comprehensive REST API platform with live documentation, user management,... - Source: dev.to / about 5 years ago
Postman - The Collaboration Platform for API Development
SQLizer - Take data in a format you don't need, and turn it into SQL
MuleSoft Anypoint Platform - Anypoint Platform is a unified, highly productive, hybrid integration platform that creates an application network of apps, data and devices with API-led connectivity.
Table Format Converter - Free online table converter tool. Convert CSV, HTML, JSON, Markdown, and other table formats instantly. No registration required, works offline, and keeps your data private.
Sentinet - API Management and SOA Governance for enterprises and developers
OI ConvertCSV - Backup your notes and shopping lists on Android