Concluído

Solution to load a CSV-type file into a Database (SQL or Oracle) with Validation Logic.

I'm trying to revamp a sort of EDI file load to our database.

Solution 1: I need to convert an CSV file type as input into a local SQL Server express tables (hosted in Windows) validates it with business rules and then updates Oracle tables (hosted in Linux) with a db link between them.

Solution 2: Alternatively, if the script can just directly load into an Oracle temp/staging tables for me to build validation and update routines in Oracle. The CSV file comes in on a different server and Oracle is on another server.

Sample of CSV file attached.

Habilidades: Oracle, SQL, Microsoft SQL Server , Administração de Bancos de Dados, Scripting

Veja mais: upload sql file database, download csv file database php, ruby file parse sql database, import txt file database sql, flat file database sql, import csv file database using wizard sql, load csv file sql server ssis, load file word database sql, asp net upload file database sql, convert type file upload sql, insert xml file database sql server xml type, sql express load csv file, uploading file ajax type file database, college assignment database sql oracle, database sql oracle

Acerca do Empregador:
( 13 comentários ) Pendle Hill, Australia

ID do Projeto: #20246965

Concedido a:

xutao650

Hi I can develop a windows service using C# to load data from csv file and insert into sql server and orcle database. I ama software engineer with 8 years' experience of .net developing. Please contact me for further d Mais

$140 AUD em 7 dias
(8 Comentários)
3.7

30 freelancers estão ofertando em média $139 para esse trabalho

expertcoder1vw

Hi, I'm an expert database developer and can deliver a Windows application that will take the CSV file, process it, and upload it to staging tables in the remote Oracle database (which is on Linux). This application Mais

$250 AUD in 7 dias
(41 Comentários)
5.7
anshulikabansal

Hello Sir, How about if I write a program in PHP which connect with your Oracle Database, validate the business rule at CSV before uploading the data to Oracle DB? Please ping me for further discussion. Looking forw Mais

$100 AUD in 2 dias
(12 Comentários)
4.4
kashivw

Hello, I am a veteran (25+ years) database developer with real industry experience using Oracle (from v6 thru 12c) and SQL Server (from Sybase thru v17). Plenty of SQL and procedural SQL (PL/SQL, T-SQL). Completely fa Mais

$140 AUD in 7 dias
(10 Comentários)
4.4
igccristian

Hi, I can provide you an Oracle procedure for loading CSV directly into staging tables. What I need to do is to know the file location (I propose to use an Oracle directory) and the CSV format. The procedure can be de Mais

$112 AUD in 2 dias
(11 Comentários)
4.1
jayantavkumar

Proposal - If you want to load csv file directly into oracle using UTL file package. OR if you want to load CSV file in sql server then we can do import of file and then do some business operation. OR you can use SSIS Mais

$200 AUD in 7 dias
(8 Comentários)
3.8
PHPsoldier

Sir, The attached file is not a CSV file. I need more info on the file [login to view URL] then I should be able to convert it in CSV which can be imported in any database. Please take a look at my reviews. Thanks........

$150 AUD in 7 dias
(5 Comentários)
3.4
nalabolusrikanth

Over 7years 6 Monthsof extensive experience as Oracle Application Technical Developer in implementation, upgrade and customization of Oracle e-Business Suite Applications R12. This includes system study, design, develo Mais

$150 AUD em 1 dia
(1 Comentário)
2.4
agkavita20

Hi, I can write the import utility in SQL to import data in SQL, then validate it and then load into Oracle.

$160 AUD in 7 dias
(1 Comentário)
2.2
l0ginp

I read in you Sampletext file and can both solutions can be applied. It's your choice. In Oracle can load csv file by "SQL Loader" and SQL Server using "Bulk insert script". Please send me message so that we could di Mais

$120 AUD in 7 dias
(2 Comentários)
1.9
purplemaestro

Hello sir. My name is Hassan. I have high level expertise in Importing csv files in oracl. I can do the work on time and wont disappoint you. Please share the work details do that I can start working.

$50 AUD in 3 dias
(2 Comentários)
1.4
Shreyaswarup

I will upload your CSV to Your Oracle Database server. I am an experienced programmer and linux system administrator. I am also providing hosting services for last six years and running technical forum on server manage Mais

$66 AUD em 1 dia
(1 Comentário)
1.1
TakaAlex

Hi, there! how are you! I've much concerned in your project, and I'd read all of your requirements carefully, and thinking this is the suitable one you're looking for. So I'd like to talk with you over chat, share mo Mais

$140 AUD em 1 dia
(0 Comentários)
0.0
rajeshanna85

1) SQL Loader can be used to load the CSV file directly on Oracle database table. Place the file on Oracle application server and run SQL loader with a control file 2) Write a plsql UTL_FILE procedure to read and inser Mais

$250 AUD in 7 dias
(1 Comentário)
0.0
nikoale

I am confused. The fact that the business rules can be on SQL Server/ORACLE means that they are not in place and you need to develop them in the meanwhile. If you do not have anything in place for the business rule Mais

$250 AUD in 7 dias
(0 Comentários)
0.0
sravankumar2507

I have 10 years of experience in Analytics. I can easily complete the task with in stipulated time.

$107 AUD in 3 dias
(0 Comentários)
0.0
sagar83

I have 14+ year experience in Oracle database. I already work like this convert data into CSV file in Oracle through query written and also do the performance tunning of your data.

$223 AUD in 7 dias
(0 Comentários)
0.0
Vinodrishi

I have good experience on load data from flat files into DB

$133 AUD in 3 dias
(0 Comentários)
0.0
sagom

Software engineer with a postgraduate in software development and I have extensive experience in the development of web and mobile software, I have worked with business intelligence projects based on Microsoft technolo Mais

$250 AUD in 2 dias
(0 Comentários)
0.0
engineerasmaa01

Dear sir, i'm oracle certified OCA&OCB and i have a good experience in database projects and tools like SQL,SQL/PL and any other tools,so i think this job is suitable to my skills thanks Asmaa

$30 AUD em 1 dia
(0 Comentários)
0.0
albertpopov46

Hi Dear I read your requirements carefully. I have rich experience with DBMS such as Mysql, Postgres, software architecture and so on. You can see my good reviews. Please touch me. I will provide good service for you. Mais

$140 AUD in 7 dias
(0 Comentários)
0.0