RapidMiner

RapidMiner

Reading a SQL BAK file for analysis

SOLVED
Contributor II

Reading a SQL BAK file for analysis

I have a couple of SQL BAK files that contain information in terms of analytics I am required to perform. I personally do not access to a SQL server to restore the files and then connect to them for the anlaysis. 

 

Is it possible to read the files directly into RapidMiner to perform the anlaysis? I do not seem to be able to read the BAK files in as all the SQL operators require connection to a SQL server. 

3 REPLIES
Community Manager

Re: Reading a SQL BAK file for analysis

When you say SQL BAK files, do you mean they have a ".bak" extension on them?  If so, they're likely to be backups of the SQL database. 

 

You can't directly import them into RM but what you could try is loading htem into a new database locally and then connect RM to that database. 

Regards,
T-Bone
Twitter: @neuralmarket
Highlighted
Contributor II

Re: Reading a SQL BAK file for analysis


Thomas_Ott wrote:

When you say SQL BAK files, do you mean they have a ".bak" extension on them?  If so, they're likely to be backups of the SQL database. 

 

You can't directly import them into RM but what you could try is loading htem into a new database locally and then connect RM to that database. 


Thanks Thomas, I was dreading that this was the answer. I assume if would be the same for a .sql backup file?

Community Manager

Re: Reading a SQL BAK file for analysis

Well .sql files are a bit different. They're just the SQL code to execute something on the database. Those you can use with the Execute SQL operator, just make the database connection and select the .sql file under the "query file" paramater. 

Regards,
T-Bone
Twitter: @neuralmarket