All Projects → dogHere → dogETL

dogHere / dogETL

Licence: other
A lib to transform data from jdbc,csv,json to ecah other.

Programming Languages

java
68154 projects - #9 most used programming language

Projects that are alternatives of or similar to dogETL

qwery
A SQL-like language for performing ETL transformations.
Stars: ✭ 28 (+86.67%)
Mutual labels:  csv, etl
Ethereum Etl
Python scripts for ETL (extract, transform and load) jobs for Ethereum blocks, transactions, ERC20 / ERC721 tokens, transfers, receipts, logs, contracts, internal transactions. Data is available in Google BigQuery https://goo.gl/oY5BCQ
Stars: ✭ 956 (+6273.33%)
Mutual labels:  csv, etl
Http Rpc
Lightweight REST for Java
Stars: ✭ 298 (+1886.67%)
Mutual labels:  csv, jdbc
dswarm
an open-source data management platform for knowledge workers (https://github.com/dswarm/dswarm-documentation/wiki)
Stars: ✭ 57 (+280%)
Mutual labels:  csv, etl
Csv2db
The CSV to database command line loader
Stars: ✭ 102 (+580%)
Mutual labels:  csv, etl
redis-connect-dist
Real-Time Event Streaming & Change Data Capture
Stars: ✭ 21 (+40%)
Mutual labels:  csv, etl
Choetl
ETL Framework for .NET / c# (Parser / Writer for CSV, Flat, Xml, JSON, Key-Value, Parquet, Yaml, Avro formatted files)
Stars: ✭ 372 (+2380%)
Mutual labels:  csv, etl
vok-orm
Mapping rows from a SQL database to POJOs in its simplest form
Stars: ✭ 13 (-13.33%)
Mutual labels:  jdbc, jdbc-orm-framework
Etl with python
ETL with Python - Taught at DWH course 2017 (TAU)
Stars: ✭ 68 (+353.33%)
Mutual labels:  csv, etl
Ether sql
A python library to push ethereum blockchain data into an sql database.
Stars: ✭ 41 (+173.33%)
Mutual labels:  csv, etl
cubetl
CubETL - Framework and tool for data ETL (Extract, Transform and Load) in Python (PERSONAL PROJECT / SELDOM MAINTAINED)
Stars: ✭ 21 (+40%)
Mutual labels:  csv, etl
Omniparser
omniparser: a native Golang ETL streaming parser and transform library for CSV, JSON, XML, EDI, text, etc.
Stars: ✭ 148 (+886.67%)
Mutual labels:  csv, etl
DaFlow
Apache-Spark based Data Flow(ETL) Framework which supports multiple read, write destinations of different types and also support multiple categories of transformation rules.
Stars: ✭ 24 (+60%)
Mutual labels:  csv, etl
dbd
dbd is a database prototyping tool that enables data analysts and engineers to quickly load and transform data in SQL databases.
Stars: ✭ 30 (+100%)
Mutual labels:  csv, etl
mydataharbor
🇨🇳 MyDataHarbor是一个致力于解决任意数据源到任意数据源的分布式、高扩展性、高性能、事务级的数据同步中间件。帮助用户可靠、快速、稳定的对海量数据进行准实时增量同步或者定时全量同步,主要定位是为实时交易系统服务,亦可用于大数据的数据同步(ETL领域)。
Stars: ✭ 28 (+86.67%)
Mutual labels:  etl, jdbc
Simpleflatmapper
Fast and Easy mapping from database and csv to POJO. A java micro ORM, lightweight alternative to iBatis and Hibernate. Fast Csv Parser and Csv Mapper
Stars: ✭ 370 (+2366.67%)
Mutual labels:  csv, jdbc
baymax
铜板街轻量级JDBC层分库分表框架
Stars: ✭ 45 (+200%)
Mutual labels:  jdbc, jdbc-orm-framework
Pyetl
python ETL framework
Stars: ✭ 33 (+120%)
Mutual labels:  csv, etl
Etl.net
Mass processing data with a complete ETL for .net developers
Stars: ✭ 129 (+760%)
Mutual labels:  csv, etl
neo4j-jdbc
JDBC driver for Neo4j
Stars: ✭ 110 (+633.33%)
Mutual labels:  etl, jdbc

Example

Start a job

Model model = new Model() 
        .setReader(reader)
        .setTransformer(transformer)
        .setWriter(writers) 

model.start(); 

Reader

//jdbc reader

Reader reader = new JDBCReader()
                .setConnection(connection) // jdbc connection
                .setSQL("select uid,count(*) as pv from logs group by uid"); // any sql

Support readers : jdbc,csv,json

Transformer

Transformer transformer = new Transformer<Row>() {
    @Override
    public void onEvent(Row event, long sequence, boolean endOfBatch) throws Exception {
        //deal each row here
    }
};

Writer

// jdbc multi-writer

Writer [] writers = new JDBCWriter()
        .setTarget("rpt_pv")
        .setPrimaryKeys("uid")
        .setWriterSize(POOL_SIZE)
        .setDataSource(dataSource)
        .create();

Support writers : jdbc,csv

License

Copyright 2016-2017 dogHere

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

    http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].